author | František Kučera <franta-hg@frantovo.cz> |
Wed, 11 Feb 2009 22:25:09 +0100 | |
changeset 6 | 38625daa449b |
permissions | -rw-r--r-- |
franta-hg@6 | 1 |
package cz.frantovo.hrisniciSpameri.dao; |
franta-hg@6 | 2 |
|
franta-hg@6 | 3 |
import cz.frantovo.hrisniciSpameri.dto.Cil; |
franta-hg@6 | 4 |
import java.sql.Connection; |
franta-hg@6 | 5 |
import java.sql.PreparedStatement; |
franta-hg@6 | 6 |
import java.sql.ResultSet; |
franta-hg@6 | 7 |
import java.util.ArrayList; |
franta-hg@6 | 8 |
import java.util.Collection; |
franta-hg@6 | 9 |
import java.util.logging.Level; |
franta-hg@6 | 10 |
|
franta-hg@6 | 11 |
/** |
franta-hg@6 | 12 |
* |
franta-hg@6 | 13 |
* @author fiki |
franta-hg@6 | 14 |
*/ |
franta-hg@6 | 15 |
public class CilDAO extends HrisniciSuperDAO { |
franta-hg@6 | 16 |
|
franta-hg@6 | 17 |
private enum SQL { |
franta-hg@6 | 18 |
|
franta-hg@6 | 19 |
VSECHNY_CILE |
franta-hg@6 | 20 |
} |
franta-hg@6 | 21 |
|
franta-hg@6 | 22 |
public Collection<Cil> getCile() { |
franta-hg@6 | 23 |
Collection<Cil> cile = new ArrayList<Cil>(); |
franta-hg@6 | 24 |
|
franta-hg@6 | 25 |
Connection db = getSpojeni(null); |
franta-hg@6 | 26 |
if (db == null) { |
franta-hg@6 | 27 |
return null; |
franta-hg@6 | 28 |
} else { |
franta-hg@6 | 29 |
PreparedStatement ps = null; |
franta-hg@6 | 30 |
ResultSet rs = null; |
franta-hg@6 | 31 |
try { |
franta-hg@6 | 32 |
ps = db.prepareStatement(getSQL(SQL.VSECHNY_CILE)); |
franta-hg@6 | 33 |
rs = ps.executeQuery(); |
franta-hg@6 | 34 |
while (rs.next()) { |
franta-hg@6 | 35 |
Cil c = new Cil(); |
franta-hg@6 | 36 |
c.setId(rs.getInt("id")); |
franta-hg@6 | 37 |
c.setNazev(rs.getString("nazev")); |
franta-hg@6 | 38 |
c.setUrl(rs.getString("url")); |
franta-hg@6 | 39 |
c.setSelekt(rs.getString("selekt")); |
franta-hg@6 | 40 |
c.setDatabaze(rs.getString("databaze")); |
franta-hg@6 | 41 |
cile.add(c); |
franta-hg@6 | 42 |
} |
franta-hg@6 | 43 |
} catch (Exception e) { |
franta-hg@6 | 44 |
log.log(Level.SEVERE, "Chyba při získávání seznamu cílů z databáze", e); |
franta-hg@6 | 45 |
} finally { |
franta-hg@6 | 46 |
zavri(db, ps, rs); |
franta-hg@6 | 47 |
} |
franta-hg@6 | 48 |
} |
franta-hg@6 | 49 |
|
franta-hg@6 | 50 |
return cile; |
franta-hg@6 | 51 |
} |
franta-hg@6 | 52 |
} |