Пример #1
0
 @Override
 public boolean insert(Connection connection, Category category) throws SQLException {
   Integer newId =
       insertQuery(connection, SQL_INSERT_QUERY, category.getName(), category.getImageUrl());
   setId(category, newId);
   return newId != null;
 }
Пример #2
0
 @Override
 public List<Category> select(Connection connection, String query, Object... args)
     throws SQLException {
   List<Category> categories = new ArrayList<>();
   ResultSet rs = selectQuery(connection, query, args);
   Category category;
   while (rs.next()) {
     category = ENTITY_FACTORY.createCategory();
     setId(category, rs.getInt("id"));
     category.setName(rs.getString("name"));
     category.setImageUrl(rs.getString("image_url"));
     categories.add(SynchronizedWrapperUtils.wrap(category));
   }
   return categories;
 }
Пример #3
0
 @Override
 public boolean update(Connection connection, int id, Category category) throws SQLException {
   return changeQuery(
       connection, SQL_UPDATE_QUERY, category.getName(), category.getImageUrl(), id);
 }