diff options
| author | Nino Breuer | 2014-10-16 21:01:06 +0200 |
|---|---|---|
| committer | Nino Breuer | 2014-10-16 21:01:06 +0200 |
| commit | d6b7e14f8cca315a45366bf8fc18633fb9cccdef (patch) | |
| tree | 0a06b27223c9ee280c7fc103dc149cde2d0eb8f2 /dozentenmodulserver/src/main/java/sql | |
| parent | Veranstaltung erzeugen geht wieder (diff) | |
| download | tutor-module-d6b7e14f8cca315a45366bf8fc18633fb9cccdef.tar.gz tutor-module-d6b7e14f8cca315a45366bf8fc18633fb9cccdef.tar.xz tutor-module-d6b7e14f8cca315a45366bf8fc18633fb9cccdef.zip | |
-
Diffstat (limited to 'dozentenmodulserver/src/main/java/sql')
| -rw-r--r-- | dozentenmodulserver/src/main/java/sql/SQL.java | 69 |
1 files changed, 61 insertions, 8 deletions
diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java index e973ba54..3649a34f 100644 --- a/dozentenmodulserver/src/main/java/sql/SQL.java +++ b/dozentenmodulserver/src/main/java/sql/SQL.java @@ -638,9 +638,10 @@ public List<Image> getImageListPermissionLink(String userID) { }
log.info(new Date() + " - 'image_name` = '" + newName+ "\n length of name="+newName.length());
- stm.executeUpdate("UPDATE `bwLehrpool`.`m_VLData_imageInfo` SET `imageVersion` = '"
+ log.info("now in UpdateImageData()");
+ log.info("UPDATE bwLehrpool.m_VLData_imageInfo SET imageVersion = "
+ newVersion
- + "',`image_name` = '"
+ + ",image_name = '"
+ newName
+ "',`image_description` = '"
+ desc
@@ -660,16 +661,51 @@ public List<Image> getImageListPermissionLink(String userID) { + cpu
+ "',`image_isTemplate` = '"
//+ isTemplate
- + "'0'"
- + "',`content_operatingSystem` = '"
+ + "0'"
+ + ",`content_operatingSystem` = "
+ ospk
- + "',`image_filesize` = '"
+ + ",`image_filesize` = "
+ filesize
- + "',`image_syncMode` = '"
+ + ",`image_syncMode` = '"
+ shareMode
- + "' WHERE `GUID_imageID` = '"
+ + "' WHERE GUID_imageID = '"
+ id
- + "' AND `imageVersion` = '" + version + "';");
+ + "' AND imageVersion = " + version + ";");
+
+
+ stm.executeUpdate("UPDATE bwLehrpool.m_VLData_imageInfo SET imageVersion = "
+ + newVersion
+ + ",image_name = '"
+ + newName
+ + "',`image_description` = '"
+ + desc
+ + "',`image_path` = '"
+ + image_path
+ + "',`image_update_time` = '"
+ + formatter.format(new Date())
+ + "',`rec_change_time` = '"
+ + formatter.format(new Date())
+ + "',`cond_hasLicenseRestriction` = '"
+ + license_bol
+ + "',`cond_hasInternetRestriction` = '"
+ + internet_bol
+ + "',`cond_minRAM` = '"
+ + ram
+ + "',`cond_minCPUs` = '"
+ + cpu
+ + "',`image_isTemplate` = '"
+ //+ isTemplate
+ + "0'"
+ + "',`content_operatingSystem` = "
+ + ospk
+ + ",`image_filesize` = "
+ + filesize
+ + ",`image_syncMode` = "
+ + shareMode
+ + " WHERE GUID_imageID = '"
+ + id
+ + "' AND imageVersion = " + version + ";");
+
con.commit();
con.close();
return 0;
@@ -1313,5 +1349,22 @@ public List<Image> getImageListPermissionLink(String userID) { return success;
}// end
+
+ public void deleteAllAdditionalImagePermissions(String imageID,String userID)
+ {
+ Connection con=getConnection();
+ Statement stm = null;
+
+
+ try {
+
+ stm = con.createStatement();
+ int ret = stm.executeUpdate("DELETE FROM pm_VLData_Image WHERE imageID = '" + imageID + "' AND userID != '" + userID + "';");
+
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ }
}//end class
|