Пример #1
0
 @Override
 public ImagesPage findByIdWithoutData(int idImg) {
   ImagesPage image = null;
   String sql = "SELECT * FROM imagespages WHERE id=" + idImg;
   try {
     conn = myDataSource.getConnection();
     Statement stat = conn.createStatement();
     ResultSet rs = stat.executeQuery(sql);
     if (rs.next()) {
       image = new ImagesPage();
       image.setId(rs.getInt(1));
       image.setDirectory(rs.getString(5));
       image.setFilename(rs.getString(4));
       image.setIdPageText(rs.getInt(3));
     }
   } catch (SQLException ex) {
     LOG.log(Level.SEVERE, null, ex);
   } finally {
     try {
       conn.close();
     } catch (SQLException ex) {
       LOG.log(Level.SEVERE, null, ex);
     }
   }
   return image;
 }
Пример #2
0
 @Override
 public List<ImagesPage> findAllWithoutData() {
   List<ImagesPage> imagesList = new ArrayList<>();
   ImagesPage image = null;
   String sql = "SELECT * FROM imagespages";
   Statement stat = null;
   ResultSet rs = null;
   try {
     conn = myDataSource.getConnection();
     stat = conn.createStatement();
     rs = stat.executeQuery(sql);
     while (rs.next()) {
       image = new ImagesPage();
       image.setId(rs.getInt(1));
       image.setDirectory(rs.getString(5));
       image.setFilename(rs.getString(4));
       image.setIdPageText(rs.getInt(3));
       imagesList.add(image);
     }
   } catch (SQLException ex) {
     LOG.log(Level.SEVERE, null, ex);
   } finally {
     try {
       stat.close();
       rs.close();
       conn.close();
     } catch (SQLException ex) {
       LOG.log(Level.SEVERE, null, ex);
     }
   }
   return imagesList;
 }