import javax.swing.SwingUtilities;
import java.awt.BorderLayout;
import javax.swing.JPanel;
import javax.swing.JFrame;
import java.awt.Dimension;
import javax.swing.JTextField;
import java.awt.Rectangle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JButton;
import javax.swing.JTextArea;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

import com.mysql.jdbc.ResultSetMetaData;

public class lg extends JFrame {

	private static final long serialVersionUID = 1L;
	private JPanel jContentPane = null;
	private JTextField jTextField = null;
	private JTextField jTextField1 = null;
	private JTextField jTextField2 = null;
	private JTextField jTextField3 = null;
	private JTextField jTextField4 = null;
	private JComboBox jComboBox = null;
	private JLabel jLabel = null;
	private JLabel jLabel1 = null;
	private JLabel jLabel2 = null;
	private JLabel jLabel3 = null;
	private JLabel jLabel4 = null;
	private JLabel jLabel5 = null;
	private JTextField jTextField5 = null;
	private JButton jButton = null;
	private JButton jButton1 = null;
	private JButton jButton2 = null;
	private JButton jButton3 = null;
	private JComboBox jComboBox1 = null;
	Statement stmt = null;
	private JScrollPane jScrollPane = null;
	private JTable jTable = null;
	DefaultTableModel dtm= new DefaultTableModel();
	/**
	 * This method initializes jTextField
	 *
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField() {
		if (jTextField == null) {
			jTextField = new JTextField();
			jTextField.setBounds(new Rectangle(84, 17, 172, 27));
		}
		return jTextField;
	}

	/**
	 * This method initializes jTextField1
	 *
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			jTextField1 = new JTextField();
			jTextField1.setBounds(new Rectangle(83, 49, 176, 27));
		}
		return jTextField1;
	}

	/**
	 * This method initializes jTextField2
	 *
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			jTextField2 = new JTextField();
			jTextField2.setBounds(new Rectangle(85, 79, 174, 27));
		}
		return jTextField2;
	}

	/**
	 * This method initializes jTextField3
	 *
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField3() {
		if (jTextField3 == null) {
			jTextField3 = new JTextField();
			jTextField3.setBounds(new Rectangle(84, 111, 177, 24));
		}
		return jTextField3;
	}

	/**
	 * This method initializes jTextField4
	 *
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField4() {
		if (jTextField4 == null) {
			jTextField4 = new JTextField();
			jTextField4.setBounds(new Rectangle(83, 140, 181, 27));
		}
		return jTextField4;
	}

	/**
	 * This method initializes jComboBox
	 *
	 * @return javax.swing.JComboBox
	 */
	private JComboBox getJComboBox() {
		if (jComboBox == null) {
			jComboBox = new JComboBox();
			jComboBox.setBounds(new Rectangle(85, 173, 186, 23));
		}
		return jComboBox;
	}

