BaseDbService (Jpom-码云(gitee.com))

java.lang.Object
- io.jpom.service.h2db.BaseDbCommonService<T>
- - io.jpom.service.h2db.BaseDbService<T>

Direct Known Subclasses:

BackupInfoService, BaseWorkspaceService, DbSystemMonitorLogService, SystemParametersServer, TriggerTokenLogServer, UserBindWorkspaceService, UserPermissionGroupServer, UserService, WorkspaceService
```
public abstract class BaseDbService<T extends BaseDbModel>
extends BaseDbCommonService<T>
```
数据库操作通用 serve

Since:

2021/8/13

Author:

bwcx_jzy

Field Summary
- Fields inherited from class io.jpom.service.h2db.BaseDbCommonService
  key, tableName, tClass

Constructor Summary

Constructors
Constructor and Description

BaseDbService()

Constructors
Constructor and Description
`BaseDbService()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`protected void`	`autoClear(String timeColumn, int maxCount, Consumer<Long> consumer)` 自动清理数据接口
`protected void`	`autoLoopClear(String timeClo, int maxCount, Consumer<cn.hutool.db.Entity> whereCon, Predicate<T> predicate)` 自动清理数据接口
`protected String[]`	`clearTimeColumns()` 安装时间自动清理数据对字段
`long`	`count()`
`long`	`count(T data)`
`protected String`	`covetTableName(String tableName, Class<T> tClass)` 转换表面
`protected cn.hutool.db.sql.Order[]`	`defaultOrders()`
`protected void`	`executeClearImpl(int h2DbLogStorageCount)` 清理分发实现
`protected void`	`fillInsert(T t)` 插入数据填充
`T`	`getData(String nodeId, String dataId)` 根据节点和数据ID查询数据
`protected long`	`getLastTimeValue(String timeColumn, int maxCount, Consumer<cn.hutool.db.Entity> whereCon)` 查询指定字段降序指定条数对最后一个值
`void`	`insert(Collection<T> t)` 插入数据
`void`	`insert(T t)` 插入数据
`void`	`insertNotFill(T t)` 不填充插入
`List<T>`	`list()`
`List<T>`	`listById(Collection<String> ids)` 多个 id 查询数据
`List<T>`	`listById(Collection<String> ids, Consumer<cn.hutool.db.Entity> consumer)` 多个 id 查询数据
`PageResultDto<T>`	`listPage(cn.hutool.db.Entity where, cn.hutool.db.Page page)` 分页查询
`PageResultDto<T>`	`listPage(javax.servlet.http.HttpServletRequest request)` 通用的分页查询, 使用该方法查询，数据库表字段不能包含 "page", "limit", "order_field", "order", "total"
`PageResultDto<T>`	`listPage(Map<String,String> paramMap)` 通用的分页查询, 使用该方法查询，数据库表字段不能包含 "page", "limit", "order_field", "order", "total"
`cn.hutool.db.Page`	`parsePage(Map<String,String> paramMap)` 转换为 page 对象
`int`	`update(T t)` 修改数据，需要自行实现
`int`	`updateById(T info)` update by id with data
`int`	`updateById(T info, Consumer<cn.hutool.db.Entity> whereConsumer)` update by id with data
`void`	`upsert(T t)` 先尝试更新，更新失败插入

Methods inherited from class io.jpom.service.h2db.BaseDbCommonService
count, count, dataBeanToEntity, del, delByKey, delByKey, entityToBean, entityToBean, entityToBeanList, execute, exists, exists, fillSelectResult, findByCondition, getByKey, getByKey, getByKey, getKey, getTableName, insert, listByBean, listByEntity, listPageOnlyResult, query, query, queryByBean, queryList, queryList, queryList, update, warpException

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - BaseDbService
```
public BaseDbService()
```
- Method Detail
  - covetTableName
```
protected String covetTableName(String tableName,
                                Class<T> tClass)
```
    Description copied from class: BaseDbCommonService
    
    转换表面
    
    Overrides:
    
    covetTableName in class BaseDbCommonService<T extends BaseDbModel>
    
    Parameters:
    
    tableName - 表面
    
    tClass - 类
    
    Returns:
    
    转换后的表名
  - insert
```
public void insert(T t)
```
    Description copied from class: BaseDbCommonService
    
    插入数据
    
    Overrides:
    
    insert in class BaseDbCommonService<T extends BaseDbModel>
    
    Parameters:
    
    t - 数据
  - upsert
```
public void upsert(T t)
```
    先尝试更新，更新失败插入
    
    Parameters:
    
    t - 数据
  - insertNotFill
```
public void insertNotFill(T t)
```
    不填充插入
    
    Parameters:
    
    t - 数据
  - insert
```
public void insert(Collection<T> t)
```
    Description copied from class: BaseDbCommonService
    
    插入数据
    
    Overrides:
    
    insert in class BaseDbCommonService<T extends BaseDbModel>
    
    Parameters:
    
    t - 数据
  - fillInsert
```
protected void fillInsert(T t)
```
    插入数据填充
    
    Parameters:
    
    t - 数据
  - updateById
```
public int updateById(T info,
                      Consumer<cn.hutool.db.Entity> whereConsumer)
