本文使用Spring Boot1.5.8版本,代码下载地址:
Spring Boot1使用MyBatis注解版例子
最终项目目录如下图所示:
新建Maven工程
pom.xml如下:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.wu.demo.springboot</groupId>
<artifactId>mybatisdemo</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>jar</packaging>
<name>jpademo</name>
<description>Demo project for Spring Boot JPA</description>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>1.5.8.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
添加application.properties文件
spring.datasource.url=jdbc:mysql://localhost:3306/test
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
mybatis.type-aliases-package=com.wu.demo
init.sql文件
这个文件不是项目必须的,里面存放了创建表的语句,如下所示:
drop table if exists user_test;
create table user_test (
id varchar(32) primary key,
username varchar(32),
password varchar(32)
);
创建Application
package com.wu.demo.springboot.mybatisdemo;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan("com.wu.demo")
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}
创建UserDO
package com.wu.demo.springboot.mybatisdemo.bean;
public class UserDO {
private String id;
private String username;
private String password;
//此处节省篇幅,省略了get/set。
}
创建Mapper
package com.wu.demo.springboot.mybatisdemo.dao;
import com.wu.demo.springboot.mybatisdemo.bean.UserDO;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
public interface UserMapper {
@Insert("insert into user_test(id,username,password)values(#{id},#{username},#{password})")
void save(UserDO user);
@Select("select * from user_test where username = #{username}")
UserDO findOne(String username);
}
创建测试类
package com.wu.demo.springboot.mybatisdemo.test;
import com.wu.demo.springboot.mybatisdemo.Application;
import com.wu.demo.springboot.mybatisdemo.bean.UserDO;
import com.wu.demo.springboot.mybatisdemo.dao.UserMapper;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest(classes = Application.class)
public class MapperTest {
@Autowired
private UserMapper userMapper;
@Test
public void test() throws Exception {
UserDO o = new UserDO();
o.setId("1");
o.setUsername("root");
o.setPassword("rootroot");
userMapper.save(o);
System.out.println(userMapper.findOne("root").getUsername());
}
}