diff -r 5a593e2fd7f7 -r 85754d201c93 java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaDAO.java --- a/java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaDAO.java Wed Feb 10 21:13:49 2010 +0100 +++ b/java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaDAO.java Wed Feb 10 21:23:45 2010 +0100 @@ -2,13 +2,11 @@ import cz.frantovo.springDemo1.KnihaDAORemote; import cz.frantovo.springDemo1.dto.Kniha; -import java.util.ArrayList; import java.util.Collection; import javax.annotation.Resource; import javax.ejb.Stateless; import javax.sql.DataSource; import org.springframework.jdbc.core.JdbcTemplate; -import org.springframework.jdbc.support.rowset.SqlRowSet; /** * @@ -19,23 +17,10 @@ @Resource(mappedName = "jdbc/sqlVyuka/piskoviste") private DataSource dataSource; + private KnihaRowMapper knihaRowMapper = new KnihaRowMapper(); public Collection getKnihy() { - Collection vysledek = new ArrayList(); - JdbcTemplate t = new JdbcTemplate(dataSource); - SqlRowSet rs = t.queryForRowSet("SELECT * FROM sbirka.kniha;"); - while (rs.next()) { - Kniha k = new Kniha(); - k.setNazev(rs.getString("nazev")); - k.setAutor(rs.getInt("autor")); - k.setDatumAktualizace(rs.getDate("datum")); - k.setId(rs.getInt("id")); - k.setPocetStran(rs.getInt("pocet_stran")); - k.setRokVydani(rs.getInt("rok_vydani")); - vysledek.add(k); - } - - return vysledek; + return t.query("SELECT * FROM sbirka.kniha;", knihaRowMapper); } }