Question: I want to get the value of the last ID insert in a table. How I can do this?

Answer: 
Well the solution that I use is:

```
select id from NEW TABLE (insert into (val1, val2, ...) values ('lorem', 'ipsum', ...))

```

This gets the id column from the last row inserted in the DB :)
```
int keyId = -1;
preparedStatement.executeUpdate();
resultSet = preparedStatement.getGeneratedKeys();
if (resultSet.next()) {
    keyId = rs.getInt(1);
}

```

<https://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#getGeneratedKeys()>

Update: and don't forget to create preparedStatement with the following flag `Statement.RETURN_GENERATED_KEYS` otherwise it won't work)))