SpringBoot项目整合mybatis的方法步骤与实例

1. 导入依赖的jar包

springboot项目整合mybatis之前首先要导入依赖的jar包，配置pom.xml文件如下：

  4.0.0
  com.u
  springboot-mybatis
  1.0-SNAPSHOT
  
    org.springframework.boot
    spring-boot-starter-parent
    1.3.0.RELEASE
  
  
    com.us.Application
    3.2.7
    1.2.2
    1.8
    1.8
  
  
    
    
      org.springframework.boot
      spring-boot-starter-web
    
    
    
      mysql
      mysql-connector-java
      6.0.5
    
    
      com.mchange
      c3p0
      0.9.5.2
      
 
   commons-logging
   commons-logging
 
      
    
    
    
      org.springframework
      spring-jdbc
    
    
      org.mybatis
      mybatis
      ${mybatis.version}
    
    
      org.mybatis
      mybatis-spring
      ${mybatis-spring.version}
    
    
    
      org.apache.commons
      commons-lang3
      3.4
    
  

2. 配置数据源

pom.xml配置完毕后需要配置数据源了。新建DBConfig类配置数据源，代码如下：

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.env.Environment;
import com.alibaba.druid.pool.DruidDataSource;
import com.google.common.base.Preconditions;
@Configuration
public class DBConfig {
  @Autowired
  private Environment env;
  @Bean(name = "dataSource")
  public DruidDataSource dataSource() {
    final String url = Preconditions.checkNotNull(env.getProperty("ms.db.url"));
    final String username = Preconditions.checkNotNull(env.getProperty("ms.db.username"));
    final String password = env.getProperty("ms.db.password");
    final int maxActive = Integer.parseInt(env.getProperty("ms.db.maxActive", "200"));
    DruidDataSource dataSource = new DruidDataSource();
    dataSource.setUrl(url);
    dataSource.setUsername(username);
    dataSource.setPassword(password);
    dataSource.setMaxActive(maxActive);
    return dataSource;
  }
}

3. 添加数据库连接信息

在配置文件application.properties中添加数据库连接信息如下：

ms.db.url=jdbc:mysql://localhost:3306/dev?prepStmtCacheSize=517&cachePrepStmts=true&autoReconnect=true&characterEncoding=utf-8&allowMultiQueries=true
ms.db.username=root
ms.db.password=admin
ms.db.maxActive=500

4. 配置mybatis的SqlSessionFactoryBean

数据源配置完以后要配置mybatis的SqlSessionFactoryBean进行扫描mapper，新建MyBatisConfig类代码如下（classpath*:mapper @RequestMapping(method = RequestMethod.GET, produces = "application/json;charset=UTF-8") @ResponseBody public ResponseEntity list(HttpServletRequest request) { Map map = CommonUtil.getParameterMap(request); return new ResponseEntity