package pl.kti.pk2.dbdemo.gui;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.BorderFactory;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextArea;

import pl.kti.pk2.dbdemo.data.CachingResultSetTableModel;
import pl.kti.pk2.dbdemo.data.DBManager;

public class DBDemoFrame extends JFrame {

	private static final long serialVersionUID = -6846315193410091203L;

	public static void main(String[] args) {
		JFrame app_frame = new DBDemoFrame();
		app_frame.setVisible(true);
	}

	private JTable _table;
	private CachingResultSetTableModel _tableModel;
	private JButton _showAll;
	private JButton _showLatest;
	private JButton _Departments;
	private JButton _EmptfromtheDept;
	private JButton _Addnewdept;
	private JButton _newemployee;

	public DBDemoFrame() {
		super("database connectivity demo");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setSize(550, 650);
		setLocationRelativeTo(null);

		initGUI();
	}

	private void initGUI() {
		getContentPane().setLayout(new BorderLayout());

		// query area
getContentPane().setLayout(new BorderLayout(2,1));

		JPanel actionPanel = new JPanel();
		actionPanel.setLayout(new GridLayout(5, 1));
		getContentPane().add(actionPanel,BorderLayout.NORTH);

		_Addnewdept = new JButton("Add new dept");
		actionPanel.add(_Addnewdept);

		_newemployee = new JButton("Add new employee");
		actionPanel.add(_newemployee);

		_Departments= new JButton("Departments");
		actionPanel.add(_Departments);
		_Departments.addActionListener( new ActionListener(){
			public void actionPerformed(ActionEvent arg0){

				Departments();
			}

		});
		_EmptfromtheDept= new JButton(" Empt. from Dept.");
		actionPanel.add(_EmptfromtheDept);
		_EmptfromtheDept.addActionListener( new ActionListener(){
			public void actionPerformed(ActionEvent arg0){
				EmptfromtheDept();
			}
		});

		_showAll = new JButton("ShowAll");
		actionPanel.add(_showAll);

		_showAll.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent arg0) {
			showAll();
		}
	});

		_showLatest = new JButton("ShowLatest");
		actionPanel.add(_showLatest);

		_showLatest.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent arg0) {
			showLatest();
		}
	});

		// data table
		_tableModel = new CachingResultSetTableModel(null);
		_table = new JTable(_tableModel);
		JScrollPane tableScroll = new JScrollPane(_table);
        add(tableScroll, BorderLayout.CENTER);





	}
	protected void EmptfromtheDept(){
		try{
			int x;
			x = _table.getSelectedRow();
			x = (Integer) _tableModel.getValueAt(x, 0);
			String query= "select * from dzialy, pracownicy where pracownicy.idd_fk="+x +" and dzialy.idd ="+x+" ;";
			Statement stmt = DBManager.getConnection().createStatement();
			ResultSet queryResult = stmt.executeQuery(query);
			_tableModel.setResultSet(queryResult);
			queryResult.close();
		    stmt.close();

		}
		catch(Exception e) {

		}

		}

	protected void Departments(){
		try{
			String query = "select * from dzialy;";
			Statement stmt = DBManager.getConnection().createStatement();
			ResultSet queryResult = stmt.executeQuery(query);
			// pass the resultSet to the table model (use setResultSet method from the model)
			_tableModel.setResultSet(queryResult);
			// close the resultSet and statement
			queryResult.close();
		    stmt.close();

		}
		catch(Exception e) {
		}


	}
	protected void showAll()
	{
		try
		{
			String query = "select * from pracownicy;";
			Statement stmt = DBManager.getConnection().createStatement();
			ResultSet queryResult = stmt.executeQuery(query);
			// pass the resultSet to the table model (use setResultSet method from the model)
			_tableModel.setResultSet(queryResult);
			// close the resultSet and statement
			queryResult.close();
		    stmt.close();

		}
		catch(Exception e) {
//			.setText(e.getMessage());
		}
	}

	protected void showLatest()
	{
		try
		{
			String query = "select * from pracownicy " +
					"ORDER BY Id desc LIMIT 1;";
			Statement stmt = DBManager.getConnection().createStatement();
			ResultSet queryResult = stmt.executeQuery(query);
			// pass the resultSet to the table model (use setResultSet method from the model)
			_tableModel.setResultSet(queryResult);
			// close the resultSet and statement
			queryResult.close();
		    stmt.close();

		}
		catch(Exception e) {

		}
	}


}