From 18af7c28471d8ea28ad50a061b7d815e710bfd7f Mon Sep 17 00:00:00 2001
From: hilgeru <hilgeru@msgn07482.int.root.msg.ag>
Date: Tue, 27 Feb 2018 14:43:52 +0000
Subject: [PATCH] SenderApi fertig
---
src/java/de/uhilger/radiozentrale/api/SenderApi.java | 32 +++++++++++++++++++++++---------
1 files changed, 23 insertions(+), 9 deletions(-)
diff --git a/src/java/de/uhilger/radiozentrale/api/SenderApi.java b/src/java/de/uhilger/radiozentrale/api/SenderApi.java
index 5493629..8937d19 100644
--- a/src/java/de/uhilger/radiozentrale/api/SenderApi.java
+++ b/src/java/de/uhilger/radiozentrale/api/SenderApi.java
@@ -18,7 +18,6 @@
package de.uhilger.radiozentrale.api;
-import de.uhilger.baselink.GenericRecord;
import de.uhilger.baselink.PersistenceManager;
import de.uhilger.radiozentrale.daten.Sender;
import de.uhilger.radiozentrale.web.Initialiser;
@@ -28,11 +27,9 @@
/**
*
*/
-public class SenderApi extends Api {
+public class SenderApi extends DbApi {
public static final String SQL_GET_SENDER = "getSender";
- public static final String SQL_GET_NEXT_KEY = "getNextKey";
- public static final String SQL_INCREMENT_KEY = "incrementKey";
public static final String KEY_SENDER_ID = "sender_id";
@@ -41,11 +38,9 @@
Sender neuerSender = null;
PersistenceManager db = getDb();
Connection c = db.getConnection();
- List<List<String>> list = db.select(getSql(SQL_GET_NEXT_KEY), GenericRecord.WITHOUT_BLOBS, KEY_SENDER_ID);
- if(list != null && list.size() > 1) {
- int nextKey = Integer.parseInt(list.get(1).get(0)); // erster Datensatz ist Ueberschrift
- db.startTransaction(c);
- db.execute(getSql(SQL_INCREMENT_KEY), nextKey+1, KEY_SENDER_ID, nextKey);
+ db.startTransaction(c);
+ int nextKey = getNextId(db, KEY_SENDER_ID);
+ if(nextKey > -1) {
sender.setId(nextKey);
Object o = getDb().insert(sender, getMapper(Initialiser.MP_SENDER));
if(o instanceof Sender) {
@@ -58,7 +53,26 @@
return neuerSender;
}
+ public Sender senderAendern(Sender sender) {
+ Sender geaendert = null;
+ Object o = getDb().update(sender, getMapper(Initialiser.MP_SENDER));
+ if(o instanceof Sender) {
+ geaendert = (Sender) o;
+ }
+ return geaendert;
+ }
+
+ public Sender senderLoeschen(Sender sender) {
+ Sender geloescht = null;
+ Object o = getDb().delete(sender, getMapper(Initialiser.MP_SENDER));
+ if(o instanceof Sender) {
+ geloescht = (Sender) o;
+ }
+ return geloescht;
+ }
+
public List senderliste() {
return getDb().select(getSql(SQL_GET_SENDER), getMapper(Initialiser.MP_SENDER));
}
+
}
--
Gitblit v1.9.3