📄 teacher_modify2_5.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>
<%
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 thesis_inf where 姓名='" & request("t5_name") & "' and 论文名称='" & request("t5_thesis") & "'" ,conn
sqlstring = "select * from thesis_inf where 姓名='" & request("t5_name") & "' "
flag=0
if request("t5_thesis")<>"" then
sqlstring=sqlstring + " and 论文名称='" & request("t5_thesis") & "'"
flag=1
end if
set rs=conn.execute(sqlstring)
%>
<form method="POST" action="teacher_modify3_5.asp" >
<table width="584" border="0" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF" height="474" 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="t5_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="t5_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="t5_thesis" size="48" value="<%=rs.fields("论文名称")%>">
</td>
</tr>
<tr>
<td width="169" height="29" align="right">日期：</td>
<td width="411" height="29">
<input type="text" name="t5_publishdate" size="15" value="<%=rs.fields("日期")%>">格式如：1999-01-01
</td>
</tr>
<tr>
<td width="169" height="29" align="right"> 第几作者：</td>
<td width="411" height="29">
<input type="text" name="t5_xth" 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="t5_publishmagazine" size="20" value="<%=rs.fields("杂志")%>"> </td>
</tr>
<tr>
<td width="169" height="29" align="right">级别：</td>
<td width="411" height="29">
<input type="text" name="t5_grade" size="20" value="<%=rs.fields("级别")%>">
</td>
</tr>
<tr>
<td width="169" height="1" align="right"> 备注：</td>
<td width="411" height="1"><textarea rows="5" name="t5_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="teacher_register1.asp">返回总录入系统</a>
<hr>
</table>
<%
Conn.Close
set Conn=nothing
%>
<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 + -