![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
笔记
文章平均质量分 50
xy294636185
交流加qq294636185,通信工程向,熟悉c,c++,linux系统编程,网络编程,数据库等。
展开
-
算法记录贴
ACM模式输出模板:import java.util.Scanner;public class Main{public static void main(String[] args){Scanner sc = new Scanner(System.in);int n = sc.nextInt();}}输入浮点:float n = sc.nextFloat();取整:1.Math.round(n)2.ans-(int)ans>=0.5?(int)(ans+1):(int原创 2021-11-08 23:58:15 · 330 阅读 · 1 评论 -
项目中常见问题总结
POI读取文件:1.读取EXCEL文件空指针异常:解决:int target_qty = 0;//添加Row.MissingCellPolicy.CREATE_NULL_AS_BLANK参数即可解决空指针异常if(row.getCell(i+3,Row.MissingCellPolicy.CREATE_NULL_AS_BLANK).getCellType().equals(CellType.BLANK)) { target_qty = 0;}else{ target_原创 2021-03-18 16:27:53 · 1112 阅读 · 0 评论 -
临时
select a.factory,b.product,a.area,if(b.total is null,0,b.total) as total from tb_area a left join (select factory,product,area,count(*) as total from a where DATE_FORMAT(newDate,'%Y-%m-%d') = '2020-03-26' GROUP BY factory,product,area) b on a.area = b.ar原创 2021-06-16 00:05:25 · 83 阅读 · 0 评论