/*
 * 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 vaja8_02_netbeans;

/**
 *
 * @author Vid
 */

import java.sql.*;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import javax.swing.AbstractAction;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.event.ActionListener;
import java.util.Arrays;
import javax.swing.JScrollPane;
import javax.swing.JTable;

public class NALOGA1 {
    static String[][] data;
    static String[] stolpci;
    /**
     * @param args the command line arguments
     * @throws java.sql.SQLException
     */
    public static void main(String[] args) throws SQLException {

        Connection povezava = DriverManager.getConnection("jdbc:mysql://localhost:3306/phonebook?zeroDateTimeBehavior=convertToNull", "mojuser", "test");
        Statement stavek = povezava.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);

        JFrame okvir = new JFrame("Vnosna forma");
        okvir.setSize(860, 300);
        okvir.setLayout(new GridLayout(4,0));
        okvir.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);


        Container neki = okvir.getContentPane();
        JPanel panel1 = new JPanel(new FlowLayout(FlowLayout.CENTER));
        JPanel panel2 = new JPanel(new FlowLayout(FlowLayout.CENTER));
        JPanel panel3 = new JPanel(new FlowLayout(FlowLayout.CENTER));
        neki.add(panel1, BorderLayout.LINE_START);
        neki.add(panel2, BorderLayout.LINE_START);
        neki.add(panel3, BorderLayout.LINE_START);

        JTextField box = new JTextField(75);
        panel1.add(box);

        JButton gumb = new JButton(new AbstractAction("IZVEDI UKAZ"){



            @Override
            public void actionPerformed(ActionEvent e){
              try{
                ResultSet rezultati = stavek.executeQuery(box.getText());
              ResultSetMetaData meta = rezultati.getMetaData();
              int j = prestejVrstice(rezultati);
              int k = meta.getColumnCount();


            stolpci = new String[k];
            for(int i = 0; i < k; i++){
            stolpci[i] = meta.getColumnName(i);
        }
            System.out.println(Arrays.toString(stolpci));
            data = new String[j][k];
            int vrst = 0;
            while(rezultati.next()){
                for(int x = 0; x < k; x++){
                    data[vrst][x] = String.valueOf(rezultati.getObject(x));
                }
                vrst++;
            }
            System.out.println(Arrays.toString(data[0]));
              } catch (SQLException s){
              }
              JTable tabela = new JTable(data, stolpci);
              JScrollPane pane = new JScrollPane(tabela);
              panel3.add(pane);
              }

            });





        panel2.add(gumb);

        okvir.setVisible(true);



    }
    static int prestejVrstice(ResultSet a) throws SQLException{

    a.last();
    int size = a.getRow();
    return size;
    }
}