com.pmease.quickbuild.plugin.report.engine.datastore
Class DbStore
java.lang.Object
com.pmease.quickbuild.plugin.report.engine.datastore.DbStore
- Direct Known Subclasses:
- CategoryDb
public abstract class DbStore
- extends java.lang.Object
Field Summary |
protected java.sql.Connection |
connection
|
protected java.io.File |
dbDir
|
protected static org.slf4j.Logger |
logger
|
Constructor Summary |
protected |
DbStore(java.io.File dbDir)
|
Method Summary |
void |
beginTransaction()
|
void |
close()
|
void |
commit()
|
protected abstract void |
createDb()
|
boolean |
exists()
|
java.sql.Connection |
getConnection()
|
protected java.sql.Connection |
getConnection(java.lang.String url)
|
java.io.File |
getDbDir()
|
java.io.File |
getDbFile()
|
protected abstract java.lang.String |
getDbName()
|
java.lang.String |
getDbPath()
|
protected java.util.concurrent.locks.Lock |
getLock()
|
protected java.io.File |
getLockDir()
|
DbStore.Mode |
getMode()
|
protected java.lang.String |
getUrl()
|
boolean |
isClosed()
|
boolean |
isReadOnly()
|
void |
open(DbStore.Mode mode)
|
void |
open(DbStore.Mode mode,
java.lang.String method)
|
|
query(SqlBuilder sb,
org.apache.commons.dbutils.ResultSetHandler<T> rsh)
|
|
query(java.lang.String sql,
org.apache.commons.dbutils.ResultSetHandler<T> rsh)
|
|
query(java.lang.String sql,
org.apache.commons.dbutils.ResultSetHandler<T> rsh,
java.lang.Object[] params)
|
java.util.List<java.lang.Object[]> |
queryForArrayList(SqlBuilder sb)
|
java.util.List<java.lang.Object[]> |
queryForArrayList(java.lang.String sql)
|
|
queryForBeanList(SqlBuilder sb,
java.lang.Class<T> requiredType)
|
Date |
queryForDate(SqlBuilder sb)
|
java.lang.Double |
queryForDouble(SqlBuilder sb)
|
java.lang.Double |
queryForDouble(java.lang.String sql)
|
java.lang.Integer |
queryForInt(SqlBuilder sb)
|
java.lang.Integer |
queryForInt(java.lang.String sql)
|
java.lang.Long |
queryForLong(SqlBuilder sb)
|
java.lang.Long |
queryForLong(java.lang.String sql)
|
java.util.Map<java.lang.String,java.lang.Object> |
queryForMap(SqlBuilder sb)
|
java.util.Map<java.lang.String,java.lang.Object> |
queryForMap(java.lang.String sql)
|
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> |
queryForMapList(SqlBuilder sb)
|
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> |
queryForMapList(java.lang.String sql)
|
|
queryForObject(SqlBuilder sb,
java.lang.Class<T> requiredType)
|
|
queryForObject(java.lang.String sql,
java.lang.Class<T> requiredType)
|
|
queryForObject(java.lang.String sql,
java.lang.Class<T> requiredType,
java.lang.Object[] params)
|
java.lang.String |
queryForString(java.lang.String sql)
|
java.util.Calendar |
queryForTime(SqlBuilder sb)
|
void |
rollback()
|
java.lang.String |
toString()
|
void |
update(SqlBuilder sb)
|
void |
update(java.lang.String sql)
|
void |
update(java.lang.String sql,
java.lang.Object[] params)
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
logger
protected static final org.slf4j.Logger logger
dbDir
protected java.io.File dbDir
connection
protected java.sql.Connection connection
DbStore
protected DbStore(java.io.File dbDir)
getDbName
protected abstract java.lang.String getDbName()
createDb
protected abstract void createDb()
query
public <T> T query(SqlBuilder sb,
org.apache.commons.dbutils.ResultSetHandler<T> rsh)
query
public <T> T query(java.lang.String sql,
org.apache.commons.dbutils.ResultSetHandler<T> rsh)
query
public <T> T query(java.lang.String sql,
org.apache.commons.dbutils.ResultSetHandler<T> rsh,
java.lang.Object[] params)
queryForObject
public <T> T queryForObject(java.lang.String sql,
java.lang.Class<T> requiredType)
queryForObject
public <T> T queryForObject(SqlBuilder sb,
java.lang.Class<T> requiredType)
queryForObject
public <T> T queryForObject(java.lang.String sql,
java.lang.Class<T> requiredType,
java.lang.Object[] params)
queryForInt
public java.lang.Integer queryForInt(java.lang.String sql)
queryForLong
public java.lang.Long queryForLong(java.lang.String sql)
queryForDouble
public java.lang.Double queryForDouble(java.lang.String sql)
queryForString
public java.lang.String queryForString(java.lang.String sql)
queryForInt
public java.lang.Integer queryForInt(SqlBuilder sb)
queryForLong
public java.lang.Long queryForLong(SqlBuilder sb)
queryForDouble
public java.lang.Double queryForDouble(SqlBuilder sb)
queryForDate
public Date queryForDate(SqlBuilder sb)
queryForTime
public java.util.Calendar queryForTime(SqlBuilder sb)
queryForMap
public java.util.Map<java.lang.String,java.lang.Object> queryForMap(java.lang.String sql)
queryForMap
public java.util.Map<java.lang.String,java.lang.Object> queryForMap(SqlBuilder sb)
queryForMapList
public java.util.List<java.util.Map<java.lang.String,java.lang.Object>> queryForMapList(SqlBuilder sb)
queryForMapList
public java.util.List<java.util.Map<java.lang.String,java.lang.Object>> queryForMapList(java.lang.String sql)
queryForArrayList
public java.util.List<java.lang.Object[]> queryForArrayList(SqlBuilder sb)
queryForArrayList
public java.util.List<java.lang.Object[]> queryForArrayList(java.lang.String sql)
queryForBeanList
public <T> java.util.List<T> queryForBeanList(SqlBuilder sb,
java.lang.Class<T> requiredType)
update
public void update(java.lang.String sql)
update
public void update(java.lang.String sql,
java.lang.Object[] params)
update
public void update(SqlBuilder sb)
beginTransaction
public void beginTransaction()
commit
public void commit()
rollback
public void rollback()
isClosed
public boolean isClosed()
getLock
protected java.util.concurrent.locks.Lock getLock()
getLockDir
protected java.io.File getLockDir()
open
public void open(DbStore.Mode mode)
open
public void open(DbStore.Mode mode,
java.lang.String method)
close
public void close()
getConnection
protected java.sql.Connection getConnection(java.lang.String url)
getUrl
protected java.lang.String getUrl()
getDbPath
public java.lang.String getDbPath()
getDbFile
public java.io.File getDbFile()
exists
public boolean exists()
isReadOnly
public boolean isReadOnly()
getDbDir
public java.io.File getDbDir()
getConnection
public java.sql.Connection getConnection()
getMode
public DbStore.Mode getMode()
toString
public java.lang.String toString()
- Overrides:
toString
in class java.lang.Object
Copyright © 2005-2010 PMEase Inc. All Rights Reserved.