Prentice Hall and Sun Microsystems. Personal use only; do not redistribute.

492

Chapter 18 JDBC and Database Connection Pooling

Listing 18.14 QueryViewer.java (continued)

    String password =

      String.valueOf(passwordField.getPassword());

    String query = queryField.getText();

    int vendor;

    if (oracleButton.isSelected()) {

      vendor = DriverUtilities.ORACLE;

    } else {

      vendor = DriverUtilities.SYBASE;

    }

    if (tablePanel != null) {

      contentPane.remove(tablePanel);

    }

    tablePanel = makeTablePanel(host, dbName, vendor,

                                username, password,

                                query);

    contentPane.add(tablePanel, BorderLayout.CENTER);

    pack();

  }

  // Executes a query and places the result in a

  // JTable that is, in turn, inside a JPanel.

  private JPanel makeTablePanel(String host,

                                String dbName,

                                int vendor,

                                String username,

                                String password,

                                String query) {

    String driver = DriverUtilities.getDriver(vendor);

    String url = DriverUtilities.makeURL(host, dbName, vendor);

    DBResults results =

      DatabaseUtilities.getQueryResults(driver, url,

                                        username, password,

                                        query, true);

    JPanel panel = new JPanel(new BorderLayout());

    if (results == null) {

      panel.add(makeErrorLabel());

      return(panel);

    }

    DBResultsTableModel model =

      new DBResultsTableModel(results);

    JTable table = new JTable(model);

    table.setFont(new Font("Serif", Font.PLAIN, 17));

    table.setRowHeight(28);

    JTableHeader header = table.getTableHeader();

    header.setFont(new Font("SansSerif", Font.BOLD, 13));

    panel.add(table, BorderLayout.CENTER);

    panel.add(header, BorderLayout.NORTH);

Second edition of this book: www.coreservlets.com; Sequel: www.moreservlets.com.

Servlet and JSP training courses by book's author: courses.coreservlets.com.