/**
* Get a customer by id
*
* @param id customer id
* @return a customer
*/
public Customer getACustomer(int id) {
String sql = "Select * From Customer where cid = ?";
try {
PreparedStatement statement = (PreparedStatement) connection.prepareStatement(sql);
statement.setInt(1, id);
ResultSet rs = statement.executeQuery();
if (rs.next()) {
Customer customer = new Customer();
customer.setEmail(rs.getString("email"));
customer.setFirstName(rs.getString("firstName"));
customer.setLastName(rs.getString("lastName"));
customer.setId(rs.getInt("cid"));
if (statement != null) statement.close();
return customer;
} else {
return null;
}
} catch (SQLException e) {
e.printStackTrace();
System.out.println("Error at get a customer");
return null;
}
}
