📄 student_modify2.asp
字号:
<!-- Created: 2001-05-30 23:24:42 -->
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
<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("./user.mdb")
set rpasswd = confirmpasswd.execute("select 密码 from student where 学号='" & request("xuehao") & "'")
if rpasswd.eof then
response.write "<p align=""center""><font size=6 color=#FF0000> 你没有账号!请先申请！ </font></p> "
response.end
end if
if replace(rpasswd.fields("密码")," ","") <> 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("./user.mdb")
set rs=server.createobject("adodb.recordset")
rs.open "select * from student where 学号='" & request("xuehao") & "'" ,conn
%>
<form method="POST" action="student_modify3.asp" >
<table width="584" border="0" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF" height="578" bgcolor="#F5A781">
<tr>
<td colspan="3" 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="3" height="24" width="558">
</td>
</tr>
<tr>
<td colspan="3" height="24" width="558">
<div align="center"><b><font size="4" color="#FFFFFF">学 生 资 料
修 改</font></b></div>
</td>
</tr>
<tr>
<td colspan="3" height="21" width="558">
<div align="left"><font color="#FFCC33"> </font><font color="#FFFFFF">带</font><font color="#FF0000">*</font><font color="#FFFFFF">为必须填写.</font></div>
</td>
</tr>
<tr>
<td width="95" height="14"></td>
<td width="485" height="14" colspan="2">
</td>
</tr>
<tr>
<td width="95" height="25" align="left"> 姓名：</td>
<td width="485" height="25" colspan="2">
<input type="text" name="name" size="15" tabindex="1" maxlength="15" value="<%=rs.fields("姓名")%>">
<font color="#FF3333">*</font>请输入真实姓名 </td>
</tr>
<tr>
<td width="95" height="25" align="left"> 密码：</td>
<td width="485" height="25" colspan="2">
<input type="password" name="password" size="20" tabindex="2" value="<%=rs.fields("密码")%>"><font color="#FF3333">*</font> </td>
</tr>
<tr>
<td width="95" height="25" align="left"> 确认密码：</td>
<td width="485" height="25" colspan="2">
<input type="password" name="password2" size="20" tabindex="3" value="<%=rs.fields("确认密码")%>"><font color="#FF3333">*</font> </td>
</tr>
<tr>
<td width="95" height="25" align="left"> 联系地址：</td>
<td width="485" height="25" colspan="2">
<input type="text" size="40" name="adr" tabindex="4" value="<%=rs.fields("联系地址")%>">
</td>
</tr>
<tr>
<td width="95" height="25" align="left"> 邮政编码：</td>
<td width="485" height="25" colspan="2">
<input type="text" size="6" name="youbian" tabindex="5" value="<%=rs.fields("邮编")%>">
</td>
</tr>
<tr>
<td width="95" height="25" align="left"> 电话：</td>
<td width="485" height="25" colspan="2">
<input type="text" size="25" name="tel" tabindex="6" value="<%=rs.fields("电话")%>">
</td>
</tr>
<tr>
<td width="95" height="25" align="left"> 性别：</td>
<td width="485" height="25" colspan="2">
<select name="sex" size="1" tabindex="7">
<option <%
if "男"=rs.fields("性别") then
response.write "selected"
end if
%>>男</option>
<option <%
if "女"=rs.fields("性别") then
response.write "selected"
end if
%>>女</option>
</select>
<font color="#FF3333">*</font>
</td>
</tr>
<tr>
<td width="95" height="25" align="left"> 邮箱：</td>
<td width="485" height="25" colspan="2">
<input type="text" name="email" size="25" tabindex="8" value="<%=rs.fields("email")%>">
<font color="#FF0000">* </font> </td>
</tr>
<tr>
<td width="95" height="25" align="left"> OICQ：</td>
<td width="485" height="25" colspan="2">
<input type="text" name="oicq" size="15" tabindex="9" value="<%=rs.fields("OICQ")%>">
</td>
</tr>
<tr>
<td width="95" height="13" align="left"> 所在班级：</td>
<td width="485" height="13" colspan="2">
<select size="1" name="grade" tabindex="10">
<option <%
if "1995"=rs.fields("入学年度") then
response.write "selected"
end if
%>>1995</option>
<option <%
if "1996"=rs.fields("入学年度") then
response.write "selected"
end if
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -