public interface CTPBaseDao<T>
限定符和类型 | 方法和说明 |
---|---|
int |
bulkUpdate(String hql,
Map<String,Object> nameParameters,
List<Object> indexParameter)
执行SQL(delete/update),支持命名参数和index参数
|
int |
bulkUpdate(String hql,
Map<String,Object> nameParameters,
Object... indexParameter)
执行SQL(delete/update),支持命名参数和index参数
|
int |
count(String hqlStr,
Map<String,Object> namedParameterMap,
List<Object> indexParameter)
给一个普通的查询语句,取出对于的查询总数,如:
select * from table where a=1 and b=2 order c 结果执行的是:select count(*) from table where a=1 and b=2 |
int |
count(String hqlStr,
Map<String,Object> namedParameterMap,
Object... indexParameter) |
int |
count(String hqlStr,
String countPropertiesName,
boolean isDistinct,
Map<String,Object> namedParameterMap,
Object... indexParameter)
给一个普通的查询语句,取出对于的查询总数,如:
select * from table where a=1 and b=2 order c 结果执行的是:select count(*) from table where a=1 and b=2 |
void |
delete(long id)
根据主键删除对象.
|
void |
delete(Object entity)
删除对象.
|
List |
executeCriteria(org.hibernate.criterion.DetachedCriteria detachedCriteria)
执行DetachedCriteria,实现自动分页, 并把rowCount注入到Pagination
|
List |
executeCriteria(org.hibernate.criterion.DetachedCriteria detachedCriteria,
int firstResult,
int maxResults)
执行DetachedCriteria,不自动分页
|
Object |
executeUniqueCriteria(org.hibernate.criterion.DetachedCriteria detachedCriteria)
执行DetachedCriteria,只取一条记录
|
List |
find(String hqlStr,
int firstResult,
int maxResults,
Map<String,Object> namedParameterMap,
List<Object> indexParameter)
查询, 不分页。
|
List |
find(String hqlStr,
int firstResult,
int maxResults,
Map<String,Object> namedParameterMap,
Object... indexParameter)
查询, 不分页,如果需要分页,请用
find(String, Map, Object[]) |
List |
find(String hqlStr,
Map<String,Object> namedParameterMap,
List<Object> indexParameter)
执行查询,
自动完成分页 ,并把总数设置到Pagination 查找总数的策略是:count(*)如果不分页,请用 find(String, int, int, Map, List) 或find(String, int, int, Map, Object[]) |
List |
find(String hqlStr,
Map<String,Object> namedParameterMap,
Object... indexParameter)
已过时。
|
List |
find(String hqlStr,
String countPropertiesName,
boolean isDistinct,
Map<String,Object> namedParameterMap,
List<Object> indexParameter)
执行查询,自动完成分页,并把总数设置到
Pagination |
List |
find(String hqlStr,
String countPropertiesName,
boolean isDistinct,
Map<String,Object> namedParameterMap,
Object... indexParameter)
查询
|
List<T> |
findBy(String name,
Object value)
根据属性名和属性值查询对象.
|
List<T> |
findByLike(String name,
String value)
根据属性名和属性值以Like AnyWhere方式查询对象.
|
List |
findNativeSQL(String nativeSQL,
Class entityClass,
Map<String,Object> namedParameterMap,
Object... indexParameter)
NativeSQL查询
|
List<T> |
findSimpleObjects(List<org.hibernate.criterion.Criterion> criterions,
List<org.hibernate.criterion.Order> orders,
int firstResult,
int maxResult,
String... propertyNames)
按照条件,查询某些字段的数据,不分页
|
List<T> |
findSimpleObjects(List<org.hibernate.criterion.Criterion> criterions,
List<org.hibernate.criterion.Order> orders,
String... propertyNames)
按照条件,查询某些字段的数据,自动分页
|
Object |
findUnique(String hqlStr,
Map<String,Object> namedParameterMap,
List<Object> indexParameter)
查询唯一对象
|
Object |
findUnique(String hqlStr,
Map<String,Object> namedParameterMap,
Object... indexParameter)
查询唯一对象
|
T |
findUniqueBy(String name,
Object value)
根据属性名和属性值查询对象.
|
List |
findVarargs(String hsql,
Object... values)
Execute a query for persistent instances, binding a number of values to
"?"
|
List |
findWithCount(String hqlStr,
String countSql,
Map<String,Object> namedParameterMap,
List<Object> indexParameter)
执行查询,自动分页,总数有第二个查询产生
|
List |
findWithCount(String hqlStr,
String countSql,
Map<String,Object> namedParameterMap,
Object... indexParameter)
执行查询,自动分页,总数有第二个查询产生
|
T |
get(Long id)
按照主键获取对象
|
List<T> |
getAll()
查找表中的所有数据
|
int |
getCountByCriteria(org.hibernate.criterion.DetachedCriteria detachedCriteria)
执行count
|
org.springframework.orm.hibernate3.HibernateTemplate |
getHibernateTemplate()
Return the HibernateTemplate for this DAO,
pre-initialized with the SessionFactory or set explicitly.
|
org.hibernate.SessionFactory |
getSessionFactory()
Return the Hibernate SessionFactory used by this DAO.
|
T |
getSimpleObject(long id,
String... propertyNames)
根据id,取得记录的指定字段
|
void |
save(Object o)
保存对象到数据库中
|
void |
savePatchAll(Collection<? extends Object> os)
批量保存,每batch_size条保存并提交一次,然后清空一级缓存
|
void |
setHibernateTemplate(org.springframework.orm.hibernate3.HibernateTemplate hibernateTemplate)
Set the HibernateTemplate for this DAO explicitly,
as an alternative to specifying a SessionFactory.
|
void |
setSessionFactory(org.hibernate.SessionFactory sessionFactory)
Set the Hibernate SessionFactory to be used by this DAO.
|
void |
update(Object o)
更新所有字段
|
void |
updatePatchAll(Collection<? extends Object> os)
批量保存,每batch_size条保存并提交一次,然后清空一级缓存
|
void setSessionFactory(org.hibernate.SessionFactory sessionFactory)
#createHibernateTemplate
,
setHibernateTemplate(org.springframework.orm.hibernate3.HibernateTemplate)
org.hibernate.SessionFactory getSessionFactory()
void setHibernateTemplate(org.springframework.orm.hibernate3.HibernateTemplate hibernateTemplate)
org.springframework.orm.hibernate3.HibernateTemplate getHibernateTemplate()
void save(Object o)
o
- void savePatchAll(Collection<? extends Object> os)
os
- void updatePatchAll(Collection<? extends Object> os)
os
- void update(Object o)
o
- List findVarargs(String hsql, Object... values)
hsql
- select id,name from Member where createDate>=? and createDate<=?
values
- List<T> findByLike(String name, String value)
void delete(long id)
id
- 主键.void delete(Object entity)
entity
- 实体对象.List executeCriteria(org.hibernate.criterion.DetachedCriteria detachedCriteria)
detachedCriteria
- List executeCriteria(org.hibernate.criterion.DetachedCriteria detachedCriteria, int firstResult, int maxResults)
detachedCriteria
- firstResult
- 数据行开始位置,从0开始,-1表示不限制maxResults
- 取数据量,-1表示不限制Object executeUniqueCriteria(org.hibernate.criterion.DetachedCriteria detachedCriteria)
detachedCriteria
- int getCountByCriteria(org.hibernate.criterion.DetachedCriteria detachedCriteria)
detachedCriteria
- T getSimpleObject(long id, String... propertyNames)
id
- 主键对应的值propertyNames
- 需要读取的字段,不允许为nullList<T> findSimpleObjects(List<org.hibernate.criterion.Criterion> criterions, List<org.hibernate.criterion.Order> orders, String... propertyNames)
criterions
- 查询条件,可以为null
orders
- 排序,可以为null
propertyNames
- 需要查询的字段List<T> findSimpleObjects(List<org.hibernate.criterion.Criterion> criterions, List<org.hibernate.criterion.Order> orders, int firstResult, int maxResult, String... propertyNames)
criterions
- 查询条件,可以为null
orders
- 排序,可以为null
firstResult
- -1表示不限制maxResult
- -1表示不限制propertyNames
- 需要查询的字段int count(String hqlStr, Map<String,Object> namedParameterMap, List<Object> indexParameter)
hqlStr
- namedParameterMap
- indexParameter
- int count(String hqlStr, String countPropertiesName, boolean isDistinct, Map<String,Object> namedParameterMap, Object... indexParameter)
hqlStr
- countPropertiesName
- isDistinct
- namedParameterMap
- indexParameter
- List find(String hqlStr, int firstResult, int maxResults, Map<String,Object> namedParameterMap, List<Object> indexParameter)
find(String, Map, List)
hqlStr
- firstResult
- -1表示不限制maxResults
- -1表示不限制namedParameterMap
- 可以为null
,自动识别参数Collection
和Object[]
indexParameter
- find(String, int, int, Map, Object...)
List find(String hqlStr, int firstResult, int maxResults, Map<String,Object> namedParameterMap, Object... indexParameter)
find(String, Map, Object[])
hqlStr
- firstResult
- -1表示不限制maxResults
- -1表示不限制namedParameterMap
- 命名参数:可以为null
,自动识别参数Collection
和Object[]
indexParameter
- 位置参数find(String, int, int, Map, List)
,
find(String, Map, List)
,
find(String, Map, Object...)\
List find(String hqlStr, String countPropertiesName, boolean isDistinct, Map<String,Object> namedParameterMap, List<Object> indexParameter)
Pagination
hqlStr
- countPropertiesName
- 统计总数的字段isDistinct
- 是否需要distinctnamedParameterMap
- 命名参数:可以为null
,自动识别参数Collection
和Object[]
indexParameter
- 位置参数List find(String hqlStr, String countPropertiesName, boolean isDistinct, Map<String,Object> namedParameterMap, Object... indexParameter)
hqlStr
- HQL语句countPropertiesName
- 分页,统计字段isDistinct
- 针对统计字段是否需要采用Distinct
namedParameterMap
- 命名参数:可以为null
,自动识别参数Collection
和Object[]
indexParameter
- 位置参数List findNativeSQL(String nativeSQL, Class entityClass, Map<String,Object> namedParameterMap, Object... indexParameter)
nativeSQL
- HQL语句entityClass
- 查询实体类namedParameterMap
- 命名参数:可以为null
,自动识别参数Collection
和Object[]
indexParameter
- 位置参数List find(String hqlStr, Map<String,Object> namedParameterMap, List<Object> indexParameter)
自动完成分页
,并把总数设置到Pagination
查找总数的策略是:count(*)find(String, int, int, Map, List)
或find(String, int, int, Map, Object[])
hqlStr
- namedParameterMap
- 命名参数:可以为null
,自动识别参数Collection
和Object[]
indexParameter
- 位置参数find(String, Map, Object[])
,
find(String, int, int, Map, List)
,
find(String, int, int, Map, Object...)
List find(String hqlStr, Map<String,Object> namedParameterMap, Object... indexParameter)
hqlStr
- namedParameterMap
- 命名参数:可以为null
,自动识别参数Collection
和Object[]
indexParameter
- 位置参数find(String, Map, List)
Object findUnique(String hqlStr, Map<String,Object> namedParameterMap, List<Object> indexParameter)
hqlStr
- namedParameterMap
- 自动识别参数Collection
和Object[]
indexParameter
- findUnique(String, Map, Object[])
Object findUnique(String hqlStr, Map<String,Object> namedParameterMap, Object... indexParameter)
hqlStr
- namedParameterMap
- 自动识别参数Collection
和Object[]
indexParameter
- findUnique(String, Map, List)
int bulkUpdate(String hql, Map<String,Object> nameParameters, List<Object> indexParameter)
hql
- nameParameters
- 命名(用:name) 的参数indexParameter
- 顺序(用?的)参数bulkUpdate(String, Map, Object[])
int bulkUpdate(String hql, Map<String,Object> nameParameters, Object... indexParameter)
hql
- HQL语句nameParameters
- 命名(用:name) 的参数indexParameter
- 顺序(用?的)参数bulkUpdate(String, Map, List)
List findWithCount(String hqlStr, String countSql, Map<String,Object> namedParameterMap, Object... indexParameter)
hqlStr
- 查询语句countSql
- 总数查询语句namedParameterMap
- indexParameter
- findWithCount(String, String, Map, List)
Copyright © 2016–2018. All rights reserved.