From f1fdca5246cce4c4c86a7fbb1418f1c758ed6175 Mon Sep 17 00:00:00 2001
From: unknown
Date: Fri, 31 Jan 2014 15:34:22 +0100
Subject: Up - und Download funktionieren nun, wichtig im Dozentenmodul muss
 der volle Serverpfad angegeben sein.

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

(limited to 'Dozentenmodulserver/src/sql')

diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java
index 8a25491b..7d990116 100644
--- a/Dozentenmodulserver/src/sql/SQL.java
+++ b/Dozentenmodulserver/src/sql/SQL.java
@@ -2,6 +2,7 @@ package sql;
 
 import java.sql.Connection;
 import java.sql.DriverManager;
+import java.sql.ResultSet;
 import java.sql.SQLException;
 import java.sql.Statement;
 
@@ -59,6 +60,38 @@ public class SQL {
 		}
 		return -1;
 	}
+	
+	public ResultSet getImage(Connection con)
+	{
+		try {
+			Statement stm=con.createStatement();
+			
+			return stm.executeQuery("SELECT image_name FROM bwLehrpool.m_VLData_imageInfo;");
+			
+			
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		
+		
+		return null;
+	}
 
-
+	public ResultSet getPathOfImage(Connection con, String image_name)
+	{
+		try {
+			Statement stm=con.createStatement();
+			
+			return stm.executeQuery("SELECT image_path FROM bwLehrpool.m_VLData_imageInfo where image_name like '"+image_name+"';");
+			
+			
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		
+		
+		return null;
+	}
 }
-- 
cgit v1.2.3-55-g7522