| 程序包 | 说明 |
|---|---|
| ai.yue.library.data.jdbc.client.dialect |
SQL方言
|
| ai.yue.library.data.jdbc.client.dialect.impl |
SQL方言实现
|
| ai.yue.library.data.jdbc.dao |
DAO默认实现
|
| 限定符和类型 | 方法和说明 |
|---|---|
<T> PageVO<T> |
Dialect.page(String tableName,
PageIPO pageIPO,
SortEnum sortEnum,
Class<T> mappedClass)
单表分页查询
阿里最优SQL示例: SELECT a.* FROM 表1 a, (select id from 表1 where 条件 ORDER BY id LIMIT 100000,20 ) b where a.id=b.id |
<T> PageVO<T> |
Dialect.page(String tableName,
PageIPO pageIPO,
SortEnum sortEnum,
Class<T> mappedClass)
单表分页查询
阿里最优SQL示例: SELECT a.* FROM 表1 a, (select id from 表1 where 条件 ORDER BY id LIMIT 100000,20 ) b where a.id=b.id |
<T> PageVO<T> |
Dialect.pageSql(String querySql,
PageIPO pageIPO,
Class<T> mappedClass)
复杂SQL分页查询
阿里最优查询SQL示例: SELECT a.* FROM 表1 a, (select id from 表1 where 条件 LIMIT :page, :limit) b where a.id=b.id |
<T> PageVO<T> |
Dialect.pageSql(String querySql,
PageIPO pageIPO,
Class<T> mappedClass)
复杂SQL分页查询
阿里最优查询SQL示例: SELECT a.* FROM 表1 a, (select id from 表1 where 条件 LIMIT :page, :limit) b where a.id=b.id |
<T> PageVO<T> |
Dialect.pageSql(String countSql,
String querySql,
PageIPO pageIPO,
Class<T> mappedClass)
复杂SQL分页查询
统计SQL示例: SELECT count(*) count FROM 表1 a, (select id from 表1 where 条件) b where a.id=b.id阿里最优查询SQL示例: SELECT a.* FROM 表1 a, (select id from 表1 where 条件 LIMIT :page, :limit) b where a.id=b.id |
<T> PageVO<T> |
Dialect.pageSql(String countSql,
String querySql,
PageIPO pageIPO,
Class<T> mappedClass)
复杂SQL分页查询
统计SQL示例: SELECT count(*) count FROM 表1 a, (select id from 表1 where 条件) b where a.id=b.id阿里最优查询SQL示例: SELECT a.* FROM 表1 a, (select id from 表1 where 条件 LIMIT :page, :limit) b where a.id=b.id |
<T> PageVO<T> |
Dialect.pageWhere(String tableName,
String whereSql,
PageIPO pageIPO,
Class<T> mappedClass)
单表分页查询
阿里最优SQL示例: SELECT a.* FROM 表1 a, (select id from 表1 where 条件 LIMIT 100000,20 ) b where a.id=b.id |
<T> PageVO<T> |
Dialect.pageWhere(String tableName,
String whereSql,
PageIPO pageIPO,
Class<T> mappedClass)
单表分页查询
阿里最优SQL示例: SELECT a.* FROM 表1 a, (select id from 表1 where 条件 LIMIT 100000,20 ) b where a.id=b.id |
| 限定符和类型 | 方法和说明 |
|---|---|
<T> PageVO<T> |
AnsiDialect.page(String tableName,
PageIPO pageIPO,
SortEnum sortEnum,
Class<T> mappedClass) |
<T> PageVO<T> |
AnsiDialect.page(String tableName,
PageIPO pageIPO,
SortEnum sortEnum,
Class<T> mappedClass) |
<T> PageVO<T> |
AnsiDialect.pageSql(String querySql,
PageIPO pageIPO,
Class<T> mappedClass) |
<T> PageVO<T> |
AnsiDialect.pageSql(String querySql,
PageIPO pageIPO,
Class<T> mappedClass) |
<T> PageVO<T> |
AnsiDialect.pageSql(String countSql,
String querySql,
PageIPO pageIPO,
Class<T> mappedClass) |
<T> PageVO<T> |
AnsiDialect.pageSql(String countSql,
String querySql,
PageIPO pageIPO,
Class<T> mappedClass) |
<T> PageVO<T> |
AnsiDialect.pageWhere(String tableName,
String whereSql,
PageIPO pageIPO,
Class<T> mappedClass) |
<T> PageVO<T> |
AnsiDialect.pageWhere(String tableName,
String whereSql,
PageIPO pageIPO,
Class<T> mappedClass) |
| 限定符和类型 | 方法和说明 |
|---|---|
PageVO<com.alibaba.fastjson.JSONObject> |
AbstractDAO.page(PageIPO pageIPO) |
PageVO<T> |
AbstractRepository.page(PageIPO pageIPO) |
PageVO<T> |
AbstractRepository.page(PageIPO pageIPO) |
PageVO<com.alibaba.fastjson.JSONObject> |
AbstractDAO.page(PageIPO pageIPO) |
PageVO<com.alibaba.fastjson.JSONObject> |
AbstractDAO.pageDESC(PageIPO pageIPO) |
PageVO<T> |
AbstractRepository.pageDESC(PageIPO pageIPO) |
PageVO<T> |
AbstractRepository.pageDESC(PageIPO pageIPO) |
PageVO<com.alibaba.fastjson.JSONObject> |
AbstractDAO.pageDESC(PageIPO pageIPO) |
Copyright © 2021. All rights reserved.