以oracle数据库为例
1、引入资源
<!-- Mybatis -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.2.0</version>
</dependency>
2、配置application.properties
#Mybatis
mybatis.type-aliases-package=com.example.SpringBootDemo.model
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@**ip**:*port*:epms
spring.datasource.username=用户名
spring.datasource.password=密码
mybatis.mapperLocations=classpath:sqlMapper/*.xml
3、设置@MapperScan
4、Mapper编写
package com.example.SpringBootDemo.mapper;
import com.example.SpringBootDemo.model.User;
public interface UserMapper
{
User queryUser(String loginname);
}
<?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.example.SpringBootDemo.mapper.UserMapper">
<select id="queryUser" resultType="com.example.SpringBootDemo.model.User" parameterType="java.lang.String">
select a.name,a.password from t_sys_user a where a.loginname=#{loginname}
</select>
</mapper>
5、controller层
@Autowired
private UserService userService;
@RequestMapping ("/mybatis")
public Object mybatis()
{
return userService.queryUser("root");
}
6、测试
7、注意: Tomcat8+JDK1.8+Ojdbc6.jar Oracle驱动包
jdk1.7时使用Oracle 10g 10.2.0.2 JDBC_ojdbc14.jar,
由于驱动包引起的:。