package kajszczak_sebastian_prj;
import java.awt.BorderLayout;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;

public class derby {
	public static void main(String [] args){
		derby x = new derby();
	   x.draw();
	}

	public JFrame draw(){
		ResultSet rs;
		String[] columnNames = { "Id_plyty",
				   "Tytul_filmu",
				   "Czas_trwania",
				   "Dubbing",
				   "Rezyser_nazwisko",
				   "Rezyser_imie",
				   "Rok_produkcji" };
		Vector<String> column = new Vector<String>();
		for(int i = 0; i < columnNames.length; i++){
			column.add(columnNames[i]);
		}
		final Vector<Vector<String>> model = new Vector<Vector<String>>();
		try{
			Connection conn;
			//Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
			conn = DriverManager.getConnection("jdbc:derby:C:\\Users\\Silme\\Desktop\\derby\\derby\\kajszczak_sebastian_bd");
			Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
			rs = stmt.executeQuery("select * from filmy");
			while(rs.next()){
				Vector<String> row = new Vector<String>();
				for(int i = 0; i<7; i++){
					System.out.println(rs.getString(i+1));
					row.add(rs.getString(i+1));
				}
				model.add(row);
				//row.clear();
			}
			conn.close();

		}
		catch(Exception e){
			System.out.println(e.toString());
		}
		 final JFrame frame = new JFrame("Filmy");
	    frame.setLayout(new FlowLayout());
	    JButton delButton = new JButton("Usun");
	    JButton modButton = new JButton("Aktualizuj");
	    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	    final JTable table = new JTable(model, column);
	    JScrollPane scrollPane = new JScrollPane(table);
	    frame.add(scrollPane, BorderLayout.CENTER);
	    frame.setSize(500,500);
	    frame.add(delButton);
	    frame.add(modButton);
	    frame.setVisible(true);
	    ActionListener delListener = new ActionListener() {
	        public void actionPerformed(ActionEvent actionEvent) {
	          try {
				Connection conn = DriverManager.getConnection("jdbc:derby:C:\\Users\\Silme\\Desktop\\derby\\derby\\kajszczak_sebastian_bd");
				Statement stmt = conn.createStatement();
				String s = "DELETE from filmy where id_plyty = '" + model.get(table.getSelectedRow()).get(0) + "'";
				System.out.println(s);
				int rs = stmt.executeUpdate(s);
				//model.remove(table.getSelectedRow());
				frame.setVisible(false);
				draw();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
	        }
	      };
	      ActionListener modListener = new ActionListener() {
		        public void actionPerformed(ActionEvent actionEvent) {
		          try {
					Vector x = model.get(table.getSelectedRow());
					String s = "UPDATE filmy SET id_plyty='"+ x.get(0)+"', tytul_filmu='"+ x.get(1)+"', czas_trwania="+ x.get(2)+", dubbing='"+ x.get(3)+"', rezyser_nazwisko='"+ x.get(4)+"', rezyser_imie='"+ x.get(5)+"', rok_produkcji="+ x.get(6)+"  where id_plyty = '" + model.get(table.getSelectedRow()).get(0) + "'";

					System.out.println(s);
					Connection conn = DriverManager.getConnection("jdbc:derby:C:\\Users\\Silme\\Desktop\\derby\\derby\\kajszczak_sebastian_bd");
					Statement stmt = conn.createStatement();
					int rs = stmt.executeUpdate(s);
					//model.remove(table.getSelectedRow());
					frame.setVisible(false);
					draw();
				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
		        }
		      };
	    delButton.addActionListener(delListener);
	    modButton.addActionListener(modListener);
	    return frame;
	}
}