| 程序包 | 说明 |
|---|---|
| org.noear.wood | |
| org.noear.wood.dialect |
| 限定符和类型 | 类和说明 |
|---|---|
class |
SelectQ |
| 限定符和类型 | 字段和说明 |
|---|---|
protected SQLBuilder |
WhereBase._builder |
| 限定符和类型 | 方法和说明 |
|---|---|
SQLBuilder |
SQLBuilder.addPrefix(String str) |
SQLBuilder |
SQLBuilder.addPrefix(String str,
boolean allowEmpty) |
SQLBuilder |
SQLBuilder.addSuffix(String str) |
SQLBuilder |
SQLBuilder.addSuffix(String str,
boolean allowEmpty) |
SQLBuilder |
SQLBuilder.append(Object val) |
SQLBuilder |
SQLBuilder.append(SQLBuilder part) |
SQLBuilder |
SQLBuilder.append(String code,
Object... args) |
SQLBuilder |
SQLBuilder.insert(int offset,
Object val) |
SQLBuilder |
SQLBuilder.insert(SQLBuilder part) |
SQLBuilder |
SQLBuilder.insert(String code,
Object... args) |
SQLBuilder |
SQLBuilder.remove(int start,
int length) |
SQLBuilder |
SQLBuilder.removeLast() |
SQLBuilder |
SQLBuilder.trimEnd(String str) |
SQLBuilder |
SQLBuilder.trimStart(String str) |
| 限定符和类型 | 方法和说明 |
|---|---|
SQLBuilder |
SQLBuilder.append(SQLBuilder part) |
SQLBuilder |
SQLBuilder.insert(SQLBuilder part) |
DbQuery |
DbQuery.sql(SQLBuilder sqlBuilder) |
DbQuery |
DbContext.sql(SQLBuilder sqlBuilder)
输入SQL builder,获取查询器
|
| 限定符和类型 | 方法和说明 |
|---|---|
DbQuery |
DbContext.sql(Act1<SQLBuilder> buildRuner)
输入SQL builder,获取查询器
|
| 构造器和说明 |
|---|
SelectQ(SQLBuilder sqlBuilder) |
| 限定符和类型 | 方法和说明 |
|---|---|
void |
DbDialectBase.buildInsertOneCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
Fun1<Boolean,String> isSqlExpr,
boolean _usingNull,
IDataItem values) |
void |
DbDialect.buildInsertOneCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
Fun1<Boolean,String> isSqlExpr,
boolean _usingNull,
IDataItem values)
单条插入代码构建
|
void |
DbDb2Dialect.buildSelectRangeCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
StringBuilder orderBy,
int start,
int size) |
void |
DbSQLiteDialect.buildSelectRangeCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
StringBuilder orderBy,
int start,
int size) |
void |
DbOracleDialect.buildSelectRangeCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
StringBuilder orderBy,
int start,
int size) |
void |
DbPostgreSQLDialect.buildSelectRangeCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
StringBuilder orderBy,
int start,
int size) |
void |
DbDialectBase.buildSelectRangeCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
StringBuilder orderBy,
int start,
int size) |
void |
DbDialect.buildSelectRangeCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
StringBuilder orderBy,
int start,
int size)
分页查询代码构建
|
void |
DbSQLServerDialect.buildSelectRangeCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
StringBuilder orderBy,
int start,
int size) |
void |
DbDb2Dialect.buildSelectTopCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
StringBuilder orderBy,
int size) |
void |
DbOracleDialect.buildSelectTopCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
StringBuilder orderBy,
int size) |
void |
DbDialectBase.buildSelectTopCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
StringBuilder orderBy,
int size) |
void |
DbDialect.buildSelectTopCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
StringBuilder orderBy,
int size)
顶部查询代码构建
|
void |
DbSQLServerDialect.buildSelectTopCode(DbContext ctx,
String table1,
SQLBuilder sqlB,
StringBuilder orderBy,
int size) |
Copyright © 2023. All rights reserved.