12 2022 档案
摘要：-- 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
阅读全文
摘要：1、创建物化视图 CREATE MATERIALIZED VIEW "view_xxx“ as select * from 表 2、刷新物化视图 refresh materialized view view_xxx; 3、删除物化视图 drop materialized view view_xxx;
阅读全文
摘要：在Terminal终端中输入 git config user.name git config --global user.name "xl"
阅读全文
摘要：// 获得总共有多少行int rowNum = 0;//存在样式的空行。会被统计进来。所以主要的问题是要判断是否是空行。for (int num = 1; num <= sheet.getLastRowNum(); num++) {//跳过第一行，看个人需求 HSSFRow row = sheet.
阅读全文
摘要：//递归插入public void add(List<Object> all, long start, long limit){ //截取 List<Object> collect = all.stream().skip(start).limit(limit).collect(Collectors.
阅读全文
