/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package main;

import com.mysql.jdbc.Driver;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.util.List;

/**
 *
 * @author Reykez
 */
public class Download {

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

    static List<String> TOKEN_NAME;
    static List<String> TOKEN_ID;
    static List<String> TOKEN_APPNAME;
    static List<String> TOKEN_PERMISSIONS;

    static void getTokens() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://reykez.pl:3306/reykez_--" , "reykez_--" , "root--");
            st = con.createStatement();
            rs = st.executeQuery("select * from TOKENS"); // ma pobierać tylko z określoną zmienną "USER"!!!!!!
            while(rs.next()) {
                TOKEN_NAME.add(rs.getString("NAME"));
                TOKEN_ID.add(rs.getString("ID"));
                TOKEN_APPNAME.add(rs.getString("APPNAME"));
                TOKEN_PERMISSIONS.add(rs.getString("PERM"));
            }
            con.close();
        } catch(Exception e) { System.out.println("Err -> "); e.printStackTrace(); }
    }

    static void getPass() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://reykez.pl:3306/reykez_--" , "reykez_--" , "root--");
            st = con.createStatement();
            rs = st.executeQuery("select * from USERDATA");
            while(rs.next()) {
                TOKEN_NAME.add(rs.getString("NAME"));
                TOKEN_ID.add(rs.getString("PASSWORD"));
            }
            con.close();
        } catch(Exception e) { System.out.println("Err -> "); e.printStackTrace(); }
    }

}