Erste Maintenance Funktion

5 files changed, 88 insertions, 1 deletions

diff --git a/bwLehrpool_ServerMaintenance/.classpath b/bwLehrpool_ServerMaintenance/.classpath
index 91ee9a52..d6a68ab0 100644
--- a/bwLehrpool_ServerMaintenance/.classpath
+++ b/bwLehrpool_ServerMaintenance/.classpath
@@ -2,5 +2,7 @@
 <classpath>

 	<classpathentry kind="src" path="src"/>

 	<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER/org.eclipse.jdt.internal.debug.ui.launcher.StandardVMType/JavaSE-1.7"/>

+	<classpathentry kind="lib" path="/Dozentenmodul/lib/ini4j-0.5.2-SNAPSHOT.jar"/>

+	<classpathentry kind="lib" path="lib/mysql-connector-java-5.1.25-bin.jar"/>

 	<classpathentry kind="output" path="bin"/>

 </classpath>

diff --git a/bwLehrpool_ServerMaintenance/lib/ini4j-0.5.2-SNAPSHOT.jar b/bwLehrpool_ServerMaintenance/lib/ini4j-0.5.2-SNAPSHOT.jar
new file mode 100644
index 00000000..6f6877c5
--- /dev/null
+++ b/bwLehrpool_ServerMaintenance/lib/ini4j-0.5.2-SNAPSHOT.jar
diff --git a/bwLehrpool_ServerMaintenance/lib/mysql-connector-java-5.1.25-bin.jar b/bwLehrpool_ServerMaintenance/lib/mysql-connector-java-5.1.25-bin.jar
new file mode 100644
index 00000000..207232df
--- /dev/null
+++ b/bwLehrpool_ServerMaintenance/lib/mysql-connector-java-5.1.25-bin.jar
diff --git a/bwLehrpool_ServerMaintenance/src/Main.java b/bwLehrpool_ServerMaintenance/src/Main.java
index 93504c7e..42b3dfcd 100644
--- a/bwLehrpool_ServerMaintenance/src/Main.java
+++ b/bwLehrpool_ServerMaintenance/src/Main.java
@@ -1,3 +1,12 @@
+import java.io.File;

+import java.io.IOException;

+import java.util.Date;

+

+import org.ini4j.InvalidFileFormatException;

+import org.ini4j.Wini;

+

+import sql.sql;

+

 

 public class Main {

 

@@ -5,7 +14,32 @@ public class Main {
 	 * @param args

 	 */

 	public static void main(String[] args) {

-		// TODO Auto-generated method stub

+		

+		Date actDate=new Date();

+		

+		System.out.println(actDate);

+		

+		try {

+			Wini ini = new Wini(new File("C:\\Users\\tspitzer\\Desktop\\Maintenance_Config.ini"));

+			String delete_ftp=ini.get("ftp", "day");

+			System.out.println(delete_ftp);

+			String inactive_lecture=ini.get("lecturetoinactive", "day");

+			System.out.println(inactive_lecture);

+			String delete_lecture=ini.get("lecturedelete", "day");

+			System.out.println(delete_lecture);

+			String image_without_lecture=ini.get("imagewithoutlecture", "day");

+			System.out.println(image_without_lecture);

+			sql s=new sql();

+			s.deleteFTPUsers();

+		} catch (InvalidFileFormatException e) {

+			// TODO Auto-generated catch block

+			e.printStackTrace();

+		} catch (IOException e) {

+			// TODO Auto-generated catch block

+			e.printStackTrace();

+		}

+		

+		

 

 	}

 

diff --git a/bwLehrpool_ServerMaintenance/src/sql/sql.java b/bwLehrpool_ServerMaintenance/src/sql/sql.java
new file mode 100644
index 00000000..61b95172
--- /dev/null
+++ b/bwLehrpool_ServerMaintenance/src/sql/sql.java
@@ -0,0 +1,51 @@
+package sql;
+
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+import java.util.Date;
+
+public class sql {
+	
+	public Connection getConnection() {
+		try {
+			Class.forName("com.mysql.jdbc.Driver").newInstance();
+		} catch (InstantiationException | IllegalAccessException
+				| ClassNotFoundException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		try {
+			Connection con = DriverManager
+					.getConnection("jdbc:mysql://localhost/bwlehrpool?user=bwlp_user&password=!20bwlehrpool14!");
+			con.setAutoCommit(false);
+			
+			return con;
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+	
+			e.printStackTrace();
+		}
+		return null;
+	}
+	
+	
+	public void deleteFTPUsers(){
+		try {
+			Connection con=getConnection();
+			Statement stm = con.createStatement();
+
+			stm.executeUpdate("Delete from bwLehrpool.FtpUsers where CreationDate > date_sub(now(),interval 1 day);");
+			con.close();
+			
+			
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			
+			e.printStackTrace();
+		}
+	}
+
+}