net.namibsun.papio.lib.db

Class DbHandler

net.namibsun.papio.lib.db.DbHandler

public class DbHandler

Class that manages database calls

Constructor Summary

Constructors

Constructor and Description
DbHandler(java.sql.Connection connection) Class that manages database calls

Method Summary

Modifier and Type	Method and Description
void	close() Closes the database connection
java.sql.Connection	getConnection() :
DbModel	getModel(Table table, int id) Retrieves a model from the database based on its ID.
NamedDbModel	getModel(Table table, java.lang.String nameOrId) Retrieves a named model from the database based on a string that either represents their ID or name
java.util.List<net.namibsun.papio.lib.db.DbModel>	getModels(Table table) Retrieves all models in a database table

Constructor Detail

DbHandler

public DbHandler(java.sql.Connection connection)

Class that manages database calls

Parameters:

connection - : A JDBC compatible database connection

connection - : A JDBC compatible database connection

Method Detail

close

public void close()

Closes the database connection

getModel

public DbModel getModel(Table table,
                        int id)

Retrieves a model from the database based on its ID.

Parameters:

table - : The table from which to fetch the model

id - : The ID of the model to fetch

Returns:

The retrieved model or null if none was found

getModel

public NamedDbModel getModel(Table table,
                             java.lang.String nameOrId)

Retrieves a named model from the database based on a string that either represents their ID or name

Parameters:

table - : The table from which to fetch the model

nameOrId - : The ID or name of the model to fetch

Returns:

The retrieved model or null if none was found

getModels

public java.util.List<net.namibsun.papio.lib.db.DbModel> getModels(Table table)

Retrieves all models in a database table

Parameters:

table - : The table for which to fetch all models

Returns:

A List of Database model objects

getConnection

public java.sql.Connection getConnection()

:

A JDBC compatible database connection