Return id after sql insert java

Asked Aug 08 '16 at 13:12

Active Aug 08 '16 at 13:19

Viewed 38 times

After inserting data into my database the database automatically generates and ID which I would like to get returned to me. But I have no idea how...

public Integer addPerson(person p) throws DBException {
    try (Connection conn = ConnectionManager.getConnection();) {
        try (PreparedStatement stmt = conn.prepareStatement(
                "insert into klant(name, date) values (?,?)");) {
            stmt.setString(1, p.getName());
            stmt.setObject(2, Date.valueOf(p.getDate()));
            stmt.execute();
        } catch (SQLException s) {
            throw new DBException(s);
        }

    } catch (SQLException s) {
        throw new DBException(s);
    }
    return id_generated_by_db;
}

asked Aug 08 '16 at 13:12

Jirne Van Camp

You could use the "RETURNING " clause (if you are using PostgreSQL) – TheLostMind Aug 08 '16 at 13:16
Use another query `"SELECT id FROM klant WHERE name=" + p.getName() + " AND date=" + Date.valueOf(p.getDate())` – CloudPotato Aug 08 '16 at 13:17
@Blobonat That's more of an emergency solution... You never know two people have the same name and are born on the same date (unlikely but plausible) – Jirne Van Camp Aug 08 '16 at 13:19
@JirneVanCamp You could order it by the id and only take the last entry, but yes it is not a very nice solution. – CloudPotato Aug 08 '16 at 13:25
There's no need to argue when JDBC has a standard solution. – Kayaman Aug 08 '16 at 13:25
This DBMS specific (e.g. MS SQL : @@identity) – Serg Aug 08 '16 at 13:27

Return id after sql insert java

0 Answers0