com.pmease.quickbuild.plugin.report.engine.datastore
Class DbStore

java.lang.Object
  extended by com.pmease.quickbuild.plugin.report.engine.datastore.DbStore
Direct Known Subclasses:
CategoryDb

public abstract class DbStore
extends java.lang.Object


Nested Class Summary
static class DbStore.Mode
           
 
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)
           
<T> T
query(SqlBuilder sb, org.apache.commons.dbutils.ResultSetHandler<T> rsh)
           
<T> T
query(java.lang.String sql, org.apache.commons.dbutils.ResultSetHandler<T> rsh)
           
<T> T
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)
           
<T> java.util.List<T>
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)
           
<T> T
queryForObject(SqlBuilder sb, java.lang.Class<T> requiredType)
           
<T> T
queryForObject(java.lang.String sql, java.lang.Class<T> requiredType)
           
<T> T
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
 

Field Detail

logger

protected static final org.slf4j.Logger logger

dbDir

protected java.io.File dbDir

connection

protected java.sql.Connection connection
Constructor Detail

DbStore

protected DbStore(java.io.File dbDir)
Method Detail

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.