SpringBoot+Mybatis+前后台隔离技术，完整源码

package com.joy.dao; import java.util.List; import java.util.Map; import org.apache.ibatis.annotations.*; import com.joy.entity.SysRole; import com.joy.entity.SysUser; import com.joy.entity.UserEntity; public interface UserMapper { @Select("<script>"+"select * from user"+"<where> "+ " <if test=\"nickName!= '' \"> " + "nick_name LIKE #{nickName}</if> " + " </where> " +" </script> ") @Results({ @Result(property = "userId", column = "user_id"), @Result(property = "nickName", column = "nick_name"), @Result(property = "userCode", column = "user_code"), @Result(property = "userName", column = "user_name"), @Result(property = "userPwd", column = "user_pwd"), @Result(property = "createDate", column = "create_date"), @Result(property = "updateDate", column = "update_date") }) public List<UserEntity> queryList(@Param(value="nickName") String nickName); @Select("SELECT * FROM USER WHERE user_id = #{userId}") @Results({ @Result(property = "userId", column = "user_id"), @Result(property = "nickName", column = "nick_name"), @Result(property = "userCode", column = "user_code"), @Result(property = "userName", column = "user_name"), @Result(property = "userPwd", column = "user_pwd"), @Result(property = "createDate", column = "create_date"), @Result(property = "updateDate", column = "update_date") }) UserEntity findById(long userId); @Insert("INSERT INTO USER(nick_name, user_code) VALUES(#{nickName}, #{userCode})") int insertParam(@Param("nickName") String nickName, @Param("userCode") String userCode); @Insert("INSERT INTO USER(nick_name, user_code) VALUES(#{nickName,jdbcType=VARCHAR}, #{userCode,jdbcType=INTEGER})") int insertByMap(Map<String, Object> map); @Insert("insert into user(nick_name,user_code,user_name,user_pwd,create_date,update_date) values(#{nickName},#{userCode},#{userName},#{userPwd},#{createDate},#{updateDate})") public int insertEntity(UserEntity entity); @Update("UPDATE user SET nick_name=#{nickName} WHERE user_id=#{userId}") int updateEntity(UserEntity user); @Delete("DELETE FROM user WHERE user_id =#{userId}") int delete(Long userId); @Delete("DELETE FROM user WHERE user_id =#{userId}") int deleteEntity(UserEntity entity); @Select("select id,password,username from sys_user where username = #{username}") @Results({@Result(property = "id",column = "id"), @Result(property = "username",column = "username"), @Result(property = "password",column = "password"), @Result(property = "roles",javaType = List.class,column ="id", many = @Many(select = "com.joy.dao.UserMapper.findByUserid"))}) public SysUser findByUserName(@Param(value="username") String username); @Select("select s.id,s.name FROM sys_role_user sru,sys_role s WHERE sru.Sys_Role_id = s.id AND sru.Sys_User_id = #{id}") public List<SysRole> findByUserid(Integer id); }