Advertisement
Guest User

Untitled

a guest
Aug 30th, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.33 KB | None | 0 0
  1.     private static final int Integer = 0;
  2.     public static MySQL MySQL = new MySQL("snip", "snip", "snip", "snip", "snip");
  3.     public static Connection c = null;
  4.    
  5.     public static void enable() {
  6.         try {
  7.             c = MySQL.openConnection();
  8.             Main.getInstance().getLogger().info("MySQL Fired!");
  9.         } catch (ClassNotFoundException e) {
  10.             // TODO Auto-generated catch block
  11.             e.printStackTrace();
  12.         } catch (SQLException e) {
  13.             // TODO Auto-generated catch block
  14.             e.printStackTrace();
  15.         }
  16.     }
  17.    
  18.     public static int sqlLoginQuery(Player p) throws SQLException {
  19.         Statement statement = c.createStatement();
  20.         Main.getInstance().getLogger().info("Second Query fired!");
  21.         ResultSet res = statement.executeQuery("SELECT * FROM player_data WHERE Name = '" + p.getName() + "';");
  22.         res.next();
  23.         int Integer = res.getInt("Logins");
  24.         Main.getInstance().getLogger().info("" + Integer);
  25.         if(res.getString("Name") == null) {
  26.             Main.getInstance().getLogger().info("Null");
  27.             statement.executeUpdate("INSERT INTO player_data (Name, Logins) VALUES ('" + p.getName() + "', 1);");
  28.         } else {
  29.             int Integer2 = Integer + 1;
  30.             Main.getInstance().getLogger().info("" + Integer2);
  31.             statement.executeUpdate("UPDATE player_data SET Logins = '" + Integer2 + "' WHERE Name = '" + p.getName() + "'");
  32.         }
  33.         return Integer;
  34.     }
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement