📄 addteacher.asp
字号:
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/function.asp"-->
<%
dim action
action=request.QueryString("action")
select case action
case ""
%>
<html>
<head>
<title>教务管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css.css" rel="stylesheet" type="text/css">
</head>
<body style="background-color: #799AE1">
<table class="tableBorder" width="887" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="7" align="center" background="images/admin_bg_1.gif" height="25"><b><font color="#ffffff">教务管理—</font></b><font color="#FFFFFF"><b>添加一名教师</b></font></td>
</tr>
<form name="studentinfo" method="post" action="addteacher.asp?action=save">
<tr>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">编号：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="Num" type="text" id="Topic0" size="12"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">姓名：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="Name" type="text" id="Topic11" size="12"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">性别：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input type="radio" value="男" name="xb">男 <input type="radio" value="女" name="xb">女</td>
<td width="22%" bgcolor="#E8F1FF" align="center" height="25">照片位置 重新上传</td>
</tr>
<tr>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">民族：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="mz" type="text" id="Topic9" size="12"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">身高：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="sg" type="text" id="Topic12" size="6"> 厘米</td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">身体状况：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="stzk" type="text" id="Topic14" size="12"></td>
<td width="22%" bgcolor="#E8F1FF" align="center" rowspan="6"> </td>
</tr>
<tr>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">视力：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="sl" type="text" id="Topic10" size="12"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">血型：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="xx" type="text" id="Topic17" size="12"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">担任职务：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="drzw" type="text" id="Topic18" size="12"></td>
</tr>
<tr>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">政治面貌：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="zzmm" type="text" id="Topic20" size="12"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">出生日期：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="csrq" type="text" id="Topic21" size="12"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">工作日期：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="gzrq" type="text" id="Topic22" size="12"></td>
</tr>
<tr>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">职称：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="zc" type="text" id="Topic20" size="12"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">教授科目：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="jskm" type="text" id="Topic21" size="12"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">联系电话：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="lxdh" type="text" id="Topic33" size="12"></td>
</tr>
<tr>
<td width="12%" bgcolor="#E8F1FF" align="center" height="25">奖惩情况：</td>
<td width="42%" bgcolor="#E8F1FF" align="center" colspan="5" height="25">
<p align="left">
<textarea class="wenbenkuang" name="jcqk" cols="80" rows="10" id="Body"></textarea>
</td>
</tr>
<tr>
<td width="12%" bgcolor="#E8F1FF" align="center" height="25">个人简历：</td>
<td width="42%" bgcolor="#E8F1FF" align="center" colspan="5" height="25">
<p align="left">
<textarea class="wenbenkuang" name="grjl" cols="80" rows="10" id="Body"></textarea>
</td>
</tr>
<tr>
<td bgcolor="#E8F1FF" height="25"></td>
<td bgcolor="#E8F1FF" colspan="6" height="25">
<input class="go-wenbenkuang" name="submit" value=添加一名教师 type=submit onClick="return checkup();">
</td>
</tr>
</form>
</table>
<%
case "edit"
teacherid=request.QueryString("id")
session("teacherid")=request.QueryString("id")
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_teacher where id="&teacherid,conn,1,3
%>
<html>
<head>
<title>教务管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css.css" rel="stylesheet" type="text/css">
</head>
<body style="background-color: #799AE1">
<table class="tableBorder" width="887" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="7" align="center" background="images/admin_bg_1.gif" height="25"><b><font color="#ffffff">教务管理—</font></b><font color="#FFFFFF"><b>修改教师资料</b></font></td>
</tr>
<form name="studentinfo" method="post" action="addteacher.asp?action=editsave&teacherid=<% =rs("id")%>">
<tr>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">编号：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="Num" type="text" id="Topic0" size="12" value="<% =rs("Num")%>" readonly></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">姓名：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="Name" type="text" id="Topic11" size="12" value="<% =rs("Name")%>"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">性别：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25">
<input type="radio" value="男" name="xb" <% if rs("xb") = "男" then response.write "checked"%>>男
<input type="radio" value="女" name="xb" <% if rs("xb") = "女" then response.write "checked"%>>女</td>
<td width="22%" bgcolor="#E8F1FF" align="center" height="25">照片位置 重新上传</td>
</tr>
<tr>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">民族：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="mz" type="text" id="Topic9" size="12" value="<% =rs("mz")%>"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">身高：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="sg" type="text" id="Topic12" size="6" value="<% =rs("sg")%>"> 厘米</td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">身体状况：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="stzk" type="text" id="Topic14" size="12" value="<% =rs("stzk")%>"></td>
<td width="22%" bgcolor="#E8F1FF" align="center" rowspan="6"> </td>
</tr>
<tr>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">视力：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="sl" type="text" id="Topic10" size="12" value="<% =rs("sl")%>"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">血型：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="xx" type="text" id="Topic17" size="12" value="<% =rs("xx")%>"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">担任职务：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="drzw" type="text" id="Topic18" size="12" value="<% =rs("drzw")%>"></td>
</tr>
<tr>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">政治面貌：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="zzmm" type="text" id="Topic20" size="12" value="<% =rs("zzmm")%>"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">出身日期：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="csrq" type="text" id="Topic21" size="12" value="<% =rs("csrq")%>"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">工作日期：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25">
<input class="wenbenkuang" name="gzrq" type="text" id="Topic22" size="12" value="<% =rs("gzrq")%>"></td>
</tr>
<tr>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">职称：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25">
<input class="wenbenkuang" name="zc" type="text" id="Topic20" size="12" value="<% =rs("zc")%>"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">教授科目：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25">
<input class="wenbenkuang" name="jskm" type="text" id="Topic21" size="12" value="<% =rs("jskm")%>"></td>
<td width="13%" bgcolor="#E8F1FF" align="center" height="25">联系电话：</td>
<td width="13%" bgcolor="#E8F1FF" align="left" height="25"><input class="wenbenkuang" name="lxdh" type="text" id="Topic33" size="12" value="<% =rs("lxdh")%>"></td>
</tr>
<tr>
<td bgcolor="#E8F1FF" align="center">奖惩情况：</td>
<td bgcolor="#E8F1FF" colspan="5">
<script language="javascript">
document.write ('<iframe src="textbox.asp?action=addteacherjcqk" id="message1" width="500" height="200"></iframe>')
frames.message1.document.designMode = "On";
</script>
</td>
</tr>
<tr>
<td bgcolor="#E8F1FF" align="center">个人简历：</td>
<td bgcolor="#E8F1FF" colspan="5">
<script language="javascript">
document.write ('<iframe src="textbox.asp?action=addteachergrjl" id="message2" width="500" height="200"></iframe>')
frames.message2.document.designMode = "On";
</script>
</td>
</tr>
<tr>
<td bgcolor="#E8F1FF"></td>
<td bgcolor="#E8F1FF" colspan="6">
<input class="wenbenkuang" name="jcqk" type="hidden" value="">
<input class="wenbenkuang" name="grjl" type="hidden" value="">
<input class="go-wenbenkuang" name="submit" value=确认修改 type=submit onClick="return checkup();">
</td>
</tr>
</form>
</table>
<SCRIPT LANGUAGE="JavaScript">
function checkup()
{
document.studentinfo.jcqk.value = frames.message1.document.body.innerHTML;
document.studentinfo.grjl.value = frames.message2.document.body.innerHTML;
}
</script>
<%
case "save"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_teacher",conn,1,3
rs.addnew
rs("Password")="965eb72c92a549dd"
rs("Lastlogin")=now()
rs("LastloginIP")="0.0.0.0"
rs("Num")=request("Num")
rs("Name")=request("Name")
rs("xb")=request("xb")
rs("mz")=request("mz")
rs("sg")=request("sg")
rs("stzk")=request("stzk")
rs("sl")=request("sl")
rs("xx")=request("xx")
rs("drzw")=request("drzw")
rs("zzmm")=request("zzmm")
rs("csrq")=request("csrq")
rs("gzrq")=request("gzrq")
rs("zc")=request("zc")
rs("jskm")=request("jskm")
rs("lxdh")=request("lxdh")
rs("jcqk")=request("jcqk")
rs("grjl")=request("grjl")
rs.update
rs.close
set rs=nothing
response.redirect "ok.asp?ok=增加一名教师"
case "editsave"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_teacher where id="&session("teacherid"),conn,1,3
rs("Name")=request("Name")
rs("xb")=request("xb")
rs("mz")=request("mz")
rs("sg")=request("sg")
rs("stzk")=request("stzk")
rs("sl")=request("sl")
rs("xx")=request("xx")
rs("drzw")=request("drzw")
rs("zzmm")=request("zzmm")
rs("csrq")=request("csrq")
rs("gzrq")=request("gzrq")
rs("zc")=request("zc")
rs("jskm")=request("jskm")
rs("lxdh")=request("lxdh")
rs("jcqk")=request("jcqk")
rs("grjl")=request("grjl")
rs.update
rs.close
set rs=nothing
response.redirect "ok.asp?ok=修改教师资料"
case "lock"
teacherid=request("id")
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_teacher where id="&teacherid,conn,1,3
rs("lock")=1
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.redirect "ok.asp?ok=锁定教师"
case "unlock"
teacherid=request("id")
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_teacher where id="&teacherid,conn,1,3
rs("lock")=0
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.redirect "ok.asp?ok=解除锁定教师"
case "del"
teacherid=request("id")
conn.execute "delete from Jw_teacher where id="&teacherid
conn.close
set conn=nothing
response.redirect "ok.asp?ok=删除教师资料"
end select
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -