SpringBoot集成MyBatis

引入依赖

在pom.xml文件中引入所需要的依赖

<!--集成MyBatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.0</version>
        </dependency>

添加MyBatis配置

在application.properties文件中添加如下配置信息

####mybatis配置
###Mapper资源文件存放的路径
mybatis.mapper-locations=classpath:/mappers/*Mapper.xml
###Dao接口文件存放的目录
mayatis.tyoe-aliases-package=com.example.test.dao

Dao层和Mapper文件开发

• dao层

@Mapper
public interface UserDao {
    /**
     * 通过用户名和密码查询用户
     * @param userName
     * @param passWord
     * @return
     */
    User findByUsernameAndPassword(String userName,String passWord);
}

• mapper

  
  image.png

<?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.test.dao.UserDao"><!--用于绑定Dao接口-->
    <resultMap id="UserResultMap" type="com.example.test.entity.User">
        <id column="id" property="id" jdbcType="NUMERIC"/>
        <result column="username" property="userName" jdbcType="VARCHAR"/>
        <result column="Password" property="passWord" jdbcType="VARCHAR"/>
    </resultMap>

    <select id="findByUsernameAndPassword" resultMap="UserResultMap" parameterType="String">
        select * from USER_TAB u
        <where>
        u.username = #{userName} and u.password = #{passWord}
        </where>
    </select>
</mapper>

service层开发

在之前开发好的UserService接口类中添加接口findByNameAndPassword
User findByUsernameAndPassword(String userName,String passWord);
在UserServiceImpl类中实现findByNameAndPassWord接口

@Resource
    private UserDao userDao;
 @Override
    public User findByUsernameAndPassword(String userName, String passWord) {
        return userDao.findByUsernameAndPassword(userName,passWord);
    }

测试

在测试类TestApplicationTests中添加测试代码

@Resource
    private UserService userService;
 @Test
    public void testMybatis(){
        User user = userService.findByUsernameAndPassword("1","哼");
        System.out.println("人员:"+user.getUserName());
    }

到此,简单的SpringBoot整合MyBatis就完成了.