SpringBoot整合mybatis

maven依赖

<!--mybatis起步依赖--> 
<dependency>   
 <groupId>org.mybatis.spring.boot</groupId>   
  <artifactId>mybatis-spring-boot-starter</artifactId>    <version>1.3.1</version> 
</dependency>

添加MyBatis配置

#spring集成Mybatis环境 #pojo别名扫描包
mybatis.type-aliases-package=com.example.springbootdemo.bean 
# 加载Mybatis映射文件
mybatis.mapper-locations=classpath:mapper/*Mapper.x

dao接口开发

简单通过用户名密码来查询

@Mapper
public interface UserDao{
	User findByNameAndPassword(@Param("name")String name,@Param("password") String password);
}

• @Mapper: MyBatis 更具接口定义与Mapper文件中的sql来动态的创建接口的实现
• @Param: 注解参数，在Mapper.xml文件中，可以采用#{}的方式对@Param注解括号中的参数进行引用
  在配置文件中配置的mybatis.mapper-locations 中找到类所对应的文件，

mapper文件

<?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="findByNameAndPassword" resultType="User">
        select * from user u
        <where>
			u.name = #{name}
			and u.password = #{password}
		</where>
     </select>
</mapper>

建立实体类

public class User {
    private String id;
    private String username;
    private String email;
    private String password;
    private String phoneNum;
    private int status;
    private String statusStr;
}