每个基于 MyBatis 的应用都是以一个 SqlSessionFactory 的实例为核心的。SqlSessionFactory 的实例可以通过 SqlSessionFactoryBuilder 获得。而 SqlSessionFactoryBuilder 则可以从 XML 配置文件或一个预先配置的 Configuration 实例来构建出 SqlSessionFactory 实例。
从 XML 文件中构建 SqlSessionFactory 的实例非常简单,建议使用类路径下的资源文件进行配置。 但也可以使用任意的输入流(InputStream)实例,比如用文件路径字符串或 file:// URL 构造的输入流。MyBatis 包含一个名叫 Resources 的工具类,它包含一些实用方法,使得从类路径或其它位置加载资源文件更加容易。
String resource = “org/mybatis/example/mybatis-config.xml”;
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
XML 配置文件中包含了对 MyBatis 系统的核心设置,包括获取数据库连接实例的数据源(DataSource)以及决定事务作用域和控制方式的事务管理器(TransactionManager)。后面会再探讨 XML 配置文件的详细内容,这里先给出一个简单的示例:
① 父pom文件中声明所有子模块依赖(dependencyManagement及dependencies的区别自行查阅文档)
com.yibao.beta beta-biz ${beta.version} com.yibao.beta beta-dao ${beta.version} com.yibao.beta beta-web ${beta.version} 其中${beta.version}定义在properties标签中② 在beta-web层中的pom文件中添加beta-biz依赖
com.yibao.beta beta-biz ③ 在beta-biz层中的pom文件中添加beta-dao依赖 com.yibao.beta beta-dao 5、web层调用biz层接口测试 ① 在beta-biz层创建http://com.yibao.beta.biz包,添加service目录并在其中创建DemoService接口类package com.yibao.beta.biz.service;
/**
-
@author linjian
-
@date 2018/9/29
*/
public interface DemoService {String test();
}
package com.yibao.beta.biz.service.impl;
import com.yibao.beta.biz.service.DemoService;
import org.springframework.stereotype.Service;
/**
-
@author linjian
-
@date 2018/9/29
*/
@Service
public class DemoServiceImpl implements DemoService {@Override
public String test() {
return “test”;
}
}
② DemoController通过@Autowired注解注入DemoService,修改DemoController的test方法使之调用DemoService的test方法,最终如下所示
package com.yibao.beta.web.controller;
import com.yibao.beta.biz.service.DemoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
/**
-
@author linjian
-
@date 2018/9/29
*/
@RestController
@RequestMapping(“demo”)
public class DemoController {@Autowired
private DemoService demoService;@GetMapping(“test”)
public String test() {
return demoService.test();
}
}
③ 再次运行BetaWebApplication类中的main方法启动项目,发现如下报错
APPLICATION FAILED TO START
Description:
Field demoService in com.yibao.beta.web.controller.DemoController required a bean of type ‘com.yibao.beta.biz.service.DemoService’ that could not be found.
Action:
Consider defining a bean of type ‘com.yibao.beta.biz.service.DemoService’ in your configuration.
原因是找不到DemoService类,此时需要在BetaWebApplication入口类中增加包扫描,设置@SpringBootApplication注解中的scanBasePackages值为com.yibao.beta,最终如下所示
package com.yibao.beta.web;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
/**
-
@author linjian
-
@date 2018/9/29
*/
@SpringBootApplication(scanBasePackages = “com.yibao.beta”)
@MapperScan(“com.yibao.beta.dao.mapper”)
public class BetaWebApplication {public static void main(String[] args) {
SpringApplication.run(BetaWebApplication.class, args);
}
}
设置完后重新运行main方法,项目正常启动,访问http://localhost:8080/demo/test得到如下效果
6、集成Mybatis
① 父pom文件中声明mybatis-spring-boot-starter及lombok依赖
dependencyManagement>
org.mybatis.spring.boot
mybatis-spring-boot-starter
1.3.2
org.projectlombok
lombok
1.16.22
② 在beta-dao层中的pom文件中添加上述依赖
④ applicatio.properties文件添加jdbc及mybatis相应配置项
spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://192.168.1.1/test?useUnicode=true&characterEncoding=utf-8
spring.datasource.username = test
spring.datasource.password = 123456
mybatis.mapper-locations = classpath:mybatis/*.xml
mybatis.type-aliases-package = com.yibao.beta.dao.entity
⑤ DemoService通过@Autowired注解注入UserMapper,修改DemoService的test方法使之调用UserMapper的selectByPrimaryKey方法,最终如下所示
package com.yibao.beta.biz.service.impl;
import com.yibao.beta.biz.service.DemoService;
import com.yibao.beta.dao.entity.UserDO;
import com.yibao.beta.dao.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
/**
-
@author linjian
-
@date 2018/9/29
*/
@Service
public class DemoServiceImpl implements DemoService {@Autowired
private UserMapper userMapper;@Override
public String test() {
UserDO user = userMapper.selectByPrimaryKey(1);
return user.toString();
}
}
⑥ 再次运行BetaWebApplication类中的main方法启动项目,发现如下报错
APPLICATION FAILED TO START
Description:
Field userMapper in com.yibao.beta.biz.service.impl.DemoServiceImpl required a bean of type ‘com.yibao.beta.dao.mapper.UserMapper’ that could not be found.
Action:
Consider defining a bean of type ‘com.yibao.beta.dao.mapper.UserMapper’ in your configuration.
原因是找不到UserMapper类,此时需要在BetaWebApplication入口类中增加dao层包扫描,添加@MapperScan注解并设置其值为com.yibao.beta.dao.mapper,最终如下所示
package com.yibao.beta.web;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
/**
-
@author linjian
-
@date 2018/9/29
*/
@SpringBootApplication(scanBasePackages = “com.yibao.beta”)
@MapperScan(“com.yibao.beta.dao.mapper”)
public class BetaWebApplication {public static void main(String[] args) {
SpringApplication.run(BetaWebApplication.class, args);
}
}