author | František Kučera <franta-hg@frantovo.cz> |
Wed Feb 10 21:13:49 2010 +0100 (2010-02-10) | |
changeset 3 | 5a593e2fd7f7 |
parent 2 | d549a4eb6aa9 |
child 4 | 85754d201c93 |
permissions | -rw-r--r-- |
franta-hg@1 | 1 |
package cz.frantovo.springDemo1.dao; |
franta-hg@1 | 2 |
|
franta-hg@2 | 3 |
import cz.frantovo.springDemo1.KnihaDAORemote; |
franta-hg@1 | 4 |
import cz.frantovo.springDemo1.dto.Kniha; |
franta-hg@1 | 5 |
import java.util.ArrayList; |
franta-hg@1 | 6 |
import java.util.Collection; |
franta-hg@1 | 7 |
import javax.annotation.Resource; |
franta-hg@2 | 8 |
import javax.ejb.Stateless; |
franta-hg@1 | 9 |
import javax.sql.DataSource; |
franta-hg@1 | 10 |
import org.springframework.jdbc.core.JdbcTemplate; |
franta-hg@3 | 11 |
import org.springframework.jdbc.support.rowset.SqlRowSet; |
franta-hg@1 | 12 |
|
franta-hg@1 | 13 |
/** |
franta-hg@1 | 14 |
* |
franta-hg@1 | 15 |
* @author fiki |
franta-hg@1 | 16 |
*/ |
franta-hg@2 | 17 |
@Stateless |
franta-hg@2 | 18 |
public class KnihaDAO implements KnihaDAORemote { |
franta-hg@1 | 19 |
|
franta-hg@3 | 20 |
@Resource(mappedName = "jdbc/sqlVyuka/piskoviste") |
franta-hg@1 | 21 |
private DataSource dataSource; |
franta-hg@1 | 22 |
|
franta-hg@1 | 23 |
public Collection<Kniha> getKnihy() { |
franta-hg@1 | 24 |
Collection<Kniha> vysledek = new ArrayList<Kniha>(); |
franta-hg@1 | 25 |
|
franta-hg@1 | 26 |
JdbcTemplate t = new JdbcTemplate(dataSource); |
franta-hg@3 | 27 |
SqlRowSet rs = t.queryForRowSet("SELECT * FROM sbirka.kniha;"); |
franta-hg@3 | 28 |
while (rs.next()) { |
franta-hg@3 | 29 |
Kniha k = new Kniha(); |
franta-hg@3 | 30 |
k.setNazev(rs.getString("nazev")); |
franta-hg@3 | 31 |
k.setAutor(rs.getInt("autor")); |
franta-hg@3 | 32 |
k.setDatumAktualizace(rs.getDate("datum")); |
franta-hg@3 | 33 |
k.setId(rs.getInt("id")); |
franta-hg@3 | 34 |
k.setPocetStran(rs.getInt("pocet_stran")); |
franta-hg@3 | 35 |
k.setRokVydani(rs.getInt("rok_vydani")); |
franta-hg@3 | 36 |
vysledek.add(k); |
franta-hg@3 | 37 |
} |
franta-hg@1 | 38 |
|
franta-hg@1 | 39 |
return vysledek; |
franta-hg@1 | 40 |
} |
franta-hg@1 | 41 |
} |