SpringBoot整合mybatis的简单过程

记录springboot整合mybatis的过程，以防忘记

主程序

@MapperScan("com.tx.connect.mapping")	//扫描mapping
@ServletComponentScan	//druid，识别servlet时使用，利用java配置druid配置
@SpringBootApplication(scanBasePackages = "com.tx.connect.*")
public class JdbcApplication {

    public static void main(String[] args) {
        SpringApplication.run(JdbcApplication.class, args);
    }
}

mapping(dao)层：

@Mapper	//mybatis标识
@Repository	//注册组件(bean)
public interface RoleMapping {

    /**
     * mybatis连接练习
     * @return 返回查询到的所有信息
     */
    public List<Role> queryRole();
}

mapping.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.tx.connect.mapping.RoleMapping">
    <select id="queryRole" resultType="Role">
    select * from code.role
  </select>
</mapper>

yaml配置

mybatis:
  type-aliases-package: com.tx.ac.pojo	//别名
  mapper-locations: classpath:mybatis/mapping/*.xml //注册

service层

@Service //注册组件(bean)
public interface RoleService {

    /**
     * mybatis练习
     * @return 返回查询到的所有信息
     */
    public List<Role> queryRole();
}

@Service //注册组件(bean)
public class RoleServiceImpl implements RoleService{

    @Autowired
    private RoleMapping roleMapping;	//利用mapping接口注册，自动导入
    
    @Override
    public List<Role> queryRole() {
        return roleMapping.queryRole();
    }
}

Controller层

@Controller
public class JdbcController {

    @Autowired
    private RoleService roleService;


    @GetMapping("/role")
    @ResponseBody
    public List<Role> getRole(){
        return this.roleService.queryRole();
    }