ch.gbssg.app.ila.database.dao

Class UserJDBCTemplate

java.lang.Object

ch.gbssg.app.ila.database.dao.UserJDBCTemplate

All Implemented Interfaces:

ICrud<User>

public class UserJDBCTemplate
extends java.lang.Object
implements ICrud<User>

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

Version:

1.0

Author:

Michael Huber

Constructor Summary

Constructors

Constructor and Description
UserJDBCTemplate()

Method Summary

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

UserJDBCTemplate

public UserJDBCTemplate()

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

Parameters:

dataSource - database connection

create

public int create(User entity)

Description copied from interface: ICrud

create a new entity of implement dao

Specified by:

create in interface ICrud<User>

Parameters:

entity - new model

Returns:

the new id of created entity

getById

public User getById(int id)

Description copied from interface: ICrud

looking for a id from implement dao

Specified by:

getById in interface ICrud<User>

Parameters:

id - of dao entity

Returns:

the dao object

get

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

Description copied from interface: ICrud

gives all the records form the dao object

Specified by:

get in interface ICrud<User>

Returns:

a list of dao entities

filterByEntity

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

Description copied from interface: ICrud

returns all filtered entities.

Specified by:

filterByEntity in interface ICrud<User>

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

Parameters:

id - of entity

Returns:

the number of affected records

update

public int update(int id,
                  User newEntity)

Description copied from interface: ICrud

update a entity of dao objects

Specified by:

update in interface ICrud<User>

Parameters:

id - to update

newEntity - includes the new values for update a entity

Returns:

the number of affected records