exp_sel.jsp

实验室教学管理系统还能为实验室评估提供原始资料和基本数据

<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<title>实验选题</title>
<table width="800" border="1" align="center" cellpadding="0" cellspacing="0">

    <td height="25"><form action="serch.jsp" method="post" >
              <input type="submit" name="Submit" value="查询">
              <input type="text" name="keywords">
              <select name="select">
          <option selected>实验名称</option>
          <option>指导教师编号</option>
        </select>
          </form>
        </td>
  </tr>
<%! String exp_state;%>  
<%
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String strSQL = "";
int PageSize =15 ;
int Page = 1;
int totalPage = 1;
int totalrecord = 0;
try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce){
	out.println(ce.getMessage());
}
request.setCharacterEncoding("GBK");
String str = request.getParameter("keywords");
String stre=request.getParameter("select");
//out.print(stre);
if( str == null)
	str = "";

try{
	conn=DriverManager.getConnection("jdbc:odbc:libwm");
	stmt=conn.createStatement(
		ResultSet.TYPE_SCROLL_INSENSITIVE,
		ResultSet.CONCUR_READ_ONLY);
	//算出总行数
	strSQL = "SELECT count(*) as recordcount FROM experiments WHERE 开放状态='1'";
	rs = stmt.executeQuery(strSQL);
	if (rs.next()) totalrecord = rs.getInt("recordcount");
	//输出记录
	strSQL="SELECT * FROM experiments WHERE 开放状态='1'";

	rs=stmt.executeQuery(strSQL);
	
	if(totalrecord % PageSize ==0)// 如果是当前页码的整数倍
		totalPage = totalrecord / PageSize; 
	else  // 如果最后还空余一页
		totalPage = (int) Math.floor( totalrecord / PageSize ) + 1; 
	if(totalPage == 0) totalPage = 1;
	if(request.getParameter("Page")==null || request.getParameter("Page").equals(""))
		Page = 1;
	else
	try {
		Page = Integer.parseInt(request.getParameter("Page"));
	}
    catch(java.lang.NumberFormatException e){
		// 捕获用户从浏览器地址拦直接输入Page=sdfsdfsdf所造成的异常
		Page = 1;
	}
	if(Page < 1)  Page = 1;
	if(Page > totalPage) Page = totalPage;
	rs.absolute((Page-1) * PageSize + 1);
	%>
	

  <tr>
    <td height="110"><table width="800" border="1" align="center" cellpadding="0" cellspacing="0" >
      <tr>
        <td width="200">实验编号</td>
        <td width="200">实验名称</td>
        <td width="100">指导教师</td>
        <td width="100">开放状态</td>
        <td width="100">选题</td>
      </tr>
	  <%
	for(int iPage=1;iPage<=PageSize; iPage++)
	{   
	   String no=rs.getString("实验编号");
	   String subject_name=rs.getString("实验名称");
	   String teacher_name=rs.getString("指导教师编号");
	    int temp=rs.getInt("开放状态");
		if(temp==0)
		 exp_state="不开放";
	else if(temp==1)
		exp_state="开放";
	else 
		exp_state="待定";

%>
      <TR>
        <TD><%=no%></TD>
        <TD><A HREF='view_expinfo.jsp?id=<%=no%>'><%=subject_name%></A></TD>
        <TD><%=teacher_name%></TD>
    <TD><%=exp_state%></TD>
        <TD><a href="select_exp.jsp?id=<%=no%>">选择该题</a></TD>
      </TR>
        <%
    
 		if(!rs.next()) break;
	}
%>
    </table>
    
 <%	
	
	
}
catch(SQLException e){
	System.out.println(e.getMessage());
}
finally{
	stmt.close();
	conn.close();
}
%>
<FORM Action="exp_sel.jsp" Method="GET">
<% 
   if(Page != 1) {
      out.print("   <A HREF=exp_sel.jsp?Page=1>第一页</A>");
      out.print("   <A HREF=exp_sel.jsp?Page=" + (Page-1) + ">上一页</A>");
   }
   if(Page != totalPage) {
      out.print("   <A HREF=exp_sel.jsp?Page=" + (Page+1) + ">下一页</A>");
      out.print("   <A HREF=exp_sel.jsp?Page=" + totalPage + ">最后一页</A>");
   }
%>
  <BR>输入页数：<input TYPE="TEXT" Name="Page" SIZE="3">
  页数:<font COLOR="Red"><%=Page%>/<%=totalPage%></font>
</FORM>
</table>