<%@ page import="java.sql.*,java.io.*,java.util.*" %> <%@ page language="java" pageEncoding="Big5" %> <%! String au_id,au_lname,au_fname,phone,address,city,state;%> ArticleList
|
標題 |
作者 |
類型 |
點擊 |
加入時間 |
<% int i; int ipage=5; //分頁單位 int allpage; //總頁數 int pages; //接受的頁碼變數 int cpage=1; //當前頁 int spage; //開始頁 int allCol=0; Vector v=null; //資料庫連接聲明 Connection conn=null; java.lang.String sql,pagesql; java.sql.ResultSet rs,pagers; Statement statement=null; String kmsdb="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=DBName"; Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); conn = DriverManager.getConnection(kmsdb, "user", "pwd"); pagesql = "SELECT COUNT(*) FROM Authors"; //取總文章數 statement = conn.createStatement(); pagers = statement.executeQuery(pagesql); while(pagers.next()) { allCol = pagers.getInt(1); System.out.println(allCol); } //獲得總頁面數 allpage = (int)Math.ceil((allCol + ipage-1) / ipage); //判斷參數pages是否空 if (request.getParameter("pages")==null) { pages=1; } else { pages = new Integer(request.getParameter("pages")).intValue(); System.out.println(pages); } //判斷當前頁 if(pages > allpage || pages == 0) {cpage = 1;} else { cpage = pages; } //判斷起始頁 sql = "select Top "+ipage+" au_id,au_lname,au_fname,address,phone from authors where au_id not in (select top "+(cpage-1)*ipage+" au_id from authors order by au_id desc)order by au_id desc"; rs = statement.executeQuery(sql); while (rs.next()) { au_id=rs.getString("au_id"); au_lname=rs.getString("au_lname"); au_fname=rs.getString("au_fname"); phone=rs.getString("phone"); address=rs.getString("address"); %> <%= au_id %> | <%= au_lname %> | <%= au_fname %> | <%= phone %> | <%= address %> | <% }%>
共 <%= allCol %>條記錄 共 <%= allpage %>頁 <% if (cpage>1) { %><% } if (cpage<% } %> / <% for (i=1;i<=allpage;i++) { if (i != pages) {%><%= i %> <% }} %> |
|
|
|