1/*
2 * Copyright (c) 1997, 2011, Oracle and/or its affiliates. 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 Oracle 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 * This source code is provided to illustrate the usage of a given feature
34 * or technique and has been deliberately simplified. Additional steps
35 * required for a production-quality application, such as security checks,
36 * input validation and proper error handling, might not be present in
37 * this sample code.
38 */
39
40
41
42import java.awt.event.WindowAdapter;
43import java.awt.event.WindowEvent;
44import java.awt.Dimension;
45import java.util.logging.Level;
46import java.util.logging.Logger;
47import javax.swing.JFrame;
48import javax.swing.JScrollPane;
49import javax.swing.JTable;
50import javax.swing.UIManager;
51import javax.swing.UIManager.LookAndFeelInfo;
52
53
54/**
55 * A minimal example, using the JTable to view data from a database.
56 *
57 * @author Philip Milne
58 */
59public class TableExample2 {
60
61    public TableExample2(String URL, String driver, String user,
62            String passwd, String query) {
63        JFrame frame = new JFrame("Table");
64        frame.addWindowListener(new WindowAdapter() {
65
66            @Override
67            public void windowClosing(WindowEvent e) {
68                System.exit(0);
69            }
70        });
71        JDBCAdapter dt = new JDBCAdapter(URL, driver, user, passwd);
72        dt.executeQuery(query);
73
74        // Create the table
75        JTable tableView = new JTable(dt);
76
77        JScrollPane scrollpane = new JScrollPane(tableView);
78        scrollpane.setPreferredSize(new Dimension(700, 300));
79
80        frame.getContentPane().add(scrollpane);
81        frame.pack();
82        frame.setVisible(true);
83    }
84
85    public static void main(String[] args) {
86        if (args.length != 5) {
87            System.err.println("Needs database parameters eg. ...");
88            System.err.println(
89                    "java TableExample2 \"jdbc:derby://localhost:1527/sample\" "
90                    + "org.apache.derby.jdbc.ClientDriver app app "
91                    + "\"select * from app.customer\"");
92            return;
93        }
94
95        // Trying to set Nimbus look and feel
96        try {
97            for (LookAndFeelInfo info : UIManager.getInstalledLookAndFeels()) {
98                if ("Nimbus".equals(info.getName())) {
99                    UIManager.setLookAndFeel(info.getClassName());
100                    break;
101                }
102            }
103        } catch (Exception ex) {
104            Logger.getLogger(TableExample2.class.getName()).log(Level.SEVERE,
105                    "Failed to apply Nimbus look and feel", ex);
106        }
107
108        new TableExample2(args[0], args[1], args[2], args[3], args[4]);
109    }
110}
111