SpringBoot 整合 Mybatis

1、整合说明

　　Spring Boot默认没有对mybatis支持，而是Mybatis对springboot进行了支持。所以Spring Boot整合Mybatis的整合包要去Mybatis的的官方寻找。

　　官方路径：https://github.com/mybatis/spring-boot-starter

　　Maven 路径：http://www.mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/

2、配置流程

　　① 创建一个 Maven 项目

　　② 在 pom.xml 导入需要的依赖包

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>cn.mgy</groupId>
    <artifactId>spring-boot-demo-01</artifactId>
    <version>1.0</version>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.4.RELEASE</version>
    </parent>
    <dependencies>
        <!-- freemarker支持包 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-freemarker</artifactId>
        </dependency>
        <!--mybatis支持包 -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.0</version>
        </dependency>
        <!-- 数据库驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!-- dbcp2连接池 -->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
        </dependency>
        <!-- Springboot测试包 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
        </dependency>
    </dependencies>
</project>

 　　③ 创建包，并且创建三个类

　　④ 编写一个 Application.java 类

package cn.mgy;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication(scanBasePackages="cn.mgy")
public class Application {
    
    public static void main(String[] args) {
        SpringApplication.run(Application.class, args);
    }

}

　　⑤ 编写配置文件 application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/school
spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=root
#dbcp2 datasource
spring.datasource.type=org.apache.commons.dbcp2.BasicDataSource

　　⑥ 测试数据源

package cn.mgy.test;

import java.sql.SQLException;

import javax.sql.DataSource;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest
public class DataSourceTest {
    
    @Autowired
    private DataSource dataSource;

    @Test
    public void dataSource() {
        try {
            System.out.println(dataSource.getConnection());
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

}

　　⑦ 测试数据源正确后，编写 StudentMapper.java 接口

package cn.mgy.mapper;
import java.util.Map;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

//注意,使用的Mapper而不是@Repository
@Mapper
public interface StudentMapper {
    
    @Insert(value="INSERT INTO student    (SNAME, SEX, BIRTHDAY, AGE)    VALUES (#{sname}, #{sex},#{birthday}, #{age})")
    public int insert(Map<String,Object> entity);

}

　　⑧ 编写一个 Service 类

package cn.mgy.service;
import java.util.Map;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import cn.gzsxt.mapper.StudentMapper;

@Service
public class StudentService {
    
    @Autowired
    private StudentMapper studentMapper;
    public int insert(Map<String,Object> entity){
        return studentMapper.insert(entity);
    }
}

　　⑨ 编写一个 Controller 类

package cn.mgy.controller;

import java.util.HashMap;
import java.util.Map;
import javax.servlet.http.HttpSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import cn.mgy.service.StudentService;

@Controller
public class StudentController {
    @Autowired
    private StudentService studentService;
    @RequestMapping(value="/index")
    public String index(Model model,HttpSession session){
        System.out.println("-测试插入数据-");
        Map<String, Object> entity=new HashMap<String, Object>();
        //插入数据
        entity.put("sname", "test3");
        studentService.insert(entity);
        return "index";
    }
}

　　⑩ 启动程序测试

　　启动成功：提示使用 8080 端口访问

　　在浏览器执行访问

　　查看数据库结果，成功