com.fr.data.dao

类 DaoMapperUtils

java.lang.Object

com.fr.data.dao.DaoMapperUtils

public class DaoMapperUtils
extends java.lang.Object

构造器概要

构造器

构造器和说明
DaoMapperUtils()

方法概要

方法

限定符和类型	方法和说明
static Delete	createAllDelete(ObjectTableMapper mapper) 全删
static Select	createAllSelect(ObjectTableMapper mapper, SortInfo si) 全选
static Select	createCountAllSelect(ObjectTableMapper mapper) 统计个数选择
static Delete	createDeleteByColumn(java.lang.String columnName, java.lang.Object value, ObjectTableMapper mapper, DataAccessObjectSession session) 列删除
static Delete	createDeleteByField(java.lang.String fieldName, java.lang.Object value, ObjectTableMapper mapper, DataAccessObjectSession session) 根据主键删除数据
static Delete	createDeleteByInfo(ObjectTableMapper mapper, java.util.Map<java.lang.String,java.lang.Object> map, DataAccessObjectSession session) 条件选择删除数据
static Delete	createDeleteByPrimaryKey(long id, ObjectTableMapper mapper) 根据主键删除数据
static Insert	createInsert(ObjectTableMapper mapper, FieldValueGetter getter, boolean isOracle, DataAccessObjectSession session) 插入
static Select	createLoadSelect(FieldColumnMapper pcMapper, java.lang.Object pcValue, ObjectTableMapper mapper, DataAccessObjectSession session) 选择
static Select	createPageSelect(ObjectTableMapper objectTableMapper, SortInfo si, PageConfiguration pageConfiguration) 分页查询选择器
static Select	createSelectAllByMoreInfo(ObjectTableMapper mapper, java.util.Map<java.lang.String,java.lang.Object> map, DataAccessObjectSession session) 更多条件的全选
static Select	createSelectByColumn(java.lang.String columnName, java.lang.Object value, int compareType, ObjectTableMapper mapper, DataAccessObjectSession session, boolean exceptThis) 选择
static Select	createSelectByField(java.lang.String fieldName, java.lang.Object value, int compareType, ObjectTableMapper mapper, DataAccessObjectSession session, boolean exceptThis) 选择
static Select	createSelectByInfo(java.lang.String columnName, int columnType, java.lang.Object value, int compareType, ObjectTableMapper mapper, boolean exceptThis) 条件选择
static java.lang.String	createSelectSQLByListFiledValue(java.util.Map<java.lang.String,java.lang.Object> map, ObjectTableMapper mapper, Dialect dialect, DataAccessObjectSession session) 生成sql选择语句
static Update	createUpdate(java.lang.Object obj, ObjectTableMapper mapper, DataAccessObjectSession session) 更新
static Update	createUpdate(ObjectTableMapper mapper, java.util.Map<java.lang.String,java.lang.Object> fvMap, FieldColumnMapper pcMapper, java.lang.Object key, DataAccessObjectSession session) 更新
static Update	createUpdateByInfo(java.lang.Object obj, ObjectTableMapper mapper, DataAccessObjectSession session, java.util.Map<java.lang.String,java.lang.Object> map) 更新
static <T> T	extractResultSet(java.sql.ResultSet resultSet, java.lang.Class<T> clazz, ObjectTableMapper mapper, DataAccessObjectSession session) 执行ResultSet

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

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

构造器详细资料

DaoMapperUtils

public DaoMapperUtils()

方法详细资料

createAllSelect

public static Select createAllSelect(ObjectTableMapper mapper,
                     SortInfo si)

全选

参数:

mapper - 数据表

si - 排序

返回:

返回选择器

createSelectAllByMoreInfo

public static Select createSelectAllByMoreInfo(ObjectTableMapper mapper,
                               java.util.Map<java.lang.String,java.lang.Object> map,
                               DataAccessObjectSession session)
                                        throws java.lang.Exception

更多条件的全选

参数:

mapper - 数据表

map - 条件

session - dao会话环境

返回:

返回选择器

抛出:

java.lang.Exception - 抛出异常

createAllDelete

public static Delete createAllDelete(ObjectTableMapper mapper)

全删

参数:

mapper - 数据表

返回:

返回选择器

createDeleteByPrimaryKey

public static Delete createDeleteByPrimaryKey(long id,
                              ObjectTableMapper mapper)

根据主键删除数据

参数:

id - 主键id

mapper - 数据表

返回:

返回选择器

createDeleteByField

public static Delete createDeleteByField(java.lang.String fieldName,
                         java.lang.Object value,
                         ObjectTableMapper mapper,
                         DataAccessObjectSession session)
                                  throws java.lang.Exception

根据主键删除数据

参数:

fieldName - 列名

value - 值

mapper - 数据表

session - dao会话环境

返回:

返回选择器

抛出:

java.lang.Exception - 抛出异常

createDeleteByColumn

public static Delete createDeleteByColumn(java.lang.String columnName,
                          java.lang.Object value,
                          ObjectTableMapper mapper,
                          DataAccessObjectSession session)
                                   throws java.lang.Exception

列删除

参数:

columnName - 列名

value - 值

mapper - 数据表

session - dao会话环境

返回:

返回选择器

抛出:

