whfXJqPD

1package de.tubecraft.Global.MySQL;
2
3import java.sql.Connection;
4import java.sql.DriverManager;
5import java.sql.ResultSet;
6import java.sql.SQLException;
7
8/**
9 * Created by Admin on 05.04.2017.
10 */
11public class MySQL {
12
13    public static Connection con;
14
15    public static void createTable()
16    {
17        if (isConnected()) {
18            try
19            {
20                con.createStatement().executeUpdate(
21                        "CREATE TABLE IF NOT EXISTS FeedBack(UUID VARCHAR(100), Punkte VARCHAR(100));");
22            }
23            catch (SQLException e)
24            {
25                e.printStackTrace();
26            }
27        }
28    }
29
30    public static void connect()
31    {
32        try
33        {
34            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/feedbackmanager?autoReconnect=true", "root", "");
35            createTable();
36        }
37        catch (SQLException e)
38        {
39            e.printStackTrace();
40        }
41    }
42
43    public static void close()
44    {
45        if (isConnected()) {
46            try
47            {
48                con.close();
49                con = null;
50            }
51            catch (SQLException e)
52            {
53                e.printStackTrace();
54            }
55        }
56    }
57
58    public static boolean isConnected()
59    {
60        return con != null;
61    }
62
63    public static void update(String qry)
64    {
65        if (isConnected()) {
66            try
67            {
68                con.createStatement().executeUpdate(qry);
69            }
70            catch (SQLException e)
71            {
72                e.printStackTrace();
73                connect();
74            }
75        }
76    }
77
78    public static ResultSet getResult(String qry)
79    {
80        if (isConnected()) {
81            try
82            {
83                return con.createStatement().executeQuery(qry);
84            }
85            catch (SQLException e)
86            {
87                e.printStackTrace();
88                connect();
89            }
90        }
91        return null;
92    }
93}