java模糊查询数据库出错,请指教

来源:百度知道 编辑:UC知道 时间:2024/06/23 09:22:06
//1.获得连接对象
Connection conn = DataBaseManager.getConnection();
//2.查询SQL语句
String querySql = "select * from cb_user where name like %?%";
PreparedStatement pstmt = null;
ResultSet rs = null;
List<User> users = null;

//3.通过连接对象获得预处理语句对象
try {
pstmt = conn.prepareStatement(querySql);
//4.设置参数
pstmt.setString(1, name);
//5.执行查询
rs = pstmt.executeQuery();
users = new ArrayList<User>();
while(rs.next()) {
User user = new User();
user = new User();
user.setId(rs.getInt(1));
user.setUsername(rs.getString(2));
user.setUserpwd(rs.getString(3));
user.setDuserpwd(rs.getString(4));
user.setName(rs.getString(5));
user.setSex(rs.getString(6));
user.setDepartment(rs.getString(7));
user.setPower(rs.getString(8));
user.setBirthday(rs.getString(9));<

String querySql = "select * from cb_user where name like %?%";
换成
String querySql = "select * from cb_user where name like ?";

pstmt.setString(1, name);
换成
pstmt.setString(1, "%"+name+"%");

SQL语法错误。看你的查询语句是怎么写的。。。