package FBC;
import java.sql.*;
import java.security.*;
import javax.crypto.*;
import javax.crypto.spec.*;
import java.io.*;
import java.net.*;
import java.util.ArrayList;

public class Mysql {
    protected static Connection conn;
    public static ArrayList<String> executeSQL(String sql, String Col) {
        try {
            ArrayList<String> out = new ArrayList<String>();
            ResultSet rs = conn.createStatement().executeQuery(sql);
            while (rs.next() == true){
                    out.add(rs.getString(Col));
                }
            rs.close();
            return out;
        } catch (SQLException e) {
            System.out.println("==>Mysql<=>SQL ERROR<-->" + e);
        }
        return new ArrayList<String>();
    }
    public static void MysqlConnect() {
        try{
            Class.forName("org.gjt.mm.mysql.Driver");
                conn = DriverManager.getConnection("jdbc:mysql://localhost/SocialGeek", "SocialGeekGamer", "SocialGeekGamer");
            System.out.println("==>Mysql<=>Connected");
        } catch (Exception err) {
            System.out.println("==>Mysql<=>Conection ERROR<-->" + err);
        }
    }
    public static void MysqlReConnect() {
        try{
                    conn.close();
            System.out.println("==>Mysql<=>Disconnected");
            MysqlConnect();
        } catch (Exception err) {
            System.out.println("==>Mysql<=>Conection ERROR<-->" + err);
        }
    }
}