public static Seller get(int id) {
Seller seller = new Seller();
String query = "Select * from Sellers where id=" + id;
try {
ResultSet result = statement.executeQuery(query);
if (result.next()) {
seller.setId(result.getInt(1));
seller.setName(result.getString(2));
seller.setSurname(result.getString(3));
seller.setPassword(result.getString(4));
}
} catch (SQLException e) {
return null;
}
return seller;
}
public static List<Seller> getAll() {
List<Seller> list = new ArrayList<Seller>();
String query = "Select * from Sellers";
try {
ResultSet result = statement.executeQuery(query);
while (result.next()) {
Seller seller = new Seller();
seller.setId(result.getInt(1));
seller.setName(result.getString(2));
seller.setSurname(result.getString(3));
seller.setPassword(result.getString(4));
list.add(seller);
}
} catch (SQLException e) {
}
return list;
}