Beispiel #1
0
 public ProductStock mapRow(ResultSet resultSet, int arg1) throws SQLException {
   ProductStock productStock = new ProductStock();
   Product product = new Product();
   product.setProductId(resultSet.getLong("product_id"));
   productStock.setGoodBalance(resultSet.getLong("good_balance"));
   productStock.setDefBalance(resultSet.getLong("def_balance"));
   productStock.setProduct(product);
   return productStock;
 }
Beispiel #2
0
 @Override
 public void updateProductStock(ProductStock productStock) throws OmsDataAccessException {
   try {
     jdbcTemplate.update(
         updateProductStockQuery,
         new Object[] {
           productStock.getGoodBalance(),
           productStock.getDefBalance(),
           productStock.getProduct().getProductId()
         });
   } catch (DataAccessException dae) {
     throw new OmsDataAccessException(dae);
   }
 }
Beispiel #3
0
    public ProductStock mapRow(ResultSet resultSet, int arg1) throws SQLException {
      ProductStock productStock = new ProductStock();
      productStock.setId(resultSet.getLong("id"));
      productStock.setGoodBalance(resultSet.getLong("good_balance"));
      productStock.setDefBalance(resultSet.getLong("def_balance"));
      productStock.setLastModified(resultSet.getString("last_modified"));
      Product product = new Product();
      product.setProductId(resultSet.getLong("product_id"));
      product.setProductName(resultSet.getString("product_name"));
      Category category = new Category();
      category.setCategoryId(resultSet.getLong("category_id"));
      category.setCategoryName(resultSet.getString("category_name"));
      product.setCategory(category);
      productStock.setProduct(product);

      return productStock;
    }