Feign实现模块间数据访问 - 有问题请留言,可以协助解决
项目结构
使用的是若依的Mybatis-plus版本
我的需求
在demo模块中调用system模块用户查询功能
我的代码
直接上代码
system模块代码
SysUserMapper.xml
<?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.ruoyi.system.mapper.SysUserMapper">
<resultMap type="SysUser" id="SysUserResult">
<id property="userId" column="user_id"/>
<result property="deptId" column="dept_id"/>
<result property="userName" column="user_name"/>
<result property="nickName" column="nick_name"/>
<result property="email" column="email"/>
<result property="phonenumber" column="phonenumber"/>
<result property="sex" column="sex"/>
<result property="avatar" column="avatar"/>
<result property="password" column="password"/>
<result property="status" column="status"/>
<result property="delFlag" column="del_flag"/>
<result property="loginIp" column="login_ip"/>
<result property="loginDate" column="login_date"/>
<result property="createBy" column="create_by"/>
<result property="createTime" column="create_time"/>
<result property="updateBy" column="update_by"/>
<result property="updateTime" column="update_time"/>
<result property="remark" column="remark"/>
<result property="schoolId" column="school_id"/>
<result property="grade" column="grade"/>
<result property="studentNum" column="student_num"/>
<result property="major" column="major"/>
<association property="dept" column="dept_id" javaType="SysDept" resultMap="deptResult"/>
<collection property="roles" javaType="java.util.List" resultMap="RoleResult"/>
</resultMap>
<resultMap id="deptResult" type="SysDept">
<id property="deptId" column="dept_id"/>
<result property="parentId" column="parent_id"/>
<result property="deptName" column="dept_name"/>
<result property="orderNum" column="order_num"/>
<result property="leader" column="leader"/>
<result property="status" column="dept_status"/>
</resultMap>
<resultMap id="RoleResult" type="SysRole">
<id property="roleId" column="role_id"/>
<result property="roleName" column="role_name"/>
<result property="roleKey" column="role_key"/>
<result property="roleSort" column="role_sort"/>
<result property="dataScope" column="data_scope"/>
<result property="status" column="role_status"/>
</resultMap>
<sql id="selectUserVo">
SELECT
u.user_id,
u.dept_id,
u.user_name,
u.nick_name,
u.email,
u.avatar,
u.phonenumber,
u.password,
u.sex,
u.status,
u.del_flag,
u.login_ip,
u.login_date,
u.create_by,
u.create_time,
u.remark,
u.school_id,
d.dept_id,
d.parent_id,
d.dept_name,
d.order_num,
d.leader,
d.status as dept_status,
r.role_id,
r.role_name,
r.role_key,
r.role_sort,
r.data_scope,
r.status as role_status
FROM sys_user u
LEFT JOIN sys_dept d on u.dept_id = d.dept_id
LEFT JOIN sys_user_role ur on u.user_id = ur.user_id
LEFT JOIN sys_role r on r.role_id = ur.role_id
</sql>
<select id="getUserForVerify" parameterType="String" resultMap="SysUserResult">
<include refid="selectUserVo"/>
<where>
<if test="nickName != null and nickName != ''">AND u.nick_name = #{
nickName}</if>
<if test="userName != null and userName != ''">AND u.user_name = #{
userName}</if>
<if test="schoolId != null and schoolId != ''">AND u.school_id = #{
schoolId}</if>
</where>
LIMIT 1
</select>
</mapper>
SysUserMapper.java
package com.ruoyi.system.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.core.domain.entity.SysUser;
import org.apache.ibatis.annotations.Param;
import java.util.List;
/**
* 用户表 数据层
*
* @author ruoyi
*/
public interface SysUserMapper extends BaseMapper<SysUser> {
/**
* 通过学生姓名&登录账号(学号)&学校主键查询用户
*
* @param nickName 学生姓名
* @param userName 登录账号(学号)
* @param schoolId 学校主键
* @return 用户对象信息
*/
public SysUser getUserForVerify(@Param("nickName") String nickName, @Param("userName") String userName, @Param("schoolId") String schoolId);
}
ISysUserService.java
package com.ruoyi.system.service;
import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.common.core.domain.entity.SysUser;
import java.util.List;
/**
* 用户 业务层
*
* @author ruoyi
*/
public interface ISysUserService extends IService<SysUser> {
/**
* 通过学生姓名&登录账号(学号)&学校主键查询用户
*
* @param nickName 学生姓名
* @param userName 登录账号(学号)
* @param schoolId 学校主键
* @return 用户对象信息
*/
public SysUser getUserForVerify(String nickName, String userName, String schoolId);
}
SysUserServiceImpl.java
package com.ruoyi.system.service.impl;
import cn.hutool.core.lang.Validator;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.system.mapper.*;
imp