1 /*

     2  * Copyright 1997-1999 Sun Microsystems, Inc.  All Rights Reserved.

     3  *

     4  * Redistribution and use in source and binary forms, with or without

     5  * modification, are permitted provided that the following conditions

     6  * are met:

     7  *

     8  *   - Redistributions of source code must retain the above copyright

     9  *     notice, this list of conditions and the following disclaimer.

    10  *

    11  *   - Redistributions in binary form must reproduce the above copyright

    12  *     notice, this list of conditions and the following disclaimer in the

    13  *     documentation and/or other materials provided with the distribution.

    14  *

    15  *   - Neither the name of Sun Microsystems nor the names of its

    16  *     contributors may be used to endorse or promote products derived

    17  *     from this software without specific prior written permission.

    18  *

    19  * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS

    20  * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,

    21  * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR

    22  * PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE COPYRIGHT OWNER OR

    23  * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,

    24  * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

    25  * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR

    26  * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF

    27  * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING

    28  * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

    29  * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

    30  */

    31 

    32 /*

    33  */

    34 

    35 /**

    36  * A minimal example, using the JTable to view data from a database.

    37  *

    38  * @author Philip Milne

    39  */

    40 

    41 import javax.swing.*;

    42 

    43 import java.awt.event.WindowAdapter;

    44 import java.awt.event.WindowEvent;

    45 import java.awt.Dimension;

    46 

    47 public class TableExample2 {

    48 

    49     public TableExample2(String URL, String driver, String user,

    50                          String passwd, String query) {

    51         JFrame frame = new JFrame("Table");

    52         frame.addWindowListener(new WindowAdapter() {

    53             public void windowClosing(WindowEvent e) {System.exit(0);}});

    54         JDBCAdapter dt = new JDBCAdapter(URL, driver, user, passwd);

    55         dt.executeQuery(query);

    56 

    57         // Create the table

    58         JTable tableView = new JTable(dt);

    59 

    60         JScrollPane scrollpane = new JScrollPane(tableView);

    61         scrollpane.setPreferredSize(new Dimension(700, 300));

    62 

    63         frame.getContentPane().add(scrollpane);

    64         frame.pack();

    65         frame.setVisible(true);

    66     }

    67 

    68     public static void main(String[] args) {

    69         if (args.length != 5) {

    70             System.err.println("Needs database parameters eg. ...");

    71             System.err.println("java TableExample2 \"jdbc:sybase://dbtest:1455/pubs2\" \"connect.sybase.SybaseDriver\" guest trustworthy \"select * from titles\"");

    72             return;

    73         }

    74         new TableExample2(args[0], args[1], args[2], args[3], args[4]);

    75     }

    76 }