diff options
| author | Tobias Spitzer | 2014-08-19 08:26:22 +0200 |
|---|---|---|
| committer | Tobias Spitzer | 2014-08-19 08:26:22 +0200 |
| commit | 5f540aaa05c9b4400d8bc58a8fdbc7a9157b4908 (patch) | |
| tree | 8de97eb2eded74d8c03f9d77c60a06fdc46ed039 /Dozentenmodulserver/src/sql | |
| parent | Suchmaske für Images neu (diff) | |
| download | tutor-module-5f540aaa05c9b4400d8bc58a8fdbc7a9157b4908.tar.gz tutor-module-5f540aaa05c9b4400d8bc58a8fdbc7a9157b4908.tar.xz tutor-module-5f540aaa05c9b4400d8bc58a8fdbc7a9157b4908.zip | |
gfdgfsd
Diffstat (limited to 'Dozentenmodulserver/src/sql')
| -rw-r--r-- | Dozentenmodulserver/src/sql/SQL.java | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java index 2922eafc..15d6950f 100644 --- a/Dozentenmodulserver/src/sql/SQL.java +++ b/Dozentenmodulserver/src/sql/SQL.java @@ -830,4 +830,37 @@ public class SQL { return null;
}
+
+ public Map<String,String> getLectureData(String id) {
+ Map<String, String> map = new HashMap<String, String>();
+ try {
+ Connection con=getConnection();
+ Statement stm = con.createStatement();
+ ResultSet data=stm
+ .executeQuery("SELECT i.image_name,i.image_update_time,i.cond_hasInternetRestriction,i.cond_hasLicenseRestriction, i.cond_minCPUs,i.cond_minRAM, i.image_syncMode,i.image_filesize,i.image_path, i.image_isTemplate,os.GuestOS, concat(u.Nachname,' ',u.Vorname) as Owner FROM bwLehrpool.m_VLData_imageInfo i,bwLehrpool.m_user u,bwLehrpool.m_operatingSystem os where i.image_owner=u.userID and i.content_operatingSystem=os.operatingSystemID and GUID_imageID = '" + id + "' ;");
+ while (data.next()) {
+ map.put("name", data.getString("image_name"));
+ map.put("internet",
+ data.getString("cond_hasInternetRestriction"));
+ map.put("license", data.getString("cond_hasLicenseRestriction"));
+ map.put("cpu", data.getString("cond_minCPUs"));
+ map.put("ram", data.getString("cond_minRAM"));
+ map.put("shareMode", data.getString("image_syncMode"));
+ map.put("filesize", data.getString("image_filesize"));
+ map.put("path", data.getString("image_path"));
+ map.put("template", data.getString("image_isTemplate"));
+ map.put("os",data.getString("GuestOS"));
+ map.put("owner", data.getString("Owner"));
+ map.put("lastupdate", data.getString("image_update_time"));
+
+ }
+ con.close();
+ return map;
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ log.info(new Date() + " - Failed to getImageData.");
+ e.printStackTrace();
+ }
+ return null;
+ }
}
|