user_select.jsp

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

JSP
160 行
字号 
<%
	/*---------------------------------------------
	功能描述:选择学生列表的条件
	编写时间:2003-08-20
	编写人:侯雄飞
	email:houxf@whaty.com
	
	修改情况记录
	修改时间：2003-9-15 14:07  修改内容:去掉年级选项   修改人：李绍炳
	-----------------------------------------------*/
%>

<%@ 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 sql = "";
	int count = 0;
	com.dbConnection.MyResultSet rs ;
%>
<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 leftmargin=0 topmargin=0 bgcolor=FFFFFF>
	<br>
<form name="select" method="post" action="user_list.jsp" target="_blank">	
  <table width="75%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="3F6c61">
  <tr class="t08_bgwhite_p2"> 
    <td colspan=2> 
      <p align="center"><b>选择条件</b></td>
  </tr>
  <tr> 
    <td class="t12_14_bgE3EAE9">选择校外学习中心</td>
    <td class="t08_bgwhite_p2"> <select name="site_id">
          <option value="" selected>所有校外学习中心</option>
<%
	sql = "select id,name from lrn_site_info order by name";
	count = work.countselect(sql);
	if(count > 0)
	{
		rs = work.executeQuery(sql);
		while(rs.next())
		{
			String id = rs.getString("id");
			String name = rs.getString("name");

%>
          <option value="<%=id%>" >(<%=id%>)<%=name%></option>
<%
		}
		work.close(rs);
	}
%>
        </select></td>
    </tr>
    <tr> 
      <td width="50%" class="t12_14_bgE3EAE9">选择专业</td>
      <td width="50%" class="t08_bgwhite_p2"> 
      <select name="major_id" size="1">
          <option value="" selected>所有专业</option>
<%
	sql = "select id,name from lrn_major_info where id <> '0' and status='1111' order by name";
	count = work.countselect(sql);
	if(count > 0)
	{
		rs = work.executeQuery(sql);
		while(rs.next())
		{
			String id = rs.getString("id");
			String name = rs.getString("name");

%>
          <option value="<%=id%>" ><%=name%></option>
<%
		}
		work.close(rs);
	}
%>
        </select></td>
    </tr>
    <tr> 
      <td class="t12_14_bgE3EAE9">选择层次</td>
      <td class="t08_bgwhite_p2"> 
      <select name="edu_type_id">
          <option value="" selected>所有层次</option>
<%
	sql = "select id,name from lrn_edu_type order by name";
	count = work.countselect(sql);
	if(count > 0)
	{
		rs = work.executeQuery(sql);
		while(rs.next())
		{
			String id = rs.getString("id");
			String name = rs.getString("name");

%>
          <option value="<%=id%>" ><%=name%></option>
<%
		}
		work.close(rs);
	}
%>
        </select></td>
    </tr>

    <tr> 
      <td class="t12_14_bgE3EAE9">选择年级</td>
      <td class="t08_bgwhite_p2"> <select name="grade_id">
          <option value="" selected>所有年级</option>
<%
	sql = "select id,name from lrn_grade_info order by name";
	count = work.countselect(sql);
	if(count > 0)
	{
		rs = work.executeQuery(sql);
		while(rs.next())
		{
			String id = rs.getString("id");
			String name = rs.getString("name");

%>
          <option value="<%=id%>" ><%=name%></option>
<%
		}
		work.close(rs);
	}
%>
        </select></td>
    </tr>

    <tr class="t08_bgwhite_p2"> 
      <td colspan="2"> <div align="center"> 
          <input type="submit" name="submit" value="查询" >
        </div></td>
    </tr>
  </table>
</form>
<p align="center"><a href="user_manage.jsp">返回</a></p>
<p>&nbsp;</p>
</body>
</html>

user_select.jsp - 源码说明

本页面展示了「远程教育系统中完整的学生管理系统,包括学生注册,学生管理等最新代码,推荐」中的 user_select.jsp 源码文件，采用 JSP 编程语言编写，共 160 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与远程教育相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?