@Override public Object getColumns(String name) { StringBuilder sql = new StringBuilder("select column_name, is_nullable, data_type, column_comment, column_key from information_schema.columns where "); if(!ObjectUtils.isEmpty(name)){ sql.append("table_name = '"+name+"' "); } sql.append("and table_schema = (select database()) order by ordinal_position"); Query query = em.createNativeQuery(sql.toString()); List<Object[]> result = query.getResultList(); List<ColumnInfo> columnInfos = new ArrayList<>(); for (Object[] obj : result) { columnInfos.add(new ColumnInfo(obj[0],obj[1],obj[2],obj[3],obj[4],null,"true")); } return PageUtil.toPage(columnInfos,columnInfos.size()); }
/** * 分页 */ @Cacheable(keyGenerator = "keyGenerator") public Object queryAll(Picture picture, Pageable pageable){ return PageUtil.toPage(pictureRepository.findAll(new Spec(picture),pageable)); }
/** * 分页 */ @Cacheable(keyGenerator = "keyGenerator") public Object queryAll(QiniuContent qiniuContent, Pageable pageable){ return PageUtil.toPage(qiniuContentRepository.findAll(new Spec(qiniuContent),pageable)); }
@Override public Object getTables(String name, int[] startEnd) { StringBuilder sql = new StringBuilder("select table_name tableName,create_time createTime from information_schema.tables where table_schema = (select database()) "); if(!ObjectUtils.isEmpty(name)){ sql.append("and table_name like '%"+name+"%' "); } sql.append("order by table_name"); Query query = em.createNativeQuery(sql.toString()); query.setFirstResult(startEnd[0]); query.setMaxResults(startEnd[1]); System.out.println(sql.toString()); List<Object[]> result = query.getResultList(); List<TableInfo> tableInfos = new ArrayList<>(); for (Object[] obj : result) { tableInfos.add(new TableInfo(obj[0],obj[1])); } Query query1 = em.createNativeQuery("SELECT COUNT(*) from information_schema.tables where table_schema = (select database())"); Object totalElements = query1.getSingleResult(); return PageUtil.toPage(tableInfos,totalElements); }
@Cacheable(keyGenerator = "keyGenerator") public Object queryAll(QuartzJob quartzJob, Pageable pageable){ return PageUtil.toPage(quartzJobRepository.findAll(new Spec(quartzJob),pageable)); }
public Object queryAll(QuartzLog quartzLog, Pageable pageable){ return PageUtil.toPage(quartzLogRepository.findAll(new Spec(quartzLog),pageable)); }
/** * 分页 */ @Cacheable(keyGenerator = "keyGenerator") public Object queryAll(String name, Pageable pageable){ Page<Role> page = roleRepository.findAll(new Spec(name),pageable); return PageUtil.toPage(page.map(roleMapper::toDto)); }
/** * 分页 */ @Cacheable(keyGenerator = "keyGenerator") public Object queryAll(UserDTO user, Pageable pageable){ Page<User> page = userRepo.findAll(new Spec(user),pageable); return PageUtil.toPage(page.map(userMapper::toDto)); }
@Override public Page findByKey(String key, Pageable pageable){ Jedis jedis = null; try{ jedis = pool.getResource(); List<RedisVo> redisVos = new ArrayList<>(); if(!key.equals("*")){ key = "*" + key + "*"; } for (String s : jedis.keys(key)) { RedisVo redisVo = new RedisVo(s,jedis.get(s)); redisVos.add(redisVo); } Page<RedisVo> page = new PageImpl<RedisVo>( PageUtil.toPage(pageable.getPageNumber(),pageable.getPageSize(),redisVos), pageable, redisVos.size()); return page; }finally{ if(null != jedis){ jedis.close(); // 释放资源还给连接池 } } }