【原创】Spring Boot 集成 Mybatis 的玩法

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `userName` varchar(32) DEFAULT NULL COMMENT '用户名',
  `passWord` varchar(32) DEFAULT NULL COMMENT '密码',
  `user_sex` varchar(32) DEFAULT NULL,
  `nick_name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
-- 初始化一条数据
INSERT INTO `my_jpa`.`users`(`id`, `userName`, `passWord`, `user_sex`, `nick_name`) VALUES (1, 'zhangsan', '123456', 'man', 'xiaosan');


<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>1.3.4</version>
</dependency>


properties
#mysql配置
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/my_jpa?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&useSSL=false
spring.datasource.username=root
spring.datasource.password=lwt123456@
#mybatis配置
mybatis.config-location=classpath:mybatis/mybatis-config.xml
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
mybatis.type-aliases-package=com.tian.usercenter.entity


package com.tian.usercenter.entity;
public class UserEntity {
    private Integer id;
    private String userName;
    private String passWord;
    private String userSex;
    private String nickName;
    //set get
}


java
import com.tian.usercenter.entity.UserEntity;
import java.util.List;
public interface UserMapper {
    List<UserEntity> getAll();
    UserEntity getOne(Long id);
    void insert(UserEntity user);
    void update(UserEntity user);
    void delete(Long id);
}


<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration   PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <setting name="callSettersOnNulls" value="true"/>
        <setting name="cacheEnabled" value="true"/>
        <setting name="lazyLoadingEnabled" value="true"/>
        <setting name="aggressiveLazyLoading" value="true"/>
        <setting name="multipleResultSetsEnabled" value="true"/>
        <setting name="useColumnLabel" value="true"/>
        <setting name="useGeneratedKeys" value="false"/>
        <setting name="autoMappingBehavior" value="PARTIAL"/>
        <setting name="defaultExecutorType" value="SIMPLE"/>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
        <setting name="localCacheScope" value="SESSION"/>
        <setting name="jdbcTypeForNull" value="NULL"/>
    </settings>
    <typeAliases>
        <typeAlias alias="Integer" type="java.lang.Integer" />
        <typeAlias alias="Long" type="java.lang.Long" />
        <typeAlias alias="HashMap" type="java.util.HashMap" />
        <typeAlias alias="LinkedHashMap" type="java.util.LinkedHashMap" />
        <typeAlias alias="ArrayList" type="java.util.ArrayList" />
        <typeAlias alias="LinkedList" type="java.util.LinkedList" />
    </typeAliases>
</configuration>


<?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.tian.usercenter.dao.UserMapper" >
    <resultMap id="BaseResultMap" type="com.tian.usercenter.entity.UserEntity" >
        <id column="id" property="id" jdbcType="INTEGER" />
        <result column="userName" property="userName" jdbcType="VARCHAR" />
        <result column="passWord" property="passWord" jdbcType="VARCHAR" />
        <result column="user_sex" property="userSex" jdbcType="VARCHAR"/>
        <result column="nick_name" property="nickName" jdbcType="VARCHAR" />
    </resultMap>
    <sql id="Base_Column_List" >
        id, userName, passWord, user_sex, nick_name
    </sql>
    <select id="getAll" resultMap="BaseResultMap"  >
        SELECT
        <include refid="Base_Column_List" />
        FROM users
    </select>
    <select id="getOne" parameterType="java.lang.Integer" resultMap="BaseResultMap" >
        SELECT
        <include refid="Base_Column_List" />
        FROM users
        WHERE id = #{id}
    </select>
    <insert id="insert" parameterType="com.tian.usercenter.entity.UserEntity" >
        INSERT INTO  users  (userName,passWord,user_sex)
        VALUES   (#{userName}, #{passWord}, #{userSex})
    </insert>
    <update id="update" parameterType="com.tian.usercenter.entity.UserEntity" >
        UPDATE users SET
        <if test="userName != null">userName = #{userName},</if>
        <if test="passWord != null">passWord = #{passWord},</if>
        nick_name = #{nickName}
        WHERE  id = #{id}
    </update>
    <delete id="delete" parameterType="java.lang.Integer" >
        DELETE FROM  users WHERE id =#{id}
    </delete>
</mapper>


@SpringBootApplication
@MapperScan("com.tian.usercenter.dao")
public class UserCenterApplication {
    public static void main(String[] args) {
        SpringApplication.run(UserCenterApplication.class, args);
    }
}


@RestController
public class MybatisController {
    @Resource
    private UserMapper userMapper;
    @GetMapping("/mybatis")
    public Object mybatis(){
        List<UserEntity> userEntityList = userMapper.getAll();
        return userEntityList;
    }
}


#mybatis.config-location=classpath:mybatis/mybatis-config.xml
#mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
mybatis.type-aliases-package=com.tian.usercenter.entity


import com.tian.usercenter.entity.UserEntity;
import org.apache.ibatis.annotations.*;
import java.util.List;
public interface UserMapper {
    @Select("select * from users")
    List<UserEntity> getAll();
    @Select("select * from users where id= #{id}")
    UserEntity getOne(@Param("id") Long id);
    @Insert("insert into users (id,userName,passWord,user_sex,nick_name) values (#{id},#{userName}{,#{passWord},#{userSex},#{nickName})")
    void insert(UserEntity user);
    @Update("update users set username=#{userName} where userName=#{userName}")
    void update(UserEntity user);
    @Delete("delete from users where id=#{id}")
    void delete(@Param("id") Long id);
}


mybatis.configuration.map-underscore-to-camel-case=true