📄 student_insert.asp
字号:
<!--#include file="open.asp" -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%if session("zzteacher")=false then
response.redirect("admin_user.asp")
end if%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!--#include file="inc/css.css" -->
<title>增加学生</title>
</head>
<body topmargin="1">
<!--#include file="inc/top.asp" -->
<!--#include file="inc/menu.asp" -->
<% yn=request.querystring("yn")
if yn=1 then
in_bj=request.form("in_bj")
in_name=trim(request.form("in_name"))
in_xj=trim(request.form("in_xj"))
if in_name="" then
msg="姓名不能为空"
yn=0
else
if in_xj="" then
msg="学籍卡号不能为空"
yn=0
else
str="insert into user_st(class,xj_id,name) values('"&in_bj&"','"&in_xj&"','"&in_name&"')"
conn.execute(str)
end if
end if
end if
%>
<table width="770" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="ff99cc" bgcolor="edebeb">
<tr>
<td width="200" valign="top"><div align="center">
<table width="163" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="unnamed6"> </td>
</tr>
<tr>
<td background="images/nxmt_lj_46.gif" class="unnamed10"> </td>
</tr>
<tr>
<td background="images/nxmt_lj_44.gif" class="unnamed14">
<div align="center">管理员已登录</div></td>
</tr>
<tr>
<td background="images/nxmt_lj_44.gif" class="unnamed10"> </td>
</tr>
<tr>
<td height="25" background="images/nxmt_lj_44.gif" class="unnamed12">
<div align="center">在此可增加学生</div></td>
</tr>
<tr>
<td background="images/nxmt_lj_44.gif" class="unnamed10"> </td>
</tr>
<tr>
<td background="images/nxmt_lj_44.gif" class="unnamed12">
<div align="center" class="unnamed14"><a href="user_student.asp">返回</a> <a href="quit.asp">退出</a></div></td>
</tr>
<tr>
<td background="images/nxmt_lj_45.gif" class="unnamed10"> </td>
</tr>
<tr>
<td class="unnamed6"> </td>
</tr>
</table>
</div></td>
<td width="570" valign="top">
<form name="form1" method="post" action="student_insert.asp?yn=1">
<table width="400" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="unnamed6"> </td>
</tr>
</table>
<table width="500" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="40" colspan="2" bgcolor="#CCCCCC" class="unnamed14"> <div align="center">增加学生操作</div></td>
</tr>
<tr>
<td width="50%" height="30" class="unnamed12"><div align="center">班 级：</div></td>
<td width="50%" height="30">
<select name="in_bj" id="in_bj">
<% str="select * from bj"
set rs=conn.execute(str)
do while not rs.eof
%>
<option value=<%=rs("bj_name")%> selected><%=rs("bj_name")%></option>
<% rs.movenext
loop%>
</select></td>
</tr>
<tr>
<td height="30" class="unnamed12"><div align="center">姓 名：</div></td>
<td height="30">
<input name="in_name" type="text" id="in_name"></td>
</tr>
<tr>
<td height="30" class="unnamed12"><div align="center">学籍卡号：</div></td>
<td height="30">
<%str="select * from config"
set rs=conn.execute(str)%>
<input name="in_xj" type="text" id="in_xj" value="<%=rs("student_id")%>"></td>
</tr>
<tr>
<td height="40" colspan="2"><div align="center">
<input type="submit" name="Submit" value=" 增 加 ">
<input type="reset" name="Submit2" value=" 重 填 ">
</div></td>
</tr>
</table>
</form>
<div align="center"> <font color="#FF0000"> <span class="unnamed14">
<%if msg<>"" then response.write msg end if%>
</span></font></div></td>
</tr>
</table>
<!--#include file="inc/bottom.asp" -->
<%conn.close%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -