From af03c88129755f57fff3389bb35c5840c0e9751f Mon Sep 17 00:00:00 2001
From: Michael Wilson
Date: Tue, 7 Oct 2014 14:01:52 +0200
Subject: -Verwaltung von Rechten ist nun in der PermissionCreateImage_GUI.java
 möglich

---
 dozentenmodulserver/src/main/java/sql/SQL.java | 50 +++++++++++++++++++++++++-
 1 file changed, 49 insertions(+), 1 deletion(-)

(limited to 'dozentenmodulserver/src/main/java/sql')

diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java
index 92af9f14..0b5765fa 100644
--- a/dozentenmodulserver/src/main/java/sql/SQL.java
+++ b/dozentenmodulserver/src/main/java/sql/SQL.java
@@ -20,6 +20,9 @@ import org.apache.log4j.Logger;
 import server.BinaryListener;
 import server.generated.Image;
 import server.generated.Lecture;
+import server.generated.Person;
+
+
 
 public class SQL {
 
@@ -249,7 +252,8 @@ public class SQL {
 		try {
 			Connection con=getConnection();
 			Statement stm = con.createStatement();
-			
+
+			//create a UUID
 			String uid = UUID.randomUUID().toString();
 			
 			log.info(" - Query is: "+"INSERT INTO `bwLehrpool`.`m_VLData_imageInfo`(`GUID_imageID`,`imageVersion`,`image_name`,`image_description`,`image_path`,`image_lastCall`,`image_create_time`,`image_update_time`,`image_owner`,`image_change_by`,`rec_create_time`,`rec_change_time`,`rec_owner`,`rec_change_by`,`content_operatingSystem`,`status_isCompressed`,`status_isSecure`,`status_isOptimzed`,`status_isValid`,`status_isReady`,`status_isDeleted`,`status_isLastOfficialVersion`,`cond_hasLicenseRestriction`,`cond_hasInternetRestriction`,`cond_minRAM`,`cond_minCPUs`,`image_isTemplate`,`image_filesize`,`image_syncMode`)VALUES('"
@@ -1051,4 +1055,48 @@ public class SQL {
 		}
 		return id;
 	}
+	
+	//get all users from HS OG -- temp, tb replaced by allUsers bwLehrpool
+	public List<Person> getAllOGUsers(){
+		Connection con=getConnection();
+		Statement stm=null;
+		ResultSet res = null;
+		//Map<String, String> map = new HashMap<String, String>();
+		List<Person> list = new ArrayList<Person>();
+		
+		
+		try {
+			stm = con.createStatement();
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		try {
+			res = stm.executeQuery("SELECT userID, Nachname, Vorname FROM m_user ORDER BY Nachname ASC;");
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		
+		try {
+			while (res.next()) {
+				
+				
+				list.add(new Person(res.getString("userID"), 
+						res.getString("Nachname"),
+						res.getString("Vorname")));
+
+			}
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		
+		return list;
+		
+	}
+	
+	
+	
+	
 }
-- 
cgit v1.2.3-55-g7522