e代劍客——溫柔一刀

生活就像海洋，只有意志堅強的人，才能到達彼岸

:: 首頁 :: 新隨筆 :: 聯系 :: 聚合

:: 管理 ::

76 隨筆 :: 7 文章 :: 215 評論 :: 0 Trackbacks

隨筆分類(78)

隨筆檔案(76)

搜索

閱讀排行榜

評論排行榜

分頁顯示記錄

?

分頁顯示記錄

<% @?page?contentType = " text/html;charset=GB2312 " ? %>

<% @?page?import = " java.sql.* " ? %>

<%

int ?dipage = 1 ; // 當前頁碼數默認為1

String ?pages = request.getParameter( " dipage " );

if (pages == null )

{

??pages = " 1 " ;

}

try

{

??dipage = Integer .parseInt(pages);

}

catch(Exception?e)

{

??dipage = 1 ;?

}

%>

< HTML >

< title > 用戶數據 </ title >

< BODY >

? <% ?Connection?con;

????Statement?sql;?

????ResultSet?rs;

????try

????{

??????Class.forName( " com.microsoft.jdbc.sqlserver.SQLServerDriver " );

????}

????catch(ClassNotFoundException?e)

????{

??????out.print( " 類找不到！ " );

????}

????try?

????{??

?????????con = DriverManager.getConnection( " jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse " , " sa " , "" );

?????????sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

?????????rs = sql.executeQuery( " SELECT?*?FROM?userTable " );

????????? int ?countRecord = 0 ; // 記錄條數

????????? int ?countPageRecord = 0 ; // 每頁記錄條數

????????? int ?countPage = 0 ; // 總頁數

?????????countPageRecord = 5 ; // 每頁5條記錄，要設置每頁記錄條數就更改這個變量的值

????????? // 得到記錄的條數

?????????rs.last();

?????????countRecord = rs.getRow();

????????? // 得到總頁數

????????? if (countRecord / countPageRecord == 0 )

????????????countPage = countRecord / countPageRecord;

????????? else

????????????countPage = countRecord / countPageRecord + 1 ;

????????? // 把記錄指針移至當前頁第一條記錄之前

????????? if ((dipage - 1 ) * countPageRecord == 0 )

????????????rs.beforeFirst();

????????? else

????????????rs.absolute((dipage - 1 ) * countPageRecord);

?????????out.print( " <Table?Border?style='font-size:?10pt'> " );

?????????out.print( " <TR><td?colspan=8?align=center>用戶數據</td></tr> " );???

?????????out.print( " <TR> " );

????????????out.print( " <Td?width=60?> " + " 用戶ID號 " );

????????????out.print( " <Td?width=50?> " + " 用戶名 " );

????????????out.print( " <Td?width=100> " + " 用戶真實姓名 " );

????????????out.print( " <Td?width=40> " + " 年齡 " );

????????????out.print( " <Td?width=40> " + " 性別 " );

????????????out.print( " <Td?width=100> " + " 聯系地址 " );

????????????out.print( " <Td?width=100> " + " 聯系電話 " );

????????????out.print( " <Td?width=100> " + " 添加時間 " );

?????????out.print( " </TR> " );

??????? int ?i = 0 ;

??????? while (rs.next())

???????{?out.print( " <TR> " );

?????????????out.print( " <TD?> " + rs.getLong( 1 ) + " </TD> " );

?????????????out.print( " <TD?> " + rs.getString( 2 ) + " </TD> " );?

?????????????out.print( " <TD?> " + rs.getString( 4 ) + " </TD> " );

?????????????out.print( " <TD?> " + rs.getInt( " user_age " ) + " </TD> " );?

?????????????out.print( " <TD?> " + rs.getString( " user_sex " ) + " </TD> " );

?????????????out.print( " <TD?> " + rs.getString( " user_address " ) + " </TD> " );

?????????????out.print( " <TD?> " + rs.getString( " user_telephone " ) + " </TD> " );

?????????????out.print( " <TD?> " + rs.getString( " add_time " ) + " </TD> " );

????????out.print( " </TR> " )?;

????????i ++ ;

???????? if (i >= countPageRecord)?break;? // 當前頁顯示完，則退出循環

????????}

????????out.print( " <TR><td?colspan=8?align=center> " );

???????????out.print( " 共 " + countRecord + " 條記錄,共 " + countPage + " 頁，當前第 " + dipage + " 頁，每頁 " + countPageRecord + " 條記錄， " );

??????????? if (dipage == 1 ) // 當前是首頁

??????????????;

??????????? else // 當前不是首頁

???????????{

??????????????out.print( " <a?href=userPage1.jsp?dipage=1>首頁</a>， " );

??????????????out.print( " <a?href=userPage1.jsp?dipage= " + (dipage - 1 ) + " >上一頁</a>, " );

???????????}

??????????? if (dipage == countPage) // 當前是末頁

??????????????;

??????????? else // 當前不是末頁

???????????{

??????????????out.print( " <a?href=userPage1.jsp?dipage= " + (dipage + 1 ) + " >下一頁</a>, " );

??????????????out.print( " <a?href=userPage1.jsp?dipage= " + countPage + " >末頁</a> " );

???????????}??????????

???????????

???????????out.print( " </td></tr> " );?

????????out.print( " </Table> " );

????????con.close();

?????}

???catch(SQLException?e1)?

???{

??????out.print( " SQL異常！ " );

???}

? %>

</ BODY >

</ HTML >

posted on 2006-04-25 18:16 溫柔一刀閱讀(161) 評論(0) 編輯收藏所屬分類: java相關

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關文章: 德比軟件(DerbySoft)誠聘java工程師（上海） jpivot中輸出pdf打印漢字、excel導出中文方法 Ant+Tomcat自動部署的小問題 FCKeditor-2.3在線編輯器，可以直接用的（java版） Eclipse快捷鍵指南 Java應用iText動態生成PDF文件將Excel文件內容寫入到數據庫 JXL操作Excel 件上傳組件commons-fileupload用戶指南隨機生成驗證碼

e代劍客——溫柔一刀

隨筆分類(78)

隨筆檔案(76)

java源碼

友情連接

開發文檔

搜索

最新評論

閱讀排行榜

評論排行榜