截取日期范围并计算相差月数代码,Java代码库,德仔网

代码语言

代码分类

【Java】截取日期范围并计算相差月数

作者:文昊 / 发布于2017/9/25/ 694

得到单元格内的两个日期范围，分别截取年月日，并比较年、月、日

public int getMonth(int row) {
        
        int result = 0;
        int coll = 14;
        
        String st = CommonF.getExcelBy07(path, index, row, coll);
        //System.out.println(st);
        String s[] = st.split("-");
        String s1 = s[0];
        String s2 = s[1];

        //System.out.println(s1);
        //System.out.println(s2);
        
        String date1[] = s1.split("\\.");
        String date2[] = s2.split("\\.");
        
        int year1 = Integer.parseInt(date1[0]);
        int month1 = Integer.parseInt(date1[1]);
        int day1 = Integer.parseInt(date1[2]);
        
        int year2 = Integer.parseInt(date2[0]);
        int month2 = Integer.parseInt(date2[1]);
        int day2 = Integer.parseInt(date2[2]);
        
        if(year1==year2) {
            if(month1==month2) {
                if(day1==day2) {
                    result = 0; 
                }
            }else if(month1<month2) {
                if(day1==1) {
                    result = month2 - month1 + 1;
                }else {
                    result = month2 - month1;
                }
            }else if(month1>month2) {
                result = month1 - month2;
            }
        }else if(year1<year2) {
            if(month1==month2) {
                if(day1==1) {
                    result = (year2 - year1)*12 + 1;
                }else {
                    result = (year2 - year1)*12;
                }
            }else if(month1<month2) {
                if(day1==1) {
                    result = (year2 - year1)*12 + (month2 - month1)+1;
                }else {
                    result = (year2 - year1)*12 + (month2 - month1);
                }
            }else if(month1>month2) {
                if(day1==1) {
                    result = (year2 - year1)*12 - (month1 - month2)+1;
                }else {
                    result = (year2 - year1)*12 - (month1 - month2);
                }
            }
        }else if(year1>year2){
            result = -2;//-2代表两个年数输入有误
        }else {
            result = -1;//-1代表日期输入有误
        }
        System.out.println("result= "+result);
        return result;
        
    }

试试其它关键字

同语言下

可能有用的

文昊贡献的其它代码(13)