import java.awt.BorderLayout;
import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;

import net.proteanit.sql.DbUtils;

import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.awt.event.ActionEvent;
import javax.swing.JTable;
import javax.swing.JScrollPane;
import javax.swing.JTabbedPane;

public class newJFrame extends JFrame {

	private JPanel contentPane;
	private JTextField Nume;
	private JTextField Marime;
	private JTextField Culoare;
	private JTextField Pret;

	Connection conn = null;
	PreparedStatement pst = null;
	ResultSet rs = null;
	private JTextField idPantofi;
	private JTable table;


	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					newJFrame frame = new newJFrame();
					frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}


	public void showTableData() {
		try {
			 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/Database?useSSL=false", "root", "password");
			 String sql = "SELECT * FROM Database.Pantofi";
			 pst = conn.prepareStatement(sql);
			 rs = pst.executeQuery();
			 table.setModel(DbUtils.resultSetToTableModel(rs));
		}
		catch (Exception ex){
			JOptionPane.showMessageDialog(null, ex);
		}
		}

	/**
	 * Create the frame.
	 */
	public newJFrame() {
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 719, 392);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);


		JLabel lblName = new JLabel("Nume");
		lblName.setBounds(66, 75, 46, 14);
		contentPane.add(lblName);

		JLabel lblSize = new JLabel("Marime");
		lblSize.setBounds(66, 115, 46, 14);
		contentPane.add(lblSize);

		JLabel lblColor = new JLabel("Culoare");
		lblColor.setBounds(66, 167, 46, 14);
		contentPane.add(lblColor);

		JLabel lblPret = new JLabel("Pret");
		lblPret.setBounds(66, 220, 46, 14);
		contentPane.add(lblPret);

		Nume = new JTextField();
		Nume.setBounds(143, 72, 86, 20);
		contentPane.add(Nume);
		Nume.setColumns(10);

		Marime = new JTextField();
		Marime.setBounds(143, 112, 86, 20);
		contentPane.add(Marime);
		Marime.setColumns(10);

		Culoare = new JTextField();
		Culoare.setBounds(143, 164, 86, 20);
		contentPane.add(Culoare);
		Culoare.setColumns(10);

		Pret = new JTextField();
		Pret.setBounds(143, 217, 86, 20);
		contentPane.add(Pret);
		Pret.setColumns(10);



		JButton btnNewButton = new JButton("Insert");
		btnNewButton.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				 try {
					 String sql = "INSERT INTO Database.Pantofi"
							 +"(idPantofi, Nume, Marime, Culoare, Pret) "
							 +"VALUES (?,?,?,?,?)";
					 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/Database?useSSL=false", "root", "password");
					 pst = conn.prepareStatement(sql);
					 pst.setString(1, idPantofi.getText());
					 pst.setString(2, Nume.getText());
					 pst.setString(3, Marime.getText());
					 pst.setString(4, Culoare.getText());
					 pst.setString(5, Pret.getText());
					 pst.executeUpdate();
					 JOptionPane.showMessageDialog(null,  "inserted successfully");
				 }
				 catch(Exception ex){
					 JOptionPane.showMessageDialog(null, ex);
				 }
				 showTableData();
			}
		});
		btnNewButton.setBounds(10, 295, 89, 23);
		contentPane.add(btnNewButton);


		JButton btnNewButton_2 = new JButton("Update");
		btnNewButton_2.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				try {
					 String sql = "UPDATE Database.Pantofi SET Nume = ?, Marime = ?, Culoare = ?, Pret = ? WHERE idPantofi = ?";
					 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/Database?useSSL=false", "root", "password");
					 pst = conn.prepareStatement(sql);
					 pst.setString(5, idPantofi.getText());
					 pst.setString(1, Nume.getText());
					 pst.setString(2, Marime.getText());
					 pst.setString(3, Culoare.getText());
					 pst.setString(4, Pret.getText());
					 pst.executeUpdate();
					 JOptionPane.showMessageDialog(null,  "updated successfully");
				 }
				 catch(Exception ex){
					 JOptionPane.showMessageDialog(null, ex);
				 }
				showTableData();
			}
		});
		btnNewButton_2.setBounds(213, 295, 89, 23);
		contentPane.add(btnNewButton_2);

		JButton btnNewButton_3 = new JButton("Delete");
		btnNewButton_3.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				try {
					 String sql = "DELETE FROM Database.Pantofi WHERE idPantofi = ?";
					 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/Database?useSSL=false", "root", "password");
					 pst = conn.prepareStatement(sql);
					 pst.setString(1, idPantofi.getText());
					 pst.executeUpdate();
					 JOptionPane.showMessageDialog(null,  "deleted successfully");
				 }
				 catch(Exception ex){
					 JOptionPane.showMessageDialog(null, ex);
				 }
			    showTableData();
			}
		});
		btnNewButton_3.setBounds(109, 295, 89, 23);
		contentPane.add(btnNewButton_3);

		JLabel lblNewLabel = new JLabel("Numar");
		lblNewLabel.setBounds(53, 32, 46, 14);
		contentPane.add(lblNewLabel);

		idPantofi = new JTextField();
		idPantofi.setBounds(143, 29, 86, 20);
		contentPane.add(idPantofi);
		idPantofi.setColumns(10);

		JScrollPane scrollPane = new JScrollPane();
		scrollPane.setBounds(239, 11, 454, 273);
		contentPane.add(scrollPane);

		table = new JTable();
		scrollPane.setViewportView(table);

		JButton btnNewButton_4 = new JButton("Show Database");
		btnNewButton_4.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				try {
					 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/Database?useSSL=false", "root", "password");
					 String sql = "SELECT * FROM Database.Pantofi";
					 pst = conn.prepareStatement(sql);
					 rs = pst.executeQuery();
					 table.setModel(DbUtils.resultSetToTableModel(rs));
				}
				catch (Exception ex){
					JOptionPane.showMessageDialog(null, ex);
				}
			}
		});
		btnNewButton_4.setBounds(556, 295, 123, 23);
		contentPane.add(btnNewButton_4);
	}
}