1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/java/HrisniciSpameri/src/java/cz/frantovo/hrisniciSpameri/dao/CilDAO.java	Wed Feb 11 22:25:09 2009 +0100
     1.3 @@ -0,0 +1,52 @@
     1.4 +package cz.frantovo.hrisniciSpameri.dao;
     1.5 +
     1.6 +import cz.frantovo.hrisniciSpameri.dto.Cil;
     1.7 +import java.sql.Connection;
     1.8 +import java.sql.PreparedStatement;
     1.9 +import java.sql.ResultSet;
    1.10 +import java.util.ArrayList;
    1.11 +import java.util.Collection;
    1.12 +import java.util.logging.Level;
    1.13 +
    1.14 +/**
    1.15 + *
    1.16 + * @author fiki
    1.17 + */
    1.18 +public class CilDAO extends HrisniciSuperDAO {
    1.19 +
    1.20 +    private enum SQL {
    1.21 +
    1.22 +        VSECHNY_CILE
    1.23 +    }
    1.24 +
    1.25 +    public Collection<Cil> getCile() {
    1.26 +        Collection<Cil> cile = new ArrayList<Cil>();
    1.27 +
    1.28 +        Connection db = getSpojeni(null);
    1.29 +        if (db == null) {
    1.30 +            return null;
    1.31 +        } else {
    1.32 +            PreparedStatement ps = null;
    1.33 +            ResultSet rs = null;
    1.34 +            try {
    1.35 +                ps = db.prepareStatement(getSQL(SQL.VSECHNY_CILE));
    1.36 +                rs = ps.executeQuery();
    1.37 +                while (rs.next()) {
    1.38 +                    Cil c = new Cil();
    1.39 +                    c.setId(rs.getInt("id"));
    1.40 +                    c.setNazev(rs.getString("nazev"));
    1.41 +                    c.setUrl(rs.getString("url"));
    1.42 +                    c.setSelekt(rs.getString("selekt"));
    1.43 +                    c.setDatabaze(rs.getString("databaze"));
    1.44 +                    cile.add(c);
    1.45 +                }
    1.46 +            } catch (Exception e) {
    1.47 +                log.log(Level.SEVERE, "Chyba při získávání seznamu cílů z databáze", e);
    1.48 +            } finally {
    1.49 +                zavri(db, ps, rs);
    1.50 +            }
    1.51 +        }
    1.52 +
    1.53 +        return cile;
    1.54 +    }
    1.55 +}