懂得归零

摘要： select relname, pg_size_pretty(pg_relation_size(relid)) from pg_stat_user_tables where schemaname='public' order by pg_relation_size(relid) desc; 阅读全文

摘要： LambdaUpdateWrapper<User> lambdaUpdateWrapper = new LambdaUpdateWrapper<>(); lambdaUpdateWrapper.set(User::getName, "newName").set(User::getAge, 20).e 阅读全文

摘要： select * from pg_stat_activity where datname = 'datname' and waiting_reason = 'lock'; 根据查询结果中的pid值杀掉进程 select pg_terminate_backend(pid) 阅读全文

摘要： SELECT array_to_json(array_agg(row_to_json(sys_xzqh))) from sys_xzqh where xzqh like '%341126%' 阅读全文

摘要： import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.*;public class WeekdaysUtils { public static List<String> list = ne 阅读全文

摘要： List<Vo> list = dao.selectList();if(CollectionUtils.isNotEmpty(list)) { Optional<Vo> max = list.stream().filter(obj->ObjectUtils.isNotEmpty(obj) && Ob 阅读全文

摘要： -- sum() over(partition by ... order by ...)SELECT len/sum(len)over(partition by road_id) param from rs; -- min() over(partition by ... order by ...)S 阅读全文

摘要： SELECT len/sum(len)over(partition by road_id) param from road_jcpd_section 阅读全文

摘要： @Component@EnableScheduling // 1.开启定时任务@EnableAsync // 2.开启多线程public class MultithreadScheduleTask { @Async @Scheduled(fixedRate= 3000) //3秒执行一次 publi 阅读全文

摘要： SELECT rl.road_code,string_agg(distinct rs.tech_level_label, ',') from road_lst rlleft join road_section rs on rl.id = rs.road_idwhere rs.tech_level_l 阅读全文