01: /*
02: * Copyright 2006-2007 Pentaho Corporation. All rights reserved.
03: * This software was developed by Pentaho Corporation and is provided under the terms
04: * of the Mozilla Public License, Version 1.1, or any later version. You may not use
05: * this file except in compliance with the license. If you need a copy of the license,
06: * please go to http://www.mozilla.org/MPL/MPL-1.1.txt.
07: *
08: * Software distributed under the Mozilla Public License is distributed on an "AS IS"
09: * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. Please refer to
10: * the license for the specific language governing your rights and limitations.
11: *
12: * Additional Contributor(s): Martin Schmid gridvision engineering GmbH
13: */
14: package org.pentaho.reportdesigner.crm.report.tests;
15:
16: import org.jetbrains.annotations.NotNull;
17: import org.pentaho.reportdesigner.crm.report.datasetplugin.multidataset.JDBCTableModel;
18: import org.pentaho.reportdesigner.crm.report.datasetplugin.multidataset.JNDISource;
19:
20: import javax.swing.*;
21: import java.awt.*;
22:
23: /**
24: * User: Martin
25: * Date: 01.09.2006
26: * Time: 08:55:46
27: */
28: public class JDBCTest {
29: public static void main(@NotNull
30: String[] args) throws Exception {
31: Class.forName("org.hsqldb.jdbcDriver");
32:
33: JDBCTableModel tableModel = new JDBCTableModel(new JNDISource(
34: "SampleData", "org.hsqldb.jdbcDriver",
35: "jdbc:hsqldb:hsql://localhost/sampledata",
36: "pentaho_user", "password"), "select * from customers",
37: 1000);//NON-NLS
38:
39: JFrame frame = new JFrame();
40: frame.getContentPane().add(
41: new JScrollPane(new JTable(tableModel)),
42: BorderLayout.CENTER);
43: frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
44: frame.setBounds(100, 100, 400, 400);
45: frame.setVisible(true);
46: }
47: }
|