batch insert get insert id.

https://stackoverflow.com/questions/4224228/preparedstatement-with-statement-return-generated-keys

PreparedStatement preparedStatement = connection.prepareStatement(YOUR_SQL_HERE, PreparedStatement.RETURN_GENERATED_KEYS);
preparedStatement.setXXX(index, VALUE);
preparedStatement.executeUpdate();

ResultSet rs = preparedStatement.getGeneratedKeys();

if (rs.next()) {
    key = rs.getLong(1);
}

ps = connection.prepareStatement(sql, ps.RETURN_GENERATED_KEYS);