expcheck.jsp

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

<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.sql.*"%>
<% request.setCharacterEncoding("GBK"); %>
<%
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());
}
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";
	rs = stmt.executeQuery(strSQL);
	if (rs.next()) totalrecord = rs.getInt("recordcount");
	//输出记录
	strSQL="SELECT * FROM experiments where 开放状态=0";
	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);
	%>
	
<table border='1' width='800' height='50' align='center' cellpadding="0" cellspacing="0">
      <tr>
        <td width="50" height="27" >编号</td>
        <td>课题名称</td>
        <td>指导教师编号</td>    
        <td>审查</td>
      </tr>
      <%
	for(int iPage=1;iPage<=PageSize; iPage++)
	{   
	   String no=rs.getString("实验编号");
	   String subject_name=rs.getString("实验名称");
	   String teacher_name=rs.getString("指导教师编号");
	  %>
      <tr>
        <td width="40" height="20"><%=no%></td>
        <td width="200" height="20"><%=subject_name%></A></td>
        <td width="100" height="20"><%=teacher_name%></td>
   
        
    <td width="100"><a href="passcheck.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="expcheck.jsp" Method="GET">
<% 
   if(Page != 1) {
      out.print("   <A HREF=expcheck.jsp?Page=1>第一页</A>");
      out.print("   <A HREF=expcheck.jsp?Page=" + (Page-1) + ">上一页</A>");
   }
   if(Page != totalPage) {
      out.print("   <A HREF=expcheck.jsp?Page=" + (Page+1) + ">下一页</A>");
      out.print("   <A HREF=expcheck.jsp?Page=" + totalPage + ">最后一页</A>");
   }
%>
  <BR>输入页数：<input TYPE="TEXT" Name="Page" SIZE="3">
  页数:<font COLOR="Red"><%=Page%>/<%=totalPage%></font>
</FORM>