displayqueryresults.java

高级java2 大学教程(含源码,经典的Java学习教程

// Fig. 8.31: DisplayQueryResults.java
// Display the contents of the Authors table in the
// Books database.
package com.deitel.advjhtp1.jdbc;

// Java core packages
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;

// Java extension packages
import javax.swing.*;
import javax.swing.table.*;

public class DisplayQueryResults extends JFrame {
   private ResultSetTableModel tableModel;
   private JTextArea queryArea;
   
   // create ResultSetTableModel and GUI
   public DisplayQueryResults() 
   {   
      super( "Displaying Query Results" );
      
      // Cloudscape database driver class name
      String driver = "COM.cloudscape.core.RmiJdbcDriver";
     
      // URL to connect to books database
      String url = "jdbc:cloudscape:rmi:books";
      
      // query to select entire authors table
      String query = "SELECT * FROM authors";
         
      // create ResultSetTableModel and display database table
      try {

         // create TableModel for results of query
         // SELECT * FROM authors
         tableModel = 
            new ResultSetTableModel( driver, url, query );

         // set up JTextArea in which user types queries
         queryArea = new JTextArea( query, 3, 100 );
         queryArea.setWrapStyleWord( true );
         queryArea.setLineWrap( true );
         
         JScrollPane scrollPane = new JScrollPane( queryArea,
            ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED, 
            ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER );
         
         // set up JButton for submitting queries
         JButton submitButton = new JButton( "Submit Query" );

         // create Box to manage placement of queryArea and 
         // submitButton in GUI
         Box box = Box.createHorizontalBox();
         box.add( scrollPane );
         box.add( submitButton );

         // create JTable delegate for tableModel 
         JTable resultTable = new JTable( tableModel );
         
         // place GUI components on content pane
         Container c = getContentPane();         
         c.add( box, BorderLayout.NORTH );
         c.add( new JScrollPane( resultTable ), 
                BorderLayout.CENTER );

         // create event listener for submitButton
         submitButton.addActionListener( 
         
            new ActionListener() {
         
               // pass query to table model
               public void actionPerformed( ActionEvent e )
               {
                  // perform a new query
                  try {
                     tableModel.setQuery( queryArea.getText() );
                  }
                  
                  // catch SQLExceptions that occur when 
                  // performing a new query
                  catch ( SQLException sqlException ) {
                     JOptionPane.showMessageDialog( null, 
                        sqlException.toString(), 
                        "Database error", 
                        JOptionPane.ERROR_MESSAGE );
                  }
               }  // end actionPerformed
               
            }  // end ActionListener inner class          
            
         ); // end call to addActionListener

         // set window size and display window
         setSize( 500, 250 );
         setVisible( true );         
      }  // end try

      // catch ClassNotFoundException thrown by 
      // ResultSetTableModel if database driver not found
      catch ( ClassNotFoundException classNotFound ) {
         JOptionPane.showMessageDialog( null, 
            "Cloudscape driver not found", "Driver not found",
            JOptionPane.ERROR_MESSAGE );
         
         System.exit( 1 );   // terminate application
      }
      
      // catch SQLException thrown by ResultSetTableModel 
      // if problems occur while setting up database
      // connection and querying database
      catch ( SQLException sqlException ) {
         JOptionPane.showMessageDialog( null, 
            sqlException.toString(), 
            "Database error", JOptionPane.ERROR_MESSAGE );
         
         System.exit( 1 );   // terminate application
      }
   }  // end DisplayQueryResults constructor
   
   // execute application
   public static void main( String args[] ) 
   {
      DisplayQueryResults app = new DisplayQueryResults();

      app.setDefaultCloseOperation( JFrame.EXIT_ON_CLOSE );      
   }
}  // end class DisplayQueryResults


/**************************************************************************
 * (C) Copyright 2001 by Deitel & Associates, Inc. and Prentice Hall.     *
 * All Rights Reserved.                                                   *
 *                                                                        *
 * DISCLAIMER: The authors and publisher of this book have used their     *
 * best efforts in preparing the book. These efforts include the          *
 * development, research, and testing of the theories and programs        *
 * to determine their effectiveness. The authors and publisher make       *
 * no warranty of any kind, expressed or implied, with regard to these    *
 * programs or to the documentation contained in these books. The authors *
 * and publisher shall not be liable in any event for incidental or       *
 * consequential damages in connection with, or arising out of, the       *
 * furnishing, performance, or use of these programs.                     *
 *************************************************************************/