📄 delcourse.jsp
字号:
<%
/*
程序员:苏楠
用途:删除课程确认
时间:2003-8-19 15:50
*/
%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" %>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding
String PrivXP="删除课程信息";
String PrivME="00603";
String PrivOUT="HTML"; // HTML | XSL | NONE
%>
<%@ include file="../pub/privGuarding.jsp" %>
<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool" />
<%
String id="";
String pageInt=request.getParameter("pageInt");
id = request.getParameter("id");
String name = request.getParameter("name");
String sql_temp="select id from lrn_course_active where course_id='"+id+"'";
if(0 < work.countselect(sql_temp))
{
out.print("该课程已经开课，不能删除");
%>
<a href="javascript:history.back()">返回</a>
<%
return;
}
//String sql = "delete lrn_teacher_info where id='T" + id + "'";
java.util.Hashtable sql_hash = new java.util.Hashtable();
String sql = "delete from lrn_course_cware where course_id='" + id + "'";
sql_hash.put(new Integer(1), sql);
sql = "delete lrn_course_info where id='" + id + "'";
sql_hash.put(new Integer(2), sql);
//out.print(sql);
if(work.executeUpdateBatch(sql_hash)==1)
{
%>
<html>
<head>
<META HTTP-EQUIV="Refresh" CONTENT="2;URL=listcourse.jsp?pageInt=<%=pageInt%>" >
</head>
<body>
<%=name%>已经删除了。<br>
自动返回课程列表,或<a href="listcourse.jsp?pageInt=<%=pageInt%>">点击这里</a>
</body>
</html>
<%
}
else
{
%>
删除失败！<br>
<a href="javascript:history.back()">返回</a>
<%
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -