modisinf.asp

网络书店

<%
set conn=server.createobject("adodb.connection")
conn.open  "Provider=sqloledb;" & "Data Source=SNB\MH123;Initial Catalog=Bookstore;User Id=sa;Password=jzh1015;"  

set rs=server.CreateObject("adodb.recordset")
sql="select * from Customer where c_name='"&session("disinf")&"'"
rs.open sql,conn,3,3

set rs1=server.CreateObject("adodb.recordset")
sql1="select * from Customer where c_name='"&request("c_name")&"'"
rs1.open sql1,conn,3,3

if rs1.eof or rs1.bof then
else%>
 <script language=javascript>
alert("用户名已存在！");
window.location="disinf.asp" 
</script> 
<%
response.End()
end if



if request("c_id")<>cstr(rs("c_id")) or rs("c_name")<>request("c_name") or  rs("c_sex")<>request("c_sex") or rs("c_sex")<>request("c_sex") or rs("c_indentity")<>request("c_indentity") or rs("c_phone")<>request("c_phone") or rs("c_address")<>request("c_address") or rs("c_postcode")<>request("c_postcode") or rs("c_email")<>request("c_email") or rs("c_pwd")<>request("c_pwd") or  rs("c_face")<>request("c_face") or cstr(rs("c_addtime"))<>request("c_addtime") then				 

					  rs("c_name")=request("c_name")
					   rs("c_id")=request("c_id")
					    rs("c_sex")=request("c_sex")
						 rs("c_indentity")=request("c_indentity")
						  rs("c_phone")=request("c_phone") 
						  rs("c_address")=request("c_address")
						   rs("c_postcode")=request("c_postcode")
						    rs("c_email")=request("c_email")
							 rs("c_pwd")=request("c_pwd")
							  rs("c_face")=request("c_face")
							   rs("c_addtime")=request("c_addtime") 
							   rs.update
%> 
					 <script language=javascript>
				     alert("修改成功!");
			    	 window.location="disinf.asp" 
                    </script> 
             <% else %>
					  <script language=javascript>
				      alert("未修改!");
				      window.location="disinf.asp" 
                      </script> 
					  <%
					  end if
             		  session("disinf")=rs("c_name")
                      %>

 <%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>