/** * Add client record to persistent store. * * @param toAdd client to add * @return id of added client, or -1 if an error occurred */ public int addClient(ClientBean toAdd) { String insertStatement = "insert into clients (firstname, lastname, email, phonenumber) values (?,?,?,?);"; try { PreparedStatement statement = connection.prepareStatement(insertStatement, Statement.RETURN_GENERATED_KEYS); statement.setNString(1, toAdd.getFirstName()); statement.setNString(2, toAdd.getLastName()); statement.setNString(3, toAdd.getEmail()); statement.setNString(4, toAdd.getPhone()); statement.executeUpdate(); ResultSet generatedKeys = statement.getGeneratedKeys(); if (generatedKeys.first()) { return generatedKeys.getInt(1); } } catch (SQLException e) { e.printStackTrace(); } return -1; }