?? questionmanager.jsp
字號:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.util.*" %>
<jsp:useBean id="conn" scope="page" class="test.ConnOracle"/>
<%@ include file="/public/checkvalidadmin.jsp"%>
<%@ include file="/public/checkvalidadmin8.jsp"%>
<%!
ResultSet rs = null;
ResultSet rsTmp = null;
String sql = "";
int PageSize = 13;
int Page = 1;
int totalPage = 1;
String str = "";
Hashtable ht = new Hashtable(); // Hashtable用于存儲班級代號和班級信息之間的對應關系
public String ShowOnePage(ResultSet rs, int Page, int PageSize) {
str = "";
// 先將記錄指針定位到相應的位置
try {
rs.absolute( (Page-1) * PageSize + 1);
}catch(SQLException e) {
}
for(int iPage=1; iPage<=PageSize; iPage++) {
str += showOneRecord(rs,Page);
try {
if(!rs.next()) break;
}catch(Exception e) {}
}
return str;
}
// 顯示單行記錄子模塊, 由于要將當前頁碼傳遞到后面的修改和刪除頁面，
// 因此，下面的shosOneRecord方法多了第二個參數
public String showOneRecord( ResultSet rs, int page ) {
String tt = "";
int endindex = 16; // 在默認情況下顯示題目標題中的前12個漢字字符
String tmp = "";
int tmpselectid = 0;
int tmpquestionid = 0;
try {
tt += "<TR class=dbt4 align=middle>";
tmpquestionid = rs.getInt("questionid");
tt += "<TD>" + tmpquestionid + "</TD>";
tmpselectid = rs.getInt("selectid");
if(tmpselectid==1)
tt += "<TD>單選</TD>";
else if(tmpselectid==2)
tt += "<TD><font color=blue>多選</font></TD>";
tt += "<TD>" + (String)(ht.get(rs.getString("classid"))) + "</TD>";
tmp = rs.getString("qname");
if(tmp.length() < endindex)
endindex = tmp.length();
tt += "<TD align=left>" + tmp.substring(0,endindex) + "</TD>";
tt += "<TD><a href=javascript:openwin(" + tmpquestionid + ")>";
tt += "察看</a></TD>";
tt += "<TD><a href=questionchange.jsp?id=" + tmpquestionid + "&Page=" + page + ">修改</TD>";
tt += "<TD><a href=questiondel.jsp?id=" + tmpquestionid + "&Page=" + page + ">刪除</TD>";
tt += "</TR>";
}catch(SQLException e) {}
return tt;
}
%>
<%
sql = "select * from test_classinfo";
try {
rs = conn.executeQuery( sql );
}catch(Exception e) {
out.println("訪問課程信息數據出錯！");
return;
}
if(!rs.next()) {
out.println("系統數據庫中無課程信息數據！");
return;
}
do {
ht.put(rs.getString("classid"),rs.getString("classname"));
}while(rs.next());
sql = "select * from test_question_lib order by questionid";
try {
rs = conn.executeQuery( sql );
}catch(Exception e) {
out.println("訪問題庫信息出錯！");
return;
}
%>
<html>
<head>
<title>試題庫信息維護</title>
<link rel="stylesheet" href="../public/style.css">
<Script language="JavaScript">
//打開新窗口函數openwin
function openwin(id)
{
window.open('questiondetails.jsp?id='+id,'infoWin', 'height=400,width=600,scrollbars=yes,resizable=yes');
}
</Script>
</head>
<body class="ss">
<h2 ALIGN="CENTER">試題庫信息維護</h2>
<hr>
<center>
<table class=dbt2 width=640 cellSpacing=1 cellPadding=3 border=0>
<tr class=dbt3 align=middle>
<TH>題目編號</TH>
<TH>題型</TH>
<TH>課程名稱</TH>
<TH width=200>題目簡介</TH>
<TH>題目詳細信息</TH>
<TH colspan=2>編輯操作</TH>
</TR>
<%
rsTmp = conn.executeQuery("select count(*) as mycount from test_question_lib");
rsTmp.next();
int totalrecord = rsTmp.getInt("mycount");
if(totalrecord % PageSize ==0) totalPage = totalrecord / PageSize; // 如果是當前頁碼的整數倍
else totalPage = (int) Math.floor( totalrecord / PageSize ) + 1; // 如果最后還空余一頁
if(totalPage == 0) totalPage = 1;
rsTmp.close();
try {
if(request.getParameter("Page")==null || request.getParameter("Page").equals(""))
Page = 1;
else
Page = Integer.parseInt(request.getParameter("Page"));
// 捕獲用戶從瀏覽器地址攔直接輸入類似于Page=sdfsdfsdf等非法信息所造成的異常
} catch(java.lang.NumberFormatException e) {
Page = 1;
}
if(Page < 1) Page = 1;
if(Page > totalPage) Page = totalPage;
out.println(ShowOnePage(rs, Page, PageSize));
%>
<TR class=dbt4 align=center>
<TD colspan=7><a href=questionadd.jsp>增加新題</a></TD>
</TR>
</table>
<form Action="questionmanager.jsp" Method="GET">
<%
if(Page != 1) {
out.println("<A HREF=questionmanager.jsp?Page=1>第一頁</A>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -