java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaDAO.java
DAO pomocí RowMapperu.
1 package cz.frantovo.springDemo1.dao;
3 import cz.frantovo.springDemo1.KnihaDAORemote;
4 import cz.frantovo.springDemo1.dto.Kniha;
5 import java.util.Collection;
6 import javax.annotation.Resource;
7 import javax.ejb.Stateless;
8 import javax.sql.DataSource;
9 import org.springframework.jdbc.core.JdbcTemplate;
16 public class KnihaDAO implements KnihaDAORemote {
18 @Resource(mappedName = "jdbc/sqlVyuka/piskoviste")
19 private DataSource dataSource;
20 private KnihaRowMapper knihaRowMapper = new KnihaRowMapper();
22 public Collection<Kniha> getKnihy() {
23 JdbcTemplate t = new JdbcTemplate(dataSource);
24 return t.query("SELECT * FROM sbirka.kniha;", knihaRowMapper);