PreparedStatement.RETURN_GENERATED_KEYS 获取自动生成的id号
//...
String sql=" sql语句 ";//sql语句
//...
PreparedStatement pstmt = con.prepareStatement(sql,PreparedStatement.RETURN_GENERATED_KEYS);
//...
//...
//...
ResultSet resultSet =pstmt.getGeneratedKeys();
//获取第一列的值,即你想要的值
Integer a=resultSet.getInt(1);