Value of auto-increment column after insert

[Rob Sworder]

I've used the following code in php to get the auto-incremented primary key column value returned after an insert:
$sql = "insert into mytable (columnB) values ('Test')";
$columnA = mysql_insert_id();
I haven't been able to repeat this in Java. I have tried:
int columnA;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rst = stmt.executeQuery("select * from mytable");
rst.moveToInsertRow();
rst.updateString(2, 'Test');
rst.insertRow();
columnA = rst.getInt(1);
//For a table:
// create table mytable (columnA int auto_increment primary key,
// columnB varchar(10));
Many Thanks

[Rob Sworder]

Found answer:
http://www.coderanch.com/t/298459/JDBC/java/last-insert-id
Moral: use search before posting!

[Gregg Bolinger]

There is a better way.

Statement stmt.executeUpdate("INSERT STATEMENT HERE", Statement.RETURN_GENERATED_KEYS);
ResultSet rs = stmt.getGeneratedKeys();

This is much cleaner than the approach you found.