spring boot整合mybatis

1. 创建spring boot项目，选中web、mybatis、jdbc、mysql-connector

2. application.yml

   spring:
     datasource:
       driver-class-name: com.mysql.cj.jdbc.Driver
       url: jdbc:mysql://47.96.234.28:3303/student?useUnicode=true&characterEncoding=utf-8
       username: root
       password: 123456
   
   mybatis:
     mapper-locations: classpath:mapping/*Mapper.xml
     type-aliases-package: com.inspur.springbootjasypt.model
   

3. studentMapper.xml

   <?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.springbootmybatis.dao.StudentMapper">
   
       <resultMap id="studentMap" type="com.springbootmybatis.model.Student">
           <result column="stu_id" jdbcType="VARCHAR" property="stuId" />
           <result column="stu_name" jdbcType="VARCHAR" property="stuName" />
           <result column="stu_sex" jdbcType="VARCHAR" property="stuSex" />
           <result column="stu_age" jdbcType="INTEGER" property="stuAge" />
           <result column="stu_phone" jdbcType="VARCHAR" property="stuPhone" />
           <result column="stu_class" jdbcType="VARCHAR" property="stuClass" />
       </resultMap>
   
       <select id="listStudent" resultMap="studentMap">
           select * from student
       </select>
   
   </mapper>
   

4. controller、dao、service、model层代码略。和ssm一样。

5. spring boot启动类上加一行注释，让其扫描mapper

@MapperScan("com.inspur.**.dao")