📄 update.asp
字号:
<%Response.Buffer=true%>
<%
'修改：
'时间：
'模板设计：秦怀平(jincao@yeah.net)
'开发时间：2000.12
%>
<!--#include file="../include/odbc.asp" -->
<!--#include file="../include/killStr.asp" -->
<!--#include file="../include/checkUser.asp" -->
<!--#include file="../include/checkServer.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Qinhp NetModel Generator">
<meta name="Author" content="QinHuaiPing(秦怀平)">
<link rel="stylesheet" href="../script/style.css" type="text/css">
<%
Id=request("Id")
set rs=server.CreateObject("adodb.recordset")
if request("submit")<>"" then
sql="select * from news2_tennis where tennisId='"&id&"'"
rs.open sql,conn,3,3
if not rs.eof then
set rsl=server.CreateObject("adodb.recordset")
if request("stopTime")="" then
response.write "数据保存出错！原因：特定字段不允许为空!<a href=javascript:history.back()>按此返回</a>"
response.end
end if
if not isdate(request("stopTime")) then
response.write "数据保存出错！原因：字段类型不符!<a href=javascript:history.back()>按此返回</a>"
response.end
end if
if killStr(request("stopTime"))="" then
rs("stopTime")=now()
else
rs("stopTime")=killStr(request("stopTime"))
end if
if request("class")="" then
response.write "数据保存出错！原因：特定字段不允许为空!<a href=javascript:history.back()>按此返回</a>"
response.end
end if
rs("class")=killStr(request("class"))
if request("country")="" then
response.write "数据保存出错！原因：特定字段不允许为空!<a href=javascript:history.back()>按此返回</a>"
response.end
end if
rs("country")=killStr(request("country"))
if request("topOrder")="" then
response.write "数据保存出错！原因：特定字段不允许为空!<a href=javascript:history.back()>按此返回</a>"
response.end
end if
if not isnumeric(request("topOrder")) then
response.write "数据保存出错！原因：字段类型不符!<a href=javascript:history.back()>按此返回</a>"
response.end
end if
'如果类型不符合，请修改转换函数！
if request("topOrder")="" then
rs("topOrder")=0
else
rs("topOrder")=cLng(killStr(request("topOrder")))
end if
if request("totalScore")="" then
response.write "数据保存出错！原因：特定字段不允许为空!<a href=javascript:history.back()>按此返回</a>"
response.end
end if
if not isnumeric(request("totalScore")) then
response.write "数据保存出错！原因：字段类型不符!<a href=javascript:history.back()>按此返回</a>"
response.end
end if
'如果类型不符合，请修改转换函数！
if request("totalScore")="" then
rs("totalScore")=0
else
rs("totalScore")=cLng(killStr(request("totalScore")))
end if
if request("player")="" then
response.write "数据保存出错！原因：特定字段不允许为空!<a href=javascript:history.back()>按此返回</a>"
response.end
end if
rs("player")=killStr(request("player"))
rs.update
end if
rs.close%>
<script language=javascript>
alert("修改成功！");
</script>
<%
Response.Redirect "list.asp?class="&request("class")
end if%>
<script src="../script/trim.js" language="JavaScript"></script>
<script src="../script/validdate.js" language="JavaScript"></script>
<script language='JavaScript'>
function check(form1){
if (trim(form1.player.value)=='')
{alert('字段选手名不允许为空!');
form1.player.focus();
form1.player.select();
return (false);
}
if (trim(form1.totalScore.value)=='')
{alert('字段积分不允许为空!');
form1.totalScore.focus();
form1.totalScore.select();
return (false);
}
if (isNaN(form1.totalScore.value))
{alert('字段积分必须是数字!');
form1.totalScore.focus();
form1.totalScore.select();
return (false);
}
if (trim(form1.topOrder.value)=='')
{alert('字段名次不允许为空!');
form1.topOrder.focus();
form1.topOrder.select();
return (false);
}
if (isNaN(form1.topOrder.value))
{alert('字段名次必须是数字!');
form1.topOrder.focus();
form1.topOrder.select();
return (false);
}
if (trim(form1.country.value)=='')
{alert('字段国家不允许为空!');
form1.country.focus();
form1.country.select();
return (false);
}
if (trim(form1.stopTime.value)=='')
{alert('字段截止日期不允许为空!');
form1.stopTime.focus();
form1.stopTime.select();
return (false);
}
}
</script>
</head>
<body bgcolor="#FFFFE0"><%sql = "select * from news2_tennis where tennisId='"&request("id")&"'"
rs.open sql,conn,3,3
if rs.eof then
response.write "记录没有找到！"
response.end
end if%>
<%
set rsSelect=server.CreateObject("adodb.recordset")
%>
<form method=POST action=<% =request.servervariables("path_info")%> name=add onsubmit="return check(this);">
<p align=center><b><font size=4 color=#0000FF><u>网球数据修改</u></font></b></p>
<div align=center><center>
<table style="border: 1 solid #0000FF" width=85%>
<tr>
<td style="border: 1 solid #0000FF" align=right>分类:</td>
<td style="border: 1 solid #0000FF">
<select size=1 name=class>
<%
selValue=trim(rs("class"))
%>
<option value=男选手 <%if selValue="男选手" then response.write "selected"%>>男选手
<option value=女选手 <%if selValue="女选手" then response.write "selected"%>>女选手
</select>
</td>
</tr>
<tr>
<td style="border: 1 solid #0000FF" align=right>选手名:</td>
<td style="border: 1 solid #0000FF"><input type=Text name=player value='<%=rs("player")%>' size=20 maxLength=40></td></tr>
</tr>
<tr>
<td style="border: 1 solid #0000FF" align=right>积分:</td>
<td style="border: 1 solid #0000FF"><input type=Text name=totalScore value='<%=rs("totalScore")%>' size=10 maxLength=9></td></tr>
</tr>
<tr>
<td style="border: 1 solid #0000FF" align=right>名次:</td>
<td style="border: 1 solid #0000FF"><input type=Text name=topOrder value='<%=rs("topOrder")%>' size=10 maxLength=9></td></tr>
</tr>
<tr>
<td style="border: 1 solid #0000FF" align=right>国家:</td>
<td style="border: 1 solid #0000FF"><input type=Text name=country value='<%=rs("country")%>' size=20 maxLength=50></td></tr>
</tr>
<tr>
<td style="border: 1 solid #0000FF" align=right>截止日期:</td>
<td style="border: 1 solid #0000FF"><input type=Text name=stopTime value='<%=rs("stopTime")%>' size=20 maxLength=18> 格式：2001-01-11 08:11</td></tr>
</tr>
<tr>
<input type=hidden value='<%=request("id")%>' name='id'>
<td style="border: 1 solid #0000FF" colspan=2 align=center><input type=submit value=' 确定 ' name=submit> <input type=reset value=' 重写 ' name=reset></td>
</tr>
</table>
</center></div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -