Spring Boot1使用MyBatis注解版例子

骑猪看日落 2022-05-22 09:49 176阅读 0赞

本文使用Spring Boot1.5.8版本，代码下载地址：  
[Spring Boot1使用MyBatis注解版例子][Spring Boot1_MyBatis]

最终项目目录如下图所示：  
![这里写图片描述][70]

# 新建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/> 
        </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());
        }
    }

参考资料：[springboot(六)：如何优雅的使用mybatis][springboot_mybatis]

[Spring Boot1_MyBatis]: https://download.csdn.net/download/wu_boy/10570892
[70]: /images/20220522/d9f8baf255b04576bad5c4bd614ccd90.png
[springboot_mybatis]: http://www.ityouknow.com/springboot/2016/11/06/spring-boo-mybatis.html