paginationutil.java

来自「报表,关于ireport报表的一些源码(转)」· Java 代码 · 共 53 行

package cn.edu.hlju.oa.kygl.util;

import java.sql.*;

import cn.edu.hlju.oa.kygl.db.entities.*;
import cn.edu.hlju.oa.kygl.db.DBConnection;

/**
 * 分页显示操作的工具
 * @author kabini
 *
 */
public class PaginationUtil {

    public static int getRecordCount(String tableName) throws Exception {
        //记录的总数量
        int recordCount = 0;
        Connection conn = DBConnection.getConnection();
        Statement stmt = conn.createStatement();

        //查询语句
        String queryStr = "select count(*) from " + tableName;

        //获得全部的元组数量
        ResultSet rs = stmt.executeQuery(queryStr);
        if (rs.next()) {
            recordCount = rs.getInt(1);
        }
        rs.close();

        DBConnection.releaseConnection(conn);
        return recordCount;
    }

    public static int ceil(double sData){
        int temp = (int)sData;
        if( ((double)temp) == sData){
            return temp;
        }
        if( ((double)temp) < sData){
            return temp +1;
        }
        return temp;
    }

    //Just for test
    public static void main(String[] s){
        System.out.println(PaginationUtil.ceil(10.1));
        System.out.println(PaginationUtil.ceil(9.9));
        System.out.println(PaginationUtil.ceil(10));
    }
}