SpringBoot整合Mybatis和Mysql

步骤

第一步：创建一个Spring Boot项目，选择相关依赖。

 第二步：配置端口数据库连接和Mybatis文件扫描路径，我这里把mapper.xml文件配置在src/main/resources/mapper下。

server.port=8010

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/xxl_job?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

mybatis.mapper-locations=classpath:/mapper/*.xml

第三步：写MVC三层架构接口。

Controller

package com.ctx.demo;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;
import java.util.Map;

@RestController
public class MyController {
    @Autowired
    private Service service;
    /**
     * http://localhost:8010/fun
     * @return
     */
    @GetMapping("/fun")
    public String fun(){
        return "hello world!";
    }


    @PostMapping("/getList")
    public List<Map<String,Object>> getList(){
        return service.getList();
    }

}

Interface

package com.ctx.demo;


import java.util.List;
import java.util.Map;

public interface Service {
    /**
     * @return
     */
    public List<Map<String,Object>> getList();
}

Service

package com.ctx.demo;
import com.ctx.demo.mapper.MyMapper;
import org.springframework.beans.factory.annotation.Autowired;

import java.util.List;
import java.util.Map;

@org.springframework.stereotype.Service
public class ServiceImpl implements Service{

    @Autowired
    private MyMapper mapper;
    @Override
    public List<Map<String,Object>> getList() {
        List<Map<String,Object>> list = mapper.getList();
        System.out.println(list);
        return list;
    }
}

Dao

package com.ctx.demo.mapper;

import java.util.List;
import java.util.Map;

@org.apache.ibatis.annotations.Mapper
public interface MyMapper {
    List<Map<String,Object>> getList();
}

Mapper.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.ctx.demo.mapper.MyMapper">


	<select id="getList" resultType="map">
		SELECT id,app_name FROM `xxl_job_group`
	</select>
</mapper>

第四步：启动测试。