最近項(xiàng)目需要,因?yàn)闀r(shí)間問題我用最簡單的方法做了一個(gè)查詢分頁+CheckBox的全選提交,我覺得非常適合小項(xiàng)目和類似郵件列表的功能.下面貼出我的代碼,希望朋友們多給我提毛病.
主要代碼都寫在JSP里.下面是一個(gè)apply_note.jsp:
<%@page contentType="text/html;charset=GBK" language="java"%>
<%@ page import="java.sql.*"%>
<%@ page import="com.deepdo.common.connect.ConSql"%>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<style type=text/css>
td,th,p,span,div,a,A {font-size:12px;text-decoration:none}
.blak a {color:#000; text-decoration:none}
.blak a:hover {color:#f00; text-decoration:underline}
</style>
<body>
<jsp:include page="/include/deepdo.jsp" flush="true"/>
<table width="700" border="0" align="center" cellpadding="0" cellspacing="0"? height="450">
? <tr>
?<td valign="top" class="bg_td1" height="450" width="160">
?<jsp:include page="/include/navigation.jsp" flush="true"/>
?</td>
?<td valign="top" class="bg_td1" height="450" width="540">
?<table width="590" border="0" align="center" cellpadding="2" cellspacing="2" bgcolor="#FAF9F5">
????????? <tr>
??????????? <td background="resume/images/color.jpg" class="font4"> <img src="resume/images/dot.gif">
????????????? 工作申請記錄</td>
????????? </tr>
??????? </table>
??????? <table width="590" border="0" align="center" cellpadding="4" cellspacing="2">
??????? <%
??//變量聲明
??Connection sqlCon; //數(shù)據(jù)庫連接對象
??Statement sqlStmt; //SQL語句對象
??ResultSet sqlRst; //結(jié)果集對象
??String strCon; //數(shù)據(jù)庫連接字符串
??String strSQL; //SQL語句
??int intPageSize; //一頁顯示的記錄數(shù)
??int intRowCount; //記錄總數(shù)
??int intPageCount; //總頁數(shù)
??int intPage; //待顯示頁碼
??String strPage;
??int i;
??//設(shè)置一頁顯示的記錄數(shù)
??intPageSize = 10;
??//取得待顯示頁碼
??strPage = request.getParameter("page");
??if(strPage==null){//表明在QueryString中沒有page這一個(gè)參數(shù)，此時(shí)顯示第一頁數(shù)據(jù)
??intPage = 1;
??}
??else{//將字符串轉(zhuǎn)換成整型
??intPage = java.lang.Integer.parseInt(strPage);
??if(intPage<1) intPage = 1;
??}
??//獲取一個(gè)TOMCAT配置的連接池
? sqlCon = ConSql.getCon();
??//創(chuàng)建一個(gè)可以滾動(dòng)的只讀的SQL語句對象
??sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
??//準(zhǔn)備SQL語句
??strSQL = "select * from apply_note where userid="+request.getAttribute("userid");
??//執(zhí)行SQL語句并獲取結(jié)果集
??sqlRst = sqlStmt.executeQuery(strSQL);
??//獲取記錄總數(shù)
??sqlRst.last();
??intRowCount = sqlRst.getRow();
??//記算總頁數(shù)
??intPageCount = (intRowCount+intPageSize-1) / intPageSize;
??//調(diào)整待顯示的頁碼
??if(intPage>intPageCount) intPage = intPageCount;
??%>
??<tr>
??<td align="center" bgcolor="#efefef" width="150" height="27">已經(jīng)申請過的職位</td>
??<td align="center" bgcolor="#efefef" width="140" height="27">公司名稱</td>
??<td align="center" bgcolor="#efefef" width="75" height="27">申請時(shí)間</td>
??<td align="center" bgcolor="#efefef" width="25" height="27"><input type=CheckBox name="selectAll" onClick="selectAll();"></td>
??</tr>
??<%
??if(intPageCount>0){
??//將記錄指針定位到待顯示頁的第一條記錄上
??sqlRst.absolute((intPage-1) * intPageSize + 1);
??//顯示數(shù)據(jù)
??i = 0;
??while(i<intPageSize && !sqlRst.isAfterLast()){
??%>
??<form name ="noteForm" action="noteRemove.do" method="post">
??<tr>
??<td><a href=<%=sqlRst.getString("url")%> target="_blank"><%=sqlRst.getString("job")%></a></td>
??<td><%=sqlRst.getString("unit")%></td>
??<td><%=sqlRst.getString("date_time")%></td>
??<td width="26" align="center"><input type=CheckBox name="id" value=<%=sqlRst.getString("id")%>></td>
??</tr>
??<%
??sqlRst.next();
??i++;
??}
??}
??%>
??<tr>
??<td>
??<a href="note.do?page=1">首頁</a>
??<%if(intPage>1){%><a href="note.do?page=<%=intPage-1%>">上一頁</a><%}
??else {%><a href="#" title="已經(jīng)是第一頁">上一頁</a><%}%>
??<%if(intPage<intPageCount){%><a href="note.do?page=<%=intPage+1%>">下一頁</a><%}
??else {%><a href="#" title="已經(jīng)是最后一頁">下一頁</a><%}%>
??<a href=note.do?page=<%=intPageCount%>>末頁</a>
??</td>
??<td>
??共 <%=intPageCount%> 頁申請記錄
??當(dāng)前為第 <%=intPage%> 頁
??</td>
??<td> </td>
??<td align="center"><input type="submit" value="刪除" onClick="manageSubmit();"></td>
??<input type="hidden" name="checkvalue" value="">
??</tr>
??</form>
??<%
??//關(guān)閉結(jié)果集
??sqlRst.close();
??//關(guān)閉SQL語句對象
??sqlStmt.close();
??//關(guān)閉數(shù)據(jù)庫
??sqlCon.close();
??%>?
??????? </table>
??? </td>
? </tr>
</table>
<jsp:include page="/include/tail.html" flush="true"/>
</body>
<script language="javascript">
function manageSubmit(){
?var ChkEls=document.getElementsByName("Id");
?var checkedIds="";
?for(var i=0;i<ChkEls.length;i++){
??if(ChkEls.item(i).type != "checkbox")continue;
??var oEl = ChkEls.item(i);
??if(oEl.checked) {
???checkedIds = checkedIds + (oEl.value + ",");
??}
?}
?document.noteForm.checkvalue.value = checkedIds;
?if ( checkedIds == "" ) return false;
?return true;
}
function selectAll(){
?var ChkEl = document.getElementsByName("selectAll").item(0);
?var ChkEls=document.getElementsByName("Id");
?for(var i=0;i<ChkEls.length;i++){
??if(ChkEls.item(i).type != "checkbox")continue;
??var oEl = ChkEls.item(i);
??oEl.status=ChkEl.status;
?}
}
</script>
</html>
下面是一個(gè)Action,基本沒處理業(yè)務(wù)邏輯,就是從Cookie里獲得了用戶的id.
這樣處理分頁感覺超級(jí)簡單,這個(gè)Action就是起到了一個(gè)中轉(zhuǎn)的作用,沒有實(shí)際業(yè)務(wù)功能,如果沒有他,那個(gè)JSP只需要修改一下上下頁的連接地址為本身.就可以自己實(shí)現(xiàn)查詢分頁功能.JSP頁最后的兩個(gè)JS方法是負(fù)責(zé)處理CheckBox全選和,和提交CheckBox的值為的問題的方法.希望朋友們幫忙指點(diǎn)一下我代碼中的不足,互相學(xué)習(xí)互相進(jìn)步.
posted on 2006-06-02 10:57
我心依舊 閱讀(3977)
評(píng)論(2) 編輯 收藏