item_input_result.asp

来自「一个修改过的ASP学籍管理系统,用javascript+ado写的」· ASP 代码 · 共 44 行

ASP
44
字号
<%@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 + =
减小字号Ctrl + -
显示快捷键?