	/**
	 * This method initializes jTextField5
	 *
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField5() {
		if (jTextField5 == null) {
			jTextField5 = new JTextField();
			jTextField5.setBounds(new Rectangle(8, 209, 268, 27));
		}
		return jTextField5;
	}

	/**
	 * This method initializes jButton
	 *
	 * @return javax.swing.JButton
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(43, 246, 206, 29));
			jButton.setText("Execute");
		}
		return jButton;
	}

	/**
	 * This method initializes jButton1
	 *
	 * @return javax.swing.JButton
	 */
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setBounds(new Rectangle(286, 20, 123, 20));
			jButton1.setText("Connect DB");
		}
		return jButton1;
	}
	 private void initializeDB() {
		    try {
		      // Load the JDBC driver
		      Class.forName("com.mysql.jdbc.Driver");
		      System.out.println("Driver loaded");

		      // Establish a connection
		      String dbname = jTextField.getText().trim();
		      String con = "jdbc:mysql://localhost/"+dbname;
		      Connection connection = DriverManager.getConnection
		        (con,"root","root");
		      System.out.println("Database connected");

		      // Create a statement
		      Statement stmt = connection.createStatement();
		    }
		    catch (Exception ex) {
		      ex.printStackTrace();
		    }
	 }

	/**
	 * This method initializes jButton2
	 *
	 * @return javax.swing.JButton
	 */
	private JButton getJButton2() {
		if (jButton2 == null) {
			jButton2 = new JButton();
			jButton2.setBounds(new Rectangle(288, 51, 124, 17));
			jButton2.setText("Show Table");
		}
		return jButton2;
	}

	public void getName(){
		try{
			ResultSet rs=stmt.executeQuery("Show Tables");
			String alltables="";
			while(rs.next()){
				String tablen=rs.toString();
				jComboBox1.addItem(tablen);
			}
		}catch(Exception e){
			System.out.println(e.toString());
			e.printStackTrace();
		}
	}
	/**
	 * This method initializes jButton3
	 *
	 * @return javax.swing.JButton
	 */
	private JButton getJButton3() {
		if (jButton3 == null) {
			jButton3 = new JButton();
			jButton3.setBounds(new Rectangle(454, 21, 153, 21));
			jButton3.setText("Get table names");
			jButton3.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					getName();
				}
			});
		}
		return jButton3;
	}

	/**
	 * This method initializes jComboBox1
	 *
	 * @return javax.swing.JComboBox
	 */
	private JComboBox getJComboBox1() {
		if (jComboBox1 == null) {
			jComboBox1 = new JComboBox();
			jComboBox1.setBounds(new Rectangle(448, 50, 172, 23));
		}
		return jComboBox1;
	}

	/**
	 * This method initializes jScrollPane
	 *
	 * @return javax.swing.JScrollPane
	 */
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setBounds(new Rectangle(296, 82, 349, 201));
			jScrollPane.setViewportView(getJTable());
		}
		return jScrollPane;
	}

	/**
	 * This method initializes jTable
	 *
	 * @return javax.swing.JTable
	 */
	private JTable getJTable() {
		if (jTable == null) {
			jTable = new JTable();
		}
		return jTable;
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		SwingUtilities.invokeLater(new Runnable() {
			public void run() {
				lg thisClass = new lg();
				thisClass.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
				thisClass.setVisible(true);
			}
		});
	}

	/**
	 * This is the default constructor
	 */
	public lg() {
		super();
		initialize();
	}
	void showTable(){
		Vector rows= new Vector();
		Vector header= new Vector();
		Vector tmp;

		rows.clear();
		header.clear();

		String tablename= (String)jComboBox.getSelectedItem();
		String sql ="select * from "+tablename;
		try{
			ResultSet rs=stmt.executeQuery(sql);
			ResultSetMetaData rsMetaData = (ResultSetMetaData) rs.getMetaData();
			for (int i = 0; i <= rsMetaData.getColumnCount(); i++) {
				header.addElement(rsMetaData.getColumnName(i));
				while(rs.next()){
					tmp= new Vector();
					for (int j = 0; j <=rsMetaData.getColumnCount(); j++) {
						tmp.addElement(rs.getObject(i));
					}
					rows.add(tmp);
				}
				dtm.setDataVector(rows, header);
			}
		}catch(SQLException e){
			e.printStackTrace();
		}
	}

	/**
	 * This method initializes this
	 *
	 * @return void
	 */
	private void initialize() {
		this.setSize(681, 336);
		this.setContentPane(getJContentPane());
		this.setTitle("JFrame");
	}

	/**
	 * This method initializes jContentPane
	 *
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabel5 = new JLabel();
			jLabel5.setBounds(new Rectangle(8, 176, 70, 20));
			jLabel5.setText("Emp Type");
			jLabel4 = new JLabel();
			jLabel4.setBounds(new Rectangle(14, 140, 66, 22));
			jLabel4.setText("Phour");
			jLabel3 = new JLabel();
			jLabel3.setBounds(new Rectangle(14, 113, 64, 22));
			jLabel3.setText("Pweek");
			jLabel2 = new JLabel();
			jLabel2.setBounds(new Rectangle(15, 83, 65, 19));
			jLabel2.setText("Sname");
			jLabel1 = new JLabel();
			jLabel1.setBounds(new Rectangle(15, 50, 60, 16));
			jLabel1.setText("Name");
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(15, 18, 55, 20));
			jLabel.setText("ID");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(getJTextField(), null);
			jContentPane.add(getJTextField1(), null);
			jContentPane.add(getJTextField2(), null);
			jContentPane.add(getJTextField3(), null);
			jContentPane.add(getJTextField4(), null);
			jContentPane.add(getJComboBox(), null);
			jContentPane.add(jLabel, null);
			jContentPane.add(jLabel1, null);
			jContentPane.add(jLabel2, null);
			jContentPane.add(jLabel3, null);
			jContentPane.add(jLabel4, null);
			jContentPane.add(jLabel5, null);
			jContentPane.add(getJTextField5(), null);
			jContentPane.add(getJButton(), null);
			jContentPane.add(getJButton1(), null);
			jContentPane.add(getJButton2(), null);
			jContentPane.add(getJButton3(), null);
			jContentPane.add(getJComboBox1(), null);
			jContentPane.add(getJScrollPane(), null);
		}
		return jContentPane;
	}

}  //  @jve:decl-index=0:visual-constraint="10,10"