@Override public int find(String typeFeed) { int id = 0; try { Connection cn = null; try { JdbcConnection connection = JdbcConnection.getInstance(); cn = connection.getConnection(); PreparedStatement st = null; try { st = cn.prepareStatement("SELECT * FROM feed WHERE typeFeed = ?"); st.setString(1, typeFeed); ResultSet rs = null; try { rs = st.executeQuery(); if (rs.next()) { id = rs.getInt(1); } } 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 id; }
@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(); } }