question.jsp

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

<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*,java.util.*"%>
<title>回复</title>
<div align="center"><font color="#6600FF" size="+3">问题列表</font> </div>
<table width="800" border="1" align="center" cellpadding="0" cellspacing="0">
<%
Calendar cal=Calendar.getInstance();
int year=cal.get(Calendar.YEAR);
int month=cal.get(Calendar.MONTH)+1;
int date=cal.get(Calendar.DATE);
int hour=cal.get(Calendar.HOUR_OF_DAY);
int minute=cal.get(Calendar.MINUTE);
String date1=year+"-"+month+"-"+date+"/"+hour+":"+minute;
out.print(date1);
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");


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

	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="100" bgcolor="#66CCFF"><div align="center">提问学生编号</div></td>
          <td width="100" bgcolor="#66CCFF"><div align="center">提问时间</div></td>
          <td width="300" bgcolor="#66CCFF"><div align="center">问题</div></td>
      </tr>
<%
	for(int iPage=1;iPage<=PageSize; iPage++)
	{   
	   String time=rs.getString("提问学生编号");
	   String tea_id=rs.getString("提问时间");
       String answer=rs.getString("问题");

%>
      <TR>
        <TD><%=time%></TD>
        <TD><%=tea_id%></TD>
        <TD><%=answer%></TD>
      </TR>
        <%
    
 		if(!rs.next()) break;
	}
%>
    </table>
    
 <%	
	
	
}
catch(SQLException e){
	System.out.println(e.getMessage());
}
finally{
	stmt.close();
	conn.close();
}
%>
<FORM Action="question.jsp" Method="GET">
<% 
   if(Page != 1) {
      out.print("   <A HREF=question.jsp?Page=1>第一页</A>");
      out.print("   <A HREF=question.jsp?Page=" + (Page-1) + ">上一页</A>");
   }
   if(Page != totalPage) {
      out.print("   <A HREF=question.jsp?Page=" + (Page+1) + ">下一页</A>");
      out.print("   <A HREF=question.jsp?Page=" + totalPage + ">最后一页</A>");
   }
%>
  <BR>输入页数：<input TYPE="TEXT" Name="Page" SIZE="3">
  页数:<font COLOR="Red"><%=Page%>/<%=totalPage%></font>
</FORM>
</table>
<div align="center"><font color="#3366FF" size="+3">回复列表</font> </div>
<table width="800" border="1" align="center" cellpadding="0" cellspacing="0">
<%
Connection conn1 = null;
Statement stmt1 = null;
ResultSet rs1 = null;
String strSQL1 = "";
int PageSize1 =15 ;
int Page1 = 1;
int totalPage1 = 1;
int totalrecord1 = 0;
try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce){
	out.println(ce.getMessage());
}
request.setCharacterEncoding("GBK");


try{
	conn1=DriverManager.getConnection("jdbc:odbc:libwm");
	stmt1=conn1.createStatement(
		ResultSet.TYPE_SCROLL_INSENSITIVE,
		ResultSet.CONCUR_READ_ONLY);
	//算出总行数
	strSQL1 = "SELECT count(*) as recordcount FROM answers ";
	rs1= stmt1.executeQuery(strSQL1);
	if (rs1.next()) totalrecord1 = rs1.getInt("recordcount");
	//输出记录
	strSQL1="SELECT * FROM answers";

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

  <tr>
    <td height="110"><table width="800" border="1" align="center" cellpadding="0" cellspacing="0" >
      <tr>
          <td width="100" bgcolor="#66CCFF"><div align="center">回答教师编号</div></td>
          <td width="100" bgcolor="#66CCFF"><div align="center">回答时间</div></td>
          <td width="300" bgcolor="#66CCFF"><div align="center">回复</div></td>
      </tr>
	  <%
	for(int iPage1=1;iPage1<=PageSize1; iPage1++)
	{   
	   String time=rs1.getString("回答教师编号");
	   String tea_id=rs1.getString("回答时间");
       String answer=rs1.getString("回复");
%>
      <TR>
        <TD><%=time%></TD>
        <TD><%=tea_id%></A></TD>
        <TD><%=answer%></TD>
      </TR>
        <%
    
 		if(!rs1.next()) break;
	}
%>
    </table>
    
 <%	
	
	
}
catch(SQLException e){
	System.out.println(e.getMessage());
}
finally{
	stmt1.close();
	conn1.close();
}
%>
<FORM Action="question.jsp" Method="GET">
<% 
   if(Page1 != 1) {
      out.print("   <A HREF=question.jsp?Page1=1>第一页</A>");
      out.print("   <A HREF=question.jsp?Page1=" + (Page1-1) + ">上一页</A>");
   }
   if(Page1 != totalPage1) {
      out.print("   <A HREF=question.jsp?Page1=" + (Page1+1) + ">下一页</A>");
      out.print("   <A HREF=question.jsp?Page1=" + totalPage1 + ">最后一页</A>");
   }
%>
  <BR>输入页数：<input TYPE="TEXT" Name="Page1" SIZE="3">
  页数:<font COLOR="Red"><%=Page1%>/<%=totalPage1%></font>
</FORM>

</table>
<center>
<table border="1" width="900">
  <tr bgcolor="#0000CC">
      
    <th colspan="2" align="center">教师回复窗口</th>
  </tr>
  <form action="an_upload.jsp" method="post" onsubmit="return on_submit()" name="form1">
  <tr bgcolor="#FFFFFF">
    <td width="13%" height="43"><div align="right">回答:</div></td>
      <td width="54%" align="center"><textarea name="textarea" cols="80" rows="5"></textarea></td>
  </tr>
  <tr bgcolor="#0000CC">
    <td height="46" colspan="2" align="center">　
      <input type="submit" value="提交"><input type="reset" value="重输">
      </td>
    </tr>
  </form>
</table>