ch.gbssg.app.ila.database.dao

Class CodeJDBCTemplate

java.lang.Object

ch.gbssg.app.ila.database.dao.CodeJDBCTemplate

All Implemented Interfaces:

ICrud<Code>

public class CodeJDBCTemplate
extends java.lang.Object
implements ICrud<Code>

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

Version:

1.0

Author:

Michael Huber

Constructor Summary

Constructors

Constructor and Description
CodeJDBCTemplate()

Method Summary

Modifier and Type	Method and Description
int	create(Code entity) create a new entity of implement dao
int	delete(int id) delete a record from dao object
java.util.List<Code>	filterByEntity(Code entity) returns all filtered entities.
java.util.List<Code>	get() gives all the records form the dao object
Code	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, Code 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

CodeJDBCTemplate

public CodeJDBCTemplate()

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<Code>

Parameters:

dataSource - database connection

create

public int create(Code entity)

Description copied from interface: ICrud

create a new entity of implement dao

Specified by:

create in interface ICrud<Code>

Parameters:

entity - new model

Returns:

the new id of created entity

getById

public Code getById(int id)

Description copied from interface: ICrud

looking for a id from implement dao

Specified by:

getById in interface ICrud<Code>

Parameters:

id - of dao entity

Returns:

the dao object

get

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

Description copied from interface: ICrud

gives all the records form the dao object

Specified by:

get in interface ICrud<Code>

Returns:

a list of dao entities

filterByEntity

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

Description copied from interface: ICrud

returns all filtered entities.

Specified by:

filterByEntity in interface ICrud<Code>

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<Code>

Parameters:

id - of entity

Returns:

the number of affected records

update

public int update(int id,
                  Code newEntity)

Description copied from interface: ICrud

update a entity of dao objects

Specified by:

update in interface ICrud<Code>

Parameters:

id - to update

newEntity - includes the new values for update a entity

Returns:

the number of affected records