iVira.name

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.