/**
* 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;
}
