From 7b8534417cc4cf7d2e6d6dcb0988ad688fc7999c Mon Sep 17 00:00:00 2001
From: unknown
Date: Fri, 4 Apr 2014 09:30:30 +0200
Subject: neue Version

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

(limited to 'Dozentenmodulserver/src/sql')

diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java
index a93f35b0..f28fdd67 100644
--- a/Dozentenmodulserver/src/sql/SQL.java
+++ b/Dozentenmodulserver/src/sql/SQL.java
@@ -205,6 +205,20 @@ public class SQL {
 		return null;
 	}
 	
+	public ResultSet getLectureList(Connection con){
+		try {
+			Statement stm=con.createStatement();
+			
+			return stm.executeQuery("SELECT l.lectureID, l.name, l.isActive,l.startTime,l.endTime,l.lastUsed,l.description, i.image_name, concat(u.Nachname,' ',u.Vorname) as user FROM bwLehrpool.m_VLData_lecture l, bwLehrpool.m_VLData_imageInfo i, bwLehrpool.m_user u where i.GUID_imageID=l.imageID and l.admin_owner=u.userID;");
+			
+			
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		return null;
+	}
+	
 	
 	public ResultSet getAllOS(Connection con)
 	{
-- 
cgit v1.2.3-55-g7522