# HG changeset patch
# User František Kučera <franta-hg@frantovo.cz>
# Date 1265926603 -3600
# Node ID 0ae95f929a1a44703fd15e7db6a1c7f9f82e8616
# Parent  7cf0cbef29369c9265a1c55d6129b6259d0bf413
Mikeš.

diff -r 7cf0cbef2936 -r 0ae95f929a1a 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 23:11:38 2010 +0100
+++ b/java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaDAO.java	Thu Feb 11 23:16:43 2010 +0100
@@ -9,7 +9,7 @@
 import org.springframework.jdbc.core.JdbcTemplate;
 
 /**
- *
+ * Pro zjednodušení bez <a href="http://hg.frantovo.cz/SuperDAO/">SuperDao</a>.
  * @author fiki
  */
 @Stateless
@@ -18,9 +18,13 @@
     @Resource(mappedName = "jdbc/sqlVyuka/piskoviste")
     private DataSource dataSource;
     private KnihaRowMapper knihaRowMapper = new KnihaRowMapper();
+    JdbcTemplate t = new JdbcTemplate(dataSource);
 
     public Collection<Kniha> getKnihy() {
-	JdbcTemplate t = new JdbcTemplate(dataSource);
 	return t.query("SELECT * FROM sbirka.kniha;", knihaRowMapper);
     }
+
+    public int ulozKnihu(Kniha k) {
+	return t.update("UPDATE kniha SET (nazev, autor, datum, isbn, pocet_stran, rok_vydani, id) VALUES (?,?,?,?,?,?,?)", new KnihaPSSetter(k));
+    }
 }
diff -r 7cf0cbef2936 -r 0ae95f929a1a java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaPSSetter.java
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/java/SpringDemo1/SpringDemo1-ejb/src/java/cz/frantovo/springDemo1/dao/KnihaPSSetter.java	Thu Feb 11 23:16:43 2010 +0100
@@ -0,0 +1,31 @@
+package cz.frantovo.springDemo1.dao;
+
+import cz.frantovo.springDemo1.dto.Kniha;
+import java.sql.PreparedStatement;
+import java.sql.SQLException;
+import java.sql.Timestamp;
+import org.springframework.jdbc.core.PreparedStatementSetter;
+
+/**
+ *
+ * @author fiki
+ */
+public class KnihaPSSetter implements PreparedStatementSetter {
+
+    private Kniha kniha;
+
+    public KnihaPSSetter(Kniha kniha) {
+	this.kniha = kniha;
+    }
+
+    public void setValues(PreparedStatement ps) throws SQLException {
+	ps.setString(1, kniha.getNazev());
+	ps.setInt(2, kniha.getAutor());
+	ps.setTimestamp(3, new Timestamp(kniha.getDatumAktualizace().getTime()));
+	ps.setString(4, kniha.getIsbn());
+	ps.setInt(5, kniha.getPocetStran());
+	ps.setInt(6, kniha.getRokVydani());
+	ps.setInt(7, kniha.getId());
+    }
+
+}
diff -r 7cf0cbef2936 -r 0ae95f929a1a java/SpringDemo1/SpringDemo1-lib/src/cz/frantovo/springDemo1/KnihaDAORemote.java
--- a/java/SpringDemo1/SpringDemo1-lib/src/cz/frantovo/springDemo1/KnihaDAORemote.java	Wed Feb 10 23:11:38 2010 +0100
+++ b/java/SpringDemo1/SpringDemo1-lib/src/cz/frantovo/springDemo1/KnihaDAORemote.java	Thu Feb 11 23:16:43 2010 +0100
@@ -13,4 +13,5 @@
 
     public Collection<Kniha> getKnihy();
 
+    public int ulozKnihu(Kniha k);
 }