/*
  i-net software provides programming examples for illustration only, without warranty
  either expressed or implied, including, but not limited to, the implied warranties
  of merchantability and/or fitness for a particular purpose. This programming example
  assumes that you are familiar with the programming language being demonstrated and
  the tools used to create and debug procedures. i-net software support professionals
  can help explain the functionality of a particular procedure, but they will not modify
  these examples to provide added functionality or construct procedures to meet your
  specific needs.
  © i-net software 1998-2010
*/

package samples.jdbc;

import com.inet.report.Engine;

/**
 * Simple example of a Database class which can be used as a data source for a report which
 * does not connect to any database but simply provides data as an Object[][].<br>
 * You can use this class at runtime to set the report data instead of using a JDBC database connection.
 * 
 * The sample {link DatabaseClassUsableInDesigner} contains a database class that can be used at design time and at runtime
 * because it also contains the database layout.
 * 
 * To do this you have to 
 * 1) Create a Data Source Configuration with a user-defined driver for this database class
 * 2) Add this class to the class path of i-net Designer or i-net Clear Reports
 * 3) Set the name of the Data Source Configuration in the parameter "datasource" at runtime
 * 
 * Create a Data Source Configuration using the Data Source Manager:
 * - select "user-defined driver"
 * - set a name for the Data Source Configuration, e.g. "DataWithoutJDBC"
 * - set this class "samples.jdbc.DataWithoutJDBC" as Database Class for the Data Source Configuration
 * 
 * Adding to class path: 
 * To add this class file to the class path, you can create a jar file containing this class 
 * (with command "jar cf custom-database-class.jar DatabaseWithoutJDBC.class")
 * and copying the created jar file into the directory "lib/driver" that is included in the installation directory 
 * of i-net Clear Reports.
 * Also, have a look at http://www.inetsoftware.de/documentation/crystal-clear/online-help/howto/library.html.
 * 
 * In the report URL you have to set the name of the Data Source Configuration in the parameter "datasource":
 * ...datasource=DataWithoutJDBC...
 */
public class DataWithoutJDBC extends com.inet.report.Database {

    /**
     * {@inheritDoc}
     */
    @Override
    public boolean useJdbcDriver(){
        return false;
    }
    
    /**
     * {@inheritDoc}
     */
    @Override
    public void getReportData( Engine engine, String configs ) {
        String[] columns = {"ID", "Name"}; // need to be the same column name(s) as in the report
        
        /* Methods to see which report or subreport is working with this engine
        engine.getReportTitle();
        engine.getPrompts();
        ...
        */
         
        Object[][] data =  {{new Integer(10), "John"},{new Integer(20), "Peter"},{new Integer(23), "Ana"}};
        try {
            engine.setData( columns, data );
        } catch (Exception e) {
            e.printStackTrace();
        }
    }   
}