YPmod.asp 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. <!--#include file="../bdcommx/connxyz.asp"-->
  2. <%call log_chk()
  3. call passChk()%>
  4. <%
  5. dim namex,sex,bron,mz,mm,sg,tz,hy,sf,tel,jg,adr,note,jl,thex
  6. thex=request("thex")
  7. namex=request("namex")
  8. sex=request("sex")
  9. bron=request("bron")
  10. mz=request("mz")
  11. mm=request("mm")
  12. sg=request("sg")
  13. tz=request("tz")
  14. hy=request("hy")
  15. sf=request("sf")
  16. tel=request("tel")
  17. jg=request("jg")
  18. adr=request("adr")
  19. note=request("note")
  20. jl=request("jl")
  21. if namex="" or tel="" then
  22. response.Write"<script language='javascript'>alert('姓名和电话不能为空!');history.go(-1);</script>"
  23. response.End()
  24. end if
  25. Set rs=Server.Createobject("Adodb.Recordset")
  26. sql="select * from adyp where yp_id="&thex&""
  27. rs.open sql,conn,1,3
  28. rs("yp_name")=namex
  29. rs("yp_sex")=sex
  30. rs("yp_bron")=bron
  31. rs("yp_mz")=mz
  32. rs("yp_mm")=mm
  33. rs("yp_sg")=sg
  34. rs("yp_tz")=tz
  35. rs("yp_hy")=hy
  36. rs("yp_sf")=sf
  37. rs("yp_tel")=tel
  38. rs("yp_jg")=jg
  39. rs("yp_adr")=adr
  40. rs("yp_note")=note
  41. rs("yp_jl")=jl
  42. rs("yp_time")=now()
  43. rs.update
  44. rs.close
  45. set rs=nothing
  46. response.write"<SCRIPT language=JavaScript>alert('修改成功!');"
  47. response.write"this.location.href='YPsee.asp?thex="&thex&"';</SCRIPT>"
  48. %>