6HqR3k8x

1package me.timlampen.killrecorder;
2
3import org.bukkit.Bukkit;
4import org.bukkit.plugin.java.JavaPlugin;
5
6import java.sql.*;
7import java.util.HashMap;
8import java.util.UUID;
9
10/**
11 * Created by Primary on 2/28/2016.
12 */
13public class Main extends JavaPlugin{
14
15    String ip = "localhost";
16    String databaseName = "stats";
17    String username = "root";
18    String password = "";
19    String databaseURL = "jdbc:mysql://" + ip + ":3306/" + databaseName;
20    Connection connection;
21    Statement state;
22
23    HashMap<UUID, Integer> kills = new HashMap<UUID, Integer>();
24    @Override
25    public void onEnable(){
26        Bukkit.getPluginManager().registerEvents(new KillListener(), this);
27        getCommand("stats").setExecutor(new CommandHandler(this));
28
29        try {
30            Class.forName("com.mysql.jdbc.Driver");
31            connection = DriverManager.getConnection(databaseURL, username, password);
32            state = connection.createStatement();
33        }
34        catch(Exception ex) {
35            ex.printStackTrace();
36        }
37        //start mysql
38
39        try{
40            PreparedStatement ps = connection.prepareStatement("CREATE TABLE IF NOT EXISTS killData (UUID VARCHAR(36) PRIMARY KEY, kills INT);");
41        }catch(SQLException e) {
42            e.printStackTrace();
43        }
44        //create table if not exist
45
46        try{
47            ResultSet res = state.executeQuery("SELECT * FROM killData");
48            while(res.next()){
49                UUID uuid = UUID.fromString(res.getString("UUID"));
50                int killAmt = res.getInt("kills");
51                kills.put(uuid, killAmt);
52            }
53        }catch(SQLException e) {
54            e.printStackTrace();
55        }
56        //open connection
57        //add data to hashmap
58    }
59
60    @Override
61    public void onDisable(){
62
63        for(UUID uuid : kills.keySet()){
64            int killAmt = kills.get(uuid);
65            try{
66                state.executeUpdate("INSERT INTO killData (`UUID`, `kills`) VALUES ('" + uuid + "', '" + killAmt + "');");
67            }catch(SQLException e) {
68                e.printStackTrace();
69            }
70        }
71    }
72}