com.aspc.DBObj.Formula

Class DBCalculator

java.lang.Object

com.aspc.DBObj.Formula.DBCalculator

public class DBCalculator
extends java.lang.Object

DBCalculator THREAD MODE: SINGLE-THREADED

Since:

October 30, 2003, 16:35 PM

Author:

Jason McGrath

Constructor Summary

Constructors

Constructor and Description
DBCalculator()

Method Summary

Modifier and Type	Method and Description
double	doAverage(DBResult results, DBFormula formula) Calculate the average value
int	doCount(DBResult results, Path pth) Counts the result according to a path
java.lang.Object	doFirst(DBResult results, Path pth) doFirst
double	doMax(DBResult results, DBFormula formula) Finds the Maximum value
double	doMin(DBResult results, DBFormula formula) Finds the minimum value
double	doSum(DBResult results, DBFormula formula) calculates the sum
double	doWeighting(DBResult results, DBFormula formula, DBFormula factor) If the factor is calculated to be the same for each record this will return the Average

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DBCalculator

public DBCalculator()

Method Detail

doSum

public double doSum(DBResult results,
                    DBFormula formula)
             throws java.lang.Exception

calculates the sum

Parameters:

results - DBResult

formula - DBFormula

Returns:

double value for sum

Throws:

java.lang.Exception - a serious problem

doWeighting

public double doWeighting(DBResult results,
                          DBFormula formula,
                          DBFormula factor)
                   throws java.lang.Exception

If the factor is calculated to be the same for each record this will return the Average

Parameters:

results - DBResult

formula - DBFormula

factor - DBFormula

Returns:

Double value

Throws:

java.lang.Exception - a serious problem

doAverage

public double doAverage(@Nonnull
                        DBResult results,
                        DBFormula formula)
                 throws java.lang.Exception

Calculate the average value

Parameters:

results - DBResult

formula - DBFormula

Returns:

Double average value

Throws:

java.lang.Exception - a serious problem

doCount

public int doCount(DBResult results,
                   Path pth)
            throws java.lang.Exception

Counts the result according to a path

Parameters:

results - DBResult

pth - Path

Returns:

Int count value

Throws:

java.lang.Exception - a serious problem

doFirst

public java.lang.Object doFirst(DBResult results,
                                Path pth)
                         throws java.lang.Exception

doFirst

Parameters:

results - DBResult

pth - Path

Returns:

Object value

Throws:

java.lang.Exception - a serious problem

doMin

public double doMin(DBResult results,
                    DBFormula formula)
             throws java.lang.Exception

Finds the minimum value

Parameters:

results - DBResult

formula - DBFormula

Returns:

minimum value as Double

Throws:

java.lang.Exception - a serious problem

doMax

public double doMax(DBResult results,
                    DBFormula formula)
             throws java.lang.Exception

Finds the Maximum value

Parameters:

results - DBResult

formula - DBFormula

Returns:

maximum value as Double

Throws:

java.lang.Exception - a serious problem