mayjorsave.asp

来自「网络考试系统最终备份」· ASP 代码 · 共 45 行

ASP
45
字号
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.inc"-->
<link rel="stylesheet" type="text/css" href="css.css">
<!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">
<title>无标题文档</title>
</head>

<body>
<%
v_collID =request("scollege")

v_depID = request("sdepartment")
v_mayName = request("mayj")

v_desc = request("textarea")


sql = "select * from mayjor_info where College_ID ="&v_collID&" AND Dep_ID = "&v_depID&" and MayjorName='"&v_mayName&"'"
 set rs = server.CreateObject("adodb.recordset")
rs.open sql,conn,3,2
if not  rs.eof then
%>
添加专业重复 请<a href="addmayjor.asp">返回</a>
<%
response.End()
end if

rs.addnew
rs("MayjorDesc")=v_desc
rs("MayjorName")=v_mayName
rs("Dep_ID")=v_depID
rs("College_ID")=v_collID
rs.update
rs.close
set rs = nothing
conn.close
set conn = nothing
response.Redirect("addmayjor.asp")
%>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?