save.asp

中原商贸城 中原商贸城 项目库 企业库 供求信息 会员 招聘 企业展示

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

sql="select * from useradmin where username='" & request("username") & "'"
rs.Open sql,conn,1,1

if not rs.EOF then 
%>
<script language=javascript>
     history.back(1)
     alert("用户名已存在！")
</script>
<%
rs.close
set rs=nothing
else
set rs1=server.CreateObject("ADODB.recordset")
sql="select*from useradmin"
rs1.open sql,conn,3,2
rs1.addnew
rs1("username")=request("username")
rs1("password")=request("password")
rs1.update
rs1.close
end if
%>
<SCRIPT LANGUAGE="JavaScript">
<!--
	alert('用户添加成功！');
	window.navigate('add.asp');
//-->
</SCRIPT>