blog.zip_blog

package com.include; import java.sql.*; /** * 日志的分页类 * * Author : 李超 * Date : 2009-10-18 09:27 * Version : 002 */ public class PagePost { private Connection conn = null; private String SQLDRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; private String URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Blog"; private String USERNAME = "sa"; private String PASSWORD = "sa"; private int pageSize = 5; private int pageId = 1; private int pageNum = 0; private int pageTotal = 0; // 用于后台的分页，需要传入用户的ID和用户的级别以确定显示哪些文章。 // 指定method参数的值为search可以返回搜索结果的分页 public ResultSet getPage(int pageId, String method, String title, String cate, String editorId, String editorAdmin) throws SQLException, ClassNotFoundException { int k; String sql; Class.forName(SQLDRIVER); conn=DriverManager.getConnection(URL,USERNAME,PASSWORD); PreparedStatement stmt = null; if("search".equals(method)) { if ("0".equals(editorAdmin)) { sql = "select * from posts_view where post_title like ? " + "and post_cate=? and post_editor=? order by post_id desc"; stmt = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); stmt.setString(1, "%" + title + "%"); stmt.setString(2, cate); stmt.setString(3, editorId); } else { sql = "select * from posts_view where post_title like ? " + "and post_cate=? order by post_id desc"; stmt = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); stmt.setString(1, "%" + title + "%"); stmt.setString(2, cate); } } else { if ("0".equals(editorAdmin)) { sql = "select * from posts_view where post_editor=? order by post_id desc"; stmt = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); stmt.setString(1, editorId); } else { sql = "select * from posts_view order by post_id desc"; stmt = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); } } ResultSet rs = stmt.executeQuery(); rs.last(); pageTotal = rs.getRow(); if(pageTotal % pageSize == 0) { pageNum = pageTotal / pageSize; } else { pageNum = pageTotal / pageSize + 1; } rs.beforeFirst(); for(k = 0; k < (pageId - 1) * pageSize; k++) { rs.next(); } return rs; } // 用于前台日志的分页，通过cate可以分页显示指定类别下的日志。 public ResultSet getPage(int pageId, String cate) throws SQLException, ClassNotFoundException { int k; String sql; Class.forName(SQLDRIVER); conn=DriverManager.getConnection(URL,USERNAME,PASSWORD); PreparedStatement stmt = null; if (cate == null) { sql = "select * from posts_view order by post_id desc"; stmt = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); } else { sql = "select * from posts_view where post_cate=? order by post_id desc"; stmt = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); stmt.setString(1, cate); } ResultSet rs = stmt.executeQuery(); rs.last(); pageTotal = rs.getRow(); if(pageTotal % pageSize == 0) { pageNum = pageTotal / pageSize; } else { pageNum = pageTotal / pageSize + 1; } rs.beforeFirst(); for(k = 0; k < (pageId - 1) * pageSize; k++) { rs.next(); } return rs; } public int getPagesize() { return pageSize; } public int getPagenum() { return pageNum; } public int getPagetotal() { return pageTotal; } public Connection getConn() { return conn; } }