- sql语句不必修改,在填充占位符时将需要模糊查询的字段拼接 % 即可,如下代码
@Override
public List<Book> selectByName(Connection conn, String name) {
String sql = "select * from book where book_name like ?";
return getForList(conn, sql, "%" + name + "%");
}
@Override
public List<Book> selectByName(Connection conn, String name) {
String sql = "select * from book where book_name like ?";
return getForList(conn, sql, "%" + name + "%");
}