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.
#	Content
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	* @version $Id: CpuUserReport.java,v 1.5 2000/12/14 17:10:47 pjm2 Exp $
11	*/
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
23	// Use this from the parameter table.
24	_reportField = "packet.cpu.user";
25
26	// Use this select query.
27	_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
29	}
30
31	//---PUBLIC METHODS---
32
33	// Override the superclass here to obtain special functionality.
34	public void createReport(){
35
36	// Perform special functions here.
37	// .....
38
39	// Now carry on with the normal method for creating reports.
40	super.createReport();
41	}
42
43	//---PRIVATE METHODS---
44
45	//---ACCESSOR/MUTATOR METHODS---
46
47	//---ATTRIBUTES---
48
49	//---STATIC ATTRIBUTES---
50
51	}