get id after insert

[sebako]

Hey guys,

I am inserting something into a database table which works fine:

Code: Select all

stmt = con.prepareStatement("INSERT INTO `planet` (`user_id`, `main`, `size`, `type`, `seed`) VALUES (?, ?, ?, ?, ?);");
                stmt.setInt(1, dbId);
                stmt.setInt(2, 1);
                stmt.setInt(3, pl.size);
                stmt.setInt(4, pl.type);
                stmt.setFloat(5, pl.seed);
                stmt.execute();

now my question is how I would get the Id (primary key) of the inserted field without querying it again directly? Is that possible?

Thanks

Seb

[rjgtav]

hi. Unfortunately i think the only way is querying it. Maybe some1 knows another way?

[kincade]

If your DB is MySQL then you can try the following:

Code: Select all

connection = connectionPool_.getConnection();
String query = "INSERT INTO event (title, type) VALUES (?, ?)";      
PreparedStatement statement = connection.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);
statement.setString(1, event.getTitle());
statement.setInt(2, event.getType());
statement.executeUpdate();        
// get event id
ResultSet keys = statement.getGeneratedKeys();   
keys.next();
int eventId = keys.getInt(1);

For other DB vendors there should be something similar - just google it.

[sebako]

alright this works - thanks kincade