PreparedStatement pstmt = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
ResultSet rsKey = pstmt.getGeneratedKeys();
rsKey.next();
int key = rsKey.getInt(1);
stmt.executeUpdate("update article set rootid = " + key + " where id = " + key);
JDBC中取得mysql自动递增的id号
最新推荐文章于 2022-11-01 07:00:00 发布