com.spoledge.audao.db.dao
Class AbstractDaoImpl<T>

java.lang.Object
  com.spoledge.audao.db.dao.RootDaoImpl
      com.spoledge.audao.db.dao.AbstractDaoImpl<T>

public abstract class AbstractDaoImpl<T>
extends RootDaoImpl

This is the parent of all DAO implementation classes. It uses all common generic methods and utilities. The implementation is not thread safe - we assume that the client creates one DAO impl per thread.

Field Summary

protected java.sql.Connection

conn The assigned connection.

Fields inherited from class com.spoledge.audao.db.dao.RootDaoImpl

log

Constructor Summary

protected

AbstractDaoImpl(java.sql.Connection conn) Creates a new DAO implementation.

Method Summary

protected int	count(java.lang.String cond, java.lang.Object... params) New counter - SQL count().
protected int	deleteMany(java.lang.String cond, java.lang.Object... params)
protected boolean	deleteOne(java.lang.String cond, java.lang.Object... params)
protected int	executeUpdate(java.lang.String sql, java.lang.Object... params)
protected abstract T	fetch(java.sql.ResultSet rs)
protected T[]	fetchArray(java.sql.ResultSet rs, int offset, int count)
protected java.util.ArrayList<T>	fetchList(java.sql.ResultSet rs, int offset, int count)
protected T[]	findManyArray(java.lang.String cond, int offset, int count, java.lang.Object... params)
protected java.util.ArrayList<T>	findManyImpl(java.lang.String cond, int offset, int count, java.lang.Object[] params)
protected java.util.ArrayList<T>	findManyList(java.lang.String cond, int offset, int count, java.lang.Object... params)
protected T	findOne(java.lang.String cond, java.lang.Object... params)
protected java.lang.String	getDeleteSql()
protected java.lang.String	getDeleteSql(java.lang.String cond)
protected java.lang.String	getInsertSelect(java.lang.String target, java.lang.String cond)
protected abstract java.lang.String	getSelectColumns()
protected java.lang.String	getSelectCountSql()
protected java.lang.String	getSelectSql()
protected java.lang.String	getSelectSql(java.lang.String cond)
protected java.lang.String	getSqlCondition(java.lang.String cond) Returns the condition starting with " WHERE " or an empty string.
protected java.lang.String	getTruncateSql()
protected java.lang.String	getUpdateSql(java.lang.String setstring)
protected java.lang.String	getUpdateSql(java.lang.String setstring, java.lang.String cond)
protected void	handleException(java.sql.SQLException e)
protected java.lang.Integer	selectInt(java.lang.String sql, java.lang.Object... params)
protected java.lang.Long	selectLong(java.lang.String sql, java.lang.Object... params)
protected java.lang.Short	selectShort(java.lang.String sql, java.lang.Object... params)
protected abstract T[]	toArray(java.util.ArrayList<T> list)
protected int	updateMany(java.lang.String setstring, java.lang.String cond, java.lang.Object... params)
protected boolean	updateOne(java.lang.String setstring, java.lang.String cond, java.lang.Object... params)

Methods inherited from class com.spoledge.audao.db.dao.RootDaoImpl

checkLength, checkLength, checkLength, checkMaxLength, checkMaxLength, checkMaxLength, checkNull, debugSql, debugSql, debugSql, deserialize, dtoKey, errorSql, errorSql, errorSql, getTableName, pageOffset, serialize, sqlLog

Methods inherited from class java.lang.Object

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

Field Detail

conn

protected java.sql.Connection conn

The assigned connection.

Constructor Detail

AbstractDaoImpl

protected AbstractDaoImpl(java.sql.Connection conn)

Creates a new DAO implementation.

Throws:

java.lang.NullPointerException - whe the passed connection is null.

Method Detail

findOne

protected T findOne(java.lang.String cond,
                    java.lang.Object... params)

findManyArray

protected T[] findManyArray(java.lang.String cond,
                            int offset,
                            int count,
                            java.lang.Object... params)

findManyList

protected java.util.ArrayList<T> findManyList(java.lang.String cond,
                                              int offset,
                                              int count,
                                              java.lang.Object... params)

findManyImpl

protected java.util.ArrayList<T> findManyImpl(java.lang.String cond,
                                              int offset,
                                              int count,
                                              java.lang.Object[] params)

count

protected int count(java.lang.String cond,
                    java.lang.Object... params)

New counter - SQL count().

updateOne

protected boolean updateOne(java.lang.String setstring,
                            java.lang.String cond,
                            java.lang.Object... params)
                     throws DaoException

Throws:

DaoException

updateMany

protected int updateMany(java.lang.String setstring,
                         java.lang.String cond,
                         java.lang.Object... params)
                  throws DaoException

Throws:

DaoException

deleteOne

protected boolean deleteOne(java.lang.String cond,
                            java.lang.Object... params)
                     throws DaoException

Throws:

DaoException

deleteMany

protected int deleteMany(java.lang.String cond,
                         java.lang.Object... params)
                  throws DaoException

Throws:

DaoException

executeUpdate

protected int executeUpdate(java.lang.String sql,
                            java.lang.Object... params)
                     throws DaoException

Throws:

DaoException

getSelectSql

protected java.lang.String getSelectSql(java.lang.String cond)

getSelectSql

protected java.lang.String getSelectSql()

getSelectCountSql

protected java.lang.String getSelectCountSql()

getUpdateSql

protected java.lang.String getUpdateSql(java.lang.String setstring,
                                        java.lang.String cond)

getUpdateSql

protected java.lang.String getUpdateSql(java.lang.String setstring)

getDeleteSql

protected java.lang.String getDeleteSql(java.lang.String cond)

getDeleteSql

protected java.lang.String getDeleteSql()

getTruncateSql

protected java.lang.String getTruncateSql()

getInsertSelect

protected java.lang.String getInsertSelect(java.lang.String target,
                                           java.lang.String cond)

getSqlCondition

protected java.lang.String getSqlCondition(java.lang.String cond)

Returns the condition starting with " WHERE " or an empty string.

getSelectColumns

protected abstract java.lang.String getSelectColumns()

fetch

protected abstract T fetch(java.sql.ResultSet rs)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

toArray

protected abstract T[] toArray(java.util.ArrayList<T> list)

fetchArray

protected T[] fetchArray(java.sql.ResultSet rs,
                         int offset,
                         int count)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

fetchList

protected java.util.ArrayList<T> fetchList(java.sql.ResultSet rs,
                                           int offset,
                                           int count)
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

selectShort

protected java.lang.Short selectShort(java.lang.String sql,
                                      java.lang.Object... params)

selectInt

protected java.lang.Integer selectInt(java.lang.String sql,
                                      java.lang.Object... params)

selectLong

protected java.lang.Long selectLong(java.lang.String sql,
                                    java.lang.Object... params)

handleException

protected void handleException(java.sql.SQLException e)
                        throws DaoException

Throws:

DaoException