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 +}