Esempio n. 1
0
 @Override
 public Project get(int id) {
   Project result = null;
   try (Connection connection = dbDataSourceProvider.getConnection()) {
     try (PreparedStatement statement = connection.prepareStatement(sqlProvider.get4Load())) {
       statement.setInt(1, id);
       ResultSet resultSet = statement.executeQuery();
       if (resultSet.next()) {
         result =
             new Project(
                 resultSet.getString("name"),
                 resultSet.getInt("goal"),
                 resultSet.getDate("deadline_date"));
         result.setShortDescription(resultSet.getString("description"));
         result.setBalance(resultSet.getInt("balance"));
         result.setDemoLink(resultSet.getString("demo_link"));
         result.setCreateDate(resultSet.getDate("create_date"));
         result.setId(id);
       }
     }
     connection.commit();
   } catch (SQLException e) {
     throw new RuntimeException(e);
   }
   return result;
 }
Esempio n. 2
0
 @Override
 public List<Project> fetch(int categoryId) {
   List<Project> result = new ArrayList<>();
   try (Connection connection = dbDataSourceProvider.getConnection();
       PreparedStatement statement = connection.prepareStatement(sqlProvider.get4Fetch())) {
     statement.setInt(1, categoryId);
     ResultSet resultSet = statement.executeQuery();
     while (resultSet.next()) {
       Project project =
           new Project(
               resultSet.getString("project_name"),
               resultSet.getInt("goal"),
               resultSet.getDate("deadline_date"));
       project.setShortDescription(resultSet.getString("short_description"));
       project.setId(resultSet.getInt("id"));
       project.setBalance(resultSet.getInt("balance"));
       result.add(project);
     }
     connection.commit();
   } catch (SQLException e) {
     throw new RuntimeException(e);
   }
   return result;
 }