user_searchexe.jsp

远程教育系统中完整的学生管理系统,包括学生注册,学生管理等最新代码,推荐

<%
	/*---------------------------------------------
	功能描述:执行查找学生
	编写时间:2003-08-21
	编写人:侯雄飞
	email:[e-mail]
	
	修改情况记录
	修改时间：  修改内容：   修改人：
	-----------------------------------------------*/
%>

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

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

	String 	PrivXP="查找学生";
	String 	PrivME="00106";
%>
<%@ 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 site_id = request.getParameter("site_id");
	String major_id = request.getParameter("major_id");
	String edu_type_id = request.getParameter("edu_type_id");
	String grade_id = request.getParameter("grade_id");
	String name = request.getParameter("name");
	String reg_no = request.getParameter("reg_no");
	String id_card = request.getParameter("id_card");
	String phone = request.getParameter("phone");
	
	String sql_site = "";
	String sql_major = "";
	String sql_edu_type = "";
	String sql_grade = "";
	String condition = "";
	String sql = "";
	boolean is_first = true;
	
	//生成查询教学站的语句	
	if(site_id != null && !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";
	}
	
	//生成查询专业的语句
	if(major_id != null && !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 != null && !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 != null && !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(name != null && !name.equals(""))
	{
		condition = "name like '%" + name.trim() + "%'";
		is_first = false;
	}
	
	if (reg_no != null && !reg_no.equals(""))
	{
		if (is_first)
		{
			condition = "reg_no like '%" + reg_no.trim() + "%'";
		}
		else
		{
			condition = condition + " and reg_no like '%" + reg_no.trim() + "%'";
		}
		is_first = false;
	}
	
	if (id_card != null && !id_card.equals(""))
	{
		if (is_first)
		{
			condition = "id_card like '%" + id_card.trim() + "%'";
		}
		else
		{
			condition = condition + " and id_card like '%" + id_card.trim() + "%'";
		}
		is_first = false;
	}
	
	if (phone != null && !phone.equals(""))
	{
		if (is_first)
		{
			condition = "phone like '%" + phone.trim() + "%'";
		}
		else
		{
			condition = condition + " and phone like '%" + phone.trim() + "%'";
		}
		is_first = false;
	}
	
	//生成总SQL语句	
	if (is_first)
	{
		sql = "select id,u_name,id_card,m_name,g_name,e_name,s_name,s_id,reg_no,phone from (select u.id as id,u.name as u_name,u.id_card as id_card,u.reg_no as reg_no,u.phone as phone,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,phone 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)";
	}
	else
	{
		sql = "select id,u_name,id_card,m_name,g_name,e_name,s_name,s_id,reg_no,phone from (select u.id as id,u.name as u_name,u.id_card as id_card,u.reg_no as reg_no,u.phone as phone,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,phone from lrn_user_info where " + condition + " and 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)";
	}
	
	String link = "&major_id=" + major_id + "&edu_type_id=" + edu_type_id + "&grade_id=" + grade_id + "&site_id=" + site_id;
	int totalItems = 0;
	com.dbConnection.MyResultSet rs;
	
	totalItems = work.countselect(sql);
	if(totalItems < 1)
	{
		//out.print(sql);
		out.print("没有符合条件的学生！ ");
		out.print("<a href=javascript:window.close()>关闭</a>");
		return;
	}
	else if (totalItems > 500)
	{
%>
<script language="javascript">
	if (!confirm('您查询的结果超过500条,如果继续，则500条以后的结果将自动略去，您希望继续查询吗?'))
	{
		window.navigate('user_search.jsp');
	}
</script>
<%
	}
%>
<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>

<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">查询结果</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>
    <TD align=center>电话号码</td>
<%
	
	rs = work.execute_oracle_page(sql, 1, 500);
	
	String id = "";
	String u_name = "";
	String m_name = "";
	String e_name = "";
	String g_name = "";
	String s_id = "";
	String s_name = "";
	String rs_id_card = "";
	String rs_reg_no = "";
	String rs_phone = "";
	
	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");
		rs_id_card = rs.getString("id_card");
		rs_reg_no = rs.getString("reg_no");
		rs_phone = rs.getString("phone");
%>
  <TR align='center' class="t08_bgwhite_p2"> 
    <TD><%=rs_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(rs_id_card)%></td>
    <td  align='center'><%=fixnull(rs_phone)%></td>
  </TR>
<%
	}
	work.close(rs);
%>
</table>
<div align=center>
  <a href="javascript:window.close()">[关闭]</a> &nbsp;&nbsp;
  <a href="user_listexcel.jsp?major_id=<%=major_id%>&site_id=<%=site_id%>&grade_id=<%=grade_id%>&edu_type_id=<%=edu_type_id%>&name=<%=name%>&temp_reg_no=<%=reg_no%>&id_card=<%=id_card%>&phone=<%=phone%>" target=_blank>[excel报表]</a>
</div>
</BODY>
</HTML>