public List<ClientBean> getClients() {
String query = "select id, firstname, lastname, email, phonenumber from clients;";
Statement statement = null;
try {
statement = connection.createStatement();
final ResultSet resultSet = statement.executeQuery(query);
List<ClientBean> result = new ArrayList<>();
boolean hasNext = resultSet.first();
while (hasNext) {
int id = resultSet.getInt(1);
ClientBean client = new ClientBean(id);
String firstName = resultSet.getString(1);
client.setFirstName(firstName);
String lastName = resultSet.getString(2);
client.setLastName(lastName);
String email = resultSet.getString(3);
client.setEmail(email);
String phoneNumber = resultSet.getString(4);
client.setPhone(phoneNumber);
result.add(client);
hasNext = resultSet.next();
}
return result;
} catch (SQLException e) {
e.printStackTrace();
}
return new ArrayList<>();
}
public ClientBean getClient(int id) {
String query = "select id, firstname, lastname, email, phonenumber from clients where id=?;";
try {
final PreparedStatement preparedStatement = connection.prepareStatement(query);
preparedStatement.setInt(1, id);
final ResultSet resultSet = preparedStatement.executeQuery();
if (resultSet.first()) {
ClientBean client = new ClientBean(id);
String firstName = resultSet.getString(2);
client.setFirstName(firstName);
String lastName = resultSet.getString(3);
client.setLastName(lastName);
String email = resultSet.getString(4);
client.setEmail(email);
String phoneNumber = resultSet.getString(5);
client.setPhone(phoneNumber);
return client;
}
} catch (SQLException e) {
e.printStackTrace();
}
return new ClientBean();
}