springBoot学习（三）Mybatis的使用

以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，

 由于驱动包引起的：。