Need help with program

import java.awt.*;
import java.awt.event.*;

import java.sql.*;

import java.util.*;

import javax.swing.*;


public class DisplayQueryResults extends JFrame {
    private Connection connection;
    private Statement statement;
    private ResultSet resultSet;
    private ResultSetMetaData rsMetaData;
    private JTable table;
    private JComboBox inputQuery;
    private JButton submitInputQuery;
    private JTextField inputQueryTF;
    private JTextArea queryArea;

    public DisplayQueryResults() {
        super("Select Query. Click Submit to See Results.");

        // The URL specifying the books database to which
        // this program connects to
        String url = "jdbc:db2j:books";

        // Load the driver to allow connection to the database
        try {
            Class.forName("com.ibm.db2j.jdbc.DB2jDriver");

            connection = DriverManager.getConnection(url);
        } // end try

        catch (ClassNotFoundException cnfex) {
            System.err.println("Failed to load JDBC/ODBC driver.");
            cnfex.printStackTrace();
            System.exit(1); // terminate program
        } // end catch

        catch (SQLException sqlex) {
            System.err.println("Unable to connect");
            sqlex.printStackTrace();
            System.exit(1); // terminate program
        } // end catch

        // If connected to database, set up GUI
        String[] queryNames = {
                "All authors", "All publishers", "All books",
                "A specific author", "A specific publisher"
            };
        inputQuery = new JComboBox(queryNames);

        JLabel inputLabel = new JLabel("Query");
        submitInputQuery = new JButton("Submit Query");
        submitInputQuery.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    getTable();
                }
            });
        inputQueryTF = new JTextField(30);
        inputQueryTF.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    try {
                        String query = inputQueryTF.getText();
                        statement = connection.createStatement();
                        resultSet = statement.executeQuery(query);
                        displayResultSet(resultSet);
                    } // end try
                    catch (SQLException sqlex) {
                        sqlex.printStackTrace();
                    } // end catch
                }
            });

        JPanel inputPanel = new JPanel();
        inputPanel.setLayout(new GridLayout(5, 1));
        inputPanel.add(inputLabel);
        inputPanel.add(inputQuery);
        inputPanel.add(new JLabel("Enter query, author or publisher:"));
        inputPanel.add(inputQueryTF);
        inputPanel.add(submitInputQuery);
        //queryArea = new JTextArea(connection);
	//CEHJ
        queryArea = new JTextArea();

        JPanel instructionPanel = new JPanel();
        instructionPanel.setLayout(new GridLayout(2, 1));
        instructionPanel.add(inputPanel);
        instructionPanel.add(queryArea);

        JPanel topPanel = new JPanel();
        topPanel.setLayout(new BorderLayout());
        topPanel.add(instructionPanel, BorderLayout.NORTH);
        table = new JTable(4, 4);

        Container c = getContentPane();
        c.setLayout(new BorderLayout());
        c.add(topPanel, BorderLayout.NORTH);
        c.add(table, BorderLayout.CENTER);
        getTable();
        setSize(500, 500);
        show();
    } // end constructor DisplayQueryResults

    public Connection getConnection() {
        return connection;
    }

    private void getTable() {
        try {
            int selection = inputQuery.getSelectedIndex();
            String query = null;

            switch (selection) {
                case 0:
                    query = "SELECT * FROM Authors";

                    break;

                case 1:
                    query = "SELECT * FROM Publishers";

                    break;

                case 2:
                    query = "SELECT * FROM TITLES";

                    break;

                case 3:
                    query = "SELECT Authors.LastName, Authors.FirstName, " +
                        "Titles.Title, Titles.Price, " + "Titles.ISBN FROM " +
                        "Titles INNER JOIN (AuthorISBN INNER JOIN Authors ON " +
                        "AuthorISBN.AuthorID = Authors.AuthorID) ON " +
                        "Titles.ISBN = AuthorISBN.ISBN WHERE Authors.LastName" +
                        " = '" + inputQueryTF.getText() +
                        "' ORDER BY Authors.LastName, Authors.FirstName ASC";

                    break;

                case 4:
                    query = "SELECT Publishers.PublisherName, Titles.Title, " +
                        "Titles.Price, Titles.ISBN FROM Titles INNER JOIN " +
                        "Publishers ON Publishers.PublisherID = " +
                        "Titles.PublisherID WHERE Publishers.PublisherName = '" +
                        inputQueryTF.getText() + "' ORDER BY Titles.Title ASC";

                    break;
            } // end switch

            statement = connection.createStatement();
            resultSet = statement.executeQuery(query);
            displayResultSet(resultSet);
        } // end try
        catch (SQLException sqlex) {
            sqlex.printStackTrace();
        } // end catch
    } // end method getTable

    public void displayResultSet(ResultSet rs) throws SQLException {
        // position to first record
        boolean moreRecords = rs.next();

        // If there are no records, display a message
        if (!moreRecords) {
            JOptionPane.showMessageDialog(this, "ResultSet contained no records");
            setTitle("No records to display");

            return;
        }

        Vector columnHeads = new Vector();
        Vector rows = new Vector();

        try {
            // get column heads
            ResultSetMetaData rsmd = rs.getMetaData();

            for (int i = 1; i <= rsmd.getColumnCount(); ++i)
                columnHeads.addElement(rsmd.getColumnName(i));

            // get row data
            do {
                rows.addElement(getNextRow(rs, rsmd));
            } while (rs.next());

            // display table with ResultSet contents
            table = new JTable(rows, columnHeads);

            JScrollPane scroller = new JScrollPane(table);
            Container c = getContentPane();
            c.remove(1);
            c.add(scroller, BorderLayout.CENTER);
            c.validate();
        } // end try
        catch (SQLException sqlex) {
            sqlex.printStackTrace();
        }
    } // end method displayResultSet

    private Vector getNextRow(ResultSet rs, ResultSetMetaData rsmd)
        throws SQLException {
        Vector currentRow = new Vector();

        for (int i = 1; i <= rsmd.getColumnCount(); ++i)
            switch (rsmd.getColumnType(i)) {
                case Types.VARCHAR:
                case Types.LONGVARCHAR:
                    currentRow.addElement(rs.getString(i));

                    break;

                case Types.INTEGER:
                    currentRow.addElement(new Long(rs.getLong(i)));

                    break;

                case Types.REAL:
                    currentRow.addElement(new Float(rs.getDouble(i)));

                    break;

                default:
                    System.out.println("Type was: " +
                        rsmd.getColumnTypeName(i));
            } // end switch

        return currentRow;
    } // end method getNextRow

    public void shutDown() {
        try {
            connection.close();
        } // end catch
        catch (SQLException sqlex) {
            System.err.println("Unable to disconnect");
            sqlex.printStackTrace();
        } // end catch
    } // end method shutDown

    public static void main(String[] args) {
        final DisplayQueryResults app = new DisplayQueryResults();
        app.addWindowListener(new WindowAdapter() {
                public void windowClosing(WindowEvent e) {
                    app.shutDown();
                    System.exit(0);
                } // end method windowClosing
            } // end method main
        );
    }
} // end class DisplayQueryResults

