From 1d53dd8f501a98ddcce8146443b51b357ef5f9b1 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 29 十二月 2022 16:55:46 +0800
Subject: [PATCH] 1

---
 src/main/java/com/lf/server/helper/StringHelper.java |   76 +++++++++++++++++++++++++++++++++++--
 1 files changed, 71 insertions(+), 5 deletions(-)

diff --git a/src/main/java/com/lf/server/helper/StringHelper.java b/src/main/java/com/lf/server/helper/StringHelper.java
index 69e73bd..d9235ef 100644
--- a/src/main/java/com/lf/server/helper/StringHelper.java
+++ b/src/main/java/com/lf/server/helper/StringHelper.java
@@ -4,6 +4,7 @@
 
 import java.text.SimpleDateFormat;
 import java.util.Date;
+import java.util.List;
 import java.util.regex.Matcher;
 import java.util.regex.Pattern;
 
@@ -30,12 +31,12 @@
     /**
      * 鏍煎紡鍖栧綋鍓嶇郴缁熸棩鏈� 3
      */
-    public static final SimpleDateFormat YMD__FORMAT = new SimpleDateFormat("yyyyMMdd_");
+    public static final SimpleDateFormat YMD2_FORMAT = new SimpleDateFormat("yyyyMMdd");
 
     /**
      * 鏍煎紡鍖栧綋鍓嶇郴缁熸棩鏈� 4
      */
-    public static final SimpleDateFormat YMD_HM_FORMAT = new SimpleDateFormat("yyyyMMdd_HHmm");
+    public static final SimpleDateFormat YMDHMS2_FORMAT = new SimpleDateFormat("yyyyMMddHHmmss");
 
     /**
      * 鍒ゆ柇瀛楃涓�,鏄惁涓烘暣鏁�
@@ -62,6 +63,11 @@
      * 鏃ユ湡姝ｅ垯
      */
     public static Pattern datePattern = Pattern.compile("^((\\d{2}(([02468][048])|([13579][26]))[\\-\\/]((((0?[13578])|(1[02]))[\\-\\/]((0?[1-9])|([1-2][0-9])|(3[01])))|(((0?[469])|(11))[\\-\\/]((0?[1-9])|([1-2][0-9])|(30)))|(0?2[\\-\\/]((0?[1-9])|([1-2][0-9])))))|(\\d{2}(([02468][1235679])|([13579][01345789]))[\\-\\/]((((0?[13578])|(1[02]))[\\-\\/]((0?[1-9])|([1-2][0-9])|(3[01])))|(((0?[469])|(11))[\\-\\/]((0?[1-9])|([1-2][0-9])|(30)))|(0?2[\\-\\/]((0?[1-9])|(1[0-9])|(2[0-8]))))))(\\s(((0?[0-9])|([1-2][0-3]))\\:([0-5]?[0-9])((\\s)|(\\:([0-5]?[0-9])))))?$");
+
+    /**
+     * SQL姝ｅ垯
+     */
+    public static Pattern sqlPattern = Pattern.compile("|and|exec|execute|insert|select|delete|update|count|drop|\\*|%|chr|mid|master|truncate|char|declare|sitename|net user|xp_cmdshell|;|or|-|\\+|,|like");
 
     /**
      * 瀛楃涓茶浆涓烘棩鏈�
@@ -105,14 +111,35 @@
      * 瀛楃涓�,鏄惁涓虹┖null鍜岀┖鏍�
      */
     public static boolean isEmpty(String str) {
-        return str == null || "".equals(str.trim());
+        return null == str || "".equals(str.trim());
     }
 
     /**
      * 鑾峰彇 like 瀛楃涓�
      */
-    public static String getLikeStr(String name) {
-        return StringHelper.isEmpty(name) ? null : "%" + name.trim() + "%";
+    public static String getLikeStr(String str) {
+        return StringHelper.isEmpty(str) ? null : "%" + str.trim() + "%";
+    }
+
+    /**
+     * 鑾峰彇 like 瀛楃涓�-2
+     */
+    public static String getLikeStr2(String str) {
+        return StringHelper.isEmpty(str) ? "%" : "%" + str.trim() + "%";
+    }
+
+    /**
+     * 鑾峰彇鍥惧舰鐨刉KT瀛楃涓�
+     *
+     * @param wkt
+     * @return
+     */
+    public static String getGeomWkt(String wkt) {
+        if (StringHelper.isEmpty(wkt)) {
+            return "null";
+        }
+
+        return String.format("ST_GeomFromText('%s')", wkt);
     }
 
     /**
@@ -130,6 +157,18 @@
     }
 
     /**
+     * 鍒ゆ柇鍊兼槸鍚﹀瓨鍦⊿QL娉ㄥ叆
+     *
+     * @param str 瀛楃涓�
+     * @return 鏄�/鍚�
+     */
+    public static boolean isSqlInjection(String str) {
+        Matcher m = sqlPattern.matcher(str);
+
+        return m.matches();
+    }
+
+    /**
      * 鏍￠獙瀵嗙爜鏄�/鍚﹀悎娉�
      *
      * @param pwd 瀵嗙爜
@@ -138,4 +177,31 @@
     public static boolean checkPwdValid(String pwd) {
         return Pattern.matches(StaticData.PWD_REG, pwd);
     }
+
+    /**
+     * 杩炴帴List闆嗗悎
+     *
+     * @param list list 鏁存暟闆嗗悎
+     * @param join join 杩炴帴瀛楃
+     * @param <T>  娉涘瀷绫�
+     * @return 瀛楃涓�
+     */
+    public static <T> String join(List<T> list, String join) {
+        if (null == list || list.isEmpty()) {
+            return "";
+        }
+
+        StringBuilder sb = new StringBuilder();
+        for (T t : list) {
+            if (null != t) {
+                sb.append(t.toString() + join);
+            }
+        }
+
+        if (sb.length() > 0 && sb.lastIndexOf(join) == sb.length() - 1) {
+            sb.deleteCharAt(sb.length() - 1);
+        }
+
+        return sb.toString();
+    }
 }

--
Gitblit v1.9.3