# HG changeset patch
# User František Kučera <franta-hg@frantovo.cz>
# Date 1265833425 -3600
# Node ID 85754d201c93228c65632848da2a4abecc148d64
# Parent  5a593e2fd7f7fdeeb469ad7ce84182d78244194c
DAO pomocí RowMapperu.

diff -r 5a593e2fd7f7 -r 85754d201c93 java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaDAO.java
--- a/java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaDAO.java	Wed Feb 10 21:13:49 2010 +0100
+++ b/java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaDAO.java	Wed Feb 10 21:23:45 2010 +0100
@@ -2,13 +2,11 @@
 
 import cz.frantovo.springDemo1.KnihaDAORemote;
 import cz.frantovo.springDemo1.dto.Kniha;
-import java.util.ArrayList;
 import java.util.Collection;
 import javax.annotation.Resource;
 import javax.ejb.Stateless;
 import javax.sql.DataSource;
 import org.springframework.jdbc.core.JdbcTemplate;
-import org.springframework.jdbc.support.rowset.SqlRowSet;
 
 /**
  *
@@ -19,23 +17,10 @@
 
     @Resource(mappedName = "jdbc/sqlVyuka/piskoviste")
     private DataSource dataSource;
+    private KnihaRowMapper knihaRowMapper = new KnihaRowMapper();
 
     public Collection<Kniha> getKnihy() {
-	Collection<Kniha> vysledek = new ArrayList<Kniha>();
-
 	JdbcTemplate t = new JdbcTemplate(dataSource);
-	SqlRowSet rs = t.queryForRowSet("SELECT * FROM sbirka.kniha;");
-	while (rs.next()) {
-	    Kniha k = new Kniha();
-	    k.setNazev(rs.getString("nazev"));
-	    k.setAutor(rs.getInt("autor"));
-	    k.setDatumAktualizace(rs.getDate("datum"));
-	    k.setId(rs.getInt("id"));
-	    k.setPocetStran(rs.getInt("pocet_stran"));
-	    k.setRokVydani(rs.getInt("rok_vydani"));
-	    vysledek.add(k);
-	}
-
-	return vysledek;
+	return t.query("SELECT * FROM sbirka.kniha;", knihaRowMapper);
     }
 }
diff -r 5a593e2fd7f7 -r 85754d201c93 java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaRowMapper.java
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaRowMapper.java	Wed Feb 10 21:23:45 2010 +0100
@@ -0,0 +1,24 @@
+package cz.frantovo.springDemo1.dao;
+
+import cz.frantovo.springDemo1.dto.Kniha;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import org.springframework.jdbc.core.simple.ParameterizedRowMapper;
+
+/**
+ *
+ * @author fiki
+ */
+public class KnihaRowMapper implements ParameterizedRowMapper<Kniha> {
+
+    public Kniha mapRow(ResultSet rs, int i) throws SQLException {
+	Kniha k = new Kniha();
+	k.setNazev(rs.getString("nazev"));
+	k.setAutor(rs.getInt("autor"));
+	k.setDatumAktualizace(rs.getDate("datum"));
+	k.setId(rs.getInt("id"));
+	k.setPocetStran(rs.getInt("pocet_stran"));
+	k.setRokVydani(rs.getInt("rok_vydani"));
+	return k;
+    }
+}