Springboot+Mybatis(xml)+MySql整合

此次主要是记录Springboot+Mybatis(xml)+MySql整合的过程
开发工具：eclipse
框架：SpringBoot、Mybatis、Maven

1. 创建一个maven项目
   File ->New->Maven Project
   
   
2. 目录结构
   
3. pom文件

<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>wmq.fly</groupId>
  <artifactId>wfboot</artifactId>
  <version>0.0.1-SNAPSHOT</version>

  <!-- 引入SpringBoot父类依赖 -->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.3.3.RELEASE</version>
    </parent>
    <dependencies>
        <!-- SpringBoot web 组件 springmvc+spring+mybatis -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!-- 引入连接数据库依赖 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.21</version>
        </dependency>
        <!-- 引入mybatis依赖 -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
    </dependencies>
</project>

4 application.yml配置

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/school?characterEncoding=utf-8
    driver-class-name: com.mysql.jdbc.Driver
    username: root
    password: 1234

mybatis:
  typeAliasesPackage: wmq.fly.mybatis.entity
  mapperLocations: classpath:wmq/fly/mybatis/mappers/*Mapper.xml 

server:
  port: 9999

5.StuInfoController.java

package wmq.fly.mybatis.controller;

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

import wmq.fly.mybatis.service.StuInfoService;

@RestController
public class StuInfoController {

    @Autowired
    private StuInfoService stuInfoService;

    @RequestMapping(value = "/stuInfo/getAllStuInfo")
    public Object getAllStuInfo() {
        return stuInfoService.getAllStuInfo();
    }
}

6.StuInfoService.java

package wmq.fly.mybatis.service;

public interface StuInfoService {

    Object getAllStuInfo();

}

7.StuInfoServiceImpl.java

package wmq.fly.mybatis.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import wmq.fly.mybatis.dao.StuInfoMapper;


@Service
public class StuInfoServiceImpl implements StuInfoService {
    @Autowired
    private StuInfoMapper stuInfoMapper;

    public Object getAllStuInfo() {
        return stuInfoMapper.selectAllStuInfo();
    }
}

8.StuInfoMapper.java

package wmq.fly.mybatis.dao;

import java.util.List;
import org.springframework.stereotype.Repository;

import wmq.fly.mybatis.entity.StuInfo;


@Repository
public interface StuInfoMapper {

    List<StuInfo> selectAllStuInfo();
}

9.StuInfo.java

package wmq.fly.mybatis.entity;

public class StuInfo {
    private Integer id;

    private Integer teacherId;

    private String stuName;

    private String stuNo;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public Integer getTeacherId() {
        return teacherId;
    }

    public void setTeacherId(Integer teacherId) {
        this.teacherId = teacherId;
    }

    public String getStuName() {
        return stuName;
    }

    public void setStuName(String stuName) {
        this.stuName = stuName == null ? null : stuName.trim();
    }

    public String getStuNo() {
        return stuNo;
    }

    public void setStuNo(String stuNo) {
        this.stuNo = stuNo == null ? null : stuNo.trim();
    }
}

11.StuInfoMapper.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="wmq.fly.mybatis.dao.StuInfoMapper">
  <resultMap id="BaseResultMap" type="wmq.fly.mybatis.entity.StuInfo">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="teacherId" jdbcType="INTEGER" property="teacherId" />
    <result column="stuName" jdbcType="VARCHAR" property="stuName" />
    <result column="stuNo" jdbcType="VARCHAR" property="stuNo" />
  </resultMap>
  <sql id="Base_Column_List">
    id, teacherId, stuName, stuNo
  </sql>
  <select id="selectAllStuInfo" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from stu_info
  </select>
</mapper>

12.启动类App.java

package wmq.fly.mybatis;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
import org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration;


@SpringBootApplication
@MapperScan(basePackages = "wmq.fly.mybatis.dao") 
public class App {
    public static void main(String[] args) {
        SpringApplication.run(App.class, args);
    }

}

13.输入http://127.0.0.1:9999/stuInfo/getAllStuInfo

到此整合完成。