From 679b6d0e2104d58525fe69be167a7ce756af2dee Mon Sep 17 00:00:00 2001 From: zhuo <2089219845@qq.com> Date: 星期一, 26 二月 2024 15:38:24 +0800 Subject: [PATCH] 新增模块 --- cnas-server/src/main/resources/mapper/RoleMapper.xml | 10 +++++ cnas-server/src/main/resources/mapper/EnumMapper.xml | 34 +++++++++++++++++ cnas-server/pom.xml | 24 ++++++++++++ cnas-server/src/main/resources/mapper/PowerMapper.xml | 15 +++++++ pom.xml | 1 system-run/pom.xml | 6 +++ cnas-server/src/main/resources/mapper/UserMapper.xml | 16 ++++++++ 7 files changed, 106 insertions(+), 0 deletions(-) diff --git a/cnas-server/pom.xml b/cnas-server/pom.xml new file mode 100644 index 0000000..7685e5e --- /dev/null +++ b/cnas-server/pom.xml @@ -0,0 +1,24 @@ +<?xml version="1.0" encoding="UTF-8"?> +<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> + <modelVersion>4.0.0</modelVersion> + <parent> + <artifactId>mom</artifactId> + <groupId>com.yuanchu.mom</groupId> + <version>1.0.0</version> + </parent> + + <artifactId>cnas-server</artifactId> + <version>0.0.1-SNAPSHOT</version> + <name>user-server</name> + <description>cnas-server</description> + <packaging>jar</packaging> + + <dependencies> + <dependency> + <groupId>com.yuanchu.mom</groupId> + <artifactId>framework</artifactId> + <version>0.0.1-SNAPSHOT</version> + </dependency> + </dependencies> +</project> diff --git a/cnas-server/src/main/resources/mapper/EnumMapper.xml b/cnas-server/src/main/resources/mapper/EnumMapper.xml new file mode 100644 index 0000000..9f3dee1 --- /dev/null +++ b/cnas-server/src/main/resources/mapper/EnumMapper.xml @@ -0,0 +1,34 @@ +<?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.yuanchu.mom.mapper.EnumMapper"> + + <resultMap id="BaseResultMap" type="com.yuanchu.mom.pojo.Enums"> + <id property="id" column="id" jdbcType="INTEGER"/> + <result property="label" column="label" jdbcType="VARCHAR"/> + <result property="value" column="value" jdbcType="VARCHAR"/> + <result property="createUser" column="create_user" jdbcType="INTEGER"/> + <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/> + <result property="updateUser" column="update_user" jdbcType="INTEGER"/> + <result property="updateTime" column="update_time" jdbcType="TIMESTAMP"/> + </resultMap> + + <sql id="Base_Column_List"> + id,label,value, + create_user,create_time,update_user, + update_time + </sql> + + <select id="selectEnumPageList" resultType="com.yuanchu.mom.pojo.Enums"> + select * from ( + select e.id,e.category,e.label,e.value, u2.name create_user_name,e.create_time, u3.name update_user_name, e.update_time + from enums e + left join user u2 on u2.id = e.create_user + left join user u3 on u3.id = e.update_user + ) a + <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''"> + ${ew.customSqlSegment} + </if> + </select> +</mapper> diff --git a/cnas-server/src/main/resources/mapper/PowerMapper.xml b/cnas-server/src/main/resources/mapper/PowerMapper.xml new file mode 100644 index 0000000..e87e79e --- /dev/null +++ b/cnas-server/src/main/resources/mapper/PowerMapper.xml @@ -0,0 +1,15 @@ +<?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.yuanchu.mom.mapper.PowerMapper"> + + <resultMap id="BaseResultMap" type="com.yuanchu.mom.pojo.Power"> + <id property="id" column="id" jdbcType="INTEGER"/> + <result property="roleId" column="role_id" jdbcType="INTEGER"/> + <result property="menuMethod" column="menu_method" jdbcType="VARCHAR"/> + <result property="look" column="look" jdbcType="TINYINT"/> + <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/> + <result property="createUser" column="create_user" jdbcType="INTEGER"/> + </resultMap> +</mapper> diff --git a/cnas-server/src/main/resources/mapper/RoleMapper.xml b/cnas-server/src/main/resources/mapper/RoleMapper.xml new file mode 100644 index 0000000..e5b1926 --- /dev/null +++ b/cnas-server/src/main/resources/mapper/RoleMapper.xml @@ -0,0 +1,10 @@ +<?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.yuanchu.mom.mapper.RoleMapper"> + <insert id="addPower"> + + </insert> + <select id="selectMenuList" resultType="com.yuanchu.mom.pojo.Menu"> + select method,remark,type from menu + </select> +</mapper> \ No newline at end of file diff --git a/cnas-server/src/main/resources/mapper/UserMapper.xml b/cnas-server/src/main/resources/mapper/UserMapper.xml new file mode 100644 index 0000000..b51610f --- /dev/null +++ b/cnas-server/src/main/resources/mapper/UserMapper.xml @@ -0,0 +1,16 @@ +<?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.yuanchu.mom.mapper.UserMapper"> + <select id="selectUserDtoPageList" resultType="com.yuanchu.mom.dto.UserPageDto"> + select * from ( + select u1.id, u1.account, u1.name, u1.state, u1.create_time, u1.update_time, u1.create_user, u1.update_user, u1.age, u1.email, u1.phone, u1.department, u1.company, u1.role_id, u2.name create_user_name, u3.name update_user_name, r.name role_name + from user u1 + left join user u2 on u2.id = u1.create_user + left join user u3 on u3.id = u1.update_user + left join role r on u1.role_id = r.id + ) a + <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''"> + ${ew.customSqlSegment} + </if> + </select> +</mapper> \ No newline at end of file diff --git a/pom.xml b/pom.xml index 50b9ca5..538a30a 100644 --- a/pom.xml +++ b/pom.xml @@ -19,6 +19,7 @@ <module>framework</module> <module>user-server</module> <module>system-run</module> + <module>cnas-server</module> </modules> <properties> diff --git a/system-run/pom.xml b/system-run/pom.xml index f94e371..9732476 100644 --- a/system-run/pom.xml +++ b/system-run/pom.xml @@ -28,6 +28,12 @@ <version>0.0.1-SNAPSHOT</version> </dependency> + <dependency> + <groupId>com.yuanchu.mom</groupId> + <artifactId>cnas-server</artifactId> + <version>0.0.1-SNAPSHOT</version> + </dependency> + <!--druid--> <dependency> <groupId>com.alibaba</groupId> -- Gitblit v1.9.3