com.dpslink.flash.db

Class CustomerController

java.lang.Object

com.dpslink.base.obj.MappedAttributesObject

com.dpslink.base.jdbc.JDBCObjectController<Customer>

com.dpslink.flash.db.CustomerController

All Implemented Interfaces:

java.io.Serializable

public class CustomerController
extends JDBCObjectController<Customer>

The controller for the Customer class. Provides methods for retrieving and persisting customer table records in the database.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
private static long	serialVersionUID The class' serialization version id.

Fields inherited from class com.dpslink.base.jdbc.JDBCObjectController

ivDBObjCls, ivFieldCount, ivFieldKeyAlt, ivFieldKeyPri, ivFieldResPfx, ivSyncLast, ivSyncType, ivTableName

Fields inherited from class com.dpslink.base.obj.MappedAttributesObject

ivHashCode, ivHashFlds, ivObjAttrs

Constructor Summary

Constructors

Constructor and Description
CustomerController() The constructor for the controller.

Method Summary

Modifier and Type	Method and Description
Customer	get(java.lang.String id) Returns the customer record for the given customer id.
java.lang.Object[]	getAllAsRS() Returns a result set of all customer records.
java.util.ArrayList<Customer>	getBillTos(java.lang.String id) Returns a collection of customer records having a bill-to customer id equal to the given customer id.
java.util.ArrayList<Customer>	getMatching(java.lang.String field, java.lang.String operand, java.lang.String argument) Returns a collection of customer records that have a field that contains characters matching the given criteria.
java.util.ArrayList<Customer>	getShipFors(java.lang.String id) Returns a collection of customer records having a ship for customer id equal to the given customer id.
boolean	hasCountry(java.lang.String code) Answers if a given country code exists in the customer table.
boolean	hasState(java.lang.String state, java.lang.String country) Answers if a given state code exists in the customer table.
boolean	hasUser(Customer customer) Answers if a given customer has at least one user associated with it.
Customer	valuesToObject(java.util.HashMap<java.lang.String,java.lang.Object> attrs) Returns a database object from the given set of attributes.

Methods inherited from class com.dpslink.base.jdbc.JDBCObjectController

add, add, add, arrayToMap, arrayToMap, countAll, delete, delete, deleteAll, dispose, equals, getAll, getConnection, getConnectionInfo, getController, getFieldNames, getFieldNamesForKey, getFieldNamesForUpdate, getFieldNulls, getFieldNullsForKey, getFieldNullsForUpdate, getFieldsForOrderBy, getFieldsForWhere, getFieldSize, getFieldTypes, getFieldTypesForKey, getFieldTypesForUpdate, getStatementForDelete, getStatementForGet, getStatementForGetAll, getStatementForInsert, getStatementForUpdate, getStatementKey, getStatementString, getTableName, hasFieldNamesForKey, hasFieldNamesForUpdate, isDuplicate, resultSetToArray, resultSetToMap, resultSetToMap, resultSetToObject, setConnectionInfo, setPSDeleteValues, setPSExistsValues, setPSInsertValues, setPSUpdateValues, setPSValue, update, update

Methods inherited from class com.dpslink.base.obj.MappedAttributesObject

cloneMapAttributes, formatValue, formatValue, getHashFields, getMapArrayList, getMapAttributes, getMapBigDecimal, getMapBoolean, getMapDate, getMapDouble, getMapInteger, getMapLong, getMapMapped, getMapObject, getMapShort, getMapString, getMapString, getMapStringBuffer, getMapStringBuilder, getMapTime, getMapTimestamp, getMapVector, hashCode, setHashFields, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMapAttributes, setMapObject, setMapTime, setMapTimestamp, toStringArray

Methods inherited from class java.lang.Object

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

Field Detail

serialVersionUID

private static final long serialVersionUID

The class' serialization version id.

See Also:

Constant Field Values

Constructor Detail

CustomerController

public CustomerController()

The constructor for the controller.

Method Detail

valuesToObject

public Customer valuesToObject(java.util.HashMap<java.lang.String,java.lang.Object> attrs)

Returns a database object from the given set of attributes. Overrides valuesToObject in JDBCObjectController.

This method assumes the attributes were obtained from the zcustomer database view.

Overrides:

valuesToObject in class JDBCObjectController<Customer>

Parameters:

attrs - (HashMap) The attributes to assign to the new object.

Returns:

Customer - An object initialized with the specified attributes.

get

public Customer get(java.lang.String id)

Returns the customer record for the given customer id.

Parameters:

id - (String) The customer id for the desired record.

Returns:

Customer - An object initialized with values from the database.

getAllAsRS

public java.lang.Object[] getAllAsRS()

Returns a result set of all customer records.

The invoker of this method is responsible for closing the returned result set and prepared statement.

Returns:

Object[] - An object array containing the result set ([0]) and the prepared statement ([1]) used to obtain the result set.

getBillTos

public java.util.ArrayList<Customer> getBillTos(java.lang.String id)

Returns a collection of customer records having a bill-to customer id equal to the given customer id.

Parameters:

id - (String) The customer id for the bill-to customers to retrieve.

Returns:

ArrayList - The bill-to customers for the requested customer id.

getMatching

public java.util.ArrayList<Customer> getMatching(java.lang.String field,
                                                 java.lang.String operand,
                                                 java.lang.String argument)

Returns a collection of customer records that have a field that contains characters matching the given criteria.

Parameters:

field - (String) The field that is to be involved in determining the query results. This value is appended to the end of the sql properties key when obtaining the appropriate sql statement for the requested query.

operand - (String) The operation that the query is to perform on the given field in order to determine the query results. Currently only "contains" and "equals" are supported.

argument - (String) The query search argument. The character string that the query is to use in determining its results.

Returns:

ArrayList - A collection of customers that match the criteria.

getShipFors

public java.util.ArrayList<Customer> getShipFors(java.lang.String id)

Returns a collection of customer records having a ship for customer id equal to the given customer id.

Parameters:

id - (String) The ship for id for the customers to retrieve.

Returns:

ArrayList - The customers for the requested ship for customer id.

hasCountry

public boolean hasCountry(java.lang.String code)

Answers if a given country code exists in the customer table.

Parameters:

code - (String) The country code to check.

Returns:

boolean - true if the country code exists, otherwise false.

hasState

public boolean hasState(java.lang.String state,
                        java.lang.String country)

Answers if a given state code exists in the customer table.

Parameters:

state - (String) The state code to check.

country - (String) The country code to check.

Returns:

boolean - true if the state code exists, otherwise false.

hasUser

public boolean hasUser(Customer customer)

Answers if a given customer has at least one user associated with it.

Parameters:

customer - (Customer) The customer to check.

Returns:

boolean - true if one or more users exists for the customer, otherwise false.