user_list.jsp

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

<%
	/*---------------------------------------------
	功能描述:学生列表
	编写时间:2003-08-20
	编写人:侯雄飞
	email:[e-mail]
	
	修改情况记录
	修改时间：2003-9-15 14:10  修改内容：去掉年级参数   修改人：李绍炳
	-----------------------------------------------*/
%>

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

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

	String 	PrivXP="浏览学生";
	String 	PrivME="00104";
%>
<%@ include file="../pub/privGuarding.jsp" %>	
<%
// Privilege Guarding
//////////////////////////////////////////////////////////////
%>

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

<%!
	//判断字符串为空的话，赋值为"不详"
	String fixnull(String str)
	{
	    if(str == null || str.equals("null") || str.equals("null"))
			str = "不详";
			return str;
	
	}
%>

<%
	String major_id = request.getParameter("major_id");
	String site_id = request.getParameter("site_id");
	String grade_id = request.getParameter("grade_id");
	String edu_type_id = request.getParameter("edu_type_id");
	
	String major_name = "";
	String grade_name = "";
	String edu_type = "";
	String site_name = "";
	
	
	String sql_major = "";
	String sql_grade = "";
	String sql_site = "";
	String sql_edu_type = "";
	String msg = "";
	String link = "&major_id=" + major_id + "&site_id=" + site_id + "&grade_id="+grade_id+"&edu_type_id=" + edu_type_id;
	//out.print(link);
	String sql = "";
	
	int totalItems = 0;
	com.dbConnection.MyResultSet rs;
	
	if((major_id == null || major_id.equals("")) && (site_id == null || site_id.equals(""))&&(grade_id == null || grade_id.equals(""))&& (edu_type_id == null || edu_type_id.equals("")))
	{
		out.print("您没有选择任何查询条件，这样会导致查询数据量过多，耗费时间过长，请至少选择一项查询条件。 ");
		out.print("<a href=javascript:window.close()>关闭</a>");
		return;
	}
	
	sql = "select name from lrn_major_info where id = '" + major_id + "'";
	totalItems = work.countselect(sql);
	if(totalItems < 1)
		major_name = "所有部门";
	else
	{
		rs = work.executeQuery(sql);
		while(rs.next())
		{
			major_name = rs.getString("name");
		}
		work.close(rs);
	}	

	sql = "select name from lrn_grade_info where id = '" + grade_id + "'";
	totalItems = work.countselect(sql);
	if(totalItems < 1)
		grade_name = "所有年级";
	else
	{
		rs = work.executeQuery(sql);
		while(rs.next())
		{
			grade_name = rs.getString("name");
		}
		work.close(rs);
	}	
	
	sql = "select name from lrn_edu_type where id = '" + edu_type_id + "'";
	totalItems = work.countselect(sql);
	if(totalItems < 1)
		edu_type = "所有层次";
	else
	{
		rs = work.executeQuery(sql);
		while(rs.next())
		{
			edu_type = rs.getString("name");
		}
		work.close(rs);
	}	
	
	sql = "select name from lrn_site_info where id = '" + site_id + "' order by name";
	totalItems = work.countselect(sql);
	if(totalItems < 1)
		site_name = "所有校外学习中心";
	else
	{
		rs = work.executeQuery(sql);
		while(rs.next())
		{
			site_name = rs.getString("name");
			
		}
		work.close(rs);
	}	
	
	msg = site_name + " " + major_name + " " + edu_type + " " + grade_name + " " + "学员列表";
	
	//生成查询专业的语句
	if(!major_id.equals(""))
		sql_major = "(select id,name from lrn_major_info where id='" + major_id + "') m";
	else
		sql_major = "(select id,name from lrn_major_info where id<>'0') m";
		
	//生成查询层次的语句	
	if(!edu_type_id.equals(""))
		sql_edu_type = "(select id,name from lrn_edu_type where id='" + edu_type_id + "') e";
	else
		sql_edu_type = "(select id,name from lrn_edu_type) e";

	//生成查询年级的语句			
	if(!grade_id.equals(""))
		sql_grade = "(select id,name from lrn_grade_info where id='" + grade_id + "') g";
	else
		sql_grade = "(select id,name from lrn_grade_info) g";
	
	//生成查询教学站的语句	
	if(!site_id.equals(""))
		sql_site = "(select id,name from lrn_site_info where id='" + site_id + "') s";
	else
		sql_site = "(select id,name from lrn_site_info) s";
	
	//生成总SQL语句	
	sql = "select id,u_name,id_card,m_name,g_name,e_name,s_name,s_id,reg_no from (select u.id as id,u.name as u_name,u.id_card as id_card,u.reg_no as reg_no,m.name as m_name,g.name as g_name,e.name as e_name,s.name as s_name,s.id as s_id from (select id,name,major_id,grade_id,site,edu_type_id,id_card,reg_no from lrn_user_info where isgraduated = '0' and status = '0000') u," + sql_major + "," + sql_grade + "," + sql_edu_type + "," + sql_site + " where u.major_id = m.id and u.grade_id = g.id and u.site = s.id and u.edu_type_id = e.id)";
	//out.print(sql);
	totalItems = work.countselect(sql);
	if(totalItems < 1)
	{
		//out.print(sql);
		out.print("没有符合条件的学生！ ");
		out.print("<a href=javascript:window.close()>关闭</a>");
		return;
	}
