红色部分为修改完的，你再把数据库的路径改为你自己的就行了! <% set cn=server.createobject("ADODB.connection") cn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&server.Mappath("ubbs2000.mdb") sql= "select * from baoming" set rs=server.createobject("ADODB.RecordSet") rs.open sql,cn,3,2 rs.AddNew born=request("textfield")+"-"+request("born")+"-"+request("born1") rs("zh_name")=request("name") rs("zh_sex")=request("sex") rs("zh_folk")=request("textfield2") rs("zh_born")=born rs("zh_no")=request("textfield3") rs("zh_jg")=request("textfield4") rs("zh_school")=request("school") rs("zh_wf")=request("leve") rs("zh_zz")=request("textfield5") rs("zh_height")=request("textfield6") rs("zh_skill")=request("T1") rs("zh_body")=request("D1") rs("zh_add")=request("address") rs("zh_tel")=request("phone") rs("zh_post")=request("skill") rs("zh_zy")=request("bkzy") rs("zh_resume")=replace(replace(request("describe"),"'","''"),vbcrlf,"<br>") if trim(request("email"))<>"@" then rs("zh_email")=request("email") end if if trim(request("textfield7"))<>"" Then rs("zh_father")=request("textfield7") end if if trim(request("textfield8"))<>"" then rs("zh_mother")=request("textfield8") end if if trim(request("textfield11"))<>"" then rs("zh_work1")=request("textfield11") end if if trim(request("textfield12"))<>"" then rs("zh_work2")=request("textfield12") end if if trim(request("textfield9"))<>"" then rs("zh_tel1")=request("textfield9") end if if trim(request("textfield10"))<>"" then rs("zh_tel2")=request("textfield10") end if rs("zh_gaokao")=request("gaokao") rs("zh_huikao")=request("huikao") rs("zh_kaoji")=request("kaoji") rs("zh_li")=request("li") rs("zh_date")=now() rs.Update rs.Close Set rs=nothing cn.close set cn=nothing response.write "<br>" response.write "<br>" response.write "<br>" response.write "<font color=#0066CC><p align=center>您已经报名成功！" response.write "<p align=center>我们将通过您的联系方式进行确认！" response.write "<p align=center>E-mail:yangbo@163.com" response.write "<p align=center><a href='javascript:window.close();'>关闭窗口</a></font>"

response.write "<br>" response.write "<br>" response.write "<br>" response.write "<font color=#0066CC><p align=center>不能重复报名，此姓名已存在！" response.write "<p align=center>谢谢合作！" %>

[此贴子已经被作者于2005-4-13 17:20:23编辑过]