br.ufscar.saci.base.database

Class Dao<E>

java.lang.Object

br.ufscar.saci.base.database.Dao<E>

Direct Known Subclasses:

AgendaDao, AgendaFilterDao, AgendaProductFilterDao, AlbumDao, CategoryDao, ClippingDao, ClippingFilterDao, ClippingSectorFilterDao, CoverphotoDao, CoverphotoFilterDao, CoverphotoSectorFilterDao, EventDao, InstitutionDao, InstitutionPermissionDao, JobDao, JobFilterDao, JobSectorFilterDao, LogDao, MediaAttendanceDao, MediaAttendanceFilterDao, MediaAttendanceSectorFilterDao, MediaJournalistDao, MediaOutletDao, MediaSectionDao, MediaShowDao, MediaSubsectionDao, NewsDao, NewsFilterDao, NewsProductFilterDao, PersonDao, PhotoDao, PhotoFilterDao, PhotoSectorFilterDao, PrintingOfficeDao, ProductDao, RequestDao, RequestFileDao, RequestFilterDao, RequestSectorFilterDao, RequestSuggestionDao, SectorDao, SectorPermissionDao, TemplateClippingDao, TemplateEmailDao, TemplateFacebookDao, TemplateNewsletterDao, TemplateNoneDao, TemplatePrintedNewsDao, TemplateRadioNewsDao, TemplateRadiospotDao, TemplateReleaseDao, TemplateTVDao, TemplateTwitterDao, TemplateUfscarPortalDao, TemplateWordpressDao, TemplateXv3Dao

public abstract class Dao<E>
extends Object

Field Summary

Fields

Modifier and Type	Field and Description
protected String	baseSelect
protected String	dbName

Constructor Summary

Constructors

Constructor and Description
Dao()

Method Summary

Methods

Modifier and Type	Method and Description
protected boolean	check(String queryOrComplement, String... args) Checks if a query is sucessfully executed in the database.
protected boolean	convenienceExists(String filename) Returns true if a file exists Note: returns false for null or empty strings
protected void	convenienceMove(String oldName, String newName) Note: read this before using (convenience behaviour).
protected void	convenienceMove(String oldName, String newName, boolean deleteIfEmpty) Note: read this before using (convenience behaviour).
protected String	convenienceRename(String filename, int id) Note: read this before using (convenience behaviour).
protected int	count(String queryComplement) Checks if a query is sucessfully executed in the database.
protected void	deactivate_(int id)
protected void	deactivate_(String queryComplement)
protected void	deactivate2_(int id)
protected void	deactivate2_(String queryComplement)
protected E	get0(int id)
protected E	get0(String queryOrComplement, String... args)
protected E	get1(int id)
protected E	get1(String queryOrComplement, String... args)
protected List<E>	getn(String queryOrComplement)
protected boolean	idExists(int id)
protected abstract void	insert(E entity)
protected abstract E	load(ResultSet rs)
protected List<E>	loadAll(ResultSet rs)
protected void	remove_(int id)
protected void	save(E entity, int id)
protected abstract void	update(E entity)

Methods inherited from class java.lang.Object

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

Field Detail

baseSelect

protected String baseSelect

dbName

protected String dbName

Constructor Detail

Dao

public Dao()

Method Detail

count

protected int count(String queryComplement)

Checks if a query is sucessfully executed in the database.

Note: table must have field "id".

Parameters:

queryComplement - complement to the query

Returns:

true if the query succed

check

protected boolean check(String queryOrComplement,
            String... args)

Checks if a query is sucessfully executed in the database.

Note: table must have field "id".

Parameters:

queryOrComplement - complement to the query

args - string parameters if any

Returns:

true if the query succed

convenienceExists

protected boolean convenienceExists(String filename)

Returns true if a file exists

Note: returns false for null or empty strings

convenienceMove

protected void convenienceMove(String oldName,
                   String newName)

Note: read this before using (convenience behaviour).

Moves a file in oldName (full path) to newName (relative path to data dir).

Note 1: does nothing if oldName and newName are the same.

Note 2: if oldName does not exists, does nothing.

convenienceMove

protected void convenienceMove(String oldName,
                   String newName,
                   boolean deleteIfEmpty)

Note: read this before using (convenience behaviour).

Moves a file in oldName (full path) to newName (relative path to data dir).

Note 1: does nothing if oldName and newName are the same.

Note 2: when deleteIfEmpty==true and oldName is null or empty, deletes new file.

Note 2: when deleteIfEmpty==false and oldName is null or empty, does nothing.

convenienceRename

protected String convenienceRename(String filename,
                       int id)

Note: read this before using (convenience behaviour).

Renames a file for convenienceMove.

Example input: /srv/tomcat/temp/my_file_9999999.pdf

Example output: 00001_my_file.pdf

deactivate_

protected void deactivate_(int id)

deactivate_

protected void deactivate_(String queryComplement)

deactivate2_

protected void deactivate2_(int id)

deactivate2_

protected void deactivate2_(String queryComplement)

get0

protected E get0(int id)

get0

protected E get0(String queryOrComplement,
     String... args)

get1

protected E get1(int id)

get1

protected E get1(String queryOrComplement,
     String... args)

getn

protected List<E> getn(String queryOrComplement)

idExists

protected boolean idExists(int id)

insert

protected abstract void insert(E entity)

load

protected abstract E load(ResultSet rs)

loadAll

protected List<E> loadAll(ResultSet rs)

remove_

protected void remove_(int id)

save

protected void save(E entity,
        int id)

update

protected abstract void update(E entity)