%>
<HTML>
<HEAD>
<TITLE>浏览学籍</TITLE>
<META http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css/style.css" rel=stylesheet type=text/css>
</HEAD>

<img src="/whatymanager/work/manager/flux/counter.jsp" width=0 height=0>
<body bgcolor=FFFFFF leftmargin="0" topmargin="0">
<br>
<TABLE width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="3F6C61">
  <TR class="t08_bgwhite_p2"> 
    <Td colspan=11 align=center><font color="#003399"><%=msg%> </font></Td>
  </TR>
  <TR class="t12_14_bgE3EAE9"> 
    <TD align=center>学号</TD>
    <TD align=center>姓名</TD>
    <TD align=center>部门</TD>
    <TD align=center>层次</TD>
    <TD align=center>年级</TD>
    <TD align=center>校外学习中心</TD>
    <TD align=center>身份证号</td>
  </TR>
<%
	//分页开始
	int pagesize = 0;
	String temp_pagesize = (String)session.getValue("pagesize");
	if (temp_pagesize == null || temp_pagesize.length() == 0 || temp_pagesize.equals("null"))
	{
		pagesize = 10;
	}
	else
	{
		pagesize = Integer.parseInt(temp_pagesize);
	}
	
	String temppage = request.getParameter("pageInt");
	if(temppage == null)  temppage = "1"; 
	int pageInt = java.lang.Integer.parseInt(temppage);
	if (totalItems <= (pageInt - 1) * pagesize)
	{
		pageInt = pageInt - 1;
		if(pageInt < 1)
		{
			pageInt = 1;
		}
	}
	int maxPage = (totalItems + pagesize - 1) / pagesize;
	int pageNext = pageInt + 1;
	int pageLast = pageInt - 1;
	
	rs = work.execute_oracle_page(sql, pageInt, pagesize);
	
	String id = "";
	String u_name = "";
	String m_name = "";
	String e_name = "";
	String g_name = "";
	String s_id = "";
	String s_name = "";
	String id_card = "";
	String reg_no = "";
	
	while(rs.next())
	{
		id = rs.getString("id");
		u_name = rs.getString("u_name");
		m_name = rs.getString("m_name");
		e_name = rs.getString("e_name");
		g_name = rs.getString("g_name");
		s_id=rs.getString("s_id");
		s_name = rs.getString("s_name");
		id_card = rs.getString("id_card");
		reg_no = rs.getString("reg_no");
%>
  <TR align='center' class="t08_bgwhite_p2"> 
    <TD><%=reg_no%></TD>
    <TD  align='left' class="t12_14_bgE3EAE9"><A  href='user_info.jsp?id=<%=id%>' target="_blank"><u> 
      <center>
        <%=fixnull(u_name)%> 
      </center>
      </u></A></TD>
    <TD  align='center'><%=fixnull(m_name)%></TD>
    <TD  align='center' class="t12_14_bgE3EAE9"><%=fixnull(e_name)%></TD>
    <TD  align='center'><%=fixnull(g_name)%></TD>
    <TD  align='center'>(<%=s_id%>)<%=fixnull(s_name)%></td>
    <td  align='center'><%=fixnull(id_card)%></td>
  </TR>
<%
	}
	work.close(rs);
%>
</table>
<%@ include file="../pub/dividepage.jsp" %>
<div align=center>
  <a href="javascript:window.close()">[关闭]</a> &nbsp;&nbsp;
  <a href="user_listexcel.jsp?major_id=<%=major_id%>&grade_id=<%=grade_id%>&site_id=<%=site_id%>&edu_type_id=<%=edu_type_id%>" target=_blank>[excel报表]</a>
</div>
</BODY>
</HTML>