509f99dbdf86001d18b3f3489ec5d0da

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

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;

public class ApartPage 
{
	static Connection con = null;
	  PreparedStatement ps = null;
	  ResultSet rs = null;
	  String sql = "";
	  private int pageSize=3;
	  private int rowCount=0;
	  private int pageCount=0;
	  public int getPageCount(){
		  try {
			con=DBConn.getConnection();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		String sql="select count(*) from message";
		try {
			ps=con.prepareStatement(sql);
			rs=ps.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;
	  }
	
}