📄 teacher_modify2_2.asp
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>教工资料修改系统</title>
<STYLE type=text/css>
TD,p,b,font,pre,BODY {
FONT-FAMILY: "Verdana", "Arial", "Helvetica", "sans-serif", "宋体"; FONT-SIZE: 12px
}
FORM {
FONT-FAMILY: "Verdana", "Arial", "Helvetica", "sans-serif", "宋体"; FONT-SIZE: 12px; MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px
}
A {
FONT-FAMILY: "Verdana", "Arial", "Helvetica", "sans-serif", "宋体"; FONT-SIZE: 12px; TEXT-DECORATION: none
}
H4 {
FONT-FAMILY: "Verdana", "Arial", "Helvetica", "sans-serif", "宋体"; FONT-SIZE: 14px
}
HR {
COLOR: #000000; HEIGHT: 1px
}
</STYLE>
</head>
<body>
<%
function change (s)
change = replace(replace(s,"'","''"),"""","""""")
end function
%>
<%
set confirmpasswd= server.createobject("adodb.connection")
confirmpasswd.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("./math_department.mdb")
set rpasswd = confirmpasswd.execute("select password1 from admin where name='" & request("name") & "'")
if rpasswd.eof then
response.write "<p align=""center""><font size=6 color=#FF0000> 你没有账号！无管理员权限！ </font></p> "
response.write "<input type='button' value='返回' onclick=history.back()>"
response.end
end if
if replace(rpasswd.fields("password1")," ","") <> request("password") then
response.write "<p align=""center""><font size=6 color=#FF0000> 密码不正确! </font></p> "
response.write "<input type='button' value='重试' onclick=history.back()>"
response.end
end if
set conn = server.createobject("adodb.connection")
conn.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("./math_department.mdb")
set rs=server.createobject("adodb.recordset")
rs.open "select * from family_inf where 姓名='" & request("t2_name") & "'" ,conn
%>
<form method="POST" action="teacher_modify3_2.asp" >
<table width="584" border="0" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF" height="682" bgcolor="#F5A781">
<tr>
<td colspan="2" height="32" width="558" bordercolorlight="#FD6868" bordercolordark="#FF3333" valign="top">
<table border="1" width="104%" cellpadding="0" cellspacing="0" height="27" bordercolorlight="#F5A781" bordercolordark="#F3BC9E">
<tr>
<td width="100%" height="27"><b><font size="2">数学系站点人事管理系统</font></b></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" height="24" width="558">
</td>
</tr>
<tr>
<td colspan="2" height="24" width="558">
<div align="center"><b><font size="4" color="#FFFFFF">教 工 家 庭
情 况 修 改 表 </font></b></div>
</td>
</tr>
<tr>
<td colspan="2" height="21" width="558">
<div align="left"><font color="#FFCC33"> </font></div>
</td>
</tr>
<tr>
<td width="169" height="29" align="right"> 工作证号：</td>
<td width="411" height="29">
<input type="text" name="t2_workcard" size="14" value="<%=rs.fields("工作证号")%>">
</td>
</tr>
<tr>
<td width="169" height="29" align="right"> 姓名：</td>
<td width="411" height="29">
<input type="text" name="t2_name" size="9" value="<%=rs.fields("姓名")%>"> </td>
</tr>
<tr>
<td width="169" height="29" align="right"> 配偶姓名：</td>
<td width="411" height="29">
<input type="text" name="t2_matename" size="9" value="<%=rs.fields("配偶姓名")%>">
</td>
</tr>
<tr>
<td width="169" height="29" align="right"> 配偶工作单位：</td>
<td width="411" height="29">
<input type="text" name="t2_matework" size="22" value="<%=rs.fields("配偶工作单位")%>">
</td>
</tr>
<tr>
<td width="169" height="29" align="right"> 配偶联系电话：</td>
<td width="411" height="29">
<input type="text" name="t2_matetel" size="15" value="<%=rs.fields("配偶联系电话")%>"> </td>
</tr>
<tr>
<td width="169" height="29" align="right">第一子女姓名：</td>
<td width="411" height="29">
<input type="text" name="t2_1childname" size="9" value="<%=rs.fields("第一子女姓名")%>">
</td>
</tr>
<tr>
<td width="169" height="29" align="right"> 第一子女工作单位：</td>
<td width="411" height="29">
<input type="text" name="t2_1childwork" size="22" value="<%=rs.fields("第一子女工作单位")%>">
</td>
</tr>
<tr>
<td width="169" height="29" align="right"> 第一子女联系电话：</td>
<td width="411" height="29">
<input type="text" name="t2_1childtel" size="15" value="<%=rs.fields("第一子女联系电话")%>"> </td>
</tr>
<tr>
<td width="169" height="29" align="right"> 第二子女姓名：</td>
<td width="411" height="29">
<input type="text" name="t2_2childname" size="9" value="<%=rs.fields("第二子女姓名")%>">
</td>
</tr>
<tr>
<td width="169" height="29" align="right"> 第二子女工作单位：</td>
<td width="411" height="29">
<input type="text" name="t2_2childwork" size="22" value="<%=rs.fields("第二子女工作单位")%>">
</td>
</tr>
<tr>
<td width="169" height="29" align="right"> 第二子女联系电话：</td>
<td width="411" height="29">
<input type="text" name="t2_2childtel" size="15" value="<%=rs.fields("第二子女联系电话")%>">
</td>
</tr>
<tr>
<td width="169" height="29" align="right">第三子女姓名：</td>
<td width="411" height="29">
<input type="text" name="t2_3childname" size="9" value="<%=rs.fields("第三子女姓名")%>">
</td>
</tr>
<tr>
<td width="169" height="29" align="right"> 第三子女工作单位：</td>
<td width="411" height="29">
<input type="text" name="t2_3childwork" size="22" value="<%=rs.fields("第三子女工作单位")%>">
</td>
</tr>
<tr>
<td width="169" height="30" align="right"> 第三子女联系电话：</td>
<td width="411" height="30"><input type="text" name="t2_3childtel" size="15" value="<%=rs.fields("第三子女联系电话")%>"></td>
</tr>
<tr>
<td width="169" height="32" align="right"> 备注：</td>
<td width="411" height="32"><textarea rows="5" name="t3_note" cols="26"><%=rs.fields("备注")%></textarea></td>
</tr>
<tr>
<td colspan="2" height="27" width="558">
<div align="center">
<input type="submit" name="Submit" value="提交" tabindex="16">
<input type="reset" name="reset" value="重来" tabindex="17">
</div>
</td>
</tr>
<tr>
<td colspan="2" height="17" width="558"> </td>
</tr>
</table>
</form>
<table width="600" align="center">
<td>
<p align="right"><img border="0" src="images/3j3.gif" width="14" height="11"><a href="jgzl_2.asp">返回总录入系统</a>
<hr>
</table>
<TABLE cellSpacing=0 borderColorDark=#ffffff cellPadding=0 width=760 borderColorLight=#009900 border=0 align="center">
<TR vAlign=center align=middle>
<TD width="100%" height=2>
<p align="center"><font color="#000000">|
</font><A
onclick="this.style.behavior='url(#default#homepage)';this.setHomePage('http://');"
href="http:///">设为首页</A>| <A href="javascript:window.external.addfavorite('http://','南气数学系')">收藏我站</A>|
<a href="mailto:maths_nim@sina.com">意见建议</a>| <a href="mailto:maths_nim@sina.com">联系我们</a>| <BR>Copyright (c)
2001-2002 All right reserved
版权所有：南京气象学院数学系
维护：数学系微机中心 </p>
</TD></TR></TABLE>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -