package Kr;

import java.awt.List;
import java.sql.*;
import java.util.ArrayList;
import java.util.Arrays;

public class DBConnect {

    private Connection con;
    private Statement st;
    private ResultSet rs;

    private String userName;
    private String password;
    private int counter = 0;
    Object record;

    public Object player, date, ychamp, echamp, item1, item2, item3, item4, item5, item6, kills, deaths, assists, minions, time, gold, mid;
    private Object userlist;
    String player11[];
    ArrayList<Object> player1, date1, ychamp1, echamp1, item11, item21, item31, item41, item51, item61, kills1, deaths1, assists1, minions1, time1, gold1, mid1 = new ArrayList<Object>();
    private Object[] playerA, dateA, ychampA, echampA, item1A, item2A, item3A, item4A, item5A, item6A, killsA, deathsA, assistsA, minionsA, timeA, goldA, midA;

    ArrayList<Object> testList = new ArrayList<Object>();

    public DBConnect() {
        try {
            Class.forName("com.mysql.jdbc.Driver");

            con = DriverManager.getConnection("jdbc:mysql://192.168.1.74:3306/leagueinfo", "kapu", "");
            st = con.createStatement();

        } catch (Exception ex) {
            System.out.println("Error: " + ex);
        }
    }

    public void checkLogin(String username1, String password1) {

        try {
            rs = st.executeQuery("SELECT * FROM users WHERE user='" + username1 + "'");

            if (rs.next()) {
                userName = rs.getString("user");
                password = rs.getString("password");
                Main.transfer(userName, password);

            } else {
                System.out.println("Error Login");
            }
        } catch (Exception ex) {
            System.out.println("Error Paste checkLogin: " + ex);
        }
    }

    public void giveRegister(String username, String password) {
        try {
            String insert = "insert into users VALUES('" + username + "','" + password + "')";
            st.executeUpdate(insert);
        } catch (Exception ex) {
            System.out.println("Error Paste Register: " + ex);
        }
    }

    public void matchInfo(String player, Date date, String ychamp, String echamp, String item1, String item2, String item3, String item4, String item5, String item6, String kills, String deaths, String assists, String farm, String time, String gold, String mid) {
        try {
            String insert = "insert into matches VALUES('" + player + "','" + date + "','" + ychamp + "','" + echamp + "','" + item1 + "','" + item2 + "','" + item3 + "','" + item4 + "','" + item5 + "','" + item6 + "','" + kills + "','" + deaths + "','" + assists + "','" + farm + "','" + time + "','" + gold + "','" + mid + "')";
            st.executeUpdate(insert);
        } catch (Exception ex) {
            System.out.println("Error Paste matchInfo " + ex);
        }
    }

    public void getUserList() {
        try {
            String query = "select user from users";
            rs = st.executeQuery(query);

            while (rs.next()) {
                userlist = rs.getString("user");
                Main.Lista(userlist);
            }

        } catch (Exception ex) {
            System.out.println("Error paste getUserList: " + ex);
        }
    }

    public void getInfo(String username1) {

        try {
            rs = st.executeQuery("SELECT * FROM matches WHERE player='" + username1 + "'");
            while (rs.next()) {
                player = rs.getString("player");
                date = rs.getString("date");
                ychamp = rs.getString("ychamp");
                echamp = rs.getString("echamp");
                item1 = rs.getString("item1");
                item2 = rs.getString("item2");
                item3 = rs.getString("item3");
                item4 = rs.getString("item4");
                item5 = rs.getString("item5");
                item6 = rs.getString("item6");
                kills = rs.getString("kills");
                deaths = rs.getString("deaths");
                assists = rs.getString("assists");
                minions = rs.getString("minions");
                time = rs.getString("time");
                gold = rs.getString("gold");
                mid = rs.getString("mid");

                counter++;
                // Main.transferinfo(player, date, ychamp, echamp, item1, item2, item3, item4, item5, item6, kills, deaths, assists, minions, time, gold, mid, counter);
                Main.transfertest(player, date, ychamp, echamp, item1, item2, item3, item4, item5, item6, kills, deaths, assists, minions, time, gold, mid, counter);

            }

        } catch (Exception ex) {
            System.out.println("Error paste getInfo " + ex);
        }
    }

}