@Override
public List<Customer> getList() throws SQLException {
String sql;
sql = "SELECT * FROM 'customer';";
System.out.println(sql);
Statement stmt = dbConnection.getConn().createStatement();
ResultSet rs = stmt.executeQuery(sql);
ArrayList<Customer> kundenarray = new ArrayList<Customer>();
while (rs.next()) {
Customer kunde =
new Customer(
rs.getInt("customerId"),
rs.getString("name"),
rs.getString("firstName"),
rs.getString("address"),
rs.getString("zip"),
rs.getString("city"),
rs.getString("phoneNo"),
rs.getString("eMail"));
kunde.setPets(new PetDataMapper().getPetsFromCustomer(kunde.getCustomerId()));
kundenarray.add(kunde);
}
return kundenarray;
}
@Override
public void save(Customer entry) throws SQLException, ValidationException {
entry.validate();
if (entry.getCustomerId() <= 0) {
entry.setCustomerId(insert(entry));
} else {
update(entry);
}
}
@Override
public void delete(Customer entry) throws SQLException {
// Beziehungen zum Tier entfernen
for (Pet t : entry.getPets()) {
t.setFkCustomer(-1);
try {
new PetDataMapper().save(t);
} catch (ValidationException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
String sql;
sql = "DELETE FROM 'customer' WHERE customerId = " + entry.getCustomerId() + ";";
System.out.println(sql);
Statement stmt = dbConnection.getConn().createStatement();
stmt.executeUpdate(sql);
}