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 | 23 +++++++++++++++++++++++ 1 files changed, 23 insertions(+), 0 deletions(-) diff --git a/web/WEB-INF/sql.properties b/web/WEB-INF/sql.properties index 5881357..3fc254c 100644 --- a/web/WEB-INF/sql.properties +++ b/web/WEB-INF/sql.properties @@ -23,4 +23,27 @@ app.keytable where key_name = ? </entry> + <entry key="getSenderList"> + select * from + app.sender + </entry> + <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