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