Select allOpen in new window

import java.awt.*;
import java.awt.event.*;

import java.sql.*;

import java.util.*;

import javax.swing.*;


public class DisplayQueryResults extends JFrame {
    private Connection connection;
    private Statement statement;
    private ResultSet resultSet;
    //private ResultSetMetaData rsMetaData;
    private JTable table;
    private JComboBox inputQuery;
    private JButton submitInputQuery;
    private JTextField inputQueryTF;
    private JTextArea queryArea;

    public DisplayQueryResults() {
        super("Select Query. Click Submit to See Results.");

        // The URL specifying the books database to which
        // this program connects to
        String url = "jdbc:db2j:books";

        // Load the driver to allow connection to the database
        try {
            Class.forName("com.ibm.db2j.jdbc.DB2jDriver");

            connection = DriverManager.getConnection(url);
        } // end try

        catch (ClassNotFoundException cnfex) {
            System.err.println("Failed to load JDBC/ODBC driver.");
            cnfex.printStackTrace();
            System.exit(1); // terminate program
        } // end catch

        catch (SQLException sqlex) {
            System.err.println("Unable to connect");
            sqlex.printStackTrace();
            System.exit(1); // terminate program
        } // end catch

        // If connected to database, set up GUI
        String[] queryNames = {
                "All authors", "All publishers", "All books",
                "A specific author", "A specific publisher"
            };
        inputQuery = new JComboBox(queryNames);

        JLabel inputLabel = new JLabel("Query");
        submitInputQuery = new JButton("Submit Query");
        submitInputQuery.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    getTable();
                }
            });
        inputQueryTF = new JTextField(30);
        inputQueryTF.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    try {
                        String query = inputQueryTF.getText();
                        statement = connection.createStatement();
                        resultSet = statement.executeQuery(query);
                        displayResultSet(resultSet);
                    } // end try
                    catch (SQLException sqlex) {
                        sqlex.printStackTrace();
                    } // end catch
                }
            });

        JPanel inputPanel = new JPanel();
        inputPanel.setLayout(new GridLayout(5, 1));
        inputPanel.add(inputLabel);
        inputPanel.add(inputQuery);
        inputPanel.add(new JLabel("Enter query, author or publisher:"));
        inputPanel.add(inputQueryTF);
        inputPanel.add(submitInputQuery);
             queryArea = new JTextArea();

        JPanel instructionPanel = new JPanel();
        instructionPanel.setLayout(new GridLayout(2, 1));
        instructionPanel.add(inputPanel);
        instructionPanel.add(queryArea);

        JPanel topPanel = new JPanel();
        topPanel.setLayout(new BorderLayout());
        topPanel.add(instructionPanel, BorderLayout.NORTH);
        table = new JTable(4, 4);

        Container c = getContentPane();
        c.setLayout(new BorderLayout());
        c.add(topPanel, BorderLayout.NORTH);
        c.add(table, BorderLayout.CENTER);
        getTable();
        setSize(500, 500);
        this.setVisible(true);
    } // end constructor DisplayQueryResults

    public Connection getConnection() {
        return connection;
    }

    private void getTable() {
        try {
            int selection = inputQuery.getSelectedIndex();
            String query = null;

            switch (selection) {
                case 0:
                    query = "SELECT * FROM Authors";

                    break;

                case 1:
                    query = "SELECT * FROM Publishers";

                    break;

                case 2:
                    query = "SELECT * FROM TITLES";

                    break;

                case 3:
                    query = "SELECT Authors.LastName, Authors.FirstName, " +
                        "Titles.Title, Titles.Price, " + "Titles.ISBN FROM " +
                        "Titles INNER JOIN (AuthorISBN INNER JOIN Authors ON " +
                        "AuthorISBN.AuthorID = Authors.AuthorID) ON " +
                        "Titles.ISBN = AuthorISBN.ISBN WHERE Authors.LastName" +
                        " = '" + inputQueryTF.getText() +
                        "' ORDER BY Authors.LastName, Authors.FirstName ASC";

                    break;

                case 4:
                    query = "SELECT Publishers.PublisherName, Titles.Title, " +
                        "Titles.Price, Titles.ISBN FROM Titles INNER JOIN " +
                        "Publishers ON Publishers.PublisherID = " +
                        "Titles.PublisherID WHERE Publishers.PublisherName = '" +
                        inputQueryTF.getText() + "' ORDER BY Titles.Title ASC";

                    break;
            } // end switch

            statement = connection.createStatement();
            resultSet = statement.executeQuery(query);
            displayResultSet(resultSet);
        } // end try
        catch (SQLException sqlex) {
            sqlex.printStackTrace();
        } // end catch
    } // end method getTable

    public void displayResultSet(ResultSet rs) throws SQLException {
        // position to first record
        boolean moreRecords = rs.next();

        // If there are no records, display a message
        if (!moreRecords) {
            JOptionPane.showMessageDialog(this, "ResultSet contained no records");
            setTitle("No records to display");

            return;
        }

        Vector <String>columnHeads = new Vector<String>();
        Vector <Vector>rows = new Vector<Vector>();

        try {
            // get column heads
            ResultSetMetaData rsmd = rs.getMetaData();

            for (int i = 1; i <= rsmd.getColumnCount(); ++i)
                columnHeads.addElement(rsmd.getColumnName(i));

            // get row data
            do {
                rows.addElement(getNextRow(rs, rsmd));
            } while (rs.next());

            // display table with ResultSet contents
            table = new JTable(rows, columnHeads);

            JScrollPane scroller = new JScrollPane(table);
            Container c = getContentPane();
            c.remove(1);
            c.add(scroller, BorderLayout.CENTER);
            c.validate();
        } // end try
        catch (SQLException sqlex) {
            sqlex.printStackTrace();
        }
    } // end method displayResultSet

    private Vector getNextRow(ResultSet rs, ResultSetMetaData rsmd)
        throws SQLException {
        Vector<Object> currentRow = new Vector<Object>();

        for (int i = 1; i <= rsmd.getColumnCount(); ++i)
            switch (rsmd.getColumnType(i)) {
                case Types.VARCHAR:
                case Types.LONGVARCHAR:
                    currentRow.addElement(rs.getString(i));

                    break;

                case Types.INTEGER:
                    currentRow.addElement(new Long(rs.getLong(i)));

                    break;

                case Types.REAL:
                    currentRow.addElement(new Float(rs.getDouble(i)));

                    break;

                default:
                    System.out.println("Type was: " +
                        rsmd.getColumnTypeName(i));
            } // end switch

        return currentRow;
    } // end method getNextRow

    public void shutDown() {
        try {
            connection.close();
        } // end catch
        catch (SQLException sqlex) {
            System.err.println("Unable to disconnect");
            sqlex.printStackTrace();
        } // end catch
    } // end method shutDown

    public static void main(String[] args) {
        final DisplayQueryResults app = new DisplayQueryResults();
        app.addWindowListener(new WindowAdapter() {
                public void windowClosing(WindowEvent e) {
                    app.shutDown();
                    System.exit(0);
                } // end method windowClosing
            } // end method main
        );
    }
} // end class DisplayQueryResults

Select allOpen in new window