iVira.name

Java tips: get last inserted autoincrement fields

September 6th, 2007 vira Posted in Computer science | No Comments »

To get last inserted autoincrement fields using JDBC you should write something like this:

ResultSet resultSet = statement.getGeneratedKeys();
int newId=0;
if ( resultSet != null && resultSet.next() )
{
newId = resultSet.getInt(1);
}

And don’t forget to add Statement.RETURN_GENERATED_KEYS parameter when create statement.

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.