有没有办法从准备好的语句中检索自动增量ID

是。看这里。第7.1.9节。将您的代码更改为：

String sql = "INSERT INTO table (column1, column2) values(?, ?)";stmt = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);stmt.executeUpdate();if(returnLastInsertId) {   ResultSet rs = stmt.getGeneratedKeys();    rs.next();   auto_id = rs.getInt(1);}