Es ist nun möglich auf der Datenbank basierend VLs sowie Veranstaltungen neu anzulegen

2 files changed, 77 insertions, 5 deletions

diff --git a/Dozentenmodulserver/src/server/ServerInterface.java b/Dozentenmodulserver/src/server/ServerInterface.java
index 49d7adb9..fffcb064 100644
--- a/Dozentenmodulserver/src/server/ServerInterface.java
+++ b/Dozentenmodulserver/src/server/ServerInterface.java
@@ -2,7 +2,9 @@ package server;
 import java.rmi.*;

 import java.sql.ResultSet;

 import java.util.ArrayList;

+import java.util.Date;

 import java.util.List;

+import java.util.Map;

 

 import Models.User;

 

@@ -15,4 +17,8 @@ public interface ServerInterface extends Remote
         public boolean writeVLdata(String imagename, String firstname, String lastname,String university, String Mail, String Tel, String Fak, boolean license, boolean internet, int ram, int cpu) throws RemoteException;

         public List<Object[]> getImageList() throws RemoteException;

         public List<String> getAllOS() throws RemoteException;

+        public Map<String,String> getPersonData(String Vorname, String Nachname) throws RemoteException;

+        public boolean writeLecturedata(String name, String shortdesc, String desc,Date start, Date end, boolean isActive, String imagename,String firstname,

+    			String lastname, String university, String Mail, String Tel,

+    			String Fak) throws RemoteException;

 }

diff --git a/Dozentenmodulserver/src/server/ServerMethod.java b/Dozentenmodulserver/src/server/ServerMethod.java
index 1f66fb6b..aa4dcae8 100644
--- a/Dozentenmodulserver/src/server/ServerMethod.java
+++ b/Dozentenmodulserver/src/server/ServerMethod.java
@@ -11,9 +11,13 @@ import java.sql.ResultSetMetaData;
 import java.sql.SQLException;

 import java.util.ArrayList;

 import java.util.Date;

+import java.util.HashMap;

 import java.util.List;

+import java.util.Map;

 import java.util.UUID;

-import Models.*;

+

+import Models.User;

+

 import sql.SQL;

 

 @SuppressWarnings("serial")

@@ -133,16 +137,17 @@ public class ServerMethod extends UnicastRemoteObject implements ServerInterface
 			String Fak, boolean license, boolean internet, int ram, int cpu)

 			throws RemoteException {

 		String login="tete";

-		System.out.println("1");

+		

 		int pk_institution=sql.setInstitution(con, university);

-		System.out.println("2");

+		

 		int pk_person=sql.setPerson(con, login, lastname, firstname, Mail, new Date(), pk_institution);

-		System.out.println("3");

+		

 		sql.setImageData(con, pk_person, license, internet, cpu, ram, imagename);

-		System.out.println("4");

+		

 		// TODO Auto-generated method stub

 		return true;

 	}

+	

 

 

 

@@ -156,6 +161,7 @@ public class ServerMethod extends UnicastRemoteObject implements ServerInterface
 			List<Object[]> listWith = ResSetToObject(resWith);

 			List<Object[]> listWithout=ResSetToObject(resWithout);

 			listWith.addAll(listWith.size(), listWithout);

+			

 			return listWith;

 		} catch (SQLException e1) {

 			// TODO Auto-generated catch block

@@ -200,4 +206,64 @@ public class ServerMethod extends UnicastRemoteObject implements ServerInterface
 		}

 		return null;

 	}

+

+

+

+	@Override

+	public Map<String,String> getPersonData(String Vorname, String Nachname)

+			throws RemoteException {

+		Map<String,String> map=new HashMap<String, String>();

+		System.out.println(Vorname+Nachname);

+		ResultSet rs=sql.getPersonData(con, Vorname, Nachname);

+		try {

+			while(rs.next())

+			{

+				

+				map.put("mail", rs.getString("mail"));

+				map.put("Nachname", rs.getString("Nachname"));

+				map.put("Vorname", rs.getString("Vorname"));

+				map.put("Hochschule", rs.getString("name"));

+				map.put("tel", "009909");

+				map.put("fak", "E+I");

+				

+			}

+			return map;

+		} catch (SQLException e) {

+			// TODO Auto-generated catch block

+			e.printStackTrace();

+		}

+		return null;

+	}

+

+

+	@Override

+	public boolean writeLecturedata(String name, String shortdesc, String desc,

+			Date start, Date end, boolean isActive, String imagename,

+			String firstname, String lastname, String university, String Mail,

+			String Tel, String Fak) throws RemoteException {

+		int pk_image = 0;

+		String login="tete";

+		int imageversion = 0;

+		int pk_institution=sql.setInstitution(con, university);

+		int pk_person=sql.setPerson(con, login, lastname, firstname, Mail, new Date(), pk_institution);

+		System.out.println(imagename);

+		ResultSet image=sql.getImageIDandVersion(con, imagename);

+

+			try {

+				while(image.next())

+				{

+				pk_image=image.getInt("GUID_imageID");

+				imageversion=image.getInt("imageVersion");

+				}

+			} catch (SQLException e) {

+				// TODO Auto-generated catch block

+				e.printStackTrace();

+			}

+			

+			

+			

+			sql.setLectureData(con, pk_person, pk_image, imageversion, name, desc, shortdesc, start, end, isActive);

+		

+		return false;

+	}

 }
\ No newline at end of file