devices
Class DbDevice

java.lang.Object
  devices.DbDevice

public class DbDevice

extends java.lang.Object

Retrieve Device records from the database.

Version:

0.1

Author:

gswalters

Constructor Summary

DbDevice()

Method Summary

static java.util.Vector	dbGetMonitoredDevices(java.sql.Connection dbConn) Query the Device table for all monitored devices.
static java.util.Vector	dbGetRemovedDevices(java.sql.Connection dbConn) Query the Device table for all removed devices.
static java.util.Vector	dbGetUnmonitoredDevices(java.sql.Connection dbConn) Query the Device table for all unmonitored devices.
static java.util.Vector	getRecords(java.sql.Connection dbConn, java.lang.String query) Retrieve multiple Device records from the database.

Methods inherited from class java.lang.Object

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

Constructor Detail

DbDevice

public DbDevice()

Method Detail

dbGetMonitoredDevices

public static java.util.Vector dbGetMonitoredDevices(java.sql.Connection dbConn)

Query the Device table for all monitored devices.

Parameters:

dbConn - Connection to the database

Returns:

Device array - a null value indicates not found or an error occured

dbGetUnmonitoredDevices

public static java.util.Vector dbGetUnmonitoredDevices(java.sql.Connection dbConn)

Query the Device table for all unmonitored devices.

Parameters:

dbConn - Connection to the database

Returns:

Device array - a null value indicates not found or an error occured

dbGetRemovedDevices

public static java.util.Vector dbGetRemovedDevices(java.sql.Connection dbConn)

Query the Device table for all removed devices.

Parameters:

dbConn - Connection to the database

Returns:

Device array - a null value indicates not found or an error occured

getRecords

public static java.util.Vector getRecords(java.sql.Connection dbConn,
                                          java.lang.String query)

Retrieve multiple Device records from the database. Submit the passed query to the database and return the results.

Parameters:

dbConn - Connection to the database

query - String containing the fully defined SQL SELECT statement

Returns:

Device array - a null value indicates not found or an error occured