```
    update by id with data
    
    Parameters:
    
    info - data
    
    whereConsumer - 查询条件回调
    
    Returns:
    
    影响的行数
  - updateById
```
public int updateById(T info)
```
    update by id with data
    
    Parameters:
    
    info - data
    
    Returns:
    
    影响的行数
  - update
```
public int update(T t)
```
    Description copied from class: BaseDbCommonService
    
    修改数据，需要自行实现
    
    Overrides:
    
    update in class BaseDbCommonService<T extends BaseDbModel>
    
    Parameters:
    
    t - 数据
    
    Returns:
    
    影响行数
  - list
```
public List<T> list()
```
  - count
```
public long count()
```
  - count
```
public long count(T data)
```
  - listPage
```
public PageResultDto<T> listPage(javax.servlet.http.HttpServletRequest request)
```
    通用的分页查询, 使用该方法查询，数据库表字段不能包含 "page", "limit", "order_field", "order", "total"
    page=1&limit=10&order=ascend&order_field=name
    
    Parameters:
    
    request - 请求对象
    
    Returns:
    
    page
  - parsePage
```
public cn.hutool.db.Page parsePage(Map<String,String> paramMap)
```
    转换为 page 对象
    
    Parameters:
    
    paramMap - 请求参数
    
    Returns:
    
    page
  - listPage
```
public PageResultDto<T> listPage(Map<String,String> paramMap)
```
    通用的分页查询, 使用该方法查询，数据库表字段不能包含 "page", "limit", "order_field", "order", "total"
    page=1&limit=10&order=ascend&order_field=name
    
    Parameters:
    
    paramMap - 请求参数
    
    Returns:
    
    page
  - listPage
```
public PageResultDto<T> listPage(cn.hutool.db.Entity where,
                                 cn.hutool.db.Page page)
```
    Description copied from class: BaseDbCommonService
    
    分页查询
    
    Overrides:
    
    listPage in class BaseDbCommonService<T extends BaseDbModel>
    
    Parameters:
    
    where - 条件
    
    page - 分页
    
    Returns:
    
    结果
  - defaultOrders
```
protected cn.hutool.db.sql.Order[] defaultOrders()
```
  - listById
```
public List<T> listById(Collection<String> ids)
```
    多个 id 查询数据
    
    Parameters:
    
    ids - ids
    
    Returns:
    
    list
  - listById
```
public List<T> listById(Collection<String> ids,
                        Consumer<cn.hutool.db.Entity> consumer)
```
    多个 id 查询数据
    
    Parameters:
    
    ids - ids
    
    Returns:
    
    list
  - executeClearImpl
```
protected void executeClearImpl(int h2DbLogStorageCount)
```
    清理分发实现
    
    Parameters:
    
    h2DbLogStorageCount - 保留数量
  - clearTimeColumns
```
protected String[] clearTimeColumns()
```
    安装时间自动清理数据对字段
    
    Returns:
    
    数组
  - autoClear
```
protected void autoClear(String timeColumn,
                         int maxCount,
                         Consumer<Long> consumer)
```
    自动清理数据接口
    
    Parameters:
    
    timeColumn - 时间字段
    
    maxCount - 最大数量
    
    consumer - 查询出超过范围的时间回调
  - getLastTimeValue
```
protected long getLastTimeValue(String timeColumn,
                                int maxCount,
                                Consumer<cn.hutool.db.Entity> whereCon)
```
    查询指定字段降序指定条数对最后一个值
    
    Parameters:
    
    timeColumn - 时间字段
    
    maxCount - 最大数量
    
    whereCon - 添加查询条件回调
    
    Returns:
    
    时间
  - autoLoopClear
```
protected void autoLoopClear(String timeClo,
                             int maxCount,
                             Consumer<cn.hutool.db.Entity> whereCon,
                             Predicate<T> predicate)
```
    自动清理数据接口
    
    Parameters:
    
    timeClo - 时间字段
    
    maxCount - 最大数量
    
    predicate - 查询出超过范围的时间,回调
  - getData
```
public T getData(String nodeId,
                 String dataId)
```
    根据节点和数据ID查询数据
    
    Parameters:
    
    nodeId - 节点ID
    
    dataId - 数据ID
    
    Returns:
    
    data

Class BaseDbService<T extends BaseDbModel>

Field Summary

Fields inherited from class io.jpom.service.h2db.BaseDbCommonService

Constructor Summary

Method Summary

Methods inherited from class io.jpom.service.h2db.BaseDbCommonService

Methods inherited from class java.lang.Object

Constructor Detail

BaseDbService

Method Detail

covetTableName

insert

upsert

insertNotFill

insert

fillInsert

updateById

updateById

update

list

count

count

listPage

parsePage

listPage

listPage

defaultOrders

listById

listById

executeClearImpl

clearTimeColumns

autoClear

getLastTimeValue

autoLoopClear

getData