StringUtils.java 40 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418
  1. package com.mixsmart.utils;
  2. import com.bstek.ureport.console.designer.ReportUtils;
  3. import com.jfirer.baseutil.encrypt.Md5Util;
  4. import com.mixsmart.constant.IMixConstant;
  5. import com.mixsmart.exception.NullArgumentException;
  6. import org.springblade.core.tool.utils.StringPool;
  7. import java.io.UnsupportedEncodingException;
  8. import java.lang.reflect.Field;
  9. import java.lang.reflect.Modifier;
  10. import java.math.BigDecimal;
  11. import java.math.RoundingMode;
  12. import java.text.DecimalFormat;
  13. import java.text.SimpleDateFormat;
  14. import java.util.*;
  15. import java.util.regex.Matcher;
  16. import java.util.regex.Pattern;
  17. import java.util.stream.Collectors;
  18. import java.util.stream.Stream;
  19. /**
  20. * @version 1.0
  21. * @Description:字符串处理工具类
  22. * @author:rock
  23. * @time:2020年4月21日 下午12:05:04
  24. */
  25. public class StringUtils {
  26. private StringUtils() {
  27. throw new UnsupportedOperationException("StringUtils类无法实例化");
  28. }
  29. private static final String CHARSET_NAME = "UTF-8";
  30. /**
  31. * 判断是否为空
  32. *
  33. * @param value 内容
  34. * @return 为空返回:true;否则返回:false
  35. */
  36. public static boolean isEmpty(String value) {
  37. return (null == value || value.trim().length() == 0);
  38. }
  39. /**
  40. * @return boolean
  41. * @Description 批量判读为空
  42. * @Param [values]
  43. * @Author yangyj
  44. * @Date 2021.11.05 13:42
  45. **/
  46. public static boolean isEmpty(Object... values) {
  47. for (Object value : values) {
  48. if (!isEmpty(value)) {
  49. return false;
  50. }
  51. }
  52. return true;
  53. }
  54. /**
  55. * 判断是否不为空
  56. *
  57. * @param value  内容
  58. * @return 不为空返回:true;否则返回:false
  59. */
  60. public static boolean isNotEmpty(String value) {
  61. return !isEmpty(value);
  62. }
  63. /**
  64. * 判断参数;如果参数<code>value</code> 为空;
  65. * 则抛出参数为空异常(运行时异常)
  66. *
  67. * @param value 需要判断的参数
  68. * @param msg 提示信息
  69. */
  70. public static void isAssert(Object value, String msg) {
  71. msg = isEmpty(msg) ? "提供的参数为空" : msg;
  72. if (null == value) {
  73. throw new NullArgumentException(msg);
  74. }
  75. if (value instanceof String) {
  76. if (isEmpty(value.toString())) {
  77. throw new NullArgumentException(msg);
  78. }
  79. } else if (value instanceof Collection) {
  80. if (CollectionUtils.isEmpty((Collection<?>) value)) {
  81. throw new NullArgumentException(msg);
  82. }
  83. } else if (value.getClass().isArray()) {
  84. if (ArrayUtils.isEmpty((Object[]) value)) {
  85. throw new NullArgumentException(msg);
  86. }
  87. }
  88. }
  89. /**
  90. * 判断值是否相等
  91. *
  92. * @param value1
  93. * @param value2
  94. * @return 相等返回:true;否则返回:false
  95. */
  96. public static boolean isEquals(Object value1, Object value2) {
  97. boolean is = false;
  98. if (null != value1 && null != value2) {
  99. is = value1.toString().equals(value2.toString());
  100. } else if (null == value1 && null == value2) {
  101. is = true;
  102. }
  103. return is;
  104. }
  105. /**
  106. * 判断值是否不相等
  107. *
  108. * @param value1
  109. * @param value2
  110. * @return 相等返回:true;否则返回:false
  111. */
  112. public static boolean isNotEquals(Object value1, Object value2) {
  113. return !isEquals(value1, value2);
  114. }
  115. /**
  116. * 判断值是否相等(不区分大小写)
  117. *
  118. * @param value1
  119. * @param value2
  120. * @return 相等返回:true;否则返回:false
  121. */
  122. public static boolean isEqualsIgnoreCase(Object value1, Object value2) {
  123. boolean is = false;
  124. if (null != value1 && null != value1) {
  125. is = value1.toString().equalsIgnoreCase(value2.toString());
  126. } else if (null == value1 && null == value1) {
  127. is = true;
  128. }
  129. return is;
  130. }
  131. /**
  132. * 判断值是否不相等(不区分大小写)
  133. *
  134. * @param value1
  135. * @param value2
  136. * @return 相等返回:true;否则返回:false
  137. */
  138. public static boolean isNotEqualsIgnoreCase(Object value1, Object value2) {
  139. return !isEqualsIgnoreCase(value1, value2);
  140. }
  141. /**
  142. * null转换为“”
  143. *
  144. * @param obj
  145. * @return 返回处理后的结果
  146. */
  147. public static String handleNull(Object obj) {
  148. if (null == obj) {
  149. return "";
  150. } else {
  151. return obj.toString().trim();
  152. }
  153. }
  154. public static String handleNullZero(Object obj, Object scale) {
  155. if (obj == null || isEmpty(obj)) {
  156. return number2StringZero("0",scale);
  157. }
  158. return number2StringZero(obj,scale);
  159. }
  160. /**
  161. * 当值为null转化为“null”
  162. *
  163. * @param obj
  164. * @return 返回处理后的结果
  165. */
  166. public static String nullToStr(Object obj) {
  167. if (null == obj) {
  168. return "null";
  169. } else {
  170. return obj.toString().trim();
  171. }
  172. }
  173. /**
  174. * 对象转化为整型
  175. * <p>注:该方法已过时,请用{@link #handleObj2Integer(Object)} 代替</p>
  176. *
  177. * @param obj
  178. * @return 返回转化结果
  179. */
  180. public static Integer handObj2Integer(Object obj) {
  181. return handleObj2Integer(obj);
  182. }
  183. /**
  184. * 对象转化为整型
  185. *
  186. * @param obj
  187. * @return 返回转化结果
  188. */
  189. public static Integer handleObj2Integer(Object obj) {
  190. if (null == obj) {
  191. return 0;
  192. } else {
  193. double value = 0;
  194. try {
  195. value = Double.parseDouble(obj.toString());
  196. } catch (Exception ex) {
  197. value = 0;
  198. }
  199. return (int) value;
  200. }
  201. }
  202. /**
  203. * @return java.lang.Double
  204. * @Description 对象转Double
  205. * @Param [obj, scale]
  206. * @Author yangyj
  207. * @Date 2022.04.20 14:15
  208. **/
  209. public static Double obj2Double(Object obj, Object scale) {
  210. if (StringUtils.isNumber(obj)) {
  211. if (StringUtils.isNumber(scale)) {
  212. obj = new BigDecimal(StringUtils.number2String(obj, scale));
  213. }
  214. BigDecimal big = new BigDecimal(obj.toString());
  215. return big.doubleValue();
  216. }
  217. return null;
  218. }
  219. public static Double obj2Double(Object obj) {
  220. return obj2Double(obj, null);
  221. }
  222. /**
  223. * 数字null转换为“0”
  224. *
  225. * @param obj
  226. * @return 返回转化结果
  227. */
  228. public static String handleNumNull(Object obj) {
  229. if (null == obj) {
  230. return "0";
  231. } else {
  232. return obj.toString().trim();
  233. }
  234. }
  235. /**
  236. * 判断是否为数字(包括小数)
  237. *
  238. * @param value
  239. * @return 数字返回:true;否则返回:false
  240. */
  241. public static boolean isNum(Object value) {
  242. boolean is = false;
  243. if (value != null) {
  244. Pattern pattern = Pattern.compile("\\d+|\\d+\\.\\d+");
  245. Matcher matcher = pattern.matcher(value.toString());
  246. if (matcher.matches()) {
  247. is = true;
  248. } else {
  249. is = false;
  250. }
  251. }
  252. return is;
  253. }
  254. /**
  255. * 判断是否数字整数
  256. *
  257. * @param value
  258. * @return 是返回:true;否则返回:false
  259. */
  260. public static boolean isInteger(String value) {
  261. boolean is = false;
  262. Pattern pattern = Pattern.compile("\\d+");
  263. if (null != value && value.length() > 1) {
  264. pattern = Pattern.compile("^[1-9]\\d+");
  265. }
  266. Matcher matcher = pattern.matcher(value);
  267. if (matcher.matches()) {
  268. is = true;
  269. } else {
  270. is = false;
  271. }
  272. return is;
  273. }
  274. /**
  275. * 判断是否小数
  276. *
  277. * @param value
  278. * @return 是返回:true;否则返回:false
  279. */
  280. public static boolean isDecimal(String value) {
  281. boolean is = false;
  282. Pattern pattern = Pattern.compile("\\d+\\.\\d+");
  283. Matcher matcher = pattern.matcher(value);
  284. if (matcher.matches()) {
  285. is = true;
  286. } else {
  287. is = false;
  288. }
  289. return is;
  290. }
  291. /**
  292. * 随机生成数
  293. *
  294. * @param num 要生成随机数的个数
  295. * @return 返回随机生成数
  296. */
  297. public static String randomNum(int num) {
  298. Random random = new Random();
  299. String numStr = "";
  300. for (int i = 0; i < num; i++) {
  301. numStr += random.nextInt(10);
  302. }
  303. return numStr;
  304. }
  305. /**
  306. * 按日期格式生成序列号
  307. *
  308. * @param dateFormaterStr 日期格式
  309. * @return 返回序列号
  310. */
  311. public static String createSerialNum(String dateFormaterStr) {
  312. String serialNum = null;
  313. if (isNotEmpty(dateFormaterStr)) {
  314. SimpleDateFormat dateFormatter = new SimpleDateFormat(dateFormaterStr);
  315. serialNum = dateFormatter.format(new Date());
  316. dateFormatter = null;
  317. }
  318. return serialNum;
  319. }
  320. /**
  321. * 生成UUID序列号
  322. *
  323. * @return 返回UUID
  324. */
  325. public static String uuid() {
  326. String value = UUID.randomUUID().toString();
  327. value = value.replaceAll("-", "");
  328. return value.substring(0, 28);
  329. }
  330. public static String uuid(int max) {
  331. String value = UUID.randomUUID().toString();
  332. value = value.replaceAll("-", "");
  333. return value.substring(0, max);
  334. }
  335. /**
  336. * 获取文件后缀
  337. *
  338. * @param fileName
  339. * @return 返回文件后缀
  340. */
  341. public static String getFileSuffix(String fileName) {
  342. int index = fileName.lastIndexOf(".");
  343. if (index != -1) {
  344. return fileName.substring(index + 1);
  345. }
  346. return "";
  347. }
  348. /**
  349. * 去掉文件后缀
  350. *
  351. * @param fileName
  352. * @return 返回文件后缀
  353. */
  354. public static String trimFileSuffix(String fileName) {
  355. return fileName.substring(0, fileName.lastIndexOf("."));
  356. }
  357. /**
  358. * 验证手机号码
  359. *
  360. * @param phoneNo
  361. * @return 验证成功返回:true;否则返回:false
  362. */
  363. public static boolean isPhoneNO(String phoneNo) {
  364. Pattern p = Pattern.compile("^((13[0-9])|(15[^4,\\D])|(18[0,5-9]))\\d{8}$");
  365. Matcher m = p.matcher(phoneNo);
  366. return m.matches();
  367. }
  368. /**
  369. * 验证固定电话号码
  370. *
  371. * @param tel
  372. * @return 验证成功返回:true;否则返回:false
  373. */
  374. public static boolean isFixedTelephone(String tel) {
  375. Pattern p = Pattern.compile("^[0][0-9]{2,3}-[2-9][0-9]{6,7}(-[0-9]{1,4})?");
  376. Matcher m = p.matcher(tel);
  377. return m.matches();
  378. }
  379. /**
  380. * 验证匿名
  381. *
  382. * @param anonymous
  383. * @return 验证成功返回:true;否则返回:false
  384. */
  385. public static boolean isAnonymous(String anonymous) {
  386. Pattern p = Pattern.compile("^[\\u4e00-\\u9fa5|A-Za-z]([\\w|\\u4e00-\\u9fa5]){1,7}$");
  387. Matcher m = p.matcher(anonymous);
  388. return m.matches();
  389. }
  390. /**
  391. * 验证汉字
  392. *
  393. * @param value
  394. * @return 验证成功返回:true;否则返回:false
  395. */
  396. public static boolean isChinese(String value) {
  397. Pattern p = Pattern.compile("^[\\u4E00-\\u9FFF]+$");
  398. Matcher m = p.matcher(value);
  399. boolean is = m.matches();
  400. return is;
  401. }
  402. /**
  403. * 验证正则表达式
  404. *
  405. * @param value
  406. * @return 验证成功返回:true;否则返回:false
  407. */
  408. public static boolean isCheckRegex(String value, String regex) {
  409. Pattern p = Pattern.compile(regex);
  410. Matcher m = p.matcher(value);
  411. boolean is = m.matches();
  412. return is;
  413. }
  414. /**
  415. * 验证QQ号码
  416. *
  417. * @param value
  418. * @return 验证成功返回:true;否则返回:false
  419. */
  420. public static boolean isQQ(String value) {
  421. Pattern p = Pattern.compile("^[1-9]\\d{6,11}$");
  422. Matcher m = p.matcher(value);
  423. return m.matches();
  424. }
  425. /**
  426. * 验证email
  427. *
  428. * @param email
  429. * @return 验证成功返回:true;否则返回:false
  430. */
  431. public static boolean isEmail(String email) {
  432. Pattern p = Pattern.compile("^([a-zA-Z0-9]+[_|\\_|\\.]?)*[a-zA-Z0-9]+@([a-zA-Z0-9]+[_|\\_|\\.]?)*[a-zA-Z0-9]+\\.[a-zA-Z]{2,3}$");
  433. Matcher m = p.matcher(email);
  434. return m.matches();
  435. }
  436. /**
  437. * 秒转化为:HH:mm:SS格式
  438. *
  439. * @param second
  440. * @return 返回转化后的结果
  441. */
  442. public static String secondToHHMMSS(long second) {
  443. long h = 0, m = 0, s = 0, tmp = 0;
  444. if (second >= 3600) {
  445. h = second / 3600;
  446. tmp = second % 36000;
  447. if (tmp >= 60) {
  448. m = tmp / 60;
  449. s = tmp % 60;
  450. } else {
  451. s = tmp;
  452. }
  453. } else if (second >= 60) {
  454. m = second / 60;
  455. s = second % 60;
  456. } else {
  457. s = second;
  458. }
  459. return (h > 9 ? h : "0" + h) + ":" + (m > 9 ? m : "0" + m) + ":" + (s > 9 ? s : "0" + s);
  460. }
  461. /**
  462. * 过滤特殊字符
  463. *
  464. * @param params
  465. * @return 返回过滤后的结果
  466. */
  467. public static String filterSQLParams(String params) {
  468. if (!isEmpty(params)) {
  469. StringBuilder strBuilder = new StringBuilder();
  470. strBuilder.append("'|\"|update|delete|select|drop|insert|=|;|0x|\\(|\\)|\\s|\\*|\\?|\\%|\\$");
  471. strBuilder.append("|and|exec|execute|chr|mid|master|truncate|char|declare|sitename|net user|xp_cmdshell|or");
  472. strBuilder.append("|\\+|,|like'|table|from|grant|use|group_concat|column_name|information_schema.columns");
  473. strBuilder.append("|table_schema|union|where|order|by|count");
  474. strBuilder.append("|--|,|like|//|/|#");
  475. String params1 = params.toLowerCase();
  476. params1 = params1.replaceAll(strBuilder.toString(), "");
  477. if ("".equals(params1) && !"''".equals(params)) {
  478. params = params1;
  479. }
  480. params = params.replaceAll("&", "&amp");
  481. params = params.replaceAll("<", "&lt");
  482. params = params.replaceAll(">", "&gt");
  483. }
  484. return params;
  485. }
  486. /**
  487. * 根据regex分隔字符串
  488. * 然后用逗号","重组
  489. *
  490. * @param ids
  491. * @param regex
  492. * @return 返回处理后的结果
  493. */
  494. public static String splitIds(String ids, String regex) {
  495. String newIds = "";
  496. if (isNotEmpty(ids)) {
  497. String[] idsArr = ids.split(regex);
  498. for (int i = 0; i < idsArr.length; i++) {
  499. if (i != (idsArr.length - 1)) {
  500. newIds += "'" + idsArr[i] + "',";
  501. } else {
  502. newIds += "'" + idsArr[i] + "'";
  503. }
  504. }
  505. }
  506. return newIds;
  507. }
  508. /**
  509. * 计算出文件大小
  510. *
  511. * @param size
  512. * @return 返回处理后的结果;<br />
  513. * 格式为:"100 KB"或”100 M“或”100 G“
  514. */
  515. public static String fileSize(long size) {
  516. DecimalFormat df = new DecimalFormat("0.0#");
  517. long KB = 1024;
  518. long MB = KB * 1024;
  519. long GB = MB * 1024;
  520. String valueStr = null;
  521. if (size < 0) {
  522. valueStr = "0 KB";
  523. } else if (size < KB * 1024) {
  524. double value = (double) size / KB;
  525. valueStr = df.format(value) + " KB";
  526. } else if (size < MB * 1024) {
  527. double value = (double) size / MB;
  528. valueStr = df.format(value) + " M";
  529. } else {
  530. double value = (double) size / GB;
  531. valueStr = df.format(value) + " G";
  532. }
  533. df = null;
  534. return valueStr;
  535. }
  536. /**
  537. * 过滤目录结构(防止参数传递目录结构)
  538. *
  539. * @param value
  540. * @return 返回过滤后的结果
  541. */
  542. public static String filterFilePath(String value) {
  543. if (!StringUtils.isEmpty(value)) {
  544. value.replaceAll("\\.|/|\\\\\\\\|\\\\|:|%2F|%2E|25%|20%|%5C|60%|27%|%3A|%2A", "");
  545. }
  546. return value;
  547. }
  548. /**
  549. * 判断是否含有contain指定的值
  550. *
  551. * @param value
  552. * @param contain
  553. * @return 包含返回:true;否则返回:false
  554. */
  555. public static boolean isContains(String value, String contain) {
  556. boolean is = false;
  557. if (!isEmpty(value) && null != contain) {
  558. is = value.contains(contain) ? true : false;
  559. }
  560. return is;
  561. }
  562. /**
  563. * list转换为数组
  564. *
  565. * @param values
  566. * @return 返回转化结果
  567. */
  568. public static String[] list2Array(Collection<String> values) {
  569. String[] valueArray = null;
  570. if (null != values && values.size() > 0) {
  571. valueArray = new String[values.size()];
  572. values.toArray(valueArray);
  573. }
  574. return valueArray;
  575. }
  576. /**
  577. * 验证IP地址
  578. *
  579. * @param ip
  580. * @return 验证成功返回:true;否则返回:false
  581. */
  582. public static boolean checkIp(String ip) {
  583. boolean is = false;
  584. String regex = "^(1\\d{2}|2[0-4]\\d|25[0-5]|[1-9]\\d|[1-9])\\."
  585. + "(1\\d{2}|2[0-4]\\d|25[0-5]|[1-9]\\d|\\d)\\."
  586. + "(1\\d{2}|2[0-4]\\d|25[0-5]|[1-9]\\d|\\d)\\."
  587. + "(1\\d{2}|2[0-4]\\d|25[0-5]|[1-9]\\d|\\d)$";
  588. Pattern pattern = Pattern.compile(regex);
  589. Matcher matcher = pattern.matcher(ip);
  590. if (matcher.matches()) {
  591. is = true;
  592. }
  593. return is;
  594. }
  595. /**
  596. * 集合转换为字符串,字符串之间用separater提供的参数分隔
  597. *
  598. * @param values
  599. * @param separater
  600. * @return 返回处理后的结果
  601. */
  602. public static <T> String collection2String(Collection<T> values, String separater) {
  603. StringBuilder strBuilder = null;
  604. if (null != values && values.size() > 0) {
  605. strBuilder = new StringBuilder();
  606. if (isEmpty(separater)) {
  607. separater = "";
  608. }
  609. for (T value : values) {
  610. strBuilder.append(StringUtils.handleNull(value) + separater);
  611. }
  612. if (isNotEmpty(separater)) {
  613. strBuilder.delete(strBuilder.length() - 1, strBuilder.length());
  614. }
  615. }
  616. return strBuilder != null ? strBuilder.toString() : null;
  617. }
  618. /**
  619. * 替换多个空格、换行、回车、tab符等为一个空格
  620. *
  621. * @param value 预处理的字符串
  622. * @return 返回处理后的字符串
  623. */
  624. public static String removeMultiSpace(String value) {
  625. if (StringUtils.isNotEmpty(value)) {
  626. value = value.replaceAll("\\s+|\n|\r|\n|\t", " ");
  627. }
  628. return value;
  629. }
  630. /**
  631. * 替换特殊字符
  632. *
  633. * @param value 预处理的字符串
  634. * @return 返回处理后的结果
  635. */
  636. public static String repaceSpecialChar(String value) {
  637. if (isNotEmpty(value)) {
  638. value = value.replaceAll("\r|\n|\t", "");
  639. }
  640. return value;
  641. }
  642. public static String changeQuotation(String value) {
  643. if (isNotEmpty(value)) {
  644. value = value.replaceAll("'", "\\\\u0027");
  645. }
  646. return value;
  647. }
  648. /**
  649. * 替换斜杠
  650. *
  651. * @param value
  652. * @return 返回处理后的结果
  653. */
  654. public static String repaceSlash(String value) {
  655. if (isNotEmpty(value)) {
  656. //value = value.replaceAll("\\\\", "\\\\\\\\\\\\\\\\");
  657. value = value.replaceAll("\\\\", "\\\\\\\\");
  658. value = value.replaceAll("`", "\\\\`");
  659. value = value.replaceAll("'", "\\\\`");
  660. }
  661. return value;
  662. }
  663. /**
  664. * 替换斜杠
  665. *
  666. * @param value
  667. * @return 返回处理后的结果
  668. */
  669. public static String repaceSlashCopyTable(String value) {
  670. if (isNotEmpty(value)) {
  671. //value = value.replaceAll("\\\\", "\\\\\\\\\\\\\\\\");
  672. //value = value.replaceAll("\\\\", "\\\\\\\\");
  673. value = value.replaceAll("`", "\\\\`");
  674. }
  675. return value;
  676. }
  677. /**
  678. * 去空格
  679. *
  680. * @param value
  681. * @return 返回处理后的结果
  682. */
  683. public static String repaceBlank(String value) {
  684. if (isNotEmpty(value)) {
  685. value = value.replaceAll("\\s", "");
  686. }
  687. return value;
  688. }
  689. /**
  690. * 字符串转换为list
  691. *
  692. * @param value 要转换的字符串
  693. * @param separater 分隔符
  694. * @return 返回转换后的List
  695. */
  696. public static List<String> string2List(String value, String separater) {
  697. List<String> lists = null;
  698. if (isNotEmpty(value)) {
  699. separater = isEmpty(separater) ? "," : separater;
  700. String[] array = value.split(separater);
  701. lists = Arrays.asList(array);
  702. }
  703. return lists;
  704. }
  705. /**
  706. * 字符串转换为Set
  707. *
  708. * @param value 要转换的字符串
  709. * @param separater 分隔符
  710. * @return 返回转换后的Set
  711. */
  712. public static Set<String> string2Set(String value, String separater) {
  713. Set<String> sets = null;
  714. if (isNotEmpty(value)) {
  715. separater = isEmpty(separater) ? "," : separater;
  716. String[] array = value.split(separater);
  717. sets = new HashSet<String>();
  718. sets.addAll(Arrays.asList(array));
  719. }
  720. return sets;
  721. }
  722. /**
  723. * 如果值为空“”转换为NULL
  724. *
  725. * @param value
  726. * @return
  727. */
  728. public static String empty2Null(String value) {
  729. return isEmpty(value) ? null : value;
  730. }
  731. /**
  732. * 移除多值,只获取第一个值;多值之间通过英文逗号分隔
  733. *
  734. * @param value 需要处理的值
  735. * @return 返回处理后的值
  736. */
  737. public static String removeMultiValue(String value) {
  738. if (isEmpty(value)) {
  739. return value;
  740. }
  741. int p = value.indexOf(IMixConstant.MULTI_VALUE_SPLIT);
  742. if (p >= 0) {
  743. value = value.substring(0, p);
  744. }
  745. return value;
  746. }
  747. /**
  748. * 数组转化为字符串;
  749. * 如果<code>separate</code>为空,则采用默认值;默认值为:{@link IMixConstant#MULTI_VALUE_SPLIT}
  750. *
  751. * @param objs 数组
  752. * @param separate 分隔符
  753. * @return 返回数组转化成功后的字符串;失败返回:null
  754. */
  755. public static String arrayToString(Object[] objs, String separate) {
  756. StringBuilder strBuff = null;
  757. if (null == objs || objs.length == 0) {
  758. return null;
  759. }
  760. if (StringUtils.isEmpty(separate)) {
  761. separate = IMixConstant.MULTI_VALUE_SPLIT;
  762. }
  763. strBuff = new StringBuilder();
  764. for (int i = 0; i < objs.length; i++) {
  765. if (i < objs.length - 1) {
  766. strBuff.append(String.valueOf(objs[i]) + separate);
  767. } else {
  768. strBuff.append(String.valueOf(objs[i]));
  769. }
  770. }//for
  771. objs = null;
  772. return (null != strBuff) ? strBuff.toString() : null;
  773. }
  774. /**
  775. * 字符串转化为数组;
  776. * 如果<code>separate</code>为空,则采用默认值;默认值为:{@link IMixConstant#MULTI_VALUE_SPLIT}
  777. *
  778. * @param value 原字符串
  779. * @param separate 分隔符
  780. * @return 返回字符串分割成功后的数组
  781. */
  782. public static String[] stringToArray(String value, String separate) {
  783. String[] array = null;
  784. if (isEmpty(separate)) {
  785. separate = IMixConstant.MULTI_VALUE_SPLIT;
  786. }
  787. if (isNotEmpty(value)) {
  788. array = value.split(separate);
  789. }
  790. value = null;
  791. return array;
  792. }
  793. /**
  794. * 按separate分离成数组,判断该数组里面是否包含subStr;
  795. * 如果<code>separate</code>为空,则采用默认值;默认值为:{@link IMixConstant#MULTI_VALUE_SPLIT}
  796. *
  797. * @param str 字符串
  798. * @param subStr 子字符串
  799. * @param separate 分隔符
  800. * @return 包含返回:true;否则返回:false
  801. */
  802. public static boolean isArrayContains(String str, String subStr, String separate) {
  803. if (isEmpty(str)) {
  804. return isEmpty(subStr);
  805. }
  806. if (null == subStr) {
  807. return true;
  808. }
  809. boolean is = false;
  810. if (isEmpty(separate)) {
  811. separate = IMixConstant.MULTI_VALUE_SPLIT;
  812. }
  813. String[] strArray = str.split(separate);
  814. for (int i = 0; i < strArray.length; i++) {
  815. if (subStr.equals(strArray[i].trim())) {
  816. is = true;
  817. break;
  818. }
  819. }//for
  820. return is;
  821. }
  822. /**
  823. * 判断对象是否为空,或转换为字符串后的值是否为空
  824. *
  825. * @param value 需要判断的值
  826. * @return 为空(null或“”)返回true;否则返回false
  827. */
  828. public static boolean isEmpty(Object value) {
  829. if (null == value) {
  830. return true;
  831. } else {
  832. return isEmpty(handleNull(value));
  833. }
  834. }
  835. /**
  836. * 判断对象是否不为空;
  837. *
  838. * @param value 需要判断的值
  839. * @return 如果不为空返回true;否则返回false
  840. */
  841. public static boolean isNotEmpty(Object value) {
  842. return !isEmpty(value);
  843. }
  844. /**
  845. * @return boolean
  846. * @Description 批量非空校验
  847. * @Param [values]
  848. * @Author yangyj
  849. * @Date 2021.10.19 17:04
  850. **/
  851. public static boolean isNotEmpty(Object... values) {
  852. for (Object value : values) {
  853. if (isEmpty(value)) {
  854. return false;
  855. }
  856. }
  857. return true;
  858. }
  859. /**
  860. * @Description 是否数字
  861. * @Param [value]
  862. * @return boolean
  863. * @Author yangyj
  864. * @Date 2022.06.02 14:54
  865. **/
  866. public static boolean isNumber(Object value) {
  867. if (isEmpty(value)) {
  868. return false;
  869. }
  870. if (value instanceof Number) {
  871. return true;
  872. }
  873. String pattern = "^[+-]?\\d+(\\.[\\dEe]+)?$";
  874. Pattern r = Pattern.compile(pattern);
  875. Matcher m = r.matcher(String.valueOf(value));
  876. return m.matches();
  877. }
  878. public static boolean isDouble(Object value) {
  879. return isNumber(value) && value.toString().contains(".");
  880. }
  881. /**
  882. * @return java.util.Map<java.lang.String, java.lang.Object>
  883. * @Description
  884. * @Param [obj] 对象转成map集合
  885. * @Author yangyj
  886. * @Date 2021.05.27 14:33
  887. **/
  888. public static Map<String, Object> objectToMap(Object obj) {
  889. Map<String, Object> map = new HashMap<String, Object>();
  890. try {
  891. Class<?> clazz = obj.getClass();
  892. for (Field field : clazz.getDeclaredFields()) {
  893. field.setAccessible(true);
  894. if (Modifier.isStatic(field.getModifiers()) || Modifier.isFinal(field.getModifiers())) {
  895. continue;
  896. }
  897. String fieldName = field.getName();
  898. Object data = field.get(obj);
  899. Object toStrValue = handleNull(data);
  900. if (isNotEmpty(toStrValue)) {
  901. if (data.getClass().isArray()) {
  902. if (ArrayUtils.isNotEmpty((String[]) data)) {
  903. map.put(fieldName, data);
  904. }
  905. } else {
  906. map.put(fieldName, data);
  907. }
  908. }
  909. }
  910. } catch (Exception e) {
  911. e.printStackTrace();
  912. }
  913. return map;
  914. }
  915. /**
  916. * @Description 包含空字段
  917. * @Param [obj] 对象转成map集合
  918. * @return java.util.Map<java.lang.String, java.lang.Object>
  919. * @Author yangyj
  920. * @Date 2021.05.27 14:33
  921. **/
  922. // public static Map<String, Object> objectToMapNull(Object obj) {
  923. // Map<String, Object> map = new HashMap<String,Object>();
  924. // try {
  925. // Class<?> clazz = obj.getClass();
  926. // for (Field field : clazz.getDeclaredFields()) {
  927. // field.setAccessible(true);
  928. // if(Modifier.isStatic(field.getModifiers()) || Modifier.isFinal(field.getModifiers())) {
  929. // continue;
  930. // }
  931. // String fieldName = field.getName();
  932. // Object data =field.get(obj);
  933. // Object toStrValue = handleNull(data);
  934. // if(isNotEmpty(toStrValue)&&data.getClass().isArray()){
  935. // if(ArrayUtils.isNotEmpty((String[])data)){
  936. // map.put(fieldName,data);
  937. // }
  938. // }else if(isNotEmpty(toStrValue)&&data instanceof Date){
  939. // map.put(fieldName, DateUtil.dateToStr((Date) data,"yyyy-MM-dd HH:mm:ss"));
  940. // }else {
  941. // map.put(fieldName,toStrValue);
  942. // }
  943. // }
  944. // }catch (Exception e){
  945. // e.printStackTrace();
  946. // }
  947. // return map;
  948. // }
  949. /**
  950. * @return java.lang.String
  951. * @Description 返回字符串后n个字符
  952. * @Param [str, n]
  953. * @Author yangyj
  954. * @Date 2021.08.06 16:31
  955. **/
  956. public static String tail(String str, int n) {
  957. if (isNotEmpty(str) && str.length() >= n) {
  958. return str.substring(str.length() - n);
  959. } else {
  960. return str;
  961. }
  962. }
  963. /**
  964. * @return java.lang.String
  965. * @Description list转字符串
  966. * @Param [list, split:分隔符]
  967. * @Author yangyj
  968. * @Date 2021.08.06 17:11
  969. **/
  970. public static String join(List<String> list, String split) {
  971. StringBuilder sb = new StringBuilder("");
  972. if (ListUtils.isNotEmpty(list)) {
  973. for (String str : list) {
  974. if (StringUtils.isNotEmpty(str)) {
  975. sb.append(str).append(split);
  976. }
  977. }
  978. if (sb.length() > 0 && isNotEmpty(split)) {
  979. sb.delete(sb.length() - split.length(), sb.length());
  980. }
  981. }
  982. return sb.toString();
  983. }
  984. public static String join(List<String> list) {
  985. return join(list, null);
  986. }
  987. public static String join(Object... args) {
  988. if (args != null) {
  989. if (args.length > 2) {
  990. List<String> list = Arrays.stream(args).limit(args.length - 1).map(StringUtils::handleNull).collect(Collectors.toList());
  991. String split = handleNull(args[args.length - 1]);
  992. return join(list, split);
  993. } else {
  994. return handleNull(args[0]);
  995. }
  996. } else {
  997. return "";
  998. }
  999. }
  1000. /**
  1001. * @Description 获取实体映射所有表字段名
  1002. * @Param [clazz]
  1003. * @return java.util.List<java.lang.String>
  1004. * @Author yangyj
  1005. * @Date 2021.08.18 11:05
  1006. **/
  1007. // public static Map<String,String> getFiledAnnotate(Class<?> clazz) {
  1008. // LinkedHashMap<String,String> names = new LinkedHashMap<>();
  1009. // Field[] fields = clazz.getDeclaredFields();
  1010. // Method[] methods=clazz.getMethods();
  1011. // for (Field field:fields) {
  1012. // field.setAccessible(true);
  1013. // if(field.isAnnotationPresent(Column.class)) {
  1014. // names.put(field.getDeclaredAnnotation(Column.class).name(),isEquals(field.getType().toString(),String.class)?"''":"null");
  1015. // }
  1016. // }
  1017. // for (Method m:methods) {
  1018. // m.setAccessible(true);
  1019. // if(m.isAnnotationPresent(Column.class)) {
  1020. // names.put(m.getDeclaredAnnotation(Column.class).name(),isEquals(m.getReturnType().toString(),String.class)?"''":"null");
  1021. // }
  1022. // }
  1023. // return names;
  1024. // }
  1025. /**
  1026. * @return java.lang.String
  1027. * @Description 只查询出指定字段内容
  1028. * @Param [clazz, fields]
  1029. * @Author yangyj
  1030. * @Date 2021.08.18 11:18
  1031. **/
  1032. // public static String selectFieldsBuilder(Class<?>clazz,String ...fields){
  1033. // StringBuilder sb = new StringBuilder();
  1034. // Map<String,String> fieldsNames=getFiledAnnotate(clazz);
  1035. // if(MapUtils.isNotEmpty(fieldsNames)){
  1036. // if(ArrayUtils.isEmpty(fields)){
  1037. // sb.append(" * ");
  1038. // }else{
  1039. // HashSet<String> keys = new HashSet<>(Arrays.asList(fields));
  1040. // for(Map.Entry<String,String> entry:fieldsNames.entrySet()){
  1041. // if(!keys.contains(entry.getKey())){
  1042. // sb.append(entry.getValue()).append(" as ");
  1043. // }
  1044. // sb.append(entry.getKey()).append(",");
  1045. // }
  1046. // if(sb.lastIndexOf(",")==sb.length()-1){
  1047. // sb.deleteCharAt(sb.length()-1);
  1048. // }
  1049. // }
  1050. // }
  1051. // return sb.toString();
  1052. // }
  1053. public static String toString(byte[] bytes) {
  1054. try {
  1055. return new String(bytes, CHARSET_NAME);
  1056. } catch (UnsupportedEncodingException e) {
  1057. return "";
  1058. }
  1059. }
  1060. /**
  1061. * @return java.lang.String
  1062. * @Description 返回保留指定小数位数字字符串
  1063. * @Param [number, scale]
  1064. * @Author yangyj
  1065. * @Date 2021.10.15 10:35
  1066. **/
  1067. public static String number2StringZero(Object number, Object scale) {
  1068. if (isNumber(number)) {
  1069. if (isEmpty(scale)) {
  1070. scale = 0;
  1071. }
  1072. return new BigDecimal(handleNull(number)).setScale(handleObj2Integer(scale), BigDecimal.ROUND_HALF_UP).toString();
  1073. }
  1074. return "";
  1075. }
  1076. public static String number2String(Object number, Object scale) {
  1077. if (isNumber(number)) {
  1078. if (isEmpty(scale)) {
  1079. scale = 0;
  1080. }
  1081. String val = new BigDecimal(handleNull(number)).setScale(handleObj2Integer(scale), BigDecimal.ROUND_HALF_UP).toString();
  1082. if (val.contains(".")) {
  1083. return new BigDecimal(val).toString().replaceAll("(0+|\\.0+)$", "");
  1084. }
  1085. return val;
  1086. }
  1087. return "";
  1088. }
  1089. /*
  1090. public static void main(String[] args) {
  1091. System.out.println(StringUtils.number2String("-2400.0000000000055",1));
  1092. }
  1093. */
  1094. /**
  1095. * @return java.lang.String
  1096. * @Description byte数组转Md5字符串
  1097. * @Param [bytes]
  1098. * @Author yangyj
  1099. * @Date 2021.12.20 17:10
  1100. **/
  1101. public static String bytes2Md5(byte[] bytes) {
  1102. StringBuffer sb = new StringBuffer("");
  1103. byte b[] = Md5Util.md5(bytes);
  1104. int d;
  1105. for (int i = 0; i < b.length; i++) {
  1106. d = b[i];
  1107. if (d < 0) {
  1108. d = b[i] & 0xff;
  1109. // 与上一行效果等同
  1110. // i += 256;
  1111. }
  1112. if (d < 16)
  1113. sb.append("0");
  1114. sb.append(Integer.toHexString(d));
  1115. }
  1116. return sb.toString();
  1117. }
  1118. /**
  1119. * 转换为字节数组
  1120. *
  1121. * @param str
  1122. * @return
  1123. */
  1124. public static byte[] getBytes(String str) {
  1125. if (str != null) {
  1126. try {
  1127. return str.getBytes(CHARSET_NAME);
  1128. } catch (UnsupportedEncodingException e) {
  1129. return null;
  1130. }
  1131. } else {
  1132. return null;
  1133. }
  1134. }
  1135. /**
  1136. * @param name
  1137. * @param suffix
  1138. * @param splitStr
  1139. * @return
  1140. */
  1141. public static String addSuffixInFirst(String name, String suffix, String splitStr) {
  1142. String newName = name;
  1143. if (isEmpty(name)) {
  1144. return newName;
  1145. }
  1146. int idx = name.indexOf(splitStr);
  1147. if (idx > 0) {
  1148. String templateName = name.substring(0, idx);
  1149. String templateNameNew = templateName + suffix;
  1150. newName = templateNameNew + name.substring(idx);
  1151. }
  1152. return newName;
  1153. }
  1154. public static String replaceSuffixInFirst(String name, String suffix, String splitStr) {
  1155. String newName = name;
  1156. if (isEmpty(name)) {
  1157. return newName;
  1158. }
  1159. int idx = name.indexOf(splitStr);
  1160. if (idx > 0) {
  1161. String templateName = name.substring(0, idx);
  1162. newName = newName.replace(templateName, suffix);
  1163. }
  1164. return newName;
  1165. }
  1166. /**
  1167. * @return boolean
  1168. * @Description 匹配度
  1169. * @Param [a, b]
  1170. * @Author yangyj
  1171. * @Date 2022.03.24 17:40
  1172. **/
  1173. public static boolean suitability(String a, String b) {
  1174. if (StringUtils.isNotEmpty(a, b)) {
  1175. char[] bA = b.toCharArray();
  1176. if (a.length() >= bA.length) {
  1177. for (char c : bA) {
  1178. if (!a.contains(String.valueOf(c))) {
  1179. return false;
  1180. }
  1181. }
  1182. return true;
  1183. }
  1184. }
  1185. return false;
  1186. }
  1187. /**
  1188. * @return int
  1189. * @Description 获取最大小数位,转String计算小数位格式,超长浮点数先转double,四舍五入取五位
  1190. * @Param [number]
  1191. * @Author yangyj
  1192. * @Date 2021.12.23 15:08
  1193. 去除有效数字后面的0*/
  1194. public static Integer getScale(Object... number) {
  1195. int max = 0;
  1196. if (number != null) {
  1197. return getScale(scaleParam(number),1);
  1198. }
  1199. return max;
  1200. }
  1201. /**保留有效数字后面的0*/
  1202. public static Integer getScaleZero(Object... number){
  1203. int max = 0;
  1204. if (number != null) {
  1205. return getScale(scaleParam(number),0);
  1206. }
  1207. return max;
  1208. }
  1209. public static void main(String[] args) {
  1210. /* System.out.println(getScaleZero(152000,"±10.0"));
  1211. System.out.println(getScaleZero(152000,"-10.0,10"));
  1212. System.out.println(getScaleZero(152000,"-10.0,10.0"));
  1213. System.out.println(getScaleZero(Double.MAX_VALUE,"-10.0,10"));
  1214. System.out.println(getScaleZero(152000,"-10,10"));*/
  1215. System.out.println(getScale(152000,"1240.32563"));
  1216. }
  1217. public static List<Object> scaleParam(Object ... number){
  1218. return Arrays.stream(number).filter(StringUtils::isNotEmpty).flatMap(e-> CustomFunction.obj2ListNe(e).stream()).distinct().map(s->s.toString().replaceAll("±","")).filter(StringUtils::isNumber).map(e->{
  1219. /*0.3999999999999986 检测到超长小数位先转double处理,再还原回String*/
  1220. int dot= e.indexOf(StringPool.DOT);
  1221. boolean unlimited=dot>0&&(e.length()-dot>6);
  1222. if(unlimited|| e.contains("e")){
  1223. return BigDecimal.valueOf(Double.parseDouble(e)).setScale(2, RoundingMode.HALF_UP).toString();
  1224. }else {
  1225. return e;
  1226. }
  1227. }).collect(Collectors.toList());
  1228. }
  1229. public static final String[] SCALE_REG=new String[]{"(\\d)+.(\\d)*[0-9]","(\\d)+.(\\d)*[1-9]"};
  1230. private static Integer getScale(List<Object> number,Integer zero){
  1231. int max=0;
  1232. if(ListUtils.isNotEmpty(number)){
  1233. for (Object n : number) {
  1234. if (StringUtils.isNotEmpty(n)) {
  1235. String[] sa = n.toString().split(StringPool.COMMA);
  1236. for (String s : sa) {
  1237. Matcher m = RegexUtils.matcher(SCALE_REG[zero], s);
  1238. if (m.find()) {
  1239. int cp = new StringBuilder(m.group()).reverse().toString().indexOf(".");
  1240. /*单位是万元的时候,可能存在五位小数*/
  1241. if (cp <= 5) {
  1242. max = Math.max(cp, max);
  1243. }
  1244. }
  1245. }
  1246. }
  1247. }
  1248. }
  1249. return max;
  1250. }
  1251. /*
  1252. public static void main(String[] args) {
  1253. List<Object> list = new ArrayList<>();
  1254. list.add(Double.parseDouble("0.3999999999999986"));
  1255. list.add(Double.parseDouble("0.1999999999999996"));
  1256. list.add(Double.parseDouble("-0.21"));
  1257. list.add(Double.parseDouble("-1.21"));
  1258. list.add("-1.260");
  1259. System.out.println(getScale(list));
  1260. System.out.println(getScaleZero(list));
  1261. }
  1262. */
  1263. /* public static void main(String[] args) {
  1264. List<Object> list = Arrays.asList("16.001",27.0,5,6);
  1265. System.out.println(getScale(list));
  1266. System.out.println(getScaleZero(150.0));
  1267. System.out.println(getScale(150.0));
  1268. }*/
  1269. /*public static void main(String[] args) {
  1270. double x=Double.parseDouble("1.2562e2");
  1271. BigDecimal big= new BigDecimal(String.valueOf(x));
  1272. System.out.println(big.scale());
  1273. }*/
  1274. /**
  1275. * @return java.lang.String
  1276. * @Description 公式脚本转义
  1277. * @Param [f]
  1278. * @Author yangyj
  1279. * @Date 2022.10.13 21:25
  1280. **/
  1281. public static String escapeFormula(String f) {
  1282. if (isNotEmpty(f)) {
  1283. if (f.contains("&gt;") || f.contains("&lt;")) {
  1284. f = f.replace("&lt;", "<").replace("&gt;", ">");
  1285. }
  1286. if (f.contains(StringPool.QUOTE)) {
  1287. f = f.replaceAll(StringPool.QUOTE, StringPool.SINGLE_QUOTE);
  1288. }
  1289. }
  1290. return f;
  1291. }
  1292. }