📄 update.asp
字号:
<!-- #include file="conn.asp" -->
<!-- #include file="top.asp" -->
<html>
<head>
<%
'取得被编辑记录的标识
cl=Request.QueryString("class")
no=Request.QueryString("no")
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="Select * From t_student Where d_class='"&cl&"' and d_no='"&no&"'"
rs.Open sql,conn,1,1
%>
<script language="javascript">
function check()
{
if(document.formup.Class.value=="")
{
document.getElementById("1").innerHTML = " <font color=red>*班级不能为空！ </font>";
return false;
}
var str1 = document.getElementById("Class").value;
if(str1.length>5)
{
document.getElementById("1").innerHTML = " <font color=red>*大于5个字符！ </font>";
return false;
}
if(document.formup.No.value=="")
{
document.getElementById("2").innerHTML = " <font color=red>*学号不能为空！ </font>";
return false;
}
var str2 = document.getElementById("No").value;
if(str2.length>2)
{
document.getElementById("2").innerHTML = " <font color=red>*大于2个字符！ </font>";
return false;
}
if(document.formup.Username.value=="")
{
document.getElementById("3").innerHTML = " <font color=red>*姓名不能为空！ </font>";
return false;
}
var str3 = document.getElementById("Username").value;
if(str3.length>12)
{
document.getElementById("3").innerHTML = " <font color=red>*大于12个字符！ </font>";
return false;
}
return true;
}
</script>
<script language="javascript" type="text/javascript">
function check1()
{
var stra = document.getElementById("Class").value;
if(stra.length!=0 || stra.length <=5)
{
document.getElementById("1").innerHTML = "";
}
var strb = document.getElementById("No").value;
if(strb.length!=0 || strb.length <=2)
{
document.getElementById("2").innerHTML = "";
}
var strc = document.getElementById("Username").value;
if(strc.length!=0 || strc.length <=12)
{
document.getElementById("3").innerHTML = "";
}
}
</script>
</head>
<body>
<h4>请输入需要修改的数据</h4>
<form method="post" name="formup" action="modify.asp" onSubmit="return check()">
<table border="0" width="650">
<tr><td height="33">班级：</td>
<td><input type="text" name="Class" size="5" value="<% =Server.HTMLEncode(Trim(rs("d_class"))) %>" onBlur="return check1()">(* 必填，最长5个字符)</td>
<td align="left" width="20%"><span id="1"></span></td>
</tr>
<tr><td height="33">学号：</td>
<td><input type="text" name="No" size="2" value="<% =Server.HTMLEncode(Trim(rs("d_no"))) %>" onBlur="return check1()">(* 必填，最长2个字符) </td>
<td><span id="2"></span></td>
</tr>
<tr><td height="41">姓名：</td>
<td><input type="text" name="Username" size="12" value="<% =Server.HTMLEncode(Trim(rs("d_name"))) %>" onBlur="return check1()">(* 必填，最长12个字符)</td>
<td><span id="3"></span></td>
</tr>
<tr><td height="34">性别： </td>
<td><select size="1" name="sex">
<option value=""><% =Server.HTMLEncode(Trim(rs("d_sex"))) %></option>
<option value="男">男</option>
<option value="女">女</option>
</select></td>
</tr>
<tr><td height="41">年龄：</td>
<td><input type="text" name="age" size="2" value="<% =Server.HTMLEncode(Trim(rs("d_age"))) %>">(最长2个字符)</td>
</tr>
<tr><td height="37">联系电话：</td>
<td><input type="text" name="phone" size="20" value="<% =Server.HTMLEncode(Trim(rs("d_phone"))) %>">(最长20个字符)</td>
</tr>
<tr><td height="33">地址：</td>
<td><input type="text" name="address" size="50" value="<% =Server.HTMLEncode(Trim(rs("d_address"))) %>">(最长50个字符)</td>
</tr>
<tr><td height="39">工作单位：</td>
<td><input type="text" name="dw" size="20" value="<% =Server.HTMLEncode(Trim(rs("d_dw"))) %>">(最长20个字符)</td>
</tr>
<tr><td height="39">电子邮件：</td>
<td><input type="text" name="email" size="20" value="<% =Server.HTMLEncode(Trim(rs("d_email"))) %>">(最长20个字符)</td>
</tr>
<tr><td height="39">备注：</td>
<td><input type="text" name="memo" size="50" value="<% =Server.HTMLEncode(Trim(rs("d_memo"))) %>">(最长50个字符)</td>
</tr>
<tr><td><input type="hidden" name="hclass" size="5" value="<% =Server.HTMLEncode(Trim(rs("d_class"))) %>"></td>
</tr>
<tr><td><input type="hidden" name="hno" size="2" value="<% =Server.HTMLEncode(Trim(rs("d_no"))) %>"></td>
</tr>
</table>
<p>
<input type="submit" value="确定" name="up">
<input type="reset" value="取消" name="res">
</form>
<!-- #include file="bottom.asp" -->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -