📄 gebieadd2.asp
字号:
<!--#include file="../conn.asp"-->
<!--#include file="../check.asp"-->
<!--#include file="../md5.asp"-->
<%
dim sid,sql1,theACT,mingzi,banji,xuehao,zhuanye,xingbie,shengri,mima,rs,temp,sql2
theACT=request("theACT")
if theACT="SAVE" then
call LinkData()
mingzi=chkhtm(request("mingzi"))
banji=chkhtm(request("banji"))
xuehao=chkhtm(request("xuehao"))
zhuanye=chkhtm(request("zhuanye"))
xingbie=chkhtm(request("xingbie"))
shengri=chkhtm(request("shengri"))
mima=chkhtm(request("mima1"))
If mingzi="" Or banji="" Or xuehao="" Or zhuanye="" Or xingbie="" Or shengri="" Or mima="" Or IsDate(shengri)=false Then
response.write "请<a href='javascript:history.go(-1);'>返回</a>按照提示填写完整，如果禁用了javascript，请启用"
response.End
End if
sql1="select * from student where xuehao='"&xuehao&"'"
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.open sql1,conn,1,3
If Not rs.eof Then
rs.close
response.write "此学号已经存在，请确认输入无误"
response.End
else
rs.addnew
rs("mingzi")=mingzi
rs("banji")=banji
rs("xuehao")=xuehao
rs("zhuanye")=zhuanye
rs("xingbie")=xingbie
rs("shengri")=CDate(shengri)
rs("mima")=md5(mima)
rs.update
rs.close
temp="login.htm"
response.Redirect (temp)
End if
end If
zhuanye=Trim(request("select"))
call LinkData()
sql2="select * from banji where zhuanye='"&zhuanye&"'"
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.open sql2,conn,1,1
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>学生注册</title>
<link href="../teacher.css" rel="stylesheet" type="text/css">
<script language="javascript">
function checkpwd(str1,str2)
{
if (str1.value == str2.value) {
return true;
} else {
alert("密码不一致！请重新输入！");
str1.focus();
return false;
}
return true
}
function validlen(fieldname,str,len)
{
if (str.value.length <len) {
alert(fieldname+"长度应大于等于"+len+"位!");
str.focus();
return false;
}
return true
}
function notNull(fieldname,string)
{
if (string.value == "") {
alert(fieldname+"不能为空");
string.focus();
return false;
}
return true;
}
function select(fieldname,string)
{
if (string.selectedIndex==-1){
alert("!!请选择"+fieldname);
string.focus();
return false;
}
return true;
}
function strdate(str){
var reg=/^((((1[6-9]|[2-9]\d)\d{2})-(0?[13578]|1[02])-(0?[1-9]|[12]\d|3[01]))|(((1[6-9]|[2-9]\d)\d{2})-(0?[13456789]|1[012])-(0?[1-9]|[12]\d|30))|(((1[6-9]|[2-9]\d)\d{2})-0?2-(0?[1-9]|1\d|2[0-8]))|(((1[6-9]|[2-9]\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))-0?2-29-))/;
var r=reg.exec(str);
if(r==null){
alert("生日格式或时间不正确");
return false; }
else
return true;
}
function check(myform)
{
if (notNull(" 姓名 ",myform.mingzi)&&validlen("姓名",myform.mingzi,2)&¬Null(" 学号 ",myform.xuehao)&&validlen("学号",myform.xuehao,10)&¬Null(" 性别 ",myform.xingbie)&¬Null(" 生日 ",myform.shengri)&&strdate(form1.shengri.value)&¬Null(" 密码 ",myform.mima1)&&validlen("密码",myform.mima1,6)&¬Null(" 确认密码 ",myform.mima2)&&select(" 班级",myform.banji)&&checkpwd(myform.mima1,myform.mima2))
return true;
return false;
}
</script>
</head>
<body>
<form method="post" action="gebieadd2.asp" name="form1" onsubmit="return check(this)">
<input type="hidden" name="sid" value="<%=sid%>">
<table border="0" width="500" cellspacing="2" cellpadding="2" align="center">
<tr>
<td colspan="3" align="center">学生注册</td>
</tr>
<tr>
<td>专业</td>
<td><input name="zhuanye" type="text" id="zhuanye" size="20" maxlength="14" value="<%=zhuanye%>" readonly></td>
<td> </td>
</tr>
<tr>
<td>班级</td>
<td>
<select name="banji" size="9">
<%
While Not rs.eof
response.write "<option>"&rs("banji")&"</option>"
rs.movenext
Wend
rs.close
%>
</select>
</td>
<td>请选择</td>
</tr>
<tr>
<td>姓名</td>
<td>
<input name="mingzi" type="text" id="mingzi" size="5" maxlength="4">
</td>
<td>2-4位</td>
</tr>
<tr>
<td>学号</td>
<td><input name="xuehao" type="text" id="xuehao" size="15" maxlength="11"></td>
<td>11位数字</td>
</tr>
<tr>
<td>性别</td>
<td><input name="xingbie" type="text" id="xingbie" size="2" maxlength="1"></td>
<td>男 或 女</td>
</tr>
<tr>
<td>生日</td>
<td><input name="shengri" type="text" id="shengri" size="15" maxlength="14"></td>
<td>8-10位,必须如“1985-3-16”</td>
</tr>
<tr>
<td>密码</td>
<td><input name="mima1" type="text" id="mima1" size="12" maxlength="8"></td>
<td>6-8位</td>
</tr>
<tr>
<td>确认密码</td>
<td><input name="mima2" type="text" id="mima2" size="12" maxlength="8"></td>
<td>6-8位</td>
</tr>
<tr>
<td colspan="3" align="center">
<input type="submit" value="提交">
<input type="reset" value="重写">
<input name="theACT" type="hidden" id="theACT" value="SAVE">
</td>
</tr>
</table>
</form>
</body>
</html>
<%
call CloseData()
'call Timenum()
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -