From 6ec6607b6c84c3b18ae8151f01574eb44f526e63 Mon Sep 17 00:00:00 2001
From: ulrich <undisclosed>
Date: Sun, 11 Mar 2018 19:38:37 +0000
Subject: [PATCH] Neuer Sender und Abspieler berichtigt
---
web/WEB-INF/sql.properties | 19 +++++++++++++++++--
1 files changed, 17 insertions(+), 2 deletions(-)
diff --git a/web/WEB-INF/sql.properties b/web/WEB-INF/sql.properties
index 714aacc..3fc254c 100644
--- a/web/WEB-INF/sql.properties
+++ b/web/WEB-INF/sql.properties
@@ -23,12 +23,27 @@
app.keytable
where key_name = ?
</entry>
- <entry key="getSender">
+ <entry key="getSenderList">
select * from
app.sender
</entry>
- <entry key="getAbspieler">
+ <entry key="getSender">
+ select * from
+ app.sender
+ where sender_id = ?
+ </entry>
+ <entry key="getAbspielerList">
select * from
app.abspieler
</entry>
+ <entry key="getAbspieler">
+ select * from
+ app.abspieler
+ where abs_id = ?
+ </entry>
+ <entry key="unselectAbspieler">
+ update app.abspieler
+ set abs_zustand = ?
+ where abs_zustand = ?
+ </entry>
</properties>
--
Gitblit v1.9.3