📄 collegeeditsave.asp

📁 网络考试系统最终备份

💻 ASP

字号:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.inc"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css.css">
<title>无标题文档</title>
</head>

<body>
<%
v_name = request("collegeName")
v_desc = request("textarea")


sql = "select count(*) as isM from college_info where CollegeDesc = '"&v_desc&"' AND CollegeName ='"&v_name&"'"

set rs = server.CreateObject("adodb.recordset")
rs.open sql,conn,3,2

if rs("isM") = 1then
%>
error:修改院校重复 请<a href="addshool.asp">返回</a>
<%
rs.close
set rs = nothing
conn.close
set conn = nothing
response.End()
end if

rs.close
set rs = nothing

sql = "select * from college_info where CollegeID ="&request("shoolID")
set rs = server.CreateObject("adodb.recordset")
rs.open sql,conn,3,2

rs("CollegeName") = v_name
rs("CollegeDesc")= v_desc
rs.update
rs.close
set rs = nothing
conn.close
set conn = nothing
response.Redirect("addshool.asp")
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -