java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaDAO.java
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaDAO.java Wed Feb 10 20:55:08 2010 +0100
1.3 @@ -0,0 +1,38 @@
1.4 +package cz.frantovo.springDemo1.dao;
1.5 +
1.6 +import cz.frantovo.springDemo1.dto.Kniha;
1.7 +import java.util.ArrayList;
1.8 +import java.util.Collection;
1.9 +import javax.annotation.Resource;
1.10 +import javax.sql.DataSource;
1.11 +import org.springframework.jdbc.core.JdbcTemplate;
1.12 +import org.springframework.stereotype.Repository;
1.13 +
1.14 +/**
1.15 + *
1.16 + * @author fiki
1.17 + */
1.18 +@Repository("knihaDAO")
1.19 +public class KnihaDAO {
1.20 +
1.21 + private DataSource dataSource;
1.22 +
1.23 + @Resource
1.24 + public void setDataSource(DataSource dataSource) {
1.25 + this.dataSource = dataSource;
1.26 + }
1.27 +
1.28 + public Collection<Kniha> getKnihy() {
1.29 + Collection<Kniha> vysledek = new ArrayList<Kniha>();
1.30 +
1.31 + JdbcTemplate t = new JdbcTemplate(dataSource);
1.32 +
1.33 + t.queryForInt("SELECT 1;");
1.34 +
1.35 + Kniha k = new Kniha();
1.36 + k.setNazev("Pokusná kniha");
1.37 + vysledek.add(k);
1.38 +
1.39 + return vysledek;
1.40 + }
1.41 +}