diff options
| author | Nino Breuer | 2014-11-03 11:38:03 +0100 |
|---|---|---|
| committer | Nino Breuer | 2014-11-03 11:38:03 +0100 |
| commit | 76375531e24e40a553531f80d438ef9288b60079 (patch) | |
| tree | d156914b02c49065f6d441e51974814fc640a11f /dozentenmodulserver/src/main/java/sql/SQL.java | |
| parent | initialize all lectures with ALL lectures... (diff) | |
| download | tutor-module-76375531e24e40a553531f80d438ef9288b60079.tar.gz tutor-module-76375531e24e40a553531f80d438ef9288b60079.tar.xz tutor-module-76375531e24e40a553531f80d438ef9288b60079.zip | |
fixed bug: all images now show ALL images
Diffstat (limited to 'dozentenmodulserver/src/main/java/sql/SQL.java')
| -rw-r--r-- | dozentenmodulserver/src/main/java/sql/SQL.java | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java index 235874c2..c9615d41 100644 --- a/dozentenmodulserver/src/main/java/sql/SQL.java +++ b/dozentenmodulserver/src/main/java/sql/SQL.java @@ -417,6 +417,43 @@ public class SQL { }
return list;
}
+
+ public List<Image> getImageList(String userID) {
+
+ Connection con = getConnection();
+ Statement stm;
+
+ List<Image> list = new ArrayList<Image>();
+ try {
+
+ stm = con.createStatement();
+
+ // ResultSet
+ ResultSet res = stm
+ .executeQuery("SELECT DISTINCT vl.GUID_imageID, vl.imageVersion, vl.image_name, vl.cond_hasLicenseRestriction, os.name, os.architecture, '' as lecture, vl.image_update_time, Concat(u.Nachname,' ',u.Vorname) as user, vl.image_isTemplate, vl.image_description FROM bwLehrpool.pm_VLData_image pmi, bwLehrpool.m_VLData_imageInfo vl, bwLehrpool.m_operatingSystem os, bwLehrpool.m_user u WHERE u.userID = vl.image_owner AND vl.content_operatingSystem = os.operatingSystemID");
+
+
+ while (res.next()) {
+ list.add(new Image(res.getString("GUID_imageID"), res
+ .getString("imageVersion"),
+ res.getString("image_name"), res
+ .getString("cond_hasLicenseRestriction"), res
+ .getString("name")
+ + " "
+ + res.getString("architecture") + " bit", res
+ .getString("lecture"), res
+ .getString("image_update_time"), res
+ .getString("user"), res
+ .getString("image_isTemplate"),
+ res.getString("image_description")));
+ }
+ con.close();
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return list;
+ }
public List<Image> getImageListPermissionLink(String userID) {
|