franta-hg@1: package cz.frantovo.springDemo1.dao;
franta-hg@1: 
franta-hg@2: import cz.frantovo.springDemo1.KnihaDAORemote;
franta-hg@1: import cz.frantovo.springDemo1.dto.Kniha;
franta-hg@1: import java.util.ArrayList;
franta-hg@1: import java.util.Collection;
franta-hg@1: import javax.annotation.Resource;
franta-hg@2: import javax.ejb.Stateless;
franta-hg@1: import javax.sql.DataSource;
franta-hg@1: import org.springframework.jdbc.core.JdbcTemplate;
franta-hg@1: 
franta-hg@1: /**
franta-hg@1:  *
franta-hg@1:  * @author fiki
franta-hg@1:  */
franta-hg@2: @Stateless
franta-hg@2: public class KnihaDAO implements KnihaDAORemote {
franta-hg@1: 
franta-hg@2:     @Resource(mappedName="jdbc/sqlVyuka/piskoviste")
franta-hg@1:     private DataSource dataSource;
franta-hg@1: 
franta-hg@1:     public Collection<Kniha> getKnihy() {
franta-hg@1: 	Collection<Kniha> vysledek = new ArrayList<Kniha>();
franta-hg@1: 
franta-hg@1: 	JdbcTemplate t = new JdbcTemplate(dataSource);
franta-hg@1: 
franta-hg@1: 	t.queryForInt("SELECT 1;");
franta-hg@1: 
franta-hg@1: 	Kniha k = new Kniha();
franta-hg@1: 	k.setNazev("Pokusná kniha");
franta-hg@1: 	vysledek.add(k);
franta-hg@1: 
franta-hg@1: 	return vysledek;
franta-hg@1:     }
franta-hg@1: }