java.lang.Exception - 抛出异常

createDeleteByInfo

public static Delete createDeleteByInfo(ObjectTableMapper mapper,
                        java.util.Map<java.lang.String,java.lang.Object> map,
                        DataAccessObjectSession session)
                                 throws java.lang.Exception

条件选择删除数据

参数:

mapper - 数据表

map - 条件

session - dao会话环境

返回:

返回选择器

抛出:

java.lang.Exception - 抛出异常

createLoadSelect

public static Select createLoadSelect(FieldColumnMapper pcMapper,
                      java.lang.Object pcValue,
                      ObjectTableMapper mapper,
                      DataAccessObjectSession session)
                               throws java.lang.Exception

选择

参数:

pcMapper - 列集合

pcValue - 值

mapper - 数据表

session - dao会话环境

返回:

返回选择器

抛出:

java.lang.Exception - 跑出异常

createSelectByField

public static Select createSelectByField(java.lang.String fieldName,
                         java.lang.Object value,
                         int compareType,
                         ObjectTableMapper mapper,
                         DataAccessObjectSession session,
                         boolean exceptThis)
                                  throws java.lang.Exception

选择

参数:

fieldName - 行

value - 值

compareType - 比较类型

mapper - 数据表

session - dao会话

exceptThis - 排除条件

返回:

选择器

抛出:

java.lang.Exception - 抛出异常

createSelectByColumn

public static Select createSelectByColumn(java.lang.String columnName,
                          java.lang.Object value,
                          int compareType,
                          ObjectTableMapper mapper,
                          DataAccessObjectSession session,
                          boolean exceptThis)
                                   throws java.lang.Exception

选择

参数:

columnName - 列名

value - 值

compareType - 比较类型

mapper - 数据表

session - dao会话

exceptThis - 排除条件

返回:

选择器

抛出:

java.lang.Exception - 抛出异常

createSelectByInfo

public static Select createSelectByInfo(java.lang.String columnName,
                        int columnType,
                        java.lang.Object value,
                        int compareType,
                        ObjectTableMapper mapper,
                        boolean exceptThis)

条件选择

参数:

columnName - 列名

columnType - 列类型

value - 值

compareType - 比较类型

mapper - 数据表

exceptThis - 排除条件

返回:

选择器

createSelectSQLByListFiledValue

public static java.lang.String createSelectSQLByListFiledValue(java.util.Map<java.lang.String,java.lang.Object> map,
                                               ObjectTableMapper mapper,
                                               Dialect dialect,
                                               DataAccessObjectSession session)
                                                        throws java.lang.Exception

生成sql选择语句

参数:

map - 条件

mapper - 数据表

dialect - 方言

session - dao会话

返回:

返回sql语句

抛出:

java.lang.Exception - 抛出异常

createInsert

public static Insert createInsert(ObjectTableMapper mapper,
                  FieldValueGetter getter,
                  boolean isOracle,
                  DataAccessObjectSession session)
                           throws java.lang.Exception

插入

参数:

mapper - 数据表

getter - 行列选择器

isOracle - 是否是oracle数据库

session - dao会话

返回:

返回选择器

抛出:

java.lang.Exception

createUpdate

public static Update createUpdate(java.lang.Object obj,
                  ObjectTableMapper mapper,
                  DataAccessObjectSession session)
                           throws java.lang.Exception

更新

参数:

obj - 更新对象

mapper - 数据表

session - dao会话

返回:

选择器

抛出:

java.lang.Exception - 抛出异常

createUpdateByInfo

public static Update createUpdateByInfo(java.lang.Object obj,
                        ObjectTableMapper mapper,
                        DataAccessObjectSession session,
                        java.util.Map<java.lang.String,java.lang.Object> map)
                                 throws java.lang.Exception

更新

参数:

obj - 更新对象

mapper - 数据表

session - dao会话

返回:

选择器

抛出:

java.lang.Exception - 抛出异常

createUpdate

public static Update createUpdate(ObjectTableMapper mapper,
                  java.util.Map<java.lang.String,java.lang.Object> fvMap,
                  FieldColumnMapper pcMapper,
                  java.lang.Object key,
                  DataAccessObjectSession session)
                           throws java.lang.Exception

更新

参数:

mapper - 数据表

fvMap - 条件

pcMapper - 行列选择器

key - 值

session - dao会话

返回:

返回选择器

抛出:

java.lang.Exception - 抛出异常

extractResultSet

public static <T> T extractResultSet(java.sql.ResultSet resultSet,
                     java.lang.Class<T> clazz,
                     ObjectTableMapper mapper,
                     DataAccessObjectSession session)
                          throws java.lang.Exception

执行ResultSet

参数:

resultSet - 结果集

clazz - 反射类

mapper - 数据表

session - dao会话

返回:

返回类结果对象

抛出:

java.lang.Exception - 抛出异常

createPageSelect

public static Select createPageSelect(ObjectTableMapper objectTableMapper,
                      SortInfo si,
                      PageConfiguration pageConfiguration)

分页查询选择器

参数:

objectTableMapper - 数据表

pageConfiguration - 分页配置

返回:

分页选择器

createCountAllSelect

public static Select createCountAllSelect(ObjectTableMapper mapper)

统计个数选择