ch.gbssg.app.ila.database.dao

Class CodeTypeJDBCTemplate

java.lang.Object

ch.gbssg.app.ila.database.dao.CodeTypeJDBCTemplate

All Implemented Interfaces:

ICrud<CodeType>

public class CodeTypeJDBCTemplate
extends java.lang.Object
implements ICrud<CodeType>

JDBC Template for the CodeType model Contains all basic SQL transaction, like Select, Insert, Update and delete

Version:

1.0

Author:

Michael Huber

Constructor Summary

Constructors

Constructor and Description
CodeTypeJDBCTemplate()

Method Summary

Modifier and Type	Method and Description
int	create(CodeType entity) create a new entity of implement dao
int	delete(int id) delete a record from dao object
java.util.List<CodeType>	filterByEntity(CodeType entity) returns all filtered entities.
java.util.List<CodeType>	get() gives all the records form the dao object
CodeType	getById(int id) looking for a id from implement dao
void	setDataSource(javax.sql.DataSource dataSource) used to initialize database resources connection.
int	update(int id, CodeType newEntity) update a entity of dao objects

Methods inherited from class java.lang.Object

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

Constructor Detail

CodeTypeJDBCTemplate

public CodeTypeJDBCTemplate()

Method Detail

setDataSource

public void setDataSource(javax.sql.DataSource dataSource)

Description copied from interface: ICrud

used to initialize database resources connection.

Specified by:

setDataSource in interface ICrud<CodeType>

Parameters:

dataSource - database connection

create

public int create(CodeType entity)

Description copied from interface: ICrud

create a new entity of implement dao

Specified by:

create in interface ICrud<CodeType>

Parameters:

entity - new model

Returns:

the new id of created entity

getById

public CodeType getById(int id)

Description copied from interface: ICrud

looking for a id from implement dao

Specified by:

getById in interface ICrud<CodeType>

Parameters:

id - of dao entity

Returns:

the dao object

get

public java.util.List<CodeType> get()

Description copied from interface: ICrud

gives all the records form the dao object

Specified by:

get in interface ICrud<CodeType>

Returns:

a list of dao entities

filterByEntity

public java.util.List<CodeType> filterByEntity(CodeType entity)

Description copied from interface: ICrud

returns all filtered entities.

Specified by:

filterByEntity in interface ICrud<CodeType>

Parameters:

entity - to filter

Returns:

a list of all filterted entites.

delete

public int delete(int id)

Description copied from interface: ICrud

delete a record from dao object

Specified by:

delete in interface ICrud<CodeType>

Parameters:

id - of entity

Returns:

the number of affected records

update

public int update(int id,
                  CodeType newEntity)

Description copied from interface: ICrud

update a entity of dao objects

Specified by:

update in interface ICrud<CodeType>

Parameters:

id - to update

newEntity - includes the new values for update a entity

Returns:

the number of affected records