我们可以在工具类DBLink.java中定义一个新的方法:
public Object getValue(String sql,String columnName) {
Connection connection=null;
Statement statement=null;
ResultSet resultSet=null;
try {
connection=getConnection();
statement = connection.createStatement();
resultSet= statement.executeQuery(sql);//执行sql语句
if(resultSet.next()) {
return resultSet.getObject(columnName);//返回columnName的数量且返回值类型为Object;
}
} catch (Exception e) {
logger.debug(e.getMessage(),e);
}finally {
close(resultSet,statement,connection);
}
return null ;
}
从而调用上面的方法来实现获取总页数的方法:
public int getPageTotal(String name,String author) {
String sql = "select count(id) count from book ;//COUNT(DISTINCT column_name) 函数返回指定列的不同值的数目,所以此sql语句是返回列名为id的数据总行数即数据总数,并将数值赋给count;
Object value = new DBLink().getValue(sql, "count");
int pageSize=2;
int pageTotal=0;
if(value!=null) {
int count = Integer.parseInt(value.toString());
pageTotal = count%pageSize==0? count/pageSize :count/pageSize+1;
}
return pageTotal;
}