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.2 2000/12/11 17:02: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 * 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+"';";
    
    }
        
//---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.3
Committed:	Mon Dec 11 21:24:10 2000 UTC (25 years ago) by pjm2
Branch:	MAIN
Changes since 1.2:	+6 -1 lines
Log Message:	Altered the main method to produce 30-day, 7-day and hourly reports as well as the original daily reports. The daily reports should be archived(?) Included generation of a list of links.
#	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.3	* @version $Id: CpuUserReport.java,v 1.2 2000/12/11 17:02: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.2	_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+"';";
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.2	//public void createReport(){
35	pjm2	1.1
36	pjm2	1.2	// Activate special funtionality.
37
38	pjm2	1.1
39			// Now carry on with the normal method for creating reports.
40	pjm2	1.2	// super.createReport();
41			//}
42	pjm2	1.1
43			//---PRIVATE METHODS---
44
45			//---ACCESSOR/MUTATOR METHODS---
46
47			//---ATTRIBUTES---
48
49			//---STATIC ATTRIBUTES---
50
51			}