Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package outfit;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.Statement;
- public class ToegangsLog {
- public void main() throws Exception {
- ACRReader SERIAL = new ACRReader();
- long key = 123;
- Connection conn = DriverManager.getConnection( "jdbc:mysql://oege.ie.hva.nl/zeverae03", "everae03", "#7HDxm9bf" );
- Statement aa = conn.createStatement();
- ResultSet AA = aa.executeQuery( "SELECT * FROM `Database` WHERE serial = "+ key +"");
- //STAP 1 !!!
- if( AA.next() ) {
- System.out.println(
- "Stap 1: key staat in database");
- //STAP 3 !!!
- Statement bb = conn.createStatement();
- ResultSet BB = bb.executeQuery( "SELECT * FROM `Database` WHERE serial = "+ key +"");
- while( BB.next() ) {
- int id = BB.getInt( "Toegang" );
- //STAP 4 !!!
- if ( id == 2){
- System.out.println("NOOD PAS, ONTRUIM GEBOUW OMG !!!\nP.S iedereen logd uit ;D");
- PreparedStatement GG = conn.prepareStatement("UPDATE `Database` SET `Login` = '0'; ");
- GG.executeUpdate();
- }
- if ( id == 1){
- System.out.println("Stap 3: kaarthouder is eigenaar van winkel, DEUR OPEN !!");
- }
- //STAP 5 !!!
- if ( id == 0){
- System.out.println("Stap 3: kaarthouder is medewerker ");
- Statement cc = conn.createStatement();
- ResultSet CC = cc.executeQuery( "SELECT * FROM `Database` WHERE Login = '1'");
- if ( CC.next() ) {
- System.out.println("Stap 5: er is al iemand ingelogd ");
- }
- else {
- System.out.println("Stap 5: er is niemand ingelogd dus deze kaart logd in, tijd opslaan + deur open ");
- PreparedStatement DD = conn.prepareStatement("UPDATE `Database` SET `Login` = '1' WHERE `serial` ="+key +"; ");
- DD.executeUpdate();
- String intijd = "CURRENT_TIMESTAMP";
- PreparedStatement HH = conn.prepareStatement("INSERT INTO `Tijden` ( `serial` , `InTijd` , `UitTijd` )VALUES ("+key+", "+intijd+" , '0000-00-00 00:00:00');");
- HH.executeUpdate();
- }
- CC.close();
- cc.close();
- }
- }
- bb.close();
- BB.close();
- }
- //STAP 2 !!!
- else {
- System.out.println("Stap 2: kaart staat niet in de database");
- }
- AA.close();
- aa.close();
- conn.close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement