集成Mybatis

(1)引入start（JDBC，MySQl，MyBatis）

org.mybatis.spring.boot
mybatis-spring-boot-starter
2.2.0



(2)配置数据库

spring.datasource.username=root
spring.datasource.password=159263487qwe
spring.datasource.url=jdbc:mysql://localhost:3306/test?serverTimezOne=UTC&useUnicode=true&characterEncoding=UTF-8&useSSL=false
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#整合MyBatis
mybatis.mapper-locatiOns=classpath:mybatis/mapper/*.xml
mybatis.type-aliases-package=com.my.pojo


(3)实体类、mapper

@Mapper
@Repository
public interface UserMapper {
List queryAll ();
User queryById(int id);
int add (User user);
int delete (int id);
int update (User user);
}


（4）mapper.xml


PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">


select * from user


select * from user where id = #{id}




(5)Controller

调用Servce层方法