a0db654d7487001d158dc7ac74c4dcae

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

package com.pure35.bean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

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;
	  }
	  //	得到用户需要显示的用户信息（分页）
	  public List getMessageByPage(int pageNow)
	  {
		  List list =new ArrayList();
		  return list;
		  
	  }
	  

}