reports/DBReporter/CpuUserReport.java

//---PACKAGE DECLARATION---

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

/**
 * Produces a report of the available memory in a host.
 *
 * @author  $Author: pjm2 $
 * @version $Id: CpuUserReport.java,v 1.5 2000/12/14 17:10:47 pjm2 Exp $
 */
public class CpuUserReport extends Report {

//---FINAL ATTRIBUTES---

//---STATIC METHODS---

//---CONSTRUCTORS---

    public CpuUserReport(String directory, Statement stmt, String machine_name, long startDate, long endDate){
        super (directory, stmt, machine_name, startDate, endDate);
        
        // Use this from the parameter table.
        _reportField = "packet.cpu.user";
        
        // Use this select query.
        _sql = "SELECT receipt_date, value FROM packet_test pkt, parameter_test 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---

    // Override the superclass here to obtain special functionality.
    public void createReport(){

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

        // Now carry on with the normal method for creating reports.
        super.createReport();
    }

//---PRIVATE METHODS---

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

//---ATTRIBUTES---

//---STATIC ATTRIBUTES---

}
Revision:	1.6
Committed:	Sat Jan 6 19:39:23 2001 UTC (24 years, 11 months ago) by pjm2
Branch:	MAIN
Changes since 1.5:	+6 -6 lines
Log Message:	Moved some parameters into the Parameter class. Program exits if the database driver cannot be found. Colours are now obtained from the IscreamColour class. (Including the infamous i-scream blue.) CpuUserReport provides an example of report overriding.
#	User	Rev	Content
1	pjm2	1.1	//---PACKAGE DECLARATION---
2
3			//---IMPORTS---
4			import java.sql.*;
5
6			/**
7			* Produces a report of the available memory in a host.
8			*
9			* @author $Author: pjm2 $
10	pjm2	1.6	* @version $Id: CpuUserReport.java,v 1.5 2000/12/14 17:10:47 pjm2 Exp $
11	pjm2	1.1	*/
12			public class CpuUserReport extends Report {
13
14			//---FINAL ATTRIBUTES---
15
16			//---STATIC METHODS---
17
18			//---CONSTRUCTORS---
19
20			public CpuUserReport(String directory, Statement stmt, String machine_name, long startDate, long endDate){
21			super (directory, stmt, machine_name, startDate, endDate);
22	pjm2	1.3
23			// Use this from the parameter table.
24	pjm2	1.2	_reportField = "packet.cpu.user";
25	pjm2	1.3
26			// Use this select query.
27	pjm2	1.5	_sql = "SELECT receipt_date, value FROM packet_test pkt, parameter_test 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;";
28	pjm2	1.3
29	pjm2	1.1	}
30
31			//---PUBLIC METHODS---
32
33			// Override the superclass here to obtain special functionality.
34	pjm2	1.6	public void createReport(){
35	pjm2	1.1
36	pjm2	1.6	// Perform special functions here.
37			// .....
38	pjm2	1.1
39			// Now carry on with the normal method for creating reports.
40	pjm2	1.6	super.createReport();
41			}
42	pjm2	1.1
43			//---PRIVATE METHODS---
44
45			//---ACCESSOR/MUTATOR METHODS---
46
47			//---ATTRIBUTES---
48
49			//---STATIC ATTRIBUTES---
50
51			}