From 5f540aaa05c9b4400d8bc58a8fdbc7a9157b4908 Mon Sep 17 00:00:00 2001
From: Tobias Spitzer
Date: Tue, 19 Aug 2014 08:26:22 +0200
Subject: gfdgfsd

---
 Dozentenmodulserver/src/sql/SQL.java | 33 +++++++++++++++++++++++++++++++++
 1 file changed, 33 insertions(+)

(limited to 'Dozentenmodulserver/src/sql')

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;
+	}
 }
-- 
cgit v1.2.3-55-g7522