ch.gbssg.app.ila.database.dao

Class PatientJDBCTemplate

java.lang.Object

ch.gbssg.app.ila.database.dao.PatientJDBCTemplate

All Implemented Interfaces:

ICrud<Patient>

public class PatientJDBCTemplate
extends java.lang.Object
implements ICrud<Patient>

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

Version:

1.0

Author:

Michael Huber

Constructor Summary

Constructors

Constructor and Description
PatientJDBCTemplate()

Method Summary

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

PatientJDBCTemplate

public PatientJDBCTemplate()

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

Parameters:

dataSource - database connection

create

public int create(Patient entity)

Description copied from interface: ICrud

create a new entity of implement dao

Specified by:

create in interface ICrud<Patient>

Parameters:

entity - new model

Returns:

the new id of created entity

getById

public Patient getById(int id)

Description copied from interface: ICrud

looking for a id from implement dao

Specified by:

getById in interface ICrud<Patient>

Parameters:

id - of dao entity

Returns:

the dao object

get

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

Description copied from interface: ICrud

gives all the records form the dao object

Specified by:

get in interface ICrud<Patient>

Returns:

a list of dao entities

filterByEntity

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

Description copied from interface: ICrud

returns all filtered entities.

Specified by:

filterByEntity in interface ICrud<Patient>

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

Parameters:

id - of entity

Returns:

the number of affected records

update

public int update(int id,
                  Patient newEntity)

Description copied from interface: ICrud

update a entity of dao objects

Specified by:

update in interface ICrud<Patient>

Parameters:

id - to update

newEntity - includes the new values for update a entity

Returns:

the number of affected records