📄 adminsavecourse.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<!--#include file="function.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<%
dim action
dim sql,rs
dim cno,cname,ctime,tid
action=request.QueryString("action")
cno=request.Form("cno")
cname=request.Form("cname")
ctime=request.Form("ctime")
tid=request.Form("tch")
if action="add" then
'添加
set rs=server.CreateObject("adodb.recordset")
sql="select * from course where courseno='" & cno & "'"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
sql="insert into course(courseno,coursename,coursetime,teacherid) values('" & cno & "','" & cname & "','" & ctime & "'," & tid & ")"
'response.Write(sql)
'response.End()
conn.execute(sql)
response.Write("添加成功")
else
response.Write("课程号已经被注册")
end if
elseif action="modify" then
'修改
id=request.Form("id")
set rs=server.CreateObject("adodb.recordset")
sql="select * from course where courseno='" & cno & "' and courseid<>" & id
rs.open sql,conn,1,1
if rs.bof and rs.eof then
sql="update course set courseno='" & cno & "',coursename='" & cname & "',coursetime='" & ctime & "',teacherid=" & tid & " where courseid=" & id
conn.execute(sql)
response.Write("修改成功")
else
response.Write("课程号已经被注册")
end if
elseif action="del" then
'删除
id=request.QueryString("id")
set rs=server.CreateObject("adodb.recordset")
sql="select * from course where courseid=" & id
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.Write("没有需要删除的课程")
else
sql="delete * from course where courseid=" & id
conn.execute(sql)
response.Write("删除成功")
end if
end if
%>
<a href="adminlistcourse.asp">返回</a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -