com.ds.common.database.dao

类 SqlUtil

java.lang.Object

com.ds.common.database.dao.SqlUtil

public class SqlUtil
extends Object

嵌套类概要

嵌套类

限定符和类型	类和说明
static class	SqlUtil.BlobImpl
static class	SqlUtil.ClobImpl

字段概要

字段

限定符和类型	字段和说明
protected static Map<Integer,String>	beanTypes
static String	EQUALS
static String	GREAT_EQUALS_THAN
static String	GREAT_THAN
static String	ISNOTNULL
static String	ISNULL
static String	LESS_EQUALS_THAN
static String	LESS_THAN
static String	LIKE
protected static com.ds.common.logging.Log	logger
static String	NOTEQALS
protected static Map	preparedStatementSetMethods
protected static Map	resultSetGetMethods
protected static Map<String,Integer>	sqlTypes
protected static String	STATUS_ACCORDWITHDB
protected static String	STATUS_DELETED
protected static String	STATUS_DIRTY
protected static String	STATUS_NEW

构造器概要

构造器

构造器和说明
SqlUtil()

方法概要

限定符和类型	方法和说明
static com.ds.common.util.CaselessStringKeyHashMap<String,Object>	fetchResultSet(TableInfo tableInfo, ResultSet result)
static String	getBatchUpdateSQLNoParas(TableInfo tableInfo, String custWhereClause)
static String	getDeleteSQLByKey(TableInfo tableInfo) Method declaration
static String	getDeleteSQLByWhereClause(TableInfo tableInfo, String custWhereClause) Method declaration
static String	getFieldArrStr(TableInfo tableInfo)
static String	getFindByPrimaryKeySQLNoParas(TableInfo tableInfo)
static String	getFullSearchSql(TableInfo tableInfo, String custWhereClause)
static String	getFullWhereClauseNoPara(TableInfo tableInfo, String custWhereClause)
static String	getInsertSQLNoParas(TableInfo tableInfo)
static String	getSerachSqlNoPara(TableInfo tableInfo, Set<String> keyList, String typeName, String custWhereClause, Map<String,Object> searchMap)
static String	getUpdateSQLNoParas(TableInfo tableInfo, Map<String,Object> updateMap, String custWhereClause)
static String	getUpdateSQLNoParasBykey(TableInfo tableInfo)
static String	getWhereSqlbyIds(String[] uuids, String pkName)
static int	prepareAllFields(TableInfo tableInfo, PreparedStatement ps, String uuid, Map updateMap)
static int	prepareFields(TableInfo tableInfo, PreparedStatement ps, Map<String,Object> updateMap)
static void	preparePrimaryKeys(TableInfo tableInfo, PreparedStatement ps, int paraBeginPosition, Object value)

从类继承的方法 java.lang.Object

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

字段详细资料

resultSetGetMethods

protected static Map resultSetGetMethods

preparedStatementSetMethods

protected static Map preparedStatementSetMethods

sqlTypes

protected static Map<String,Integer> sqlTypes

beanTypes

protected static Map<Integer,String> beanTypes

GREAT_THAN

public static final String GREAT_THAN

另请参阅:

常量字段值

GREAT_EQUALS_THAN

public static final String GREAT_EQUALS_THAN

另请参阅:

常量字段值

LESS_THAN

public static final String LESS_THAN

另请参阅:

常量字段值

LESS_EQUALS_THAN

public static final String LESS_EQUALS_THAN

另请参阅:

常量字段值

EQUALS

public static final String EQUALS

另请参阅:

常量字段值

LIKE

public static final String LIKE

另请参阅:

常量字段值

NOTEQALS

public static final String NOTEQALS

另请参阅:

常量字段值

ISNULL

public static final String ISNULL

另请参阅:

常量字段值

ISNOTNULL

public static final String ISNOTNULL

另请参阅:

常量字段值

STATUS_NEW

protected static final String STATUS_NEW

另请参阅:

常量字段值

STATUS_DELETED

protected static final String STATUS_DELETED

另请参阅:

常量字段值

STATUS_DIRTY

protected static final String STATUS_DIRTY

另请参阅:

常量字段值

STATUS_ACCORDWITHDB

protected static final String STATUS_ACCORDWITHDB

另请参阅:

常量字段值

logger

protected static final transient com.ds.common.logging.Log logger

构造器详细资料

SqlUtil

public SqlUtil()

方法详细资料

getWhereSqlbyIds

public static String getWhereSqlbyIds(String[] uuids,
                                      String pkName)

getFieldArrStr

public static String getFieldArrStr(TableInfo tableInfo)

getInsertSQLNoParas

public static String getInsertSQLNoParas(TableInfo tableInfo)

getDeleteSQLByWhereClause

public static String getDeleteSQLByWhereClause(TableInfo tableInfo,
                                               String custWhereClause)
                                        throws DAOException

Method declaration

返回:

抛出:

DAOException

getDeleteSQLByKey

public static String getDeleteSQLByKey(TableInfo tableInfo)
                                throws DAOException

Method declaration

返回:

抛出:

DAOException

getUpdateSQLNoParasBykey

public static String getUpdateSQLNoParasBykey(TableInfo tableInfo)

getUpdateSQLNoParas

public static String getUpdateSQLNoParas(TableInfo tableInfo,
                                         Map<String,Object> updateMap,
                                         String custWhereClause)

getBatchUpdateSQLNoParas

public static String getBatchUpdateSQLNoParas(TableInfo tableInfo,
                                              String custWhereClause)

getFullSearchSql

public static String getFullSearchSql(TableInfo tableInfo,
                                      String custWhereClause)

preparePrimaryKeys

public static void preparePrimaryKeys(TableInfo tableInfo,
                                      PreparedStatement ps,
                                      int paraBeginPosition,
                                      Object value)
                               throws DAOException

抛出:

DAOException

getFullWhereClauseNoPara

public static String getFullWhereClauseNoPara(TableInfo tableInfo,
                                              String custWhereClause)

prepareFields

public static int prepareFields(TableInfo tableInfo,
                                PreparedStatement ps,
                                Map<String,Object> updateMap)
                         throws DAOException

抛出:

DAOException

prepareAllFields

public static int prepareAllFields(TableInfo tableInfo,
                                   PreparedStatement ps,
                                   String uuid,
                                   Map updateMap)
                            throws DAOException

抛出:

DAOException

getFindByPrimaryKeySQLNoParas

public static String getFindByPrimaryKeySQLNoParas(TableInfo tableInfo)

getSerachSqlNoPara

public static String getSerachSqlNoPara(TableInfo tableInfo,
                                        Set<String> keyList,
                                        String typeName,
                                        String custWhereClause,
                                        Map<String,Object> searchMap)

fetchResultSet

public static com.ds.common.util.CaselessStringKeyHashMap<String,Object> fetchResultSet(TableInfo tableInfo,
                                                                                        ResultSet result)