给你一段参考的代码:
Set rs= Server.CreateObject("ADODB.Recordset")
sql="select * from yp order by id desc where id="&request("id")
rs.open sql,conn,1,3
rs("name")=name1
rs("sex")=sex
rs("shenggao")=shenggao
rs("old")=old
rs("address")=address
rs("phone")=phone
rs("email")=email
rs("zw")=zw
rs("yq")=yq
rs("grjl")=grjl
rs.update
rs.close
response.write "<script>alert('申请成功!我们会尽快与你联系。');history.back(1);</script>"