page.java

来自「实现了基本的增删改查和分页功能很简单的但是挺不错的适合初学者」· Java 代码 · 共 30 行

package org.demo.util;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.demo.dbutil.DBConn;

public class Page {
    public static int totalRows;
    public static int totalPages;
    public static int getTotaRows(String strSQL){
    	DBConn dbconn=new DBConn();
    	ResultSet rs=dbconn.execQuery(strSQL);
    	try {
			rs.last();
			totalRows=rs.getRow();
			return totalRows;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return -1;
    } 
    public static int getTotalPages(String strSQL,int pageSize){
    	getTotaRows(strSQL);
    	totalPages=totalRows%pageSize>0?totalRows/pageSize+1:totalRows/pageSize;
    	return totalPages;
    }
}