import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.text.*;
import java.util.*;
import javax.swing.ImageIcon;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import java.util.regex.Pattern;
import java.util.Date;
import java.util.concurrent.TimeUnit;
import java.text.DateFormat;
import java.text.SimpleDateFormat;

import javax.swing.table.DefaultTableModel;
import java.sql.*;

public class dtr {

	        JFrame frame = new JFrame();
			JPanel panel = new JPanel();
			JTextField search = new JTextField ();
			//JLabel ID = new JLabel();

    		dtr(){
			  	JButton sr = new JButton("Search");

			    	search.setBounds(90, 70, 300, 40);
					search.setForeground(Color.BLACK);
					search.setFont(new Font("Century-Gothic", Font.PLAIN, 20));


			    	//ID.setBounds(210,65,70,30);
					//ID.setBorder(BorderFactory.createLineBorder(Color.black, 1));
					sr.setBounds(150, 370, 200, 30);
					sr.setFont(new Font("Century-Gothic", Font.PLAIN,30));



					frame.add(search);
					//frame.add(ID);
					frame.add(sr);

					Connection con = null;
					Statement stmt = null;
					ResultSet rs = null;
					String s;

					try{
					con = DriverManager.getConnection("jdbc:mysql://localhost:3306/payroll","root", "1234");
					s = "select * from emp";
					stmt = con.createStatement();
					rs = stmt.executeQuery(s);
					ResultSetMetaData rsmt = rs.getMetaData();
					int c = rsmt.getColumnCount();


					Vector column = new Vector(c);

					for(int i = 1; i <= c; i++)
				{
					column.add(rsmt.getColumnName(i));
				}

					Vector data = new Vector();
					Vector row = new Vector();
					while(rs.next())
					{
						row = new Vector(c);
						for(int i = 1; i <= c;i++)
						{
							row.add(rs.getString(i));
						}
						data.add(row);
					}

					JTable table = new JTable(data, column);
					table.setBounds(100, 230, 750, 240);
					JScrollPane mm = new JScrollPane(table);
					mm.setBounds(30, 140, 710, 200);
					frame.add(mm);


					}catch(Exception e){
					JOptionPane.showMessageDialog(null,e);


				}

			frame.add(panel);
			frame.setSize(500,500);
			frame.setVisible(true);
			frame.setLocationRelativeTo(null);
			frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

			sr.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent ae){
			dtr up = new dtr();
			}});



}
}