Example #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;
 }
Example #2
0
 @Override
 public void setBalance(int projectId, int amount) {
   try (Connection connection = dbDataSourceProvider.getConnection();
       PreparedStatement statement = connection.prepareStatement(sqlProvider.get4SetBalance())) {
     statement.setInt(1, amount);
     statement.setInt(2, projectId);
     statement.executeUpdate();
     connection.commit();
   } catch (SQLException e) {
     throw new RuntimeException(e);
   }
 }
Example #3
0
 @Override
 public int getBalance(int projectId) {
   int result = 0;
   try (Connection connection = dbDataSourceProvider.getConnection();
       PreparedStatement statement = connection.prepareStatement(sqlProvider.get4GetBalance())) {
     statement.setInt(1, projectId);
     ResultSet resultSet = statement.executeQuery();
     if (resultSet.next()) {
       result = resultSet.getInt("balance");
     }
     connection.commit();
   } catch (SQLException e) {
     throw new RuntimeException(e);
   }
   return result;
 }
Example #4
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;
 }