public interface DBQueryDSL
| Modifier and Type | Method and Description |
|---|---|
com.querydsl.sql.Configuration |
queryDSLConfiguration(Class<? extends DBObject>... tableClass)
QueryDSL支持，返回一个QueryDSL的查询对象，可以使用QueryDSL进行数据库操作(存在连接泄漏风险)
|
int |
queryDSLDelete(com.querydsl.sql.dml.SQLDeleteClause delete) |
<T extends DBObject> |
queryDSLExists(List<com.querydsl.core.types.Predicate> predicates,
Class<T> clz)
是否存在
|
int |
queryDSLInsert(com.querydsl.sql.dml.SQLInsertClause insert) |
int |
queryDSLInsert(com.querydsl.sql.dml.SQLInsertClause insert,
List<Map<String,Object>> keyValues) |
int |
queryDSLMerge(com.querydsl.sql.dml.SQLMergeClause merge)
merge into 只有oracle支持
|
int |
queryDSLMerge(com.querydsl.sql.dml.SQLMergeClause merge,
List<Map<String,Object>> keyValues)
merge into 只有oracle支持
|
javax.inject.Provider<Connection> |
queryDSLProvider(boolean readonly) |
<T> void |
queryDSLSelectIterator(OrmIterator<T> ormIt,
Class<T> beanClass,
com.querydsl.sql.AbstractSQLQuery<?,?> query) |
<T> List<T> |
queryDSLSelectList(com.querydsl.sql.AbstractSQLQuery<?,?> query,
Class<T> returnClass) |
<T> T |
queryDSLSelectOne(com.querydsl.sql.AbstractSQLQuery<?,?> query,
Class<T> returnClass) |
<T> Page<T> |
queryDSLSelectPage(com.querydsl.sql.AbstractSQLQuery<?,?> query,
Class<T> returnClass,
long start,
int limit)
sqlserver2000分页有bug
|
<T> void |
queryDSLSelectStream(OrmStream<T> ormStream,
Class<T> beanClass,
com.querydsl.sql.AbstractSQLQuery<?,?> query) |
com.querydsl.sql.SQLTemplates |
queryDSLSQLTemplates(boolean readonly) |
int |
queryDSLUpdate(com.querydsl.sql.dml.SQLUpdateClause update) |
com.querydsl.sql.SQLTemplates queryDSLSQLTemplates(boolean readonly)
readonly - com.querydsl.sql.Configuration queryDSLConfiguration(Class<? extends DBObject>... tableClass)
tableClass - 注册自定义类型,主要是对Map映射为json的支持.SQLQueryjavax.inject.Provider<Connection> queryDSLProvider(boolean readonly)
readonly - <T extends DBObject> boolean queryDSLExists(List<com.querydsl.core.types.Predicate> predicates, Class<T> clz)
T - predicates - clz - <T> List<T> queryDSLSelectList(com.querydsl.sql.AbstractSQLQuery<?,?> query, Class<T> returnClass)
T - query - returnClass - <T> Page<T> queryDSLSelectPage(com.querydsl.sql.AbstractSQLQuery<?,?> query, Class<T> returnClass, long start, int limit)
T - query - start - 必须为数字(<0,将忽略该参数)limit - 必须为>=0的数字<T> T queryDSLSelectOne(com.querydsl.sql.AbstractSQLQuery<?,?> query,
Class<T> returnClass)
T - query - <T> void queryDSLSelectIterator(OrmIterator<T> ormIt, Class<T> beanClass, com.querydsl.sql.AbstractSQLQuery<?,?> query)
T - ormIt - beanClass - query - <T> void queryDSLSelectStream(OrmStream<T> ormStream, Class<T> beanClass, com.querydsl.sql.AbstractSQLQuery<?,?> query)
T - ormStream - beanClass - query - int queryDSLInsert(com.querydsl.sql.dml.SQLInsertClause insert)
insert - int queryDSLInsert(com.querydsl.sql.dml.SQLInsertClause insert,
List<Map<String,Object>> keyValues)
insert - keyValues - int queryDSLUpdate(com.querydsl.sql.dml.SQLUpdateClause update)
update - int queryDSLDelete(com.querydsl.sql.dml.SQLDeleteClause delete)
delete - int queryDSLMerge(com.querydsl.sql.dml.SQLMergeClause merge)
merge - Copyright © 2020. All rights reserved.