pagedao.java

一个相对比较简单的留言簿！功能还比较齐全！

package com.pure35.bean;

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

import com.pure35.database.DBConn;
import com.pure35.vo.MessageVo;

public class PageDao 
{
	//	定义总记录数与总页面数
	int rowCount=0;
	int pageCount=0;
	Connection con=null;
	PreparedStatement pm=null;
	ResultSet rs;
	MessageVo message;
	
	//获取页面总数
	public int getPageCount(String sql,int pageSize)
	{
		 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())
					{
						//从执行sql操作后从得到总记录数
						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;
	}
}