package project;

import java.awt.Dimension;
import java.awt.EventQueue;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JPanel;
import javax.swing.JTable;
import javax.swing.border.EmptyBorder;
import javax.swing.border.TitledBorder;
import javax.swing.table.DefaultTableModel;
import javax.swing.JScrollPane;

public class Data extends JFrame {
	/**
	 *
	 */
	private static final long serialVersionUID = 1L;
	private JPanel contentPane;
	private JTable table_1;

	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					Data frame = new Data();
					frame.setVisible(true);
					Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
					  int height = screenSize.height;
					  int width = screenSize.width;
					  frame.setSize(width/2, height/2);
					  frame.setLocationRelativeTo(null);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

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

		JPanel panel = new JPanel();
		panel.setBorder(new TitledBorder(null, "Guests", TitledBorder.LEADING, TitledBorder.TOP, null, null));
		panel.setBounds(14, 29, 616, 306);
		contentPane.add(panel);
		panel.setLayout(null);

		table_1 = new JTable();
		table_1.setToolTipText("Guests");
		table_1.setBounds(6, 16, 604, 283);
		panel.add(table_1);

		JButton btnNewButton = new JButton("Add feedback");
		btnNewButton.setBounds(471, 342, 128, 23);
		contentPane.add(btnNewButton);

		JMenuBar menuBar = new JMenuBar();
		menuBar.setBounds(0, 0, 634, 21);
		contentPane.add(menuBar);

		JMenu mnMenu = new JMenu("Menu");
		menuBar.add(mnMenu);

		JMenuItem mntmOpenGuestbook = new JMenuItem("Open guestbook");
		mntmOpenGuestbook.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				try{
					Connection conn = DriverManager.
							getConnection("jdbc:mysql://localhost:3306/guestbook",
									"root", "admin");
				 System.out.println(conn);
				 Statement stmt = conn.createStatement();
				 String query = "SELECT * FROM GUESTS";
				 ResultSet rs = stmt.executeQuery(query);
				 DefaultTableModel model = new DefaultTableModel(new String[]{"FIRST_NAME", "SURNAME", "EMAIL", "COMMENTS"}, 0);
				 String[] column= {"FIRST_NAME", "SURNAME", "EMAIL", "COMMENTS"};


			    while (rs.next())
			      {
			        String firstName = rs.getString("FIRST_NAME");
			        String lastName = rs.getString("SURNAME");
			        String email = rs.getString("EMAIL");
			        String comments = rs.getString("COMMENTS");
			        model.addRow(new Object[]{firstName, lastName, email, comments});

			      }table_1.setModel(model);
			      table_1.createDefaultColumnsFromModel();



				}catch(SQLException e2){}

			}
		});
		mnMenu.add(mntmOpenGuestbook);

		JMenuItem mntmSaveAs = new JMenuItem("Save as...");
		mnMenu.add(mntmSaveAs);

		JMenuItem mntmExit = new JMenuItem("Exit");
		mntmExit.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				System.exit(0);
			}
		});
		mnMenu.add(mntmExit);

		JMenu mnHelp = new JMenu("Help");
		menuBar.add(mnHelp);

		JMenuItem mntmAbout = new JMenuItem("About");
		mnHelp.add(mntmAbout);
	}
}