多条件查询数据库Dao

package com.mkk.goods.books.bookDao;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

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

import com.mkk.goods.books.domain.Book;
import com.mkk.goods.paper.Expression;
import com.mkk.goods.paper.Page;
import com.mkk.goods.paper.PageConstant;

import cn.itcast.jdbc.TxQueryRunner;

/*
 * 图书相关数据库操作
 */
public class BookDao {
	QueryRunner queryRunner = new TxQueryRunner();
	
	/**********************具体的查询方法 *************************************/
	
	/*
	 * 5.多条件查询
	 */
	public Page<Book> findByThreeCriteria(Book book,int pageNow) throws SQLException{
		List<Expression> listEx=new ArrayList<Expression>();
		listEx.add(new Expression("author","like","%"+book.getAuthor()+"%"));
		listEx.add(new Expression("bname","like","%"+book.getBname()+"%"));
		listEx.add(new Expression("press","like","%"+book.getPress()+"%"));
		return findByCriteria(listEx, pageNow);
	}
	
	/*
	 * 4.按出版社查询
	 * 
	 */
	public Page<Book> findByPress(String press,int pageNow) throws SQLException{
		List<Expression> listEx=new ArrayList<Expression>();
		listEx.add(new Expression("press","like","%"+press+"%"));
		return findByCriteria(listEx, pageNow);
	}
	
	
	/*
	 * 3.按作者查询
	 */
	public Page<Book> findByAuthor(String author,int pageNow) throws SQLException{
		List<Expression> listEx=new ArrayList<Expression>();
		listEx.add(new Expression("author","like","%"+author+"%"));
		return findByCriteria(listEx, pageNow);
	}
	
	/*
	 * 2.按书名查询
	 */
	public Page<Book> findB