jdbc 插入记录后返回主键

出处  http://blog.sina.com.cn/s/blog_4b5bc01101019vc3.html

String sql = "insert into ...";
PreparedStatement pstmt = conn.prepareStatement(sql,
Statement.RETURN_GENERATED_KEYS);
pstmt.setString(1, treeNode.getName());
pstmt.execute();
ResultSet rs = pstmt.getGeneratedKeys();
int id = -1;
while (rs.next()) {
id = rs.getInt(1);
}
rs.close();
pstmt.close();