📄 add_student.asp
字号:
<!--#include file = "inc/conn.asp" -->
<!--#include file = "CheckLogin.asp" -->
<!--#include file = "inc/zhuru.asp" -->
<style type="text/css">
<!--
.STYLE9 {color: #003300; font-size: 12px; }
body,td,th {
font-size: 12px;
}
.STYLE10 {font-size: 12px}
.STYLE11 {color: #003300; font-size: 12px; }
.STYLE12 {font-size: 14px}
-->
</style>
<SCRIPT language=JavaScript>
function CheckValue(thisform)
{
if (thisform.Sno.value.length == 0){
alert ('请输入学号。');
return false;
}
if (thisform.Sno.value.length > 40){
alert ('学号过长。');
return false;
}
if (thisform.Name.value.length == 0){
alert ('请输入学生名。');
return false;
}
if (thisform.Name.value.length > 100){
alert ('学生名过长。');
return false;
}
else if (thisform.Pwd.value.length == 0){
alert ('请输入密码。');
return false;
}
else if (thisform.Pwd.value.length > 40){
alert ('密码过长。');
return false;
}
else if (thisform.Pwd.value.length == 0){
alert ('请输入确认密码。');
return false;
}
else if (thisform.Pwd2.value != thisform.Pwd.value){
alert ('两次密码不一致。');
return false;
}
else if (thisform.Class.value.length == 0){
alert ('请选择班级。');
return false;
}
else if (thisform.Nianyue.value.length > 50){
alert ('出生年月信息过长。');
return false;
}
else if (thisform.Zhengzhimianmao.value.length > 50){
alert ('政治面貌信息过长。');
return false;
}
else if (thisform.Nationality.value.length > 30){
alert ('民族信息过长。');
return false;
}
else if (thisform.Native.value.length > 50){
alert ('籍贯信息过长。');
return false;
}
else if (thisform.CardID.value.length > 100){
alert ('身份证信息过长。');
return false;
}
else if (thisform.Tel.value.length > 50){
alert ('电话信息过长。');
return false;
}
else if (thisform.Email.value.length > 50){
alert ('Email信息过长。');
return false;
}
else if (thisform.QQ.value.length > 100){
alert ('QQ信息过长。');
return false;
}
else if (thisform.MSN.value.length > 50){
alert ('MSN信息过长。');
return false;
}
else if (thisform.Sex.value.length == 0){
alert ('请选择性别。');
return false;
}
else {
thisform.submit();
}
}
</SCRIPT>
<body bgcolor="#B1DB99" topmargin="5" leftmargin="5">
<table width="355" border="0" align="left">
<form id="form1" name="form1" method="post" action="addStudent.asp" onSubmit="CheckValue(this);return false">
<tr bgcolor="#66C06D">
<td colspan="4" bgcolor="#66C06D" background="images/Down_bg.gif"><div align="center" class="STYLE12">学生信息</div></td>
</tr>
<tr bgcolor="#66C06D">
<td><div align="right">学号：</div></td>
<td colspan="3"><input type="text" name="Sno"></td>
</tr>
<tr bgcolor="#66C06D">
<td width="94"><div align="right"><span class="STYLE11">姓名：</span></div></td>
<td width="251" colspan="3">
<label>
<input type="text" name="Name" />
</label> </td>
</tr>
<tr bgcolor="#66C06D">
<td height="19"><div align="right"><span class="STYLE11">密码：</span></div></td>
<td colspan="3"><input type="password" name="Pwd" /></td>
</tr>
<tr bgcolor="#66C06D">
<td height="17"><div align="right"><span class="STYLE9"><span class="STYLE10">密码确认</span>：</span></div></td>
<td colspan="3"><input type="password" name="Pwd2" /></td>
</tr>
<tr bgcolor="#66C06D">
<td height="17"><div align="right">学院：</div></td>
<td><select name="SchoolID">
<%
Dim rs ,strSql
strSql = "SELECT * FROM School ORDER BY Name ASC"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql,conn,1,1
%>
<%
Do While Not rs.EOF
%>
<option value=<%=rs("ID").Value%>><%=rs("name").Value%></option>
<%
rs.movenext
loop
rs.close
%>
</select> </td>
<td><div align="right">专业：</div></td>
<td><select name="zhuanyeID">
<%
strSql = "SELECT * FROM zhuanye ORDER BY Name ASC"
rs.open strSql,conn,1,1
%>
<%
Do While Not rs.EOF
%>
<option value=<%=rs("ID").Value%>><%=rs("name").Value%></option>
<%
rs.movenext
loop
rs.close
%>
</select></td>
</tr>
<tr bgcolor="#66C06D">
<td height="17"><div align="right"><span class="STYLE11">班级：</span></div></td>
<td><select name="ClassID">
<%
strSql = "SELECT * FROM Class ORDER BY Name ASC"
rs.open strSql,conn,1,1
%>
<%
Do While Not rs.EOF
%>
<option value=<%=rs("ID").Value%>><%=rs("name").Value%></option>
<%
rs.movenext
loop
rs.close
%>
</select></td>
<td><div align="right"><span class="STYLE11">性别：</span></div></td>
<td><select name="Sex">
<option value="男">男</option>
<option value="女">女</option>
</select></td>
</tr>
<tr bgcolor="#66C06D">
<td height="17"><div align="right">出生年月：</div></td>
<td colspan="3"><input type="text" name="Nianyue"></td>
</tr>
<tr bgcolor="#66C06D">
<td height="17"><div align="right">政治面貌：</div></td>
<td colspan="3"><input type="text" name="Zhengzhimianmao"></td>
</tr>
<tr bgcolor="#66C06D">
<td height="17"><div align="right">民族：</div></td>
<td colspan="3"><input type="text" name="Nationality"></td>
</tr>
<tr bgcolor="#66C06D">
<td height="17"><div align="right">籍贯：</div></td>
<td colspan="3"><input type="text" name="Native"></td>
</tr>
<tr bgcolor="#66C06D">
<td height="17"><div align="right">身份证号：</div></td>
<td colspan="3"><input type="text" name="CardID"></td>
</tr>
<tr bgcolor="#66C06D">
<td height="17"><div align="right"><span class="STYLE9">电话：</span></div></td>
<td colspan="3"><input type="text" name="Tel" /></td>
</tr>
<tr bgcolor="#66C06D">
<td height="17"><div align="right"><span class="STYLE9">Email: </span></div></td>
<td colspan="3"><input type="text" name="Email" /></td>
</tr>
<tr bgcolor="#66C06D">
<td height="17"><div align="right"><span class="STYLE9">MSN: </span></div></td>
<td colspan="3"><input type="text" name="MSN" /></td>
</tr bgcolor="#66C06D">
<tr bgcolor="#66C06D">
<td height="17"><div align="right"><span class="STYLE9">QQ: </span></div></td>
<td colspan="3"><input type="text" name="QQ" /></td>
</tr>
<tr bgcolor="#66C06D">
<td height="49" colspan="4" align="center">
<input name="清空" type="reset" value="清空" />
<input type="submit" name="Submit2" value="添加" /></td>
</tr>
<tr bgcolor="#66C06D">
<td colspan="4" bgcolor="#66C06D" background="images/Top_bg.gif"><div align="center"> </div></td>
</tr>
</form>
</table>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -