com.itstyle.seckill.common.dynamicquery

Interface DynamicQuery

All Known Implementing Classes:

DynamicQueryImpl

public interface DynamicQuery

扩展SpringDataJpa, 支持动态jpql/nativesql查询并支持分页查询 使用方法：注入ServiceImpl 创建者 张志朋 创建时间 2018年3月8日

Method Summary

Modifier and Type	Method and Description
<T> void	delete(Class<T> entityClass, Object entityid)
<T> void	delete(Class<T> entityClass, Object[] entityids)
int	nativeExecuteUpdate(String nativeSql, Object... params) 执行nativeSql的update,delete操作
Object[]	nativeQueryArray(String nativeSql, Object... params) 执行nativeSql统计查询
<T> List<T>	nativeQueryList(String nativeSql, Object... params) 查询对象列表，返回List
<T> List<T>	nativeQueryListMap(String nativeSql, Object... params) 查询对象列表，返回List>
<T> List<T>	nativeQueryListModel(Class<T> resultClass, String nativeSql, Object... params) 查询对象列表，返回List<组合对象>
Object	nativeQueryObject(String nativeSql, Object... params) 执行nativeSql统计查询
void	save(Object entity)
void	update(Object entity)

Method Detail

save

void save(Object entity)

update

void update(Object entity)

delete

<T> void delete(Class<T> entityClass,
                Object entityid)

delete

<T> void delete(Class<T> entityClass,
                Object[] entityids)

nativeQueryList

<T> List<T> nativeQueryList(String nativeSql,
                            Object... params)

查询对象列表，返回List

Parameters:

resultClass -

nativeSql -

params -

Returns:

List

nativeQueryListMap

<T> List<T> nativeQueryListMap(String nativeSql,
                               Object... params)

查询对象列表，返回List>

Parameters:

nativeSql -

params -

Returns:

List

nativeQueryListModel

<T> List<T> nativeQueryListModel(Class<T> resultClass,
                                 String nativeSql,
                                 Object... params)

查询对象列表，返回List<组合对象>

Parameters:

resultClass -

nativeSql -

params -

Returns:

List

nativeQueryObject

Object nativeQueryObject(String nativeSql,
                         Object... params)

执行nativeSql统计查询

Parameters:

nativeSql -

params - 占位符参数(例如?1)绑定的参数值

Returns:

统计条数

nativeQueryArray

Object[] nativeQueryArray(String nativeSql,
                          Object... params)

执行nativeSql统计查询

Parameters:

nativeSql -

params - 占位符参数(例如?1)绑定的参数值

Returns:

统计条数

nativeExecuteUpdate

int nativeExecuteUpdate(String nativeSql,
                        Object... params)

执行nativeSql的update,delete操作

Parameters:

nativeSql -

params -

Returns: