From be1c643d8e723dc717be2e4c1d8c329da648524b Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 31 十月 2022 10:24:21 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/service/all/BaseQueryService.java | 23 +++++++++++
src/main/resources/mapper/all/BaseQueryMapper.xml | 23 +++++++++++
data/db_fn.sql | 10 +++++
src/main/java/com/lf/server/controller/all/BaseQueryController.java | 4 +-
说明.txt | 7 ---
src/main/java/com/lf/server/mapper/all/BaseQueryMapper.java | 31 +++++++++++++++
6 files changed, 89 insertions(+), 9 deletions(-)
diff --git a/data/db_fn.sql b/data/db_fn.sql
index bdeaead..985f573 100644
--- a/data/db_fn.sql
+++ b/data/db_fn.sql
@@ -252,6 +252,16 @@
and ST_Intersects(geom,
ST_PolygonFromText('POLYGON ((115.94927385452 32.3754479115071 0,121.989371092554 32.2766788010181 0,121.850621222894 29.6874200067864 0,115.9727267226 29.7835368627922 0,115.94927385452 32.3754479115071 0))', 4326))
+select id,uname "name" from lf.sys_user where uname like '%瀹�%' order by uname limit 10;
+select id,name from lf.sys_dep where name like '%鍙�%' order by order_num limit 10;
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/lf/server/controller/all/BaseQueryController.java b/src/main/java/com/lf/server/controller/all/BaseQueryController.java
index 3775718..01e22c4 100644
--- a/src/main/java/com/lf/server/controller/all/BaseQueryController.java
+++ b/src/main/java/com/lf/server/controller/all/BaseQueryController.java
@@ -158,7 +158,7 @@
@GetMapping(value = "/selectUserFuzzy")
public ResponseMsg<List<IdNameEntity>> selectUserFuzzy(String name) {
try {
- List<IdNameEntity> rs = null;
+ List<IdNameEntity> rs = baseQueryService.selectUserFuzzy(name);
return success(rs);
} catch (Exception ex) {
@@ -174,7 +174,7 @@
@GetMapping(value = "/selectDepFuzzy")
public ResponseMsg<List<IdNameEntity>> selectDepFuzzy(String name) {
try {
- List<IdNameEntity> rs = null;
+ List<IdNameEntity> rs = baseQueryService.selectDepFuzzy(name);
return success(rs);
} catch (Exception ex) {
diff --git a/src/main/java/com/lf/server/mapper/all/BaseQueryMapper.java b/src/main/java/com/lf/server/mapper/all/BaseQueryMapper.java
new file mode 100644
index 0000000..864baca
--- /dev/null
+++ b/src/main/java/com/lf/server/mapper/all/BaseQueryMapper.java
@@ -0,0 +1,31 @@
+package com.lf.server.mapper.all;
+
+import com.lf.server.entity.ctrl.IdNameEntity;
+import org.apache.ibatis.annotations.Mapper;
+import org.springframework.stereotype.Repository;
+
+import java.util.List;
+
+/**
+ * 鐖舵煡璇apper
+ * @author WWW
+ */
+@Mapper
+@Repository
+public interface BaseQueryMapper {
+ /**
+ * 妯＄硦鎼滅储鐢ㄦ埛
+ *
+ * @param name 鐢ㄦ埛鍚�
+ * @return 瀹炰綋绫婚泦鍚�
+ */
+ public List<IdNameEntity> selectUserFuzzy(String name);
+
+ /**
+ * 妯＄硦鎼滅储鍗曚綅
+ *
+ * @param name 鍗曚綅鍚�
+ * @return 瀹炰綋绫婚泦鍚�
+ */
+ public List<IdNameEntity> selectDepFuzzy(String name);
+}
diff --git a/src/main/java/com/lf/server/service/all/BaseQueryService.java b/src/main/java/com/lf/server/service/all/BaseQueryService.java
index 1429df2..306d2f9 100644
--- a/src/main/java/com/lf/server/service/all/BaseQueryService.java
+++ b/src/main/java/com/lf/server/service/all/BaseQueryService.java
@@ -2,14 +2,18 @@
import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.lf.server.entity.ctrl.IdNameEntity;
import com.lf.server.helper.AesHelper;
import com.lf.server.helper.ClassHelper;
import com.lf.server.helper.StringHelper;
+import com.lf.server.mapper.all.BaseQueryMapper;
import com.lf.server.mapper.all.BasicMapper;
import com.lf.server.mapper.all.GeomBaseMapper;
+import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.HashMap;
+import java.util.List;
import java.util.Map;
/**
@@ -17,7 +21,10 @@
* @author WWW
*/
@Service
-public class BaseQueryService {
+public class BaseQueryService implements BaseQueryMapper {
+ @Autowired
+ BaseQueryMapper baseQueryMapper;
+
/**
* 琛ㄥ悕Map
*/
@@ -197,4 +204,18 @@
return tabName;
}
+
+ @Override
+ public List<IdNameEntity> selectUserFuzzy(String name) {
+ name = StringHelper.getLikeStr(name);
+
+ return baseQueryMapper.selectUserFuzzy(name);
+ }
+
+ @Override
+ public List<IdNameEntity> selectDepFuzzy(String name) {
+ name = StringHelper.getLikeStr(name);
+
+ return baseQueryMapper.selectDepFuzzy(name);
+ }
}
diff --git a/src/main/resources/mapper/all/BaseQueryMapper.xml b/src/main/resources/mapper/all/BaseQueryMapper.xml
new file mode 100644
index 0000000..69aa1d6
--- /dev/null
+++ b/src/main/resources/mapper/all/BaseQueryMapper.xml
@@ -0,0 +1,23 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.lf.server.mapper.all.BaseQueryMapper">
+ <select id="selectUserFuzzy" resultType="com.lf.server.entity.ctrl.IdNameEntity">
+ select id,uname "name" from lf.sys_user
+ <where>
+ <if test="name != null">
+ uname like #{name}
+ </if>
+ </where>
+ order by uname limit 10
+ </select>
+
+ <select id="selectDepFuzzy" resultType="com.lf.server.entity.ctrl.IdNameEntity">
+ select id,name from lf.sys_dep
+ <where>
+ <if test="name != null">
+ name like #{name}
+ </if>
+ </where>
+ order by order_num limit 10
+ </select>
+</mapper>
\ No newline at end of file
diff --git "a/\350\257\264\346\230\216.txt" "b/\350\257\264\346\230\216.txt"
index 82e713e..7c9c51e 100644
--- "a/\350\257\264\346\230\216.txt"
+++ "b/\350\257\264\346\230\216.txt"
@@ -79,6 +79,7 @@
String pwd = RsaHelper.decrypt(user.getPwd());
String p1="Admin@123";
+boolean f = p1.equalsIgnoreCase("Some text here");
String p2= RsaHelper.encrypt(p1);
String p3= RsaHelper.decrypt(p2);
@@ -154,12 +155,6 @@
杩愮淮绠＄悊\杩愮淮鐩戞帶\榛戠櫧/鍚嶅崟锛� 鏂板銆佷慨鏀广�佸垹闄�
杩愮淮绠＄悊\绯荤粺閰嶇疆: 淇敼
----------------------------------------------------------------------------------------------------
-{
- "id": 2,
- "pwd": "000000",
- "salt": "Admin@123"
-}
-
// 鑾峰彇璇锋眰鏂瑰紡: GET
String getMethod()
--
Gitblit v1.9.3