📄 yangong_add.asp

📁 下了就能用不信你看一下一定能用的
💻 ASP
字号:
<!--#include file="../conn.asp"-->
<%
user_id=douhao(trim(request("user_id")))
user_name=douhao(trim(request("user_name")))
user_pass=douhao(trim(request("user_pass")))
department_name=trim(request("department"))
quan=trim(request("quan"))

if request("action")="add" then
if user_id="" or user_name="" or user_pass="" then
response.write "<script>alert('用户名密码不能为空');history.back();</sript>"
response.End()
end if 

set rs1=conn.execute("select * from ht_employee_user where user_id='"&user_id&"'")
if not rs1.eof then
response.write "<script>alert('用户名已经存在');history.back();</script>"
response.End()
end if 
rs1.close
set rs1=nothing

set rs=server.CreateObject("adodb.recordset")
sql="select * from ht_employee_user"
rs.open sql,conn,1,3
rs.addnew
rs("user_id")=user_id
rs("user_name")=user_name
rs("user_password")=user_pass
rs("user_module")=quan
rs("branch_name")=department_name
rs.update
rs.close
set rs=nothing
 response.write "<script language='javascript'>window.opener.location.href = window.opener.location.href;window.close();</script>"
end if 
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>增加员工资料</title>
 <script language="javascript">
			function check(){
			if (document.form1.user_id.value==''){
			alert('请输入用户名！');
			document.form1.user_id.focus();
			return false;
			
			history.back();
			}
			if (document.form1.user_name.value==''){
			alert('请输入姓名！');
			document.form1.user_name.focus();
			return false;
			history.back();
			}
			if (document.form1.user_pass.value==''){
			alert('请输入密码！');
			document.form1.user_pass.focus();
			return false;
			history.back();
			}
			return true;
			}
			</script>
</head>
<link href="../css/body.css" rel="stylesheet" type="text/css">
<body>
<form name="form1" method="post" action="?action=add" onSubmit="return check();">
  <table width="359" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td height="30" colspan="2" class="borderon">用户信息输入：</td>
    </tr>
    <tr>
      <td width="135" height="25" class="borderon"><div align="right">用 户 名：</div></td>
      <td width="265" class="borderon"><input name="user_id" type="text" id="user_id" size="15"></td>
    </tr>
    <tr>
      <td height="25" class="borderon"><div align="right">姓　　名：</div></td>
      <td class="borderon"><input name="user_name" type="text" id="user_name" size="20"></td>
    </tr>
    <tr>
      <td height="25" class="borderon"><div align="right">密　　码：</div></td>
      <td class="borderon"><input name="user_pass" type="text" id="user_pass"></td>
    </tr>
    <tr>
      <td height="25" class="borderon"><div align="right">权　　限：</div></td>
      <td class="borderon"><input name="quan" type="text" id="quan"></td>
    </tr>
    <tr>
      <td height="25" class="borderon"><div align="right">所属部门：</div></td>
      <td class="borderon"><select name="department_name" id="department_name">
      <%set rs=conn.execute("select * from department")
	  if not rs.eof then
	  do while not rs.eof
	  response.write "<option value="&rs("department_name")&">"&rs("department_name")&"</option>"
	  rs.movenext
	  loop
	  else
	  response.write "对不起，还没有数据，请你管理员联系"
	  end if 
	  rs.close
	  set rs=nothing
	  %>
	  
	  </select>
      </td>
    </tr>
    <tr>
      <td height="28" colspan="2"><div align="center" class="borderon">
        <input type="submit" name="Submit" value="增加">
        <input type="button" name="Submit2" value="关闭" onClick="javascript:window.close();">
      </div></td>
    </tr>
  </table>

</form>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -