【springboot系列】springboot集成mybatis

springboot集成mybatis

1、mybatis依赖：

官方文档
添加以下依赖：

<!--4、mybatis依赖添加-->
    <dependency>
      <groupId>org.mybatis.spring.boot</groupId>
      <artifactId>mybatis-spring-boot-starter</artifactId>
      <version>1.3.2</version>
    </dependency>

配置项如下：

#mybatis
# application.properties
mybatis.type-aliases-package=xyz.haibofaith.miaosha.model
#下划线转驼峰
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.default-fetch-size=100
mybatis.configuration.default-statement-timeout=3000
#将接口与xml放在同一个路径下
mybatis.mapper-locations=classpath:com/haibofaith/miaosha/dao/*.xml

2、druid连接池和数据源

添加如下依赖文件：（mysql+druid）

<!--mysql-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <scope>runtime</scope>
    </dependency>
    <!-- druid -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid-spring-boot-starter</artifactId>
      <version>1.1.10</version>
    </dependency>

application.properties配置文件添加如下：

# druid
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/haibodb?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
spring.datasource.username=root
spring.datasource.password=haibo1118
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.filters=stat
spring.datasource.maxActive=2
spring.datasource.initialSize=1
spring.datasource.maxWait=60000
spring.datasource.minIdle=1
spring.datasource.timeBetweenEvictionRunsMillis=60000
spring.datasource.minEvictableIdleTimeMillis=300000
spring.datasource.validationQuery=select 'x'
spring.datasource.testWhileIdle=true
spring.datasource.testOnBorrow=false
spring.datasource.testOnReturn=false
spring.datasource.poolPreparedStatements=true
spring.datasource.maxOpenPreparedStatements=20

3、测试数据库连接

新建一张数据库表：

CREATE TABLE `haibodb`.`user_info` (
	`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
	`name` varchar(20) DEFAULT NULL COMMENT '姓名',
	PRIMARY KEY (`id`)
) ENGINE=`InnoDB` AUTO_INCREMENT=1 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ROW_FORMAT=COMPACT COMMENT='' CHECKSUM=0 DELAY_KEY_WRITE=0;

插入一条数据： 1，haibo

创建一个dao接口：

package xyz.haibofaith.miaosha.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import xyz.haibofaith.miaosha.model.UserInfo;

@Mapper
public interface UserInfoDao {
    @Select("select * from user_info where id = #{id}")
    public UserInfo getById(@Param("id") int id);
}

创建一个Service类：

package xyz.haibofaith.miaosha.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import xyz.haibofaith.miaosha.dao.UserInfoDao;
import xyz.haibofaith.miaosha.model.UserInfo;

/**
 * @author:haibo.xiong
 * @date:2019/5/5
 * @description:
 */
@Service
public class UserInfoSerivice {
    @Autowired
    UserInfoDao userInfoDao;
    public UserInfo getById(int id){
        return userInfoDao.getById(id);
    }
}

创建一个Controller接口：

@Autowired
    UserInfoSerivice userInfoSerivice;

    @RequestMapping("/dbGet")
    @ResponseBody
    public Result<UserInfo> dbGet(){
        UserInfo userInfo = userInfoSerivice.getById(1);
        return Result.success(userInfo);
    }

项目结构如下

访问以下路径测试结果

http://localhost:8096/demo/dbGet

4、事务

dao写一个insert方法：

package xyz.haibofaith.miaosha.dao;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import xyz.haibofaith.miaosha.model.UserInfo;

@Mapper
public interface UserInfoDao {
    @Select("select * from user_info where id = #{id}")
    public UserInfo getById(@Param("id") int id);
    @Insert("insert into user_info(id,name) values(#{id},#{name})")
    void insert(UserInfo userInfo);
}

service中新增重复Id的代码块：

package xyz.haibofaith.miaosha.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import xyz.haibofaith.miaosha.dao.UserInfoDao;
import xyz.haibofaith.miaosha.model.UserInfo;

/**
 * @author:haibo.xiong
 * @date:2019/5/5
 * @description:
 */
@Service
public class UserInfoSerivice {
    @Autowired
    UserInfoDao userInfoDao;
    public UserInfo getById(int id){
        return userInfoDao.getById(id);
    }
    @Transactional
    public boolean tx() {
        UserInfo userInfo1 = new UserInfo();
        userInfo1.setId(2);
        userInfo1.setName("hehe");
        userInfoDao.insert(userInfo1);
        UserInfo userInfo2 = new UserInfo();
        userInfo2.setId(1);
        userInfo2.setName("shiwu");
        userInfoDao.insert(userInfo2);
        return true;
    }
}

controller调用：

@RequestMapping("/dbTx")
    @ResponseBody
    public Result<Boolean> dbTx(){
        boolean b = userInfoSerivice.tx();
        return Result.success(b);
    }

访问以下路径测试：
http://localhost:8096/demo/dbTx

查看数据库发现，两条数据均未插入。假如去掉注解Transactional，则第一条会被插入。

4、源码自取

github源码路径