Up - und Download funktionieren nun, wichtig im Dozentenmodul muss der volle Serverpfad angegeben sein.

6 files changed, 85 insertions, 3 deletions

diff --git a/Dozentenmodulserver/bin/server/ServerInterface.class b/Dozentenmodulserver/bin/server/ServerInterface.class
index ca7f3971..411a676d 100644
--- a/Dozentenmodulserver/bin/server/ServerInterface.class
+++ b/Dozentenmodulserver/bin/server/ServerInterface.class
diff --git a/Dozentenmodulserver/bin/server/ServerMethod.class b/Dozentenmodulserver/bin/server/ServerMethod.class
index e08f8a11..4b4096d1 100644
--- a/Dozentenmodulserver/bin/server/ServerMethod.class
+++ b/Dozentenmodulserver/bin/server/ServerMethod.class
diff --git a/Dozentenmodulserver/bin/sql/SQL.class b/Dozentenmodulserver/bin/sql/SQL.class
index 49415869..245013e2 100644
--- a/Dozentenmodulserver/bin/sql/SQL.class
+++ b/Dozentenmodulserver/bin/sql/SQL.class
diff --git a/Dozentenmodulserver/src/server/ServerInterface.java b/Dozentenmodulserver/src/server/ServerInterface.java
index 6ae6e529..bce713c0 100644
--- a/Dozentenmodulserver/src/server/ServerInterface.java
+++ b/Dozentenmodulserver/src/server/ServerInterface.java
@@ -1,5 +1,7 @@
 package server;

 import java.rmi.*;

+import java.sql.ResultSet;

+import java.util.ArrayList;

 

 import Models.User;

 

@@ -7,6 +9,7 @@ public interface ServerInterface extends Remote
 {

         public User getFtpUser() throws RemoteException;

         public int DeleteFtpUser(String user) throws RemoteException;

-        

+        public ArrayList<String> getImages() throws RemoteException;

+        public String getPathOfImage(String name) throws RemoteException;

         

 }

diff --git a/Dozentenmodulserver/src/server/ServerMethod.java b/Dozentenmodulserver/src/server/ServerMethod.java
index a401c7b9..1039e238 100644
--- a/Dozentenmodulserver/src/server/ServerMethod.java
+++ b/Dozentenmodulserver/src/server/ServerMethod.java
@@ -6,6 +6,9 @@ import java.rmi.server.UnicastRemoteObject;
 import java.security.MessageDigest;

 import java.security.NoSuchAlgorithmException;

 import java.sql.Connection;

+import java.sql.ResultSet;

+import java.sql.SQLException;

+import java.util.ArrayList;

 import java.util.UUID;

 import Models.*;

 import sql.SQL;

@@ -14,6 +17,7 @@ import sql.SQL;
 public class ServerMethod extends UnicastRemoteObject implements ServerInterface

 {

     protected static String          m_strName;

+ 

 

     public ServerMethod() throws RemoteException

     {

@@ -77,6 +81,48 @@ public class ServerMethod extends UnicastRemoteObject implements ServerInterface
 		return null;

 	}

 

-

+	

+	

+	public ArrayList<String> getImages(){

+		

+		

+		SQL sql=new SQL();

+		Connection con=sql.getConnection();

+		ResultSet rs= sql.getImage(con);

+		ArrayList<String> al=new ArrayList<String>();

+		try {

+			while(rs.next())

+			{

+						

+				al.add(rs.getString(1));				

+				

+			}

+		} catch (SQLException e) {

+			// TODO Auto-generated catch block

+			e.printStackTrace();

+		}

+		return al;

+	}

+	

+	public String getPathOfImage(String name){

+		

+		String path = null;

+		SQL sql=new SQL();

+		Connection con=sql.getConnection();

+		ResultSet rs= sql.getPathOfImage(con, name);

+		

+		try {

+			while(rs.next())

+			{

+						

+				path=rs.getString(1);				

+				

+			}

+		} catch (SQLException e) {

+			// TODO Auto-generated catch block

+			e.printStackTrace();

+		}

+		return path;

+	}

 

 }
\ No newline at end of file
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;

+	}

 }