From 59db94e4e113d5a145b7e9ebaf96cc972db3f6db Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期一, 15 四月 2024 15:45:18 +0800
Subject: [PATCH] 1、完善代码：mysql的varchar的长度就是中文汉字的数量 2、增加了系统设置管理
---
pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaUser.java | 2
pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/global/SysSetSv.java | 27 ++++++
pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaPrivilege.java | 2
pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaRole.java | 2
pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/global/SysSetCtrl.java | 42 ++++++++++
pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoBa/BaSysSetMapper.java | 19 ++++
pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/user/UserCtrl.java | 2
pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaSysSet.java | 52 +++++++++++++
pms-parent/pms-global/src/main/resources/mapper/BaSysSetMapper.xml | 46 +++++++++++
9 files changed, 190 insertions(+), 4 deletions(-)
diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoBa/BaSysSetMapper.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoBa/BaSysSetMapper.java
new file mode 100644
index 0000000..ff0dced
--- /dev/null
+++ b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoBa/BaSysSetMapper.java
@@ -0,0 +1,19 @@
+package com.dy.pmsGlobal.daoBa;
+
+import com.dy.pmsGlobal.pojoBa.BaSysSet;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.util.List;
+
+@Mapper
+public interface BaSysSetMapper {
+ /**
+ * 鏌ヨ鏌愪釜鐢ㄦ埛鎵�闅跺睘浜庣殑瑙掕壊
+ * @return List<BaSysSet>
+ */
+ List<BaSysSet> selectSingle() ;
+
+ int insert(BaSysSet record);
+
+ int insertSelective(BaSysSet record);
+}
\ No newline at end of file
diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/global/SysSetCtrl.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/global/SysSetCtrl.java
new file mode 100644
index 0000000..64c3f1d
--- /dev/null
+++ b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/global/SysSetCtrl.java
@@ -0,0 +1,42 @@
+package com.dy.pmsGlobal.global;
+
+
+import com.dy.common.aop.SsoPowerAop;
+import com.dy.common.webUtil.BaseResponse;
+import com.dy.common.webUtil.BaseResponseUtils;
+import com.dy.pmsGlobal.pojoBa.BaUser;
+import lombok.extern.slf4j.Slf4j;
+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;
+
+/**
+ * 绯荤粺璁剧疆
+ */
+@Slf4j
+@RestController
+@RequestMapping(path = "sysSet")
+@SuppressWarnings("unchecked")//java鐗堟湰瓒婇珮锛屽娉涘瀷绾︽潫瓒婁弗锛屾墍浠ラ厤缃甋uppressWarnings("unchecked")
+public class SysSetCtrl {
+
+ @Autowired
+ private SysSetSv sv;
+
+ /**
+ * 寰楀埌鍞竴绯荤粺璁剧疆
+ * @return 鍞竴绯荤粺璁剧疆
+ */
+ //@GetMapping(path = "one", consumes = MediaType.TEXT_PLAIN_VALUE)//鎸囧墠绔悜鍚庝紶鐨勫弬鏁扮被鍨�
+ @GetMapping(path = "one")
+ //@SsoAop() //鍙湁鐧诲綍楠岃瘉锛屾病鏈夋潈闄愰獙璇�
+ @SsoPowerAop(power = "-1") //鐧诲綍涓庢潈闄愬悓鏃堕獙璇�
+ public BaseResponse<BaUser> single() {
+ try {
+ return BaseResponseUtils.buildSuccess(this.sv.selectSingle());
+ } catch (Exception e) {
+ log.error("鏌ヨ涓�涓敤鎴锋暟鎹紓甯�", e);
+ return BaseResponseUtils.buildException(e.getMessage());
+ }
+ }
+}
diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/global/SysSetSv.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/global/SysSetSv.java
new file mode 100644
index 0000000..64743e6
--- /dev/null
+++ b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/global/SysSetSv.java
@@ -0,0 +1,27 @@
+package com.dy.pmsGlobal.global;
+
+
+import com.dy.pmsGlobal.daoBa.BaSysSetMapper;
+import com.dy.pmsGlobal.pojoBa.BaSysSet;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import java.util.List;
+
+@Slf4j
+@Service
+public class SysSetSv {
+ @Autowired
+ private BaSysSetMapper dao ;
+
+ public BaSysSet selectSingle(){
+ List<BaSysSet> list = this.dao.selectSingle() ;
+ if(list != null && list.size() > 0){
+ return list.get(0) ;
+ }else{
+ return null ;
+ }
+ }
+
+}
diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaPrivilege.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaPrivilege.java
index a5c4b52..2df3dde 100644
--- a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaPrivilege.java
+++ b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaPrivilege.java
@@ -48,7 +48,7 @@
* 鏉冮檺鍚嶇О
*/
@NotEmpty(message = "鏉冮檺鍚嶇О涓嶈兘涓虹┖") //涓嶈兘涓虹┖涔熶笉鑳戒负null
- @Length(message = "鏉冮檺鍚嶇О涓嶅ぇ浜巤max}瀛楋紝涓嶅皬浜巤min}瀛�", min = 2, max = 25)
+ @Length(message = "鏉冮檺鍚嶇О涓嶅ぇ浜巤max}瀛楋紝涓嶅皬浜巤min}瀛�", min = 2, max = 50)
public String name;
/**
diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaRole.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaRole.java
index 34d9f90..dc282fd 100644
--- a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaRole.java
+++ b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaRole.java
@@ -48,7 +48,7 @@
* 瑙掕壊鍚嶇О
*/
@NotEmpty(message = "濮撳悕涓嶈兘涓虹┖") //涓嶈兘涓虹┖涔熶笉鑳戒负null
- @Length(message = "濮撳悕涓嶅ぇ浜巤max}瀛楋紝涓嶅皬浜巤min}瀛�", min = 2, max = 25)
+ @Length(message = "濮撳悕涓嶅ぇ浜巤max}瀛楋紝涓嶅皬浜巤min}瀛�", min = 2, max = 50)
public String name;
/**
diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaSysSet.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaSysSet.java
new file mode 100644
index 0000000..62f7ab3
--- /dev/null
+++ b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaSysSet.java
@@ -0,0 +1,52 @@
+package com.dy.pmsGlobal.pojoBa;
+
+
+import com.alibaba.fastjson2.annotation.JSONField;
+import com.alibaba.fastjson2.writer.ObjectWriterImplToString;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.dy.common.po.BaseEntity;
+import jakarta.validation.constraints.NotEmpty;
+import lombok.*;
+import org.hibernate.validator.constraints.Length;
+
+/**
+ * 鐢ㄦ埛
+ */
+//2024-04-12涓嬮潰TableName涓嶇敤閰嶇疆琛ㄥ悕绉帮紙value="BaUser"鎴栤�渂a_user鈥濓級
+//鍙閫氳繃椹煎嘲鍛藉悕娉曞垯绫诲悕涓庤〃鍚嶅搴旇捣鏉ュ氨鍙互浜嗭紝濡傛灉涓嶈兘瀵瑰簲璧锋潵锛岄渶瑕佹寚瀹氳〃鍚嶇О
+//渚嬪@TableName(value="TestUser" autoResultMap = true)
+@TableName(value="ba_sys_set", autoResultMap = true)
+@Data
+@Builder
+@ToString
+@NoArgsConstructor
+@AllArgsConstructor
+public class BaSysSet implements BaseEntity {
+
+ public static final long serialVersionUID = 202404151528001L;
+ /**
+ * 涓婚敭
+ */
+ /* 濡傛灉涓嶆槑纭� type绫诲瀷锛孧P灏嗚嚜鍔ㄤ负鍏惰祴鍊硷紙闆姳ID锛�
+ IdType:
+ AUTO(0), //鑷
+ NONE(1), //鏈缃富閿�
+ INPUT(2), //鎵嬪姩杈撳叆
+ ASSIGN_ID(3), //榛樿鍏ㄥ眬鍞竴ID
+ ASSIGN_UUID(4), //鍏ㄥ眬鍞竴鐨� uuid
+ */
+ @JSONField(serializeUsing= ObjectWriterImplToString.class)
+ @TableId(value = "id", type = IdType.INPUT)
+ public Long id;
+
+ /**
+ * 绯荤粺鍚嶇О
+ */
+ @NotEmpty(message = "绯荤粺鍚嶇О涓嶈兘涓虹┖") //涓嶈兘涓虹┖涔熶笉鑳戒负null
+ @Length(message = "绯荤粺鍚嶇О涓嶅ぇ浜巤max}瀛楋紝涓嶅皬浜巤min}瀛�", min = 2, max = 30)
+ public String sysName;
+
+
+}
\ No newline at end of file
diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaUser.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaUser.java
index 434c5f7..4fefbde 100644
--- a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaUser.java
+++ b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoBa/BaUser.java
@@ -47,7 +47,7 @@
* 濮撳悕
*/
@NotEmpty(message = "濮撳悕涓嶈兘涓虹┖") //涓嶈兘涓虹┖涔熶笉鑳戒负null
- @Length(message = "濮撳悕涓嶅ぇ浜巤max}瀛楋紝涓嶅皬浜巤min}瀛�", min = 2, max = 25)
+ @Length(message = "濮撳悕涓嶅ぇ浜巤max}瀛楋紝涓嶅皬浜巤min}瀛�", min = 2, max = 50)
public String name;
/**
diff --git a/pms-parent/pms-global/src/main/resources/mapper/BaSysSetMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/BaSysSetMapper.xml
new file mode 100644
index 0000000..6297087
--- /dev/null
+++ b/pms-parent/pms-global/src/main/resources/mapper/BaSysSetMapper.xml
@@ -0,0 +1,46 @@
+<?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.dy.pmsGlobal.daoBa.BaSysSetMapper">
+ <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoBa.BaSysSet">
+ <!--@mbg.generated-->
+ <!--@Table ba_sys_set-->
+ <result column="id" property="id" />
+ <result column="sys_name" property="sysName" />
+ </resultMap>
+ <sql id="Base_Column_List">
+ <!--@mbg.generated-->
+ id, sys_name
+ </sql>
+
+ <select id="selectSingle" resultMap="BaseResultMap">
+ select <include refid="Base_Column_List" />
+ from ba_sys_set
+ </select>
+
+
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoBa.BaSysSet">
+ <!--@mbg.generated-->
+ insert into ba_sys_set (id, sys_name)
+ values (#{id}, #{sysName})
+ </insert>
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoBa.BaSysSet">
+ <!--@mbg.generated-->
+ insert into ba_sys_set
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="id != null">
+ id,
+ </if>
+ <if test="sysName != null">
+ sys_name,
+ </if>
+ </trim>
+ <trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="id != null">
+ #{id},
+ </if>
+ <if test="sysName != null">
+ #{sysName},
+ </if>
+ </trim>
+ </insert>
+</mapper>
\ No newline at end of file
diff --git a/pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/user/UserCtrl.java b/pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/user/UserCtrl.java
index a7c9605..2c16460 100644
--- a/pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/user/UserCtrl.java
+++ b/pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/user/UserCtrl.java
@@ -22,7 +22,7 @@
import java.util.Objects;
/**
- * 娴嬭瘯
+ * 鐢ㄦ埛绠＄悊
*/
@Slf4j
@RestController
--
Gitblit v1.8.0