30e8b775da87001d1657cff6aa0c1152

来自「一个相对比较简单的留言簿！功能还比较齐全！」· 代码 · 共 57 行

package com.pure35.database;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.pure35.vo.MessageVo;

public class PageDao 
{
	Connection con=null;
	PreparedStatement pm=null;
	ResultSet rs;
	MessageVo message;
	public int getPageCount(String sql,int pageSize)
	{
		 int rowCount=0;
		 int pageCount=0;
		  
		 try {
				con=DBConn.getConnection();
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
			try {
				pm=con.prepareStatement(sql);
				rs=pm.executeQuery();
				if(rs.next())
				{
					rowCount=rs.getInt(1);
				}
				if(rowCount%pageSize==0)
				{
					pageCount=rowCount/pageSize;
				}
				else
				{
					pageCount=rowCount/pageSize+1;
				}	
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally
			{
				DBConn.closeConnection();
			}
			  return pageCount;
	}

}