//Employee database query application
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.awt.FlowLayout;
import java.awt.BorderLayout;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import javax.swing.JFrame;
import javax.swing.JTable;
import javax.swing.JComboBox;
import javax.swing.JButton;
import javax.swing.JTextField;

public class DisplayQueryResults extends Jframe
{
	 // JDBC driver name and database URL
   static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
   static final String DB_URL = "jdbc:mysql://localhost/EMP";
   static final String USER = "username";
   static final String PASS = "password";

    //default query retrieve all data from employees table
	static final String Default_Query = "SELECT * FROM employees";

	private Connection connection;
	private Statement statement;
	private ResultSetTableModel tablemodel;
	private JTable table;
	private JComboBox inputQuery;
	private JButton submitQuery;
	private JTextField input;

	public DisplayQueryResults ()
	{
	super ( "Select Query. Click Submit To See Results.");
	// Create ResultSetTableModel with default JDBC driver,
	//database URL and query
	try
	{
		//create TableModel for results of query SELECT*FROM employees
		tableModel = new ResultSetTableModel ( JDBC Driver, DataBase URL,
		USERNAME, PASSWORD, Default_Query );

		connection = tableModel.getConnection();
		{//end try

		String Queries [] ={ "Select all employees working in Department " +
		"Sales", "Select hourly employees working over 30 hours.",
		"Select all comission employees in descending order of the " +
		"comission rate.", "Specify particular query"};

		public class PayrollSystemTest
   {
      public static void main( String args[] )
      {
         // create subclass objects
         SalariedEmployee salariedEmployee =
           new SalariedEmployee( "Kerry", "Smith", "111-11-1111",
                       800.00 );
        HourlyEmployee hourlyEmployee =
           new HourlyEmployee( "Mike", "Price", "222-22-2222", 16.75,
                       40 );
        CommissionEmployee commissionEmployee =
           new CommissionEmployee(
         "Mark", "Jones", "333-33-3333", 10000, .06 );
        BasePlusCommissionEmployee basePlusCommissionEmployee =
           new BasePlusCommissionEmployee(
           "Bob", "Williams", "444-44-4444", 5000, .04, 300 );

        System.out.println( "Employees processed individually:\n" );

        System.out.printf( "%s\n%s: $%,.2f\n\n",
           salariedEmployee, "earned", salariedEmployee.earnings() );
        System.out.printf( "%s\n%s: $%,.2f\n\n",
           hourlyEmployee, "earned", hourlyEmployee.earnings() );
        System.out.printf( "%s\n%s: $%,.2f\n\n",
           commissionEmployee, "earned",
                       commissionEmployee.earnings() );
        System.out.printf( "%s\n%s: $%,.2f\n\n",
           basePlusCommissionEmployee,
           "earned", basePlusCommissionEmployee.earnings() );

        // create four-element Employee array

        Employee employees[] = new Employee[ 4 ];

        // initialize array with Employees
        employees[ 0 ] = salariedEmployee;
        employees[ 1 ] = hourlyEmployee;
        employees[ 2 ] = commissionEmployee;
        employees[ 3 ] = basePlusCommissionEmployee;

        System.out.println(
                        "Employees processed polymorphically:\n" );

        // generically process each element in array employees
        for ( Employee currentEmployee : employees )
        {
           System.out.println( currentEmployee ); // invokes toString


           // determine whether element is a BasePlusCommissionEmployee
           if (
                           currentEmployee instanceof BasePlusCommissionEmployee )
           {
              // downcast Employee reference to
              // BasePlusCommissionEmployee reference

              BasePlusCommissionEmployee employee =
                 ( BasePlusCommissionEmployee ) currentEmployee;

              double oldBaseSalary = employee.getBaseSalary();
              employee.setBaseSalary( 1.10 * oldBaseSalary );
              System.out.printf(
                 "new base salary with 10%% increase is: $%,.2f\n",