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
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!