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.3 2000/12/11 21:24:10 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 * 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(){

        // Activate special funtionality.
        

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

//---PRIVATE METHODS---

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

//---ATTRIBUTES---

//---STATIC ATTRIBUTES---

}
Revision:	1.4
Committed:	Thu Dec 14 15:01:22 2000 UTC (25 years ago) by pjm2
Branch:	MAIN
Changes since 1.3:	+2 -2 lines
Log Message:	The query now returns the data sorted by receipt_date rather than the default order (typically the order in which it was entered into the database)
#	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.3 2000/12/11 21:24:10 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 * 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	// Activate special funtionality.
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	}