From d166463aa463122d2387b05e8f4bfe82fe2ad104 Mon Sep 17 00:00:00 2001 From: ulrich <undisclosed> Date: Sat, 24 Mar 2018 14:47:26 +0000 Subject: [PATCH] Auf dynamisch geladene Vorlagen umgestellt --- web/WEB-INF/sql.properties | 21 ++++++++++++++++++++- 1 files changed, 20 insertions(+), 1 deletions(-) diff --git a/web/WEB-INF/sql.properties b/web/WEB-INF/sql.properties index f33598d..3fc254c 100644 --- a/web/WEB-INF/sql.properties +++ b/web/WEB-INF/sql.properties @@ -23,8 +23,27 @@ app.keytable where key_name = ? </entry> - <entry key="getSender"> + <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