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