Mysql--->PreparedStatement 查询报错
时间:2020-09-26 18:56:03
收藏:0
阅读:60
String sql="select * from t_dept where id = ? and name = ?"; PreparedStatement ps=conn.prepareStatement(sql); ps.setInt(1,id); ps.setString(2,name); System.out.println(ps); ResultSet resultSet = ps.executeQuery(); while(resultSet.next()){ flag++; // //对应的类是自己数据对应的 User user = new User(); user.setId(resultSet.getInt(1)); user.setName(resultSet.getString(2)); System.out.println(user);
ps直接执行ps.executeQuery()不要在括号里写东西
错误示范:ps.executeQuery(sql)
错误示范:ps.executeQuery(sql)
错误示范:ps.executeQuery(sql)
原文:https://www.cnblogs.com/springxian/p/13734610.html
评论(0)