com.serotonin.mango.db.dao

Class BaseDao

java.lang.Object

com.serotonin.db.DaoUtils

com.serotonin.mango.db.dao.BaseDao

Direct Known Subclasses:

CompoundEventDetectorDao, DataPointDao, DataSourceDao, DBUpgrade, EventDao, EventDetectorTemplateDao, FlexProjectDao, MailingListDao, MaintenanceEventDao, PointLinkDao, PointValueDao, PublisherDao, ReportDao, ScheduledEventDao, ScriptDao, SystemSettingsDao, UserDao, UsersProfileDao, ViewDao, WatchListDao

public class BaseDao
extends com.serotonin.db.DaoUtils

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	DEFAULT_GENERATED_KEY_COLUMN_NAME

Fields inherited from class com.serotonin.db.DaoUtils

dataSource, ejt, tm

Constructor Summary

Constructors

Modifier	Constructor and Description
	BaseDao() Public constructor for code that needs to get stuff from the database.
protected	BaseDao(javax.sql.DataSource dataSource)

Method Summary

Modifier and Type	Method and Description
protected static java.lang.String	boolToChar(boolean b)
protected static boolean	charToBool(java.lang.String s)
protected void	deleteInChunks(java.lang.String sql, java.util.List<java.lang.Integer> ids)
protected int	doInsert(java.lang.String sql, java.lang.Object[] params)
protected int	doInsert(java.lang.String sql, java.lang.Object[] params, int[] types)
protected int	doInsert(java.lang.String sql, org.springframework.jdbc.core.PreparedStatementSetter pss)
protected long	doInsertLong(java.lang.String sql, java.lang.Object[] params)
protected long	doInsertLong(java.lang.String sql, java.lang.Object[] params, int[] types)
protected long	doInsertLong(java.lang.String sql, org.springframework.jdbc.core.PreparedStatementSetter pss)
private int	executeInsert(java.lang.String sql, org.springframework.jdbc.core.PreparedStatementSetter pss)
private long	executeInsertLong(java.lang.String sql, org.springframework.jdbc.core.PreparedStatementSetter pss)
protected java.lang.String	generateUniqueXid(java.lang.String prefix, java.lang.String tableName)
protected java.lang.String	getGeneratedKeyName() Return the column name of the auto-generated key.
protected org.springframework.jdbc.core.PreparedStatementCreator	getPreparedStatementCreator(java.lang.String sql, org.springframework.jdbc.core.PreparedStatementSetter setter) Implements the prepared statement creator, to get the prepared statement to insert operation that returning auto-generated key
protected boolean	isXidUnique(java.lang.String xid, int excludeId, java.lang.String tableName)

Methods inherited from class com.serotonin.db.DaoUtils

batchUpdate, createDelimitedList, createDelimitedList, createDelimitedList, createIntValuePairs, createKeyValuePairs, dbEncodeSearchString, getInt, getTransactionManager, getTransactionTemplate, now, query, query, query, query, query, query, queryForList, queryForList, queryForObject, queryForObject, queryForObject, setInt

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_GENERATED_KEY_COLUMN_NAME

private static final java.lang.String DEFAULT_GENERATED_KEY_COLUMN_NAME

See Also:

Constant Field Values

Constructor Detail

BaseDao

public BaseDao()

Public constructor for code that needs to get stuff from the database.

BaseDao

protected BaseDao(javax.sql.DataSource dataSource)

Method Detail

boolToChar

protected static java.lang.String boolToChar(boolean b)

charToBool

protected static boolean charToBool(java.lang.String s)

deleteInChunks

protected void deleteInChunks(java.lang.String sql,
                              java.util.List<java.lang.Integer> ids)

generateUniqueXid

protected java.lang.String generateUniqueXid(java.lang.String prefix,
                                             java.lang.String tableName)

isXidUnique

protected boolean isXidUnique(java.lang.String xid,
                              int excludeId,
                              java.lang.String tableName)

getGeneratedKeyName

protected java.lang.String getGeneratedKeyName()

Return the column name of the auto-generated key. Wheiter the column name is different of the default generated key column name, the DAO should override this method.

Returns:

the column name of the generated key

getPreparedStatementCreator

protected org.springframework.jdbc.core.PreparedStatementCreator getPreparedStatementCreator(java.lang.String sql,
                                                                                             org.springframework.jdbc.core.PreparedStatementSetter setter)

Implements the prepared statement creator, to get the prepared statement to insert operation that returning auto-generated key

Parameters:

sql - an SQL statement that may contain one or more '?' IN parameter placeholders

setter - parameter setter that will set the statement parameters

Returns:

executeInsert

private int executeInsert(java.lang.String sql,
                          org.springframework.jdbc.core.PreparedStatementSetter pss)

executeInsertLong

private long executeInsertLong(java.lang.String sql,
                               org.springframework.jdbc.core.PreparedStatementSetter pss)

doInsert

protected int doInsert(java.lang.String sql,
                       java.lang.Object[] params)

Overrides:

doInsert in class com.serotonin.db.DaoUtils

doInsert

protected int doInsert(java.lang.String sql,
                       java.lang.Object[] params,
                       int[] types)

Overrides:

doInsert in class com.serotonin.db.DaoUtils

doInsert

protected int doInsert(java.lang.String sql,
                       org.springframework.jdbc.core.PreparedStatementSetter pss)

Overrides:

doInsert in class com.serotonin.db.DaoUtils

doInsertLong

protected long doInsertLong(java.lang.String sql,
                            java.lang.Object[] params)

Overrides:

doInsertLong in class com.serotonin.db.DaoUtils

doInsertLong

protected long doInsertLong(java.lang.String sql,
                            java.lang.Object[] params,
                            int[] types)

Overrides:

doInsertLong in class com.serotonin.db.DaoUtils

doInsertLong

protected long doInsertLong(java.lang.String sql,
                            org.springframework.jdbc.core.PreparedStatementSetter pss)

Overrides:

doInsertLong in class com.serotonin.db.DaoUtils