Question

怎么字后台把上几次的查询条件存在一起

Answer 1

public ArrayList<BookBean> serchBook(String name,String author){
ArrayList<BookBean> arrayBookBean = new ArrayList<BookBean>();
conn = new DBConnection();
conn.getMyConnection();
String sql = "select * from book_info_t where book_name like '%"+name+"%' and book_author like '%"+author+"%'";;
arrayBookBean = conn.allBookQuery(sql);
return arrayBookBean;
这是我程序的一段代码，sql 语句用书籍名称和作者来模糊查询书籍的，条件还可以增加。用的oracle数据库，mysql会有细微差别。希望对你有帮助