summaryrefslogtreecommitdiffstats
path: root/dozentenmodulserver/src/main/java/sql
diff options
context:
space:
mode:
authorNino Breuer2014-12-01 16:30:59 +0100
committerNino Breuer2014-12-01 16:30:59 +0100
commit6a90495ac046d90a749ec2ec152ffdf4d7d603f0 (patch)
tree625e5d14802ad1d3d847ab1895edd85a48167e95 /dozentenmodulserver/src/main/java/sql
parent• changed implementation of user authentication. (diff)
parent• Admin can download any image (diff)
downloadtutor-module-6a90495ac046d90a749ec2ec152ffdf4d7d603f0.tar.gz
tutor-module-6a90495ac046d90a749ec2ec152ffdf4d7d603f0.tar.xz
tutor-module-6a90495ac046d90a749ec2ec152ffdf4d7d603f0.zip
Merge branch 'master' of ssh://git.openslx.org/openslx-ng/tutor-module
Conflicts: dozentenmodul/src/main/java/gui/image/CreateImageTechnisch_GUI.java dozentenmodul/src/main/java/gui/image/EditImageTechnisch_GUI.java dozentenmodul/src/main/java/gui/image/FTPCreateUploader_GUI.java möp. großes geschrei, fehler bitte an mich. dozentenmodul/src/main/java/gui/image/FTPEditDownloader_GUI.java dozentenmodul/src/main/java/gui/image/FTPEditUploader_GUI.java dozentenmodul/src/main/java/gui/image/SearchImage_GUI.java dozentenmodul/src/main/java/gui/lecture/DeleteLecture_GUI.java dozentenmodul/src/main/java/gui/lecture/EditLectureAllgemein_GUI.java dozentenmodul/src/main/java/gui/lecture/EditLectureLink_GUI.java dozentenmodulserver/src/main/java/server/ServerHandler.java dozentenmodulserver/src/main/java/server/generated/Server.java dozentenmodulserver/thrift/server.thrift
Diffstat (limited to 'dozentenmodulserver/src/main/java/sql')
-rw-r--r--dozentenmodulserver/src/main/java/sql/SQL.java11
1 files changed, 9 insertions, 2 deletions
diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java
index 9144e4b1..b7cb4ada 100644
--- a/dozentenmodulserver/src/main/java/sql/SQL.java
+++ b/dozentenmodulserver/src/main/java/sql/SQL.java
@@ -1396,11 +1396,18 @@ public class SQL {
//delete the lecture record
String sql = "DELETE FROM bwLehrpool.m_VLData_lecture WHERE lectureID = ?;";
PreparedStatement prest = con.prepareStatement(sql);
- prest.setString(1, id);
+ prest.setString(1, id);
prest.executeUpdate();
- //delete all permission records for this lecture
+
+ //delete all permission records for this lecture
+ sql = "DELETE FROM bwLehrpool.pm_VLData_lecture WHERE lectureID = ?;";
+ prest = con.prepareStatement(sql);
+ prest.setString(1, id);
+
+ prest.executeUpdate();
+
con.commit();
con.close();
return true;