0N/A/*
3853N/A * Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.
0N/A *
0N/A * Redistribution and use in source and binary forms, with or without
0N/A * modification, are permitted provided that the following conditions
0N/A * are met:
0N/A *
0N/A * - Redistributions of source code must retain the above copyright
0N/A * notice, this list of conditions and the following disclaimer.
0N/A *
0N/A * - Redistributions in binary form must reproduce the above copyright
0N/A * notice, this list of conditions and the following disclaimer in the
0N/A * documentation and/or other materials provided with the distribution.
0N/A *
2362N/A * - Neither the name of Oracle nor the names of its
0N/A * contributors may be used to endorse or promote products derived
0N/A * from this software without specific prior written permission.
0N/A *
0N/A * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
0N/A * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
0N/A * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
0N/A * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
0N/A * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
0N/A * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
0N/A * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
0N/A * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
0N/A * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
0N/A * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
0N/A * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
0N/A */
0N/A
4378N/A/*
4378N/A * This source code is provided to illustrate the usage of a given feature
4378N/A * or technique and has been deliberately simplified. Additional steps
4378N/A * required for a production-quality application, such as security checks,
4378N/A * input validation and proper error handling, might not be present in
4378N/A * this sample code.
4378N/A */
4378N/A
4378N/A
3853N/A
3853N/Aimport java.awt.event.WindowAdapter;
3853N/Aimport java.awt.event.WindowEvent;
3853N/Aimport java.awt.Dimension;
3853N/Aimport java.util.logging.Level;
3853N/Aimport java.util.logging.Logger;
3853N/Aimport javax.swing.JFrame;
3853N/Aimport javax.swing.JScrollPane;
3853N/Aimport javax.swing.JTable;
3853N/Aimport javax.swing.UIManager;
3853N/Aimport javax.swing.UIManager.LookAndFeelInfo;
3853N/A
0N/A
0N/A/**
0N/A * A minimal example, using the JTable to view data from a database.
0N/A *
0N/A * @author Philip Milne
0N/A */
0N/Apublic class TableExample2 {
0N/A
0N/A public TableExample2(String URL, String driver, String user,
3853N/A String passwd, String query) {
0N/A JFrame frame = new JFrame("Table");
0N/A frame.addWindowListener(new WindowAdapter() {
3853N/A
3853N/A @Override
3853N/A public void windowClosing(WindowEvent e) {
3853N/A System.exit(0);
3853N/A }
3853N/A });
0N/A JDBCAdapter dt = new JDBCAdapter(URL, driver, user, passwd);
0N/A dt.executeQuery(query);
0N/A
0N/A // Create the table
0N/A JTable tableView = new JTable(dt);
0N/A
0N/A JScrollPane scrollpane = new JScrollPane(tableView);
0N/A scrollpane.setPreferredSize(new Dimension(700, 300));
0N/A
0N/A frame.getContentPane().add(scrollpane);
0N/A frame.pack();
0N/A frame.setVisible(true);
0N/A }
0N/A
0N/A public static void main(String[] args) {
0N/A if (args.length != 5) {
0N/A System.err.println("Needs database parameters eg. ...");
3853N/A System.err.println(
3853N/A "java TableExample2 \"jdbc:derby://localhost:1527/sample\" "
3853N/A + "org.apache.derby.jdbc.ClientDriver app app "
3853N/A + "\"select * from app.customer\"");
0N/A return;
0N/A }
3853N/A
3853N/A // Trying to set Nimbus look and feel
3853N/A try {
3853N/A for (LookAndFeelInfo info : UIManager.getInstalledLookAndFeels()) {
3853N/A if ("Nimbus".equals(info.getName())) {
3853N/A UIManager.setLookAndFeel(info.getClassName());
3853N/A break;
3853N/A }
3853N/A }
3853N/A } catch (Exception ex) {
3853N/A Logger.getLogger(TableExample2.class.getName()).log(Level.SEVERE,
3853N/A "Failed to apply Nimbus look and feel", ex);
3853N/A }
3853N/A
0N/A new TableExample2(args[0], args[1], args[2], args[3], args[4]);
0N/A }
0N/A}