package kappa;

import java.sql.*;
import javax.swing.JOptionPane;

/*
 * 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.
 */
/**
 *
 * @author Krulcifer
 */
public class DBconnect {

    private Connection con;
    private Statement st;
    private ResultSet rs;
    private static String name;
    private static String raid;
    private static String address;

    public void GetSet(String name, String address, String raid) {
        this.name = name;
        this.raid = raid;
        this.address = address;
    }

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

            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/teht13", "root", "");
            st = con.createStatement();
        } catch (Exception ex) {
            System.out.println("Error: " + ex);
        }
    }

    public void getData(int idm) {

        try {
            String query = "select * from information where id="+idm;
            rs = st.executeQuery(query);
            System.out.println("Results from ID: " + idm);
            if (rs.next()) {
                name = rs.getString("name");
                address = rs.getString("address");
                raid = rs.getString("raid");
                System.out.println("ID: " + idm + "     " + " Name: " + name + "   " + "Age: " + address + "     " + "Raid: " + raid);
                Main.transfer(name, address, raid);
            }

        } catch (Exception ex) {
            System.out.println(ex);
        }

    }


    /*try {

            String query = "select * from information";
            rs = st.executeQuery(query);
            System.out.println("Results from ID: " + idm);
            while (rs.next()) {
                String id = rs.getString("ID");
                String name = rs.getString("name");
                String address = rs.getString("address");
                String raid = rs.getString("raid");
                System.out.println("ID: " + id + "     " + " Name: " + name + "   " + "Age: " + address + "     " + "Raid: " + raid);
            }
        } catch (Exception ex) {
            System.out.println("Error Data: " + ex);
        }
}*/
    public void setData(String name, String address, String raid) {

        try {
            String query1 = "insert into information VALUES(null,'" + name + "','" + address + "','" + raid + "')";
            int result = st.executeUpdate(query1);
            //rs = st.executeQuery(query1);

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

}