diff options
author | Michael Wilson | 2014-11-28 15:46:50 +0100 |
---|---|---|
committer | Michael Wilson | 2014-11-28 15:46:50 +0100 |
commit | 5da4cf29171b2b3e5dafa8f969b57d02c0ed6743 (patch) | |
tree | 59871e3bfc46150b45ee3c17ce6cb32cf8fca1fb /dozentenmodulserver/src/main/java/sql/SQL.java | |
parent | If OS=windows, then isLicensed always true (diff) | |
download | tutor-module-5da4cf29171b2b3e5dafa8f969b57d02c0ed6743.tar.gz tutor-module-5da4cf29171b2b3e5dafa8f969b57d02c0ed6743.tar.xz tutor-module-5da4cf29171b2b3e5dafa8f969b57d02c0ed6743.zip |
lecture permissions deleted after deleting lecture
Diffstat (limited to 'dozentenmodulserver/src/main/java/sql/SQL.java')
-rw-r--r-- | dozentenmodulserver/src/main/java/sql/SQL.java | 11 |
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 d496489d..5ba19c70 100644 --- a/dozentenmodulserver/src/main/java/sql/SQL.java +++ b/dozentenmodulserver/src/main/java/sql/SQL.java @@ -1390,11 +1390,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;
|