自定义mapper.java,springboot配置自定义mapper.xml文件

1.声明mapper接口

package com.hundsun.one.mapper;

@Repository

public interface ResultUserRoleMapper extends BaseMapper {

/**

* 分页查询

* @param page

* @return

*/

Page pageUsers(@Param("page") Page page);

}

2.创建mapper配置文件

SELECT

u.username,u.name,u.employee_no,u.email,r.role_name,u.update_time

FROM mgr_user u

INNER JOIN mgr_user_role ur

ON u.user_id = ur.user_id

INNER JOIN mgr_role r

ON ur.role_id = r.role_id

3.启动类上扫描Mapper包

@EnableSwagger2

@SpringBootApplication

@MapperScan("com.hundsun.one.mapper")

public class OneApplication {

public static void main(String[] args) {

SpringApplication.run(OneApplication.class, args);

}

}

4.运行项目，