diff options
Diffstat (limited to 'bwLehrpool_ServerMaintenance/src/sql/sql.java')
-rw-r--r-- | bwLehrpool_ServerMaintenance/src/sql/sql.java | 34 |
1 files changed, 31 insertions, 3 deletions
diff --git a/bwLehrpool_ServerMaintenance/src/sql/sql.java b/bwLehrpool_ServerMaintenance/src/sql/sql.java index 61b95172..dd8f9a39 100644 --- a/bwLehrpool_ServerMaintenance/src/sql/sql.java +++ b/bwLehrpool_ServerMaintenance/src/sql/sql.java @@ -1,5 +1,7 @@ package sql; +import java.io.File; +import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; @@ -7,6 +9,9 @@ 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() { @@ -18,12 +23,13 @@ public class sql { e.printStackTrace(); } try { + Wini ini = new Wini(new File("Maintenance_Config.ini")); Connection con = DriverManager - .getConnection("jdbc:mysql://localhost/bwlehrpool?user=bwlp_user&password=!20bwlehrpool14!"); + .getConnection("jdbc:mysql://"+ini.get("sql", "connection")+"?user="+ini.get("sql", "user")+"&password="+ini.get("sql", "pass")+""); con.setAutoCommit(false); return con; - } catch (SQLException e) { + } catch (SQLException | IOException e) { // TODO Auto-generated catch block e.printStackTrace(); @@ -37,7 +43,29 @@ public class sql { Connection con=getConnection(); Statement stm = con.createStatement(); - stm.executeUpdate("Delete from bwLehrpool.FtpUsers where CreationDate > date_sub(now(),interval 1 day);"); + 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(); |