import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JTextArea;

/*
 * 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 chrastek_martin
 */
public class Okno extends JFrame{

    JTextArea text = new JTextArea();
    Connection con = null;

    public Okno() throws IOException{
        initComponents();
        pripojeni();
        //pridani();
        vypis();
    }


    private void initComponents(){
        this.setTitle("Databázový výpis");
        this.setDefaultCloseOperation(EXIT_ON_CLOSE);
        this.setSize(275,120);
        this.setLocationRelativeTo(null);
        this.getContentPane().add(text);

    }

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) throws IOException {
        new Okno().setVisible(true);;
    }

    private Connection pripojeni() throws FileNotFoundException, IOException {
        // Zkontrolujeme instalaci ovladače
        try {
            Class.forName("com.mysql.jdbc.Connection");
        } catch (ClassNotFoundException ex) {
            JOptionPane.showMessageDialog(
                    null,
                    "Ovladač databáze není správně zahrnut do projektu! Nenalezena třída: "+ ex.getMessage()+"!",
                    "Chyba ovladače JDBC",
                    JOptionPane.ERROR_MESSAGE);
            System.exit(1);
        }

        try
        {
        Properties prop=new Properties();
        FileInputStream in = new FileInputStream("spojeni.properties");
        prop.load(in);
        in.close();

        String host = prop.getProperty("host");
        String nazevDatabaze = prop.getProperty("nazevDatabaze");
        String userDB = prop.getProperty("userDB");
        String passDB = prop.getProperty("passDB");
        String url = "jdbc:mysql://" + host + "/" + nazevDatabaze;

        con=DriverManager.getConnection(url,userDB,passDB);

            System.out.println("Connection Successful");
            return con;
        }
        catch(SQLException ex)
        {
            JOptionPane.showMessageDialog(
                    null,
                    "Chyba při otevření spojení s s databází:"+ ex.getMessage(),
                    "Chyba spojení s databází", JOptionPane.ERROR_MESSAGE);
            System.exit(1);
        }
        return null;

    }

    private void pridani() {
        Statement st = null;

        try {
            st = con.createStatement();

            st.executeUpdate("INSERT INTO Zaci VALUES ('Martin','Chrástek','4',2);");

        } catch (SQLException ex) {
            Logger.getLogger(Okno.class.getName()).log(Level.SEVERE, null, ex);
        }

        if (con != null) {
            try {
                con.close();
            } catch (SQLException ex) {
                Logger.getLogger(Okno.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    }

    private void vypis() {
        Statement st = null;

        try {
            st = con.createStatement();
            ResultSet rs = null;

            rs = st.executeQuery("SELECT * FROM Zaci");

            while (rs.next()){
                text.append(rs.getString(1)+ " ");
                text.append(rs.getString(2)+ ", ");
                text.append(rs.getString(3)+ ", ");
                text.append(rs.getString(4));
                text.append("\n");
            }

        } catch (SQLException ex) {
            Logger.getLogger(Okno.class.getName()).log(Level.SEVERE, null, ex);
        }

        if (con != null) {
            try {
                con.close();
            } catch (SQLException ex) {
                Logger.getLogger(Okno.class.getName()).log(Level.SEVERE, null, ex);
            }
        }

    }

}