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@3: import org.springframework.jdbc.support.rowset.SqlRowSet;
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@3:     @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@3: 	SqlRowSet rs = t.queryForRowSet("SELECT * FROM sbirka.kniha;");
franta-hg@3: 	while (rs.next()) {
franta-hg@3: 	    Kniha k = new Kniha();
franta-hg@3: 	    k.setNazev(rs.getString("nazev"));
franta-hg@3: 	    k.setAutor(rs.getInt("autor"));
franta-hg@3: 	    k.setDatumAktualizace(rs.getDate("datum"));
franta-hg@3: 	    k.setId(rs.getInt("id"));
franta-hg@3: 	    k.setPocetStran(rs.getInt("pocet_stran"));
franta-hg@3: 	    k.setRokVydani(rs.getInt("rok_vydani"));
franta-hg@3: 	    vysledek.add(k);
franta-hg@3: 	}
franta-hg@1: 
franta-hg@1: 	return vysledek;
franta-hg@1:     }
franta-hg@1: }