计算身份证中的年龄

直接在mysql里面计算

#计算
select identity_card,(YEAR(NOW())- SUBSTRING(identity_card,7,4)) from his_declare_people ;
#查询
select identity_card from his_declare_people
where  (YEAR(NOW())- SUBSTRING(identity_card,7,4)) between #{ageID1} and  #{ageID2}

然后在网上搜索到的一个大兄弟写的在程序里面计算也可以，感觉不错，也写在下面了

    /*** 根据身份证的号码算出当前身份证持有者的年龄** @return*/public static int countAge(String idNumber) {if (idNumber.length() != 18 && idNumber.length() != 15) {throw new IllegalArgumentException("身份证号长度错误");}String year;String yue;String day;if (idNumber.length() == 18) {year = idNumber.substring(6).substring(0, 4);// 得到年份yue = idNumber.substring(10).substring(0, 2);// 得到月份day = idNumber.substring(12).substring(0, 2);//得到日} else {year = "19" + idNumber.substring(6, 8);// 年份yue = idNumber.substring(8, 10);// 月份day = idNumber.substring(10, 12);//日}Date date = new Date();// 得到当前的系统时间SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");String fyear = format.format(date).substring(0, 4);// 当前年份String fyue = format.format(date).substring(5, 7);// 月份String fday = format.format(date).substring(8, 10);//int age = 0;if (Integer.parseInt(yue) == Integer.parseInt(fyue)) {//如果月份相同//说明已经过了生日或者今天是生日if (Integer.parseInt(day) <= Integer.parseInt(fday)) {age = Integer.parseInt(fyear) - Integer.parseInt(year);} else {age = Integer.parseInt(fyear) - Integer.parseInt(year) - 1;}} else {if (Integer.parseInt(yue) < Integer.parseInt(fyue)) {//如果当前月份大于出生月份age = Integer.parseInt(fyear) - Integer.parseInt(year);} else {//如果当前月份小于出生月份,说明生日还没过age = Integer.parseInt(fyear) - Integer.parseInt(year) - 1;}}System.out.println("age = " + age);return age;}

引用的博客地址： https://blog.csdn.net/Chen_chenjiasheng/article/details/120017848