reports/DBReporter/Template__Report.java

//---PACKAGE DECLARATION---

//---IMPORTS---
import java.sql.*;

/**
 * This is a report template.
 *
 * @author  $Author:  $
 * @version $Id:  $
 */
public class Template__Report extends Report {

//---FINAL ATTRIBUTES---

    /**
     * The current CVS revision of this class
     */
    public final String REVISION = "$ Revision:  $";
    
    
//---STATIC METHODS---

//---CONSTRUCTORS---

    public Template__Report(){
        
        // Use this key value from the parameter table for the report data.
        _reportField = "packet.template.name";
        
        // Use this select query.
        _sql = "SELECT receipt_date, value FROM "+DBParameters.PACKET_TABLE+" pkt, "+DBParameters.PARAMETER_TABLE+" param WHERE pkt.id=param.packet_id AND pkt.machine_name='"+ _machine_name+"' AND pkt.receipt_date >= "+_startDate+" AND pkt.receipt_date <= "+_endDate+" AND param.name='"+_reportField+"' ORDER BY pkt.receipt_date;";
    
    }
        
//---PUBLIC METHODS---

    
    /**
     * This method overrides the superclass.  It should be used to provide
     * special functionality for the report.
     */
    public void createReport(String directory, Statement stmt, String machine_name, long startDate, long endDate){

        // Perform special functions here.
        // .....

        // Or carry on with the normal method for creating reports.
        super.createReport(directory, stmt, machine_name, startDate, endDate);
    }
    
    
    /**
     * Overrides the {@link java.lang.Object#toString() Object.toString()}
     * method to provide clean logging (every class should have this).
     *
     * @return the name of this class and its CVS revision
     */
    public String toString() {
        return this.getClass().getName() + "(" + REVISION.substring(11, REVISION.length() - 2) + ")";
    }   

//---PRIVATE METHODS---

//---ACCESSOR/MUTATOR METHODS---

//---ATTRIBUTES---

//---STATIC ATTRIBUTES---

}
Revision:	1.2
Committed:	Sat Jan 6 22:09:32 2001 UTC (24 years, 11 months ago) by pjm2
Branch:	MAIN
Changes since 1.1:	+4 -5 lines
Log Message:	Remove the first two reports as they no longer comply with the template standards. The rest of the program has been altered to handle plugin reports, which can be defined in a report.lst file.
#	User	Rev	Content
1	pjm2	1.1	//---PACKAGE DECLARATION---
2
3			//---IMPORTS---
4			import java.sql.*;
5
6			/**
7			* This is a report template.
8			*
9			* @author $Author: $
10			* @version $Id: $
11			*/
12			public class Template__Report extends Report {
13
14			//---FINAL ATTRIBUTES---
15
16			/**
17			* The current CVS revision of this class
18			*/
19			public final String REVISION = "$ Revision: $";
20
21
22			//---STATIC METHODS---
23
24			//---CONSTRUCTORS---
25
26	pjm2	1.2	public Template__Report(){
27	pjm2	1.1
28			// Use this key value from the parameter table for the report data.
29			_reportField = "packet.template.name";
30
31			// Use this select query.
32	pjm2	1.2	_sql = "SELECT receipt_date, value FROM "+DBParameters.PACKET_TABLE+" pkt, "+DBParameters.PARAMETER_TABLE+" param WHERE pkt.id=param.packet_id AND pkt.machine_name='"+ _machine_name+"' AND pkt.receipt_date >= "+_startDate+" AND pkt.receipt_date <= "+_endDate+" AND param.name='"+_reportField+"' ORDER BY pkt.receipt_date;";
33	pjm2	1.1
34			}
35
36			//---PUBLIC METHODS---
37
38
39			/**
40			* This method overrides the superclass. It should be used to provide
41			* special functionality for the report.
42			*/
43	pjm2	1.2	public void createReport(String directory, Statement stmt, String machine_name, long startDate, long endDate){
44	pjm2	1.1
45			// Perform special functions here.
46			// .....
47
48			// Or carry on with the normal method for creating reports.
49	pjm2	1.2	super.createReport(directory, stmt, machine_name, startDate, endDate);
50	pjm2	1.1	}
51
52
53			/**
54			* Overrides the {@link java.lang.Object#toString() Object.toString()}
55			* method to provide clean logging (every class should have this).
56			*
57			* @return the name of this class and its CVS revision
58			*/
59			public String toString() {
60			return this.getClass().getName() + "(" + REVISION.substring(11, REVISION.length() - 2) + ")";
61			}
62
63			//---PRIVATE METHODS---
64
65			//---ACCESSOR/MUTATOR METHODS---
66
67			//---ATTRIBUTES---
68
69			//---STATIC ATTRIBUTES---
70
71			}