带查询条件的分页实例

1、配置bean文件 2、建立DBUtilsTemplate类 public class DBUtilsTemplate {    private DataSource dataSource;    private QueryRunner queryRunner;    private static final Log LOG = LogFactory.getLog(DBUtilsTemplate.class);      public void setDataSource(DataSource dataSource) {        this.dataSource = dataSource;     }      public  QueryRunnergetQueryRunner() {        queryRunner = new QueryRunner(dataSource);        return queryRunner;     }       } 3、在BasicDao中实现通用的查询方法 // queryWhere="where name=? and age=?"          publicQueryResult<T> pageQuery(int startindex,int pagesize,StringqueryWhere,Object queryParams[]){                                       QueryResult<T>queryResult = new QueryResult<T>();                    try{                             List<T>list = null;                             Longtotalrecord = null;                                                         QueryRunnerqueryRunner = db.getQueryRunner();------------>这里实例化new QueryRunner(datasource)的那个类DBUtilsTemplate，是交给spring中的bean打理了，只需在该类中注册DBUtilsTemplate：db就可以了，就是在这样子：                                                           //Stringsql = "select * from customer where limit "                             if(startindex<0|| pagesize<0){                                      //不想分页                                      if(queryWhere==null){