author | František Kučera <franta-hg@frantovo.cz> |
Wed, 10 Feb 2010 21:05:17 +0100 | |
changeset 2 | d549a4eb6aa9 |
parent 1 | 9a3fced9634d |
child 3 | 5a593e2fd7f7 |
permissions | -rw-r--r-- |
franta-hg@1 | 1 |
package cz.frantovo.springDemo1.dao; |
franta-hg@1 | 2 |
|
franta-hg@2 | 3 |
import cz.frantovo.springDemo1.KnihaDAORemote; |
franta-hg@1 | 4 |
import cz.frantovo.springDemo1.dto.Kniha; |
franta-hg@1 | 5 |
import java.util.ArrayList; |
franta-hg@1 | 6 |
import java.util.Collection; |
franta-hg@1 | 7 |
import javax.annotation.Resource; |
franta-hg@2 | 8 |
import javax.ejb.Stateless; |
franta-hg@1 | 9 |
import javax.sql.DataSource; |
franta-hg@1 | 10 |
import org.springframework.jdbc.core.JdbcTemplate; |
franta-hg@1 | 11 |
|
franta-hg@1 | 12 |
/** |
franta-hg@1 | 13 |
* |
franta-hg@1 | 14 |
* @author fiki |
franta-hg@1 | 15 |
*/ |
franta-hg@2 | 16 |
@Stateless |
franta-hg@2 | 17 |
public class KnihaDAO implements KnihaDAORemote { |
franta-hg@1 | 18 |
|
franta-hg@2 | 19 |
@Resource(mappedName="jdbc/sqlVyuka/piskoviste") |
franta-hg@1 | 20 |
private DataSource dataSource; |
franta-hg@1 | 21 |
|
franta-hg@1 | 22 |
public Collection<Kniha> getKnihy() { |
franta-hg@1 | 23 |
Collection<Kniha> vysledek = new ArrayList<Kniha>(); |
franta-hg@1 | 24 |
|
franta-hg@1 | 25 |
JdbcTemplate t = new JdbcTemplate(dataSource); |
franta-hg@1 | 26 |
|
franta-hg@1 | 27 |
t.queryForInt("SELECT 1;"); |
franta-hg@1 | 28 |
|
franta-hg@1 | 29 |
Kniha k = new Kniha(); |
franta-hg@1 | 30 |
k.setNazev("Pokusná kniha"); |
franta-hg@1 | 31 |
vysledek.add(k); |
franta-hg@1 | 32 |
|
franta-hg@1 | 33 |
return vysledek; |
franta-hg@1 | 34 |
} |
franta-hg@1 | 35 |
} |