package cz.frantovo.hrisniciSpameri.dao;

 import cz.frantovo.hrisniciSpameri.dto.Cil;

 import java.sql.Connection;

 import java.sql.PreparedStatement;

 import java.sql.ResultSet;

 import java.util.ArrayList;

 import java.util.Collection;

 import java.util.logging.Level;

 /**

  *

  * @author fiki

  */

 public class CilDAO extends HrisniciSuperDAO {

     private enum SQL {

         VSECHNY_CILE

     }

     public Collection<Cil> getCile() {

         Collection<Cil> cile = new ArrayList<Cil>();

         Connection db = getSpojeni(null);

         if (db == null) {

             return null;

         } else {

             PreparedStatement ps = null;

             ResultSet rs = null;

             try {

                 ps = db.prepareStatement(getSQL(SQL.VSECHNY_CILE));

                 rs = ps.executeQuery();

                 while (rs.next()) {

                     Cil c = new Cil();

                     c.setId(rs.getInt("id"));

                     c.setNazev(rs.getString("nazev"));

                     c.setUrl(rs.getString("url"));

                     c.setSelekt(rs.getString("selekt"));

                     c.setDatabaze(rs.getString("databaze"));

                     cile.add(c);

                 }

             } catch (Exception e) {

                 log.log(Level.SEVERE, "Chyba při získávání seznamu cílů z databáze", e);

             } finally {

                 zavri(db, ps, rs);

             }

         }

         return cile;

     }

 }