Spring-Boot学习（3）-----Spring-Boot整合mybatis

为了更上技术的革新，近期打算学习下spring-Boot跟Spring-Cloud。下面将记录下自己学习过程。Spring-boot系列学习源代码放在https://github.com/wenbo2018/spring-boot-learning，有需要的可以自行下载。

spring-boot整合mybatis是非常方便而且简单的，没有以往那么多配置文件，下面记录详细过程。

1.maven依赖

 <parent>      <groupId>org.springframework.boot</groupId>      <artifactId>spring-boot-starter-parent</artifactId>      <version>1.4.0.RELEASE</version>  </parent><!-- Spring Boot web 依赖 --><dependency>    <groupId>org.springframework.boot</groupId>    <artifactId>spring-boot-starter-web</artifactId></dependency><dependency>    <groupId>org.mybatis.spring.boot</groupId>    <artifactId>mybatis-spring-boot-starter</artifactId>    <version>1.2.0</version></dependency><dependency>    <groupId>mysql</groupId>    <artifactId>mysql-connector-java</artifactId>    <scope>runtime</scope></dependency>

2.application.properties配置文件

配置数据源和mybatis

#dataSourcespring.datasource.url=jdbc:mysql://localhost:3306/springspring.datasource.username=rootspring.datasource.password=rootspring.datasource.driver-class-name=com.mysql.jdbc.Driver#spring.profiles.active=dev## Mybatis 配置#实体类包mybatis.typeAliasesPackage=com.github.wenbo2018.dto#xml映射文件所在位置,通常weichatresources/mapper/mybatis.mapperLocations=classpath:mapper/*.xml

3.mybatis配置

UserDao.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.github.wenbo2018.dao.UserDao">    <resultMap id="BaseResultMap" type="com.github.wenbo2018.dto.User">        <result column="Id" property="id" jdbcType="INTEGER" />        <result column="UserName" property="username" jdbcType="VARCHAR" />        <result column="PassWord" property="password" jdbcType="VARCHAR" />        <result column="Email" property="email" jdbcType="VARCHAR" />        <result column="Au" property="au" jdbcType="INTEGER" />    </resultMap>    <insert id="add" parameterType="com.github.wenbo2018.dto.User" >        insert into User (        UserName,        PassWord,        Au,Email,Status        )        values (        #{username},        #{password},        #{au},#{email},#{status}        )    </insert>    <select id="list"  resultMap="BaseResultMap">        SELECT * FROM User    </select>    <delete id="delete" parameterType="int">        DELETE FROM User WHERE Id=#{id}    </delete>    <select id="load" parameterType="int" resultMap="BaseResultMap">        SELECT * FROM User WHERE Id=#{id}    </select>    <update id="update" parameterType="com.github.wenbo2018.dto.User">        UPDATE  User SET  UserName=#{username}, Password=#{password},Au=#{au},Email=#{email}    </update>    <select id="queryByUserNameAndPassWord"  resultMap="BaseResultMap">        SELECT *  FROM User WHERE UserName=#{0} and  PassWord=#{1}    </select>    <select id="loadByUserName" parameterType="java.lang.String" resultMap="BaseResultMap">        SELECT * FROM User WHERE  UserName=#{username}    </select></mapper>

public interface UserDao {    public void add(User user);    public User load(int userId);    public User loadByUserName(String username);    public void delete(int userId);    public void update(User user);    List<User> list();    User queryByUserNameAndPassWord(String username, String password);}

实体类User

package com.github.wenbo2018.dto;import lombok.Getter;import lombok.Setter;import java.io.Serializable;/** * Created by shenwenbo on 2017/4/14. */@Getter@Setterpublic class User implements Serializable {    private static final long serialVersionUID = -7091478494529379221L;    private int id;    private String username;    private String password;    private int au;    private String email;    private int status;    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getUsername() {        return username;    }    public void setUsername(String username) {        this.username = username;    }    public String getPassword() {        return password;    }

@Getter @Setter可以自动构造get set方法，只需要依赖lombok即可。

        <dependency>            <groupId>org.projectlombok</groupId>            <artifactId>lombok</artifactId>            <version>1.12.6</version>        </dependency>

Application.class配置

@SpringBootApplication@MapperScan("com.github.wenbo2018.dao")public class Application {    public static void main(String[] args) throws Exception {        SpringApplication app = new SpringApplication(Application.class);        app.run(args);    }}

@MapperScan(“com.github.wenbo2018.dao”)用户扫描mapper接口，com.github.wenbo2018.dao为mapper接口所在包，spring-boot会自动将其注入到ioc中。