📄 item_input_result.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<!--#include file="verifyTeacher.asp"-->
<%
var profession = Request.Form("Profession");
var courseName = Request.Form("Itemname");
var xuefen = Request.Form("xuefen");
var teacherId = Request.Form("teacher");
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<style type="text/css">
body{
text-align:center;
}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!--#include file="link.asp"-->
<title>添加新专业结果</title>
</head>
<body>
<!--#include file="top.asp"-->
<%
Conn.BeginTrans(); /*开启事务*/
sql="insert into course(name,xuefen,teacherId,professionId) values('"+courseName+"',"+xuefen+","+teacherId+",'"+profession+"')";
Conn.Execute(sql,0,0);
if(Conn.Errors.Count>0)
{
Response.Write("<div align=center><font size='6' color='#ff0000'>系统发生"+Conn.Errors.Count+"个错误！</font></div>");
Conn.RollbackTrans ();/*回滚事务*/
}
else
{
Conn.CommitTrans ();/*提交事务*/
Response.Redirect("errormessage.asp?message=课程添加成功&toUrl=item_input.asp");
}
Conn.Close();
Conn=null;
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -