Modifier and Type | Method and Description |
---|---|
default Column |
SingleIdMapper.getId()
获取主键列
|
Modifier and Type | Method and Description |
---|---|
default int |
SingleIdMapper.updateByIdsWithColumns(T po,
List<Column> columns,
Collection<K> ids)
通过主键批量更新指定列
|
default int |
MultipleIdMapper.updateByIdsWithColumns(T po,
List<Column> columns,
List<K> ids)
通过主键批量更新指定列
|
default int |
SingleIdMapper.updateByIdWithColumns(T po,
List<Column> columns)
通过主键更新指定的列
|
default int |
MultipleIdMapper.updateByIdWithColumns(T po,
List<Column> columns)
通过主键更新指定的列
|
default int |
Mapper.updateByUniqueKeysWithColumns(T po,
List<Column> columns,
Collection<UniqueKey> uniqueKeys)
通过主键批量更新指定列
|
default int |
Mapper.updateByUniqueKeyWithColumns(T po,
List<Column> columns,
UniqueKey uniqueKey)
通过主键更新指定的列
|
Modifier and Type | Class and Description |
---|---|
class |
ColumnAs
列(带别名)
|
Modifier and Type | Method and Description |
---|---|
Column |
SetItem.getColumn()
Gets the value of column
|
Modifier and Type | Method and Description |
---|---|
List<Column> |
JoinOn.getColumnPairs()
Gets the value of columnPairs
|
Modifier and Type | Method and Description |
---|---|
static SetItem |
SetItem.decreaseSet(Column column,
Number value)
设置自减
|
static String |
CriteriaMaker.egt(Column column,
Column secondColumn)
构造"大于等于"条件内容
|
static SetItem |
SetItem.increaseSet(Column column,
Number value)
设置自增长
|
static SetItem |
SetItem.set(Column column,
Object value)
设置具体值
|
Modifier and Type | Method and Description |
---|---|
static JoinOn |
JoinOn.full(Table table,
List<Column> columnPairs)
full join on
|
static JoinOn |
JoinOn.full(Table table,
List<Column> columnPairs,
List<CriteriaItem> criteriaItems)
full join on
|
static JoinOn |
JoinOn.inner(Table table,
List<Column> columnPairs)
inner join on
|
static JoinOn |
JoinOn.inner(Table table,
List<Column> columnPairs,
List<CriteriaItem> criteriaItems)
inner join on
|
static JoinOn |
JoinOn.left(Table table,
List<Column> columnPairs)
left join on
|
static JoinOn |
JoinOn.left(Table table,
List<Column> columnPairs,
List<CriteriaItem> criteriaItems)
left join on
|
static JoinOn |
JoinOn.none(Table table,
List<Column> columnPairs)
join on
|
static JoinOn |
JoinOn.none(Table table,
List<Column> columnPairs,
List<CriteriaItem> criteriaItems)
join on
|
static JoinOn |
JoinOn.right(Table table,
List<Column> columnPairs)
right join on
|
static JoinOn |
JoinOn.right(Table table,
List<Column> columnPairs,
List<CriteriaItem> criteriaItems)
right join on
|
Constructor and Description |
---|
ColumnAs(Column column,
String nameAs)
构造函数
|
SetItem(Column column,
Object value,
SetItemTypeEnum type)
设置对象
|
Modifier and Type | Method and Description |
---|---|
Column |
ColumnInfo.getColumn()
Gets the value of column
|
Modifier and Type | Method and Description |
---|---|
List<Column> |
TableColumnInfo.getColumns()
获取列
|
static List<Column> |
EntityConverter.getColumns(Class<?> poClazz)
获取列
|
List<Column> |
TableColumnInfo.getIds()
获取主键列
|
List<Column> |
TableColumnInfo.getNotIdColumns()
获取非主键列
|
static List<Column> |
EntityConverter.getUpdateColumns(Class<?> poClazz)
获取需要被更新的列
|
static List<Column> |
EntityConverter.getUpdateColumns(Class<?> poClazz,
List<Column> ignoreColumns)
获取需要被更新的列
|
Modifier and Type | Method and Description |
---|---|
void |
ColumnInfo.setColumn(Column column)
Sets the column
|
Modifier and Type | Method and Description |
---|---|
static TableColumnSetValues |
EntityConverter.getTableColumnValues(Object entity,
List<Column> orderList)
获取指定表-列值信息
|
static List<TableColumnSetValues> |
EntityConverter.getTableColumnValuesList(Collection<?> pos,
List<Column> columnsOrder)
批量指定列获取需要更新的列信息和相应的值
|
static List<Column> |
EntityConverter.getUpdateColumns(Class<?> poClazz,
List<Column> ignoreColumns)
获取需要被更新的列
|
Constructor and Description |
---|
ColumnInfo(Column column,
boolean id,
boolean nullable)
构造函数
|
ColumnSetValue(Column column,
Object value,
boolean id,
boolean nullable,
boolean autoIncrease) |
Modifier and Type | Method and Description |
---|---|
UpdateSql |
UpdateSqlImpl.decreaseSet(Column column,
Number value) |
CountSql |
CountSqlImpl.groupBy(Column groupBy) |
QuerySql<T> |
QuerySqlImpl.groupBy(Column groupBy) |
UpdateSql |
UpdateSqlImpl.increaseSet(Column column,
Number value) |
UpdateSql |
UpdateSqlImpl.set(Column column,
Object value) |
InsertSql |
InsertSqlImpl.values(Column column,
Object value) |
Modifier and Type | Method and Description |
---|---|
CountSql |
CountSqlImpl.fullJoinOn(Table table,
List<Column> columnPairs) |
DeleteSql |
DeleteSqlImpl.fullJoinOn(Table table,
List<Column> columnPairs) |
UpdateSql |
UpdateSqlImpl.fullJoinOn(Table table,
List<Column> columnPairs) |
QuerySql<T> |
QuerySqlImpl.fullJoinOn(Table table,
List<Column> columnPairs) |
CountSql |
CountSqlImpl.groupBy(List<Column> groupBys) |
QuerySql<T> |
QuerySqlImpl.groupBy(List<Column> groupBys) |
CountSql |
CountSqlImpl.innerJoinOn(Table table,
List<Column> columnPairs) |
DeleteSql |
DeleteSqlImpl.innerJoinOn(Table table,
List<Column> columnPairs) |
UpdateSql |
UpdateSqlImpl.innerJoinOn(Table table,
List<Column> columnPairs) |
QuerySql<T> |
QuerySqlImpl.innerJoinOn(Table table,
List<Column> columnPairs) |
CountSql |
CountSqlImpl.joinOn(Table table,
List<Column> columnPairs) |
DeleteSql |
DeleteSqlImpl.joinOn(Table table,
List<Column> columnPairs) |
UpdateSql |
UpdateSqlImpl.joinOn(Table table,
List<Column> columnPairs) |
QuerySql<T> |
QuerySqlImpl.joinOn(Table table,
List<Column> columnPairs) |
CountSql |
CountSqlImpl.leftJoinOn(Table table,
List<Column> columnPairs) |
DeleteSql |
DeleteSqlImpl.leftJoinOn(Table table,
List<Column> columnPairs) |
UpdateSql |
UpdateSqlImpl.leftJoinOn(Table table,
List<Column> columnPairs) |
QuerySql<T> |
QuerySqlImpl.leftJoinOn(Table table,
List<Column> columnPairs) |
CountSql |
CountSqlImpl.rightJoinOn(Table table,
List<Column> columnPairs) |
DeleteSql |
DeleteSqlImpl.rightJoinOn(Table table,
List<Column> columnPairs) |
UpdateSql |
UpdateSqlImpl.rightJoinOn(Table table,
List<Column> columnPairs) |
QuerySql<T> |
QuerySqlImpl.rightJoinOn(Table table,
List<Column> columnPairs) |
InsertSql |
InsertSqlImpl.values(List<Column> columns,
List<Object> values) |
Modifier and Type | Method and Description |
---|---|
T |
SetSupport.decreaseSet(Column column,
Number value)
设置自减
|
T |
GroupBySupport.groupBy(Column groupBy)
`GROUP BY t1.column`语句
|
T |
SetSupport.increaseSet(Column column,
Number value)
设置自增长
|
T |
SetSupport.set(Column column,
Object value)
设置具体值
|
T |
ValuesSupport.values(Column column,
Object value)
`(column1) VALUES(?)`语句
|
Modifier and Type | Method and Description |
---|---|
T |
JoinOnSupport.fullJoinOn(Table table,
List<Column> columnPairs)
`FULL JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
|
T |
GroupBySupport.groupBy(List<Column> groupBys)
`GROUP BY t1.column1, t2.column2, ...`语句
|
T |
JoinOnSupport.innerJoinOn(Table table,
List<Column> columnPairs)
`INNER JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
|
T |
JoinOnSupport.joinOn(Table table,
List<Column> columnPairs)
`JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
|
T |
JoinOnSupport.leftJoinOn(Table table,
List<Column> columnPairs)
`LEFT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
|
T |
JoinOnSupport.rightJoinOn(Table table,
List<Column> columnPairs)
`RIGHT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
|
T |
ValuesSupport.values(List<Column> columns,
List<Object> values)
`(column1, column2, ...) VALUES(?, ?, ...)`语句
|
Modifier and Type | Method and Description |
---|---|
T |
SetSupportImpl.decreaseSet(Column column,
Number value) |
T |
GroupBySupportImpl.groupBy(Column groupBy) |
T |
SetSupportImpl.increaseSet(Column column,
Number value) |
T |
SetSupportImpl.set(Column column,
Object value) |
T |
ValuesSupportImpl.values(Column column,
Object value) |
Modifier and Type | Method and Description |
---|---|
T |
JoinOnSupportImpl.fullJoinOn(Table table,
List<Column> columnPairs) |
T |
GroupBySupportImpl.groupBy(List<Column> groupBys) |
T |
JoinOnSupportImpl.innerJoinOn(Table table,
List<Column> columnPairs) |
T |
JoinOnSupportImpl.joinOn(Table table,
List<Column> columnPairs) |
T |
JoinOnSupportImpl.leftJoinOn(Table table,
List<Column> columnPairs) |
T |
JoinOnSupportImpl.rightJoinOn(Table table,
List<Column> columnPairs) |
T |
ValuesSupportImpl.values(List<Column> columns,
List<Object> values) |
Modifier and Type | Method and Description |
---|---|
static <T> InsertSql |
IdSqlUtils.batchInsertInto(Mapper<T> mapper,
List<T> pos,
List<Column> columns)
构造批量插入对象的SQL对象参数
SQL语法 : `INSERT INTO table(column1, column2, ...) values(?, ?, ...), (?, ?, ...)`
|
static <T> UpdateSql |
IdSqlUtils.updateById(Mapper<T> mapper,
T updateObject,
List<Column> updateColumns)
构造通过主键更新对象指定列的SQL参数对象(支持单列或多列主键)
|
static <T,K> UpdateSql |
IdSqlUtils.updateByIds(SingleIdMapper<T,K> mapper,
T updateObject,
List<Column> updateColumns,
Collection<K> idValues)
构造通过主键批量更新对象指定列的SQL参数对象(单列作为主键)
|
static <T,K extends MultiId> |
IdSqlUtils.updateByMultiIds(MultipleIdMapper<T,K> mapper,
T updateObject,
List<Column> updateColumns,
Collection<K> idValues)
构造通过主键批量更新对象指定列的SQL参数对象(多列作为主键)
|
static <T> UpdateSql |
UniqueKeySqlUtils.updateByUniqueKeys(Mapper<T> mapper,
T updateObject,
List<Column> updateColumns,
Collection<UniqueKey> uniqueKeys)
构造通过 unique key 批量更新对象指定列的SQL参数对象
|
Modifier and Type | Method and Description |
---|---|
static void |
MapperUtils.addExactKeywords(WhereSupport<?> sql,
String keyword,
List<Column> searchColumns,
List<Column> exactSearchColumns)
增加精确搜索关键字
|
static void |
MapperUtils.addExactKeywords(WhereSupport<?> sql,
String keyword,
List<Column> searchColumns,
List<Column> exactSearchColumns)
增加精确搜索关键字
|
static void |
MapperUtils.addKeywords(WhereSupport<?> sql,
String keyword,
List<Column> searchColumns)
增加关键字查询参数
|
static <T> void |
MapperUtils.batchUpdateById(Mapper<T> mapper,
List<T> entities,
List<Column> columns)
通过主键批量更新实体
|
static <T> void |
MapperUtils.batchUpdateByIdAndIgnoreColumns(Mapper<T> mapper,
List<T> entities,
List<Column> ignoreColumns)
通过主键更新非忽略的列
|
static <T> int |
MapperUtils.updateById(Mapper<T> mapper,
T entity,
List<Column> columns)
通过主键更新实体指定字段
|
static <T> int |
MapperUtils.updateByIdAndIgnoreColumns(Mapper<T> mapper,
T entity,
List<Column> ignoreColumns)
通过主键更新非忽略的列
|
static <T,K> int |
MapperUtils.updateByIdAndIgnoreColumns(SingleIdMapper<T,K> mapper,
T entity,
List<Column> ignoreColumns,
Collection<K> ids)
通过主键更新非忽略的列
|
static <T,K> int |
MapperUtils.updateByIds(SingleIdMapper<T,K> mapper,
T entity,
List<Column> columns,
Collection<K> ids)
通过主键更新实体指定列
|
static <T,K extends MultiId> |
MapperUtils.updateByMultiIds(MultipleIdMapper<T,K> mapper,
T entity,
List<Column> columns,
Collection<K> ids)
通过主键更新实体指定列
|
static <T> int |
MapperUtils.updateByUniqueKey(Mapper<T> mapper,
T entity,
List<Column> columns,
UniqueKey uniqueKey)
通过 unique key 更新实体指定列
|
static <T> int |
MapperUtils.updateByUniqueKeys(Mapper<T> mapper,
T entity,
List<Column> columns,
Collection<UniqueKey> uniqueKeys)
通过 unique key 更新实体指定列
|
Copyright © 2020 IBIT程序猿. All rights reserved.