JDBC主键回显

主要实现类Starement.RETURN_GENERATED_KEYS,getGeneratedKeys

public class PSOtherPart {
    /**
     * PS特殊使用--主键回显
     */
    @Test
    public void PrimaryKeyReturn() throws Exception {
        //1.注册驱动
        Class.forName("com.mysql.cj.jdbc.Driver");
        //2.建立连接
        Connection connection = DriverManager.getConnection("jdbc:mysql:///atguigu", "root", "123456");
        //3.创建sql语句
        String sql = "insert into t_user(account,password,nickname) values(?,?,?)";
        //4.创建prepareStatement，Statement接口调用运回主键方法
         PreparedStatement statement = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
        statement.setObject(1,"diingzhen");
        statement.setObject(2,"1234");
        statement.setObject(3,"理塘王");
        //返回修改条数
        int i = statement.executeUpdate();
        //判断条数
        if(i > 0){
            System.out.println("插入成功");
            ResultSet resultSet = statement.getGeneratedKeys();
            //指针移动到数据上
            resultSet.next();
            //取一行一列的数据
            int id = resultSet.getInt(1);
            System.out.println("id=" + id);
            //5.回收
            resultSet.close();
            statement.close();

        }else{
            System.out.println("插入失败");
        }

        

    }
}