package ts;

import java.awt.BorderLayout;
import java.awt.Button;
import java.awt.Dimension;
import java.awt.Frame;
import java.awt.GridLayout;
import java.awt.Label;
import java.awt.Menu;
import java.awt.MenuBar;
import java.awt.Panel;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.lang.Object;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;

public class Main {

    ActionHandler ah = new ActionHandler(this);
    TextField uid = new TextField("");
    TextField user = new TextField("");
    TextField nwmin = new TextField("0");
    TextField nwmax = new TextField("0");
    TextField dagarmax = new TextField("0");
    TextField fick = new TextField("0");
    TextField dagarmin = new TextField("0");
    TextField tjuvar = new TextField("0");
    Label uid3 = new Label("UID:");
    Label user3 = new Label("User:");
    Label nwmin3 = new Label("NWmin:");
    Label nwmax3 = new Label("NWmax:");
    Label dagarmin3 = new Label("DagarMin:");
    Label fick3 = new Label("Fick:");
    Label dagarmax3 = new Label("DagarMax:");
    Label tjuvar3 = new Label("Tjvar:");
    Panel sokpanel = new Panel(new GridLayout(2, 8));
    Button sok = new Button("Sök");
    Statement stmt;
    ResultSet Objrs;
    Object[][] list;
    
    public Main() throws SQLException {
        uid.addActionListener(ah);
        user.addActionListener(ah);
        nwmin.addActionListener(ah);
        nwmax.addActionListener(ah);
        dagarmin.addActionListener(ah);
        fick.addActionListener(ah);
        dagarmax.addActionListener(ah);
        tjuvar.addActionListener(ah);
        sokpanel.add(uid3);
        sokpanel.add(user3);
        sokpanel.add(nwmin3);
        sokpanel.add(nwmax3);
        sokpanel.add(dagarmin3);
        sokpanel.add(dagarmax3);
        sokpanel.add(fick3);
        sokpanel.add(tjuvar3);
        sokpanel.add(uid);
        sokpanel.add(user);
        sokpanel.add(nwmin);
        sokpanel.add(nwmax);
        sokpanel.add(dagarmin);
        sokpanel.add(dagarmax);
        sokpanel.add(fick);
        sokpanel.add(tjuvar);
        
        uppkoppling("SELECT * FROM anvandare");

        String[] columnNames = {"UID",
            "user Name",
            "Nw",
            "Tid",
            "Dagar",
            "tjuvad",
            "fick",
            "tjuvar"
        };
        Objrs.last();
        int rad = Objrs.getRow();
        Objrs.beforeFirst();
        int x;
        Object[][] list = new Object[rad][8];
        while (Objrs.next()) {
            x = Objrs.getRow() - 1;
            list[x][0] = Objrs.getObject(2);
            list[x][1] = Objrs.getObject(3);
            list[x][2] = Objrs.getObject(4);
            list[x][3] = Objrs.getObject(5);
            list[x][4] = Objrs.getObject(6);
            list[x][5] = Objrs.getObject(8);
            list[x][6] = Objrs.getObject(9);
            list[x][7] = Objrs.getObject(10);
        }
        
        JTable jt = new JTable(list, columnNames);
        jt.setFillsViewportHeight(true);
        JScrollPane scrollPane = new JScrollPane(jt, JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
        scrollPane.setWheelScrollingEnabled(true);
        scrollPane.setPreferredSize(new Dimension(800, 600));
        JFrame frame = new JFrame("TheUberHaxxorTs");
        frame.setPreferredSize(new Dimension(800, 600));
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.pack();
        frame.setVisible(true);
        frame.setLayout(new BorderLayout());
        addMenu(frame);
        frame.add(sokpanel, BorderLayout.NORTH);
        frame.add(scrollPane);

    }

    public void uppkoppling(String sql) {
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        try {
            String url = "jdbc:mysql://mixt.mine.nu:3306/ts2";
            Connection conn = DriverManager.getConnection(url, "ts", "ts");
            System.out.println("Connection: " + conn);
            stmt = conn.createStatement();
            Objrs = stmt.executeQuery(sql);
//            tabel(Objrs);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }

    }
//    public Object tabel(ResultSet Objrs) throws SQLException{
// 
//            Objrs.last();
//            int rad = Objrs.getRow();
//            Objrs.beforeFirst();
//            int x;
//            Object[][] list = new Object[rad][8];
//            while (Objrs.next()) {
//                x = Objrs.getRow() - 1;
//                list[x][0] = Objrs.getObject(2);
//                list[x][1] = Objrs.getObject(3);
//                list[x][2] = Objrs.getObject(4);
//                list[x][3] = Objrs.getObject(5);
//                list[x][4] = Objrs.getObject(6);
//                list[x][5] = Objrs.getObject(8);
//                list[x][6] = Objrs.getObject(9);
//                list[x][7] = Objrs.getObject(10);
//              }
//           return list;
//
//    }

    private void addMenu(Frame frame) {
        MenuBar menu = new MenuBar();
        Menu game = new Menu();
        game.addActionListener(ah);
        game.setLabel("Arkiv");
        game.add("Connect");
        game.addSeparator();
        game.add("Exit");


        menu.add(game);
        frame.setMenuBar(menu);
    }

    private class ActionHandler implements ActionListener {

        private Main prog;

        private ActionHandler(Main prog) {

        }

        @Override
        public void actionPerformed(ActionEvent e) {
            String uid3 = uid.getText();
            String user3 = user.getText();
            int nwmin3 = Integer.parseInt(nwmin.getText());
            int nwmax3 = Integer.parseInt(nwmax.getText());
            int dagarmin3 = Integer.parseInt(dagarmin.getText());
            int fick3 = Integer.parseInt(fick.getText());
            int dagarmax3 = Integer.parseInt(dagarmax.getText());
            int tjuvar3 = Integer.parseInt(tjuvar.getText());

            if (nwmax3 == 0) {
                nwmax3 = 99999999;
            }
            if (dagarmax3 == 0) {
                dagarmax3 = 999;
            }

            System.out.println("SELECT * from anvandare where " + nwmax3 + " >= nw and nw >= " + nwmin3 + " and " + dagarmin3 + " >= dagar and dagar >= " + dagarmax3 + " and fick >= " + fick3 + " and " + tjuvar3 + " >= tjuvar  and UID like '%" + uid3 + "%' and user like '%" + user3 + "%'");
            uppkoppling("SELECT * from anvandare where " + nwmax3 + " >= nw and nw >= " + nwmin3 + " and " + dagarmin3 + " >= dagar and dagar >= " + dagarmax3 + " and fick >= " + fick3 + " and " + tjuvar3 + " >= tjuvar  and UID like '%" + uid3 + "%' and user like '%" + user3 + "%'");
            if ("Exit".equals(e.getActionCommand())) {
                System.exit(0);
            }
            if ("Connect".equals(e.getActionCommand())) {
                System.out.println("connect");
            }
        }
    }

    public static void main(String[] args) throws SQLException {
        Main prog = new Main();
    }
}