📄 addstudent.asp
字号:
<!--#include file ="connection.asp"-->
<%
user=session("user")
lb=session("lb")
if user=""or lb<>"admin" then
response.redirect"index.asp"
else
sqlstr="select * from 系"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open sqlstr,CN
sqlstr="select * from 专业"
set rs1=Server.CreateObject("ADODB.Recordset")
rs1.open sqlstr,CN
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加教师信息</title>
<style type="text/css">
<!--
.STYLE1 {
color: #FFFFFF;
font-size: 18px;
font-weight: bold;
}
.STYLE2 {color: #FFFFFF}
-->
</style>
</head>
<body bgcolor="#FBC2AD">
<div align=center>
<form action="addstudentz.asp" method="post">
<table width="338" border="0" cellpadding="3" cellspacing="1" bordercolor="#000000" bgcolor="#000000" class="sft">
<tr>
<td height="30" colspan="2" bgcolor="#FF903C"><div align="center" class="STYLE1">添加学生信息</div> </td>
</tr>
<tr>
<td height="28" bgcolor="#FF903C"><div align="center" class="STYLE2">学号：</div></td>
<td height="28" bgcolor="#FFFFFF"><input name="studentno" type="text" id="studentno"style="border-style: dotted; border-width: 0; background-color: #FCB4BC" size="20"> </td>
</tr>
<tr>
<td width="100" height="23" bgcolor="#FF903C"><div align="center" class="STYLE2">姓名：</div></td>
<td width="223" height="23" bgcolor="#FFFFFF"><input name="studentname" type="text" id="studentname"style="border-style: dotted; border-width: 0; background-color: #FCB4BC" size="20"> </td>
</tr>
<tr>
<td height="30" bgcolor="#FF903C"><div align="center" class="STYLE2">系部：</div></td>
<td height="30" bgcolor="#FFFFFF"><select name="xiname" size="1" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<option value="--选择系--" selected>--选择系--</option>
<%
do while not rs.eof
%>
<option value="<%=rs("xiname")%>"><%=rs("xiname")%></option>
<% rs.movenext
loop
%>
</select> </td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center" class="STYLE2">专业：</div></td>
<td height="31" bgcolor="#FFFFFF"><select name="zhuanye" size="1" id="zhuanye" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<option value="--选择专业--" selected>--选择专业--</option>
<% do while not rs1.eof
%>
<option value="<%=rs1("zhuanye")%>"><%=rs1("zhuanye")%></option>
<% rs1.movenext
loop
%>
</select></td>
</tr>
<tr>
<td height="26" bgcolor="#FF903C"><div align="center" class="STYLE2">年级：</div></td>
<td height="26" bgcolor="#FFFFFF"><select name="jino" size="1" id="jino" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
<% do while not rs1.eof
%>
<% rs1.movenext
loop
%>
</select>
级</td>
</tr>
<tr>
<td height="26" bgcolor="#FF903C"><div align="center" class="STYLE2">班级：</div></td>
<td height="26" bgcolor="#FFFFFF"><select name="banno" size="1" id="banno" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<% do while not rs1.eof
%>
<% rs1.movenext
loop
%>
</select>
班</td>
</tr>
<tr>
<td height="26" bgcolor="#FF903C"><div align="center" class="STYLE2">出生日期：</div></td>
<td height="26" bgcolor="#FFFFFF"><select name="nian" size="1" id="nian" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<option value="1985">1985</option>
<option value="1986">1986</option>
<option value="1987">1987</option>
<option value="1988">1988</option>
<option value="1989">1989</option>
<option value="2000">2000</option>
<% do while not rs1.eof
%>
<% rs1.movenext
loop
%>
</select>
年
<select name="yue" size="1" id="yue" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<option value="1">01</option>
<option value="2">02</option>
<option value="3">03</option>
<option value="4">04</option>
<option value="5">05</option>
<option value="6">06</option>
<option value="7">07</option>
<option value="8">08</option>
<option value="9">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<% do while not rs1.eof
%>
<% rs1.movenext
loop
%>
</select>
月
<select name="ri" size="1" id="ri" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<option value="1">01</option>
<option value="2">02</option>
<option value="3">03</option>
<option value="4">04</option>
<option value="5">05</option>
<option value="6">06</option>
<option value="7">07</option>
<option value="8">08</option>
<option value="9">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<% do while not rs1.eof
%>
<% rs1.movenext
loop
%>
</select>
日</td>
</tr>
<tr>
<td width="100" height="26" bgcolor="#FF903C"><div align="center" class="STYLE2">性别： </div></td>
<td width="223" height="26" bgcolor="#FFFFFF"><select name="sex" size="1"style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<option selected>女</option>
<option>男</option>
</select> </td>
</tr>
<tr>
<td height="26" bgcolor="#FF903C"><div align="center" class="STYLE2">家庭住址：</div></td>
<td height="26" bgcolor="#FFFFFF"><input name="address" type="text" id="address" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" size="20"> </td>
</tr>
<tr>
<td height="26" bgcolor="#FF903C"><div align="center" class="STYLE2">电话：</div></td>
<td height="26" bgcolor="#FFFFFF"><input name="teleph" type="text" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" size="20"> </td>
</tr>
<tr>
<td width="100" height="26" bgcolor="#FF903C"><div align="center" class="STYLE2">备注：</div></td>
<td width="223" height="26" bgcolor="#FFFFFF"><textarea name="bz" cols="20" rows="5" id="bz" style="border-style: dotted; border-width: 0; background-color: #FCB4BC"></textarea></td>
</tr>
<tr>
<td height="36" colspan="2" bgcolor="#FFFFFF"><div align="center">
<input type="submit" name="Submit" value="添加学生信息" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
</div></td>
</tr>
</table>
</form>
<p class=sft>
</div>
<body>
</body>
</html>
<%
end if
rs.close
rs1.close
CN.close
set rs=nothing
set rs1=nothing
set CN=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -