user_delexe.jsp

来自「远程教育系统中完整的学生管理系统,包括学生注册,学生管理等最新代码,推荐」· JSP 代码 · 共 112 行

<%
	/*---------------------------------------------
	功能描述:删除用户
	编写时间:2003-09-12
	编写人:侯雄飞
	email:[e-mail]
	
	修改情况记录
	修改时间：  修改内容：   修改人：
	-----------------------------------------------*/
%>

<%@ page language="java" %>
<%@ page contentType="text/html;charset=gb2312" %>

<%
//////////////////////////////////////////////////////////////
// Privilege Guarding

	String 	PrivXP="删除用户";
	String 	PrivME="00103";
%>
<%@ include file="../pub/privGuarding.jsp" %>	
<%
// Privilege Guarding
//////////////////////////////////////////////////////////////
%>

<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool"/>

<%
	String id = request.getParameter("id");
	String sql = "";
	com.dbConnection.MyResultSet rs;
	
	sql = "select register_count,open_course_count from (select count(user_id) as register_count from lrn_register_info where user_id='" + id + "') a,(select count(student_id) as open_course_count from lrn_elective where student_id='" + id + "') b";
	//out.print(sql);
	
	int register_count = 0;
	int open_course_count = 0;
	
	rs = work.executeQuery(sql);
	if(rs != null && rs.next())
	{
		register_count = rs.getInt("register_count");
		open_course_count = rs.getInt("open_course_count");
	}
	work.close(rs);
	
	if (open_course_count > 0)
	{
%>
<script language="javascript">
	if(!confirm("该学生已经选过课，如果删除，则会删除该学生的所有信息，您确定要删除么？"))
	{
		history.back();
	}
</script>
<%
	}
	else
	{
		if (register_count > 0)
		{
%>
<script language="javascript">
	if(!confirm("该学生已经注册过，如果删除，则会同时删除该学生的注册信息，您确定要删除么？"))
	{
		history.back();
	}
</script>
<%
		}
	}
	
	java.util.Hashtable sql_hash = new java.util.Hashtable();
	sql = "delete from tevaluate where t_user_id='" + id + "'";
	sql_hash.put(new Integer(1), sql);
	sql = "delete from tcalendar where student_id='" + id + "'";
	sql_hash.put(new Integer(2), sql);
	sql = "delete from stu_note where stu_id='" + id + "'";
	sql_hash.put(new Integer(3), sql);
	sql = "delete from mng_exam_modifyrecord where student_id='" + id + "'";
	sql_hash.put(new Integer(4), sql);
	sql = "delete from lrn_elective where student_id='" + id + "'";
	sql_hash.put(new Integer(5), sql);
	sql = "delete from lrn_register_info where user_id='" + id + "'";
	sql_hash.put(new Integer(6), sql);
	sql = "delete from lrn_user_info where id='" + id + "'";
	sql_hash.put(new Integer(7), sql);
	
	int count = work.executeUpdateBatch(sql_hash);
	
	if (count < 1)
	{
%>
<script language="javascript">
	alert("删除学生失败！");
	history.back();
</script>
<%
	}
	else
	{
%>
<script language="javascript">
	alert("成功删除学生！");
	window.close();
</script>
<%
	}
%>