Пример #1
0
  @Override
  public void create(Feed feed) {
    try {
      Connection cn = null;
      try {
        cn = JdbcConnection.getInstance().getConnection();
        PreparedStatement st = null;
        try {
          st =
              cn.prepareStatement(
                  "INSERT INTO feed (typeFeed, valueFeed) values (?, ?)",
                  Statement.RETURN_GENERATED_KEYS);
          st.setString(1, feed.name());
          st.setString(2, feed.getValueFeed());
          st.executeUpdate();

        } finally {
          if (st != null) st.close();
          st = null;
        }
      } finally {
        if (cn != null) cn.close();
        cn = null;
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }
Пример #2
0
  @Override
  public void update(int id, Feed feed) {
    try {
      Connection cn = null;
      try {
        JdbcConnection connection = JdbcConnection.getInstance();
        cn = connection.getConnection();
        PreparedStatement st = null;
        try {
          st =
              cn.prepareStatement("UPDATE feed SET (typeFeed = ?, valueFeed = ?) WHERE idFeed = ?");
          st.setString(1, feed.name());
          st.setString(2, feed.getValueFeed());
          st.setInt(3, id);
          st.executeUpdate();

        } finally {
          if (st != null) st.close();
          st = null;
        }
      } finally {
        if (cn != null) cn.close();
        cn = null;
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }
Пример #3
0
 @Override
 public Feed find(int id) {
   Feed feed = null;
   try {
     Connection cn = null;
     try {
       JdbcConnection connection = JdbcConnection.getInstance();
       cn = connection.getConnection();
       PreparedStatement st = null;
       try {
         st = cn.prepareStatement("SELECT * FROM feed WHERE idFeed = ?");
         st.setInt(1, id);
         ResultSet rs = null;
         try {
           rs = st.executeQuery();
           if (rs.next()) {
             feed = Feed.valueOf(rs.getString(2));
           }
         } finally {
           if (rs != null) rs.close();
           rs = null;
         }
       } finally {
         if (st != null) st.close();
         st = null;
       }
     } finally {
       if (cn != null) cn.close();
       cn = null;
     }
   } catch (SQLException e) {
     e.printStackTrace();
   }
   return feed;
 }
Пример #4
0
  @Override
  public List<Feed> findAll() {
    List<Feed> feeds = new ArrayList<Feed>();

    try {
      Connection cn = null;
      try {
        cn = JdbcConnection.getInstance().getConnection();
        Statement st = null;
        try {
          st = cn.createStatement();
          ResultSet rs = null;
          try {
            rs = st.executeQuery("SELECT * FROM feed ");
            while (rs.next()) {
              feeds.add(Feed.valueOf(rs.getString(2)));
            }
          } finally {
            if (rs != null) rs.close();
            rs = null;
          }
        } finally {
          if (st != null) st.close();
          st = null;
        }
      } finally {
        if (cn != null) cn.close();
        cn = null;
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return feeds;
  }