From 039685231a047668e98ad595557eab5ec6447374 Mon Sep 17 00:00:00 2001
From: Tobias Spitzer
Date: Fri, 6 Jun 2014 12:32:59 +0200
Subject: Erste Maintenance Funktion

---
 bwLehrpool_ServerMaintenance/src/sql/sql.java | 51 +++++++++++++++++++++++++++
 1 file changed, 51 insertions(+)
 create mode 100644 bwLehrpool_ServerMaintenance/src/sql/sql.java

(limited to 'bwLehrpool_ServerMaintenance/src/sql/sql.java')

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();
+		}
+	}
+
+}
-- 
cgit v1.2.3-55-g7522