分页&条件查询分页

BaseDao

package day21;

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

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.sun.org.apache.bcel.internal.generic.NEW;

public abstract class BaseDao {

	public List findAllObject(Connection conn, String sqlList,
			Class clazz) throws SQLException {
		return this.findAllObjectByCondition(conn, sqlList, clazz, null);
	}

	public  List findAllObjectByCondition(Connection conn, String sqlList,
			Class clazz, Object ... params) throws SQLException {
		QueryRunner query=new QueryRunner();
		return (List)query.query(conn, sqlList, new BeanListHandler(clazz),params);
	}

	@SuppressWarnings("unchecked")
	public int getCount(Connection conn, String sql) throws SQLException {
		/****************/
		 ResultSetHandler resultSetHandler=new ResultSetHandler() {

			public Object handle(ResultSet rs) throws SQLException {
				int count=0;
				if(rs.next()){
					count=rs.getInt(1); 
				}
				return count;
			}
		};
		/*************** */
		int count=0;
		QueryRunner query=new QueryRunner();
		count=(Integer)query.query(conn, sql, resultSetHandler);
		return count;
	}

	public int getCount(Connection conn, String sql, Object[] params) throws SQLException {
		 ResultSetHandler resultSetHandler=new ResultSetHandler() {

				public Object handle(ResultSet rs) throws SQLException {
					int count=0;
					if(rs.next()){
						count=rs.getInt(1); 
					}
					return count;
				}
			};
			/*************** */
			int count=0;
			QueryRunner query=new QueryRunner();
			count=(Integer)query.query(conn, sql, resultSetHandler,params);
			return count;
	}
}
package day21;

import java.sql.Co