import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class MySql {

    private static Connection c = null;
    private static Statement st;
    private Main m;
    private static final String DATABASE = "";
    private static final String TABLE = "players";

    public MySql(Main m) {
        this.m = m;
    }

    public void createConnection() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            c = DriverManager.getConnection("jdbc:mysql://64.120.203.67/"+DATABASE,"","");
            st = c.createStatement();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public void insertIntoTable(String primaryKey, String valName, Object toInsert) {
        try {
            st.execute("INSERT INTO " + TABLE + " ('/"+valName+"') VALUES ('"+toInsert+"') WHERE names = "+primaryKey + " {escape '/'}");
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    public Object getFromTable(String name, String toGet) {
        try {
            st.execute("SELECT * FROM " + TABLE +" WHERE names = " +name);
            ResultSet r = st.getResultSet();
            while (r.next()) {
                return r.getObject(toGet);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
            return -1;
        }
        return -1;
    }

    public void createRow(String name) {
        try {
            //st.execute("INSERT INTO " + TABLE +" (names) VALUES ("+name+");");
            st.execute("INSERT INTO "+TABLE+" (names) VALUES ("+name+")");
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

}