使用poi读取单元格内容，如果是整数读取之后 后端获取却是小数所以需要处理一下
public static String getStringValue(XSSFCell cell) {NumberFormat numberFormat = NumberFormat.getInstance();// 不显示千位分割符，否则显示结果会变成类似1,234,567,890numberFormat.setGroupingUsed(false);if (null == cell) {return null;}String value = cell.toString();//如果单元格没有内容if (value.equals("") || value.equals(" ")) {return null;}int i = cell.getCellType();if (i == 1) {//字符串类型return value;} else {value = numberFormat.format(cell.getNumericCellValue());return value;}}
验证手机号是否合法
public static boolean isMobileNO(String mobile) {if (mobile.length() != 11) {return false;} else {/*** 移动号段正则表达式*/String pat1 = "^((13[4-9])|(147)|(15[0-2,7-9])|(178)|(18[2-4,7-8]))\\d{8}|(1705)\\d{7}$";/*** 联通号段正则表达式*/String pat2 = "^((13[0-2])|(145)|(15[5-6])|(176)|(18[5,6]))\\d{8}|(1709)\\d{7}$";/*** 电信号段正则表达式*/String pat3 = "^((133)|(153)|(177)|(18[0,1,9])|(149))\\d{8}$";/*** 虚拟运营商正则表达式*/String pat4 = "^((170))\\d{8}|(1718)|(1719)\\d{7}$";Pattern pattern1 = pile(pat1);Matcher match1 = pattern1.matcher(mobile);boolean isMatch1 = match1.matches();if (isMatch1) {return true;}Pattern pattern2 = pile(pat2);Matcher match2 = pattern2.matcher(mobile);boolean isMatch2 = match2.matches();if (isMatch2) {return true;}Pattern pattern3 = pile(pat3);Matcher match3 = pattern3.matcher(mobile);boolean isMatch3 = match3.matches();if (isMatch3) {return true;}Pattern pattern4 = pile(pat4);Matcher match4 = pattern4.matcher(mobile);boolean isMatch4 = match4.matches();if (isMatch4) {return true;}return false;}}
检查字符串是否包含中文
public static boolean isContainChinese(String str) {Pattern p = pile("[\u4e00-\u9fa5]");Matcher m = p.matcher(str);if (m.find()) {return true;}return false;}
