/*
wyświetlenie zawartości lodówki w formie listy
*/
public List<Fridge> getAllProducts(int userid) {
List<Fridge> products = new ArrayList<Fridge>();
try {
PreparedStatement preparedStatement =
connection.prepareStatement("select * from fridge where userid=?");
preparedStatement.setInt(1, userid);
ResultSet rs = preparedStatement.executeQuery();
// ResultSet rs = preparedStatement.executeQuery();
// Statement statement = connection.createStatement();
// ResultSet rs = statement.executeQuery("select * from fridge where userid=?");
while (rs.next()) {
// wypełnianie listy
Fridge product = new Fridge();
product.setProductID(rs.getInt("ProductID"));
product.setName(rs.getString("ProductName"));
product.setAmount(rs.getInt("ProductAmount"));
product.setUserID(rs.getInt("UserID"));
products.add(product);
}
} catch (SQLException e) {
e.printStackTrace();
}
return products;
}
/*
uaktualnienie danych nt. produktu w lodówce
*/
public void updateFridge(Fridge fridge) {
try {
PreparedStatement preparedStatement =
connection.prepareStatement(
"update fridge set ProductName=?, ProductAmount=?" + " where ProductID=?");
preparedStatement.setString(1, fridge.getName());
preparedStatement.setInt(2, fridge.getAmount());
preparedStatement.setInt(3, fridge.getProductID());
preparedStatement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
/*dodawanie produktu do lodówki
Atrybuty: nazwa składnika (varchar) - ProductName
ilość (int) - ProductAmount
Użytkownik wprowadza posiadane pokarmy wraz z ich ilością.
*/
public void addProduct(Fridge fridge) {
try {
PreparedStatement preparedStatement =
connection.prepareStatement(
"insert into fridge(ProductName,ProductAmount, UserID) values (?, ?, ? )");
preparedStatement.setString(1, fridge.getName());
preparedStatement.setInt(2, fridge.getAmount());
preparedStatement.setInt(3, fridge.getUserID());
preparedStatement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
/*
wyświetlenie jednego produktu na podstawie ID
*/
public Fridge getProductById(int ProductID) {
Fridge product = new Fridge();
try {
PreparedStatement preparedStatement =
connection.prepareStatement("select * from fridge where ProductID=?");
preparedStatement.setInt(1, ProductID);
ResultSet rs = preparedStatement.executeQuery();
if (rs.next()) {
product.setProductID(rs.getInt("ProductID"));
product.setName(rs.getString("ProductName"));
product.setAmount(rs.getInt("ProductAmount"));
product.setUserID(rs.getInt("UserID"));
}
} catch (SQLException e) {
e.printStackTrace();
}
return product;
}