http://www.brentozar.com/archive/2009/09/whats-on-my-bookshelf/
// insert row AND retrieve key int rowcount = stmt.executeUpdate( "INSERT INTO LocalGeniusList (name) VALUES ('Karen')", Statement.RETURN_GENERATED_KEYS); ResultSet rs = stmt.getGeneratedKeys(); // key is available for future queries