useradd.asp

医药进销存管理系统 全代码 很详细 可惜没有数据库 可供参考

<!--#include virtual="/manage/include/top.asp"-->
		 <tr bgcolor="#6699CC">
		   <td height="1" colspan="4"></td>
		 </tr>
		 <tr>
		   <td height="34" colspan="2" bgcolor="#FFCC66">		     
	       <span class="style8">　<img src="/manage/images/borrow.gif"><span class="style2"><strong> 连锁店添加</strong></span></span></td>
		 </tr>
		 <tr>
		   <td height="184" colspan="4">
<%
If Session("flag")<>1 Then
  Response.Write "<script language=javascript>window.history.back();</script>"
  Response.End()
End If
'Set conn=Server.CreateObject("ADODB.Connection")
'conn.connectionstring="Driver={Sql Server};Server=(local);UID=sa;database=DB_lsmanage"
'conn.open

if request.ServerVariables("CONTENT_LENGTH")>0 then
  UserId=trim(request("UserId"))
  UserName=trim(request("UserName"))
  UserPass=trim(request("UserPass"))
  Address=trim(request("Address"))
   mName=trim(request("mName"))
   Tel=trim(request("Tel"))
   Email=trim(request("Email"))
   YouBian=request("YouBian")
   
   sql="insert into tb_User (UserId,UserName,UserPass,Flag,Address,Tel,YouBian,Email,Mname,RegDate) values ("&UserId&",'"&UserName&"','"&UserPass&"',0,'"&Address&"','"&Tel&"','"&YouBian&"','"&Email&"','"&Mname&"','"&RegDate&"')"
   response.write sql
   response.End()
   set rs=server.CreateObject("adodb.recordset")
   sqlstr="select * from tb_User"
   rs.open sqlstr,conn,3,3
   rs.addnew
   rs("UserId")=UserId
   rs("UserName")=UserName
   rs("UserPass")=UserPass
   rs("Flag")=0
   rs("Address")=Address
   rs("Tel")=Tel
   rs("YouBian")=YouBian
   rs("Email")=Email
   rs("mName")=mName
   rs("RegDate")=now()
   rs.update
   response.write "<br><center><h2><font color=blue>添加连锁店成功！</font></h2></center>"
end if
set rs1=conn.execute("select max(UserId)+1 from tb_User")
%>
<form action="/manage/user/useradd.asp" method="post" name="form1" onSubmit="return chkfields();">
			     <p>&nbsp;</p>
			     <table width="600" border="0" align="center" cellpadding="8" cellspacing="1" bgcolor="#0099CC">
				    <tr>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>用户ID:</strong></div></td>
					  <td width="211" bgcolor="#FFFFFF"><input type="text" value="<%=rs1(0)%>" name="UserId" size="10" style="border:1px solid;border-color:#000000" readonly></td>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>用户名称:</strong></div></td>
					  <td width="180" bgcolor="#FFFFFF"><input type="text" name="UserName" size="20" style="border:1px solid;border-color:#000000"></td>
					</tr>

				    <tr>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>用户密码:</strong></div></td>
					  <td width="211" bgcolor="#FFFFFF"><input type="password" name="UserPass" size="20" style="border:1px solid;border-color:#000000"></td>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>确认密码:</strong></div></td>
					  <td width="180" bgcolor="#FFFFFF"><input type="password" name="UserPass2" size="20" style="border:1px solid;border-color:#000000"></td>
					</tr>
										
					<tr>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>联系电话:</strong></div></td>
					  <td bgcolor="#FFFFFF">
					    <input type="text" name="Tel" size="15" maxlength="11" style="border:1px solid;border-color:#000000">
					  </td>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>联系人:</strong></div></td>
					  <td bgcolor="#FFFFFF"><input type="text" name="mName" size="10" style="border:1px solid;border-color:#000000"></td>
					</tr>
					<tr>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>邮编:</strong></div></td>
					  <td bgcolor="#FFFFFF"><input type="text" name="YouBian" size="8" maxlength="6" style="border:1px solid;border-color:#000000"></td>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>Emial:</strong></div></td>
					  <td width="180" bgcolor="#FFFFFF"><input type="text" name="Email" size="20" style="border:1px solid;border-color:#000000"></td>				      
					</tr>
					<tr>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>地 址:</strong></div></td>
					  <td colspan="3" bgcolor="#FFFFFF"><input type="text" name="Address" size="30" style="border:1px solid;border-color:#000000"></td>
				    </tr>
					<tr bgcolor="#FFFFFF">
					  <td colspan="4" height="2">
				        <div align="center">
				          <input type="submit" name="b1" value="注　册">
				          　　　　&nbsp;
				          <input type="reset" name="b2" value="取　消">
			          </div></td>
				   </tr>
		     </table>
	</form>
<script language="javascript">
  function chkfields(){
  if(document.form1.UserId.value==''){
     alert("请输入用户ID");
	 form1.UserId.focus();
     return false;
	}
  if(document.form1.UserName.value==''){
     alert("请输入用户名称");
	 form1.UserName.focus();
     return false;
	}
	 if(document.form1.UserPass.value==''){
     alert("请输入用户密码");
	 form1.UserPass.focus();
     return false;
	}
	if(document.form1.UserPass2.value==''){
     alert("请输入确认密码");
	 form1.UserPass2.focus();
     return false;
	}
	if(document.form1.UserPass2.value!=document.form1.UserPass.value){
     alert("两次输入密码不同");
	 form1.UserPass2.focus();
     return false;
	}
	  if(document.form1.Tel.value==''){
     alert("请输入联系电话");
	 form1.Tel.focus();
     return false;
	}
	  if(document.form1.YouBian.value==''){
     alert("请输入邮编");
	 form1.YouBian.focus();
     return false;
	}
	  if(document.form1.Address.value==''){
     alert("地址呢？");
	 form1.Address.focus();
     return false;
	}
	  if(document.form1.mName.value==''){
     alert("联系人是谁？");
	 form1.mName.focus();
     return false;
	}
	return true;
  }
</script>
<!--#include virtual="/manage/include/bottom.asp"-->