package com.terra.system.service.show;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.metadata.OrderItem;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.terra.system.entity.ctrl.TabEntity;
|
import com.terra.system.helper.ClassHelper;
|
import com.terra.system.mapper.all.BasicMapper;
|
import com.terra.system.service.data.DictService;
|
import org.apache.commons.logging.Log;
|
import org.apache.commons.logging.LogFactory;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import java.util.List;
|
|
/**
|
* 自动执行查询服务类
|
* @author WWW
|
* @date 2023-09-24
|
*/
|
@Service
|
public class AutoQueryService {
|
@Resource
|
DictService dictService;
|
|
private final static Log log = LogFactory.getLog(AutoQueryService.class);
|
|
/**
|
* 自动查询
|
*/
|
public void autoQuery() {
|
try {
|
log.info("开始自动查询..");
|
long beginTime = System.currentTimeMillis();
|
|
List<TabEntity> list = dictService.selectDictTab(null, "gid");
|
if (null != list && list.size() > 0) {
|
for (TabEntity tab : list) {
|
queryTable(tab.getEntity());
|
}
|
}
|
|
double time = (System.currentTimeMillis() - beginTime) / 1000.0;
|
log.info("自动查询结束(" + time + "s).");
|
} catch (Exception ex) {
|
log.error(ex.getMessage(), ex);
|
}
|
}
|
|
/**
|
* 查询数据表
|
*/
|
private void queryTable(String name) {
|
try {
|
BasicMapper baseMapper = ClassHelper.getBasicMapper(name);
|
if (null == baseMapper) {
|
log.error("查询对象不存在：" + name);
|
return;
|
}
|
|
Page<Object> page = new Page<>(1, 10);
|
page.addOrder(OrderItem.desc("gid"));
|
|
QueryWrapper wrapper = new QueryWrapper();
|
IPage<?> paged = baseMapper.selectPage(page, wrapper);
|
|
long count = paged.getTotal();
|
List<?> list = paged.getRecords();
|
} catch (Exception ex) {
|
log.error("查询出错：" + name + "\r\n" + ex.getMessage());
|
}
|
}
|
}
|
