From f6573cd9038a036d0bba826655c34ac347926ab0 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 07 四月 2023 13:56:52 +0800
Subject: [PATCH] 1
---
/dev/null | 8 -
src/main/java/service/MainService.java | 18 +++
src/main/java/com/terra/coal/controller/MainController.java | 35 +++++++
src/main/java/com/terra/coal/helper/StringHelper.java | 217 +++++++++++++++++++++++++++++++++++++++++++
4 files changed, 270 insertions(+), 8 deletions(-)
diff --git a/src/main/java/com/terra/coal/controller/MainController.java b/src/main/java/com/terra/coal/controller/MainController.java
index e58fffa..0c52b85 100644
--- a/src/main/java/com/terra/coal/controller/MainController.java
+++ b/src/main/java/com/terra/coal/controller/MainController.java
@@ -1,14 +1,21 @@
package com.terra.coal.controller;
+import com.terra.coal.entity.ResponseMsg;
+import com.terra.coal.helper.StringHelper;
import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiImplicitParam;
+import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.ModelAndView;
+import service.MainService;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
+import java.io.File;
/**
* CoalController
@@ -18,6 +25,9 @@
@RestController
@RequestMapping("/main")
public class MainController extends BaseController {
+ @Autowired
+ MainService mainService;
+
@ApiOperation(value = "璺宠浆棣栭〉")
@GetMapping({"/", "/toIndex"})
public ModelAndView toIndex(ModelAndView mv, HttpServletRequest req) {
@@ -34,4 +44,29 @@
return mv;
}
+
+ @ApiOperation(value = "鍔犺浇54鏁版嵁鍏ュ簱")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "txtPath", value = "鍧椾綋鏁版嵁鏂囦欢璺緞", dataType = "String", paramType = "query", example = "D:\\鍧椾綋鏁版嵁.txt")
+ })
+ @GetMapping(value = "/load54Data")
+ public ResponseMsg<Integer> load54Data(String txtPath) {
+ try {
+ if (StringHelper.isEmpty(txtPath)) {
+ return fail("璇烽�夋嫨鈥樺潡浣撴暟鎹�.txt鈥�", null);
+ }
+
+ File f = new File(txtPath);
+ if (!f.exists() || f.isDirectory()) {
+ return fail("鏂囦欢涓嶅瓨鍦�", null);
+ }
+
+ Integer rows = mainService.load54Data(f);
+
+ return success("鎴愬姛", rows);
+ } catch (Exception ex) {
+ log.error(ex.getMessage(), ex);
+ return fail(ex.getMessage(), null);
+ }
+ }
}
diff --git a/src/main/java/com/terra/coal/helper/StringHelper.java b/src/main/java/com/terra/coal/helper/StringHelper.java
new file mode 100644
index 0000000..5f19f16
--- /dev/null
+++ b/src/main/java/com/terra/coal/helper/StringHelper.java
@@ -0,0 +1,217 @@
+package com.terra.coal.helper;
+
+import java.text.SimpleDateFormat;
+import java.util.Date;
+import java.util.List;
+import java.util.UUID;
+import java.util.regex.Matcher;
+import java.util.regex.Pattern;
+
+/**
+ * StringHelper
+ * @author WWW
+ */
+public class StringHelper {
+ /**
+ * 鏁板瓧姝ｅ垯
+ */
+ public static final Pattern NUMBER_PATTERN = Pattern.compile("-?\\d+(\\.\\d+)?");
+
+ /**
+ * 鏍煎紡鍖栧綋鍓嶇郴缁熸棩鏈� 1
+ */
+ public static final SimpleDateFormat YMD_FORMAT = new SimpleDateFormat("yyyy-MM-dd");
+
+ /**
+ * 鏍煎紡鍖栧綋鍓嶇郴缁熸棩鏈� 2
+ */
+ public static final SimpleDateFormat YMDHMS_FORMAT = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+
+ /**
+ * 鏍煎紡鍖栧綋鍓嶇郴缁熸棩鏈� 3
+ */
+ public static final SimpleDateFormat YMD2_FORMAT = new SimpleDateFormat("yyyyMMdd");
+
+ /**
+ * 鏍煎紡鍖栧綋鍓嶇郴缁熸棩鏈� 4
+ */
+ public static final SimpleDateFormat YMDHMS2_FORMAT = new SimpleDateFormat("yyyyMMddHHmmss");
+
+ /**
+ * 鍒ゆ柇瀛楃涓�,鏄惁涓烘暣鏁�
+ */
+ public static boolean isInteger(String str) {
+ return str != null && str.matches("[0-9]+");
+ }
+
+ /**
+ * 鍒ゆ柇瀛楃涓�,鏄惁涓烘诞鐐规暟
+ */
+ public static boolean isNumeric(String str) {
+ return str != null && str.matches("-?\\d+(\\.\\d+)?");
+ }
+
+ /**
+ * 鍒ゆ柇瀛楃涓�,鏄惁涓烘诞鐐规暟
+ */
+ public static boolean isNumeric2(String str) {
+ return str != null && NUMBER_PATTERN.matcher(str).matches();
+ }
+
+ /**
+ * 鏃ユ湡姝ｅ垯
+ */
+ 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");
+
+ /**
+ * 瀛楃涓茶浆涓烘棩鏈�
+ */
+ public static Date parseDate(String str) {
+ try {
+ return YMD_FORMAT.parse(str);
+ } catch (Exception ex) {
+ return null;
+ }
+ }
+
+ /**
+ * 瀛楃涓茶浆涓烘棩鏈熸椂闂�
+ */
+ public static Date parseTime(String str) {
+ try {
+ return YMDHMS_FORMAT.parse(str);
+ } catch (Exception e) {
+ return null;
+ }
+ }
+
+ /**
+ * 鍒ゆ柇鍊兼槸鍚︿负鏃ユ湡鏍煎紡
+ */
+ public static boolean isDate(String strDate) {
+ Matcher m = datePattern.matcher(strDate);
+
+ return m.matches();
+ }
+
+ /**
+ * 瀛楃涓诧紝鏄惁涓簄ull 鎴� ""
+ */
+ public static boolean isNull(String str) {
+ return null == str || str.length() == 0;
+ }
+
+ /**
+ * 瀛楃涓�,鏄惁涓虹┖null鍜岀┖鏍�
+ */
+ public static boolean isEmpty(String str) {
+ return null == str || "".equals(str.trim());
+ }
+
+ /**
+ * 鑾峰彇 like 瀛楃涓�
+ */
+ public static String getLikeStr(String str) {
+ return StringHelper.isEmpty(str) ? null : "%" + str.trim() + "%";
+ }
+
+ /**
+ * 鑾峰彇 like 瀛楃涓�
+ */
+ public static String getLikeUpperStr(String str) {
+ return StringHelper.isEmpty(str) ? null : "%" + str.trim().toUpperCase() + "%";
+ }
+
+ /**
+ * 鑾峰彇 鍙砽ike 瀛楃涓�
+ */
+ public static String getRightLike(String str) {
+ return StringHelper.isEmpty(str) ? null : 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);
+ }
+
+ /**
+ * 棣栧瓧姣嶅ぇ鍐�
+ */
+ public static String firstCharToUpperCase(String str) {
+ return str.substring(0, 1).toUpperCase() + str.substring(1);
+ }
+
+ /**
+ * 棣栧瓧姣嶅皬鍐�
+ */
+ public static String firstCharToLowerCase(String str) {
+ return str.substring(0, 1).toLowerCase() + str.substring(1);
+ }
+
+ /**
+ * 鍒ゆ柇鍊兼槸鍚﹀瓨鍦⊿QL娉ㄥ叆
+ *
+ * @param str 瀛楃涓�
+ * @return 鏄�/鍚�
+ */
+ public static boolean isSqlInjection(String str) {
+ if (null == str) {
+ return false;
+ }
+
+ Matcher m = sqlPattern.matcher(str);
+
+ return m.matches();
+ }
+
+ /**
+ * 鑾峰彇GUID
+ *
+ * @return
+ */
+ public static String getGuid() {
+ return UUID.randomUUID().toString();
+ }
+
+ /**
+ * 杩炴帴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() - join.length()) {
+ // 鍒犻櫎浠庣储寮� start 寮�濮嬪埌 end 涔嬮棿鐨勫瓧绗︼紝鍗� 鍓嶅寘鎷� 鍚庝笉鍖呮嫭銆�
+ sb.delete(sb.length() - join.length(), sb.length());
+ }
+
+ return sb.toString();
+ }
+}
diff --git a/src/main/java/service/CoalService.java b/src/main/java/service/CoalService.java
deleted file mode 100644
index 824c3d6..0000000
--- a/src/main/java/service/CoalService.java
+++ /dev/null
@@ -1,8 +0,0 @@
-package service;
-
-/**
- * CoalService
- * @author WWW
- */
-public class CoalService {
-}
diff --git a/src/main/java/service/MainService.java b/src/main/java/service/MainService.java
new file mode 100644
index 0000000..34b3f24
--- /dev/null
+++ b/src/main/java/service/MainService.java
@@ -0,0 +1,18 @@
+package service;
+
+import org.springframework.stereotype.Service;
+
+import java.io.File;
+
+/**
+ * CoalService
+ * @author WWW
+ */
+@Service
+public class MainService {
+ public Integer load54Data(File f){
+
+
+ return 0;
+ }
+}
--
Gitblit v1.9.3