Java+Mysql的数据库查找实现

public class select {
 public List XiuGai_select(String keyword){
  List list=new ArrayList();
        Connection conn = null;
  Statement stmt = null;
  String sql=null;
  ResultSet res = null;
  getConnection b=new getConnection();
  conn=b.getconnection(); 
  sql="select * from book where bookName like'%"+keyword+"%'";
  try {
   stmt = conn.createStatement();
   res=stmt.executeQuery(sql);
   while (res.next()) {                                    //如果结果集不为空，那么取出值输出
       int id = res.getInt("id");
       String bookName= res.getString("bookName");
       String author= res.getString("author");
       String publisher= res.getString("publisher");
       int isBorrow=res.getInt("isBorrow");
       int isRenew=res.getInt("isRenew");
       Date dateOfBorrow=res.getDate("dateOfBorrow");
       int numberOfBook=res.getInt("numberOfBook");
       int numberOfNow=res.getInt("numberOfNow");
       int userId=res.getInt("userId");
       Book book = new Book(id,bookName,author,publisher,isBorrow,isRenew,dateOfBorrow,numberOfBook,numberOfNow,userId);
       list.add(book);
       
       System.out.println(id);
       System.out.println(b