.....aaaaand it's gone

1 files changed, 0 insertions, 79 deletions

diff --git a/bwLehrpool_ServerMaintenance/src/sql/sql.java b/bwLehrpool_ServerMaintenance/src/sql/sql.java
deleted file mode 100644
index b3b20a89..00000000
--- a/bwLehrpool_ServerMaintenance/src/sql/sql.java
+++ /dev/null
@@ -1,79 +0,0 @@
-package sql;
-
-import java.io.File;
-import java.io.IOException;
-import java.sql.Connection;
-import java.sql.DriverManager;
-import java.sql.ResultSet;
-import java.sql.SQLException;
-import java.sql.Statement;
-import java.util.Date;
-
-import org.ini4j.InvalidFileFormatException;
-import org.ini4j.Wini;
-
-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 {
-			Wini ini = new Wini(new File("Maintenance_Config.ini"));
-			Connection con = DriverManager
-					.getConnection("jdbc:mysql://"+ini.get("sql", "connection")+"?user="+ini.get("sql", "user")+"&password="+ini.get("sql", "pass")+"");
-			con.setAutoCommit(false);
-			
-			return con;
-		} catch (SQLException | IOException 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.commit();
-			con.close();
-			
-			
-		} catch (SQLException e) {
-			// TODO Auto-generated catch block
-			
-			e.printStackTrace();
-		}
-	}
-	
-	public void setLectureInactive(){
-		try {
-			Connection con=getConnection();
-			Statement stm_query = con.createStatement();
-			Statement stm_update = con.createStatement();
-			ResultSet rs=stm_query.executeQuery("SELECT lectureID FROM bwLehrpool.m_VLData_lecture where lastUsed < date_sub(now(),interval 1 day);");
-			while(rs.next()){
-				System.out.println(rs.getString("lectureID"));
-				stm_update.executeUpdate("UPDATE `bwLehrpool`.`m_VLData_lecture` SET `isActive`='0' WHERE `lectureID`='"+rs.getString("lectureID")+"';");
-			}
-			con.commit();
-			con.close();
-			
-			
-		} catch (SQLException e) {
-			// TODO Auto-generated catch block
-			
-			e.printStackTrace();
-		}
-	}
-
-}