springboot整合Mybatis

pom.xml

    
    
        org.mybatis.spring.boot
        mybatis-spring-boot-starter
        2.1.1
    
    
    
    
        org.springframework.boot
        spring-boot-starter-jdbc
    
    
    
        mysql
        mysql-connector-java
        runtime
    

application.properties

spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/song?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

# 整合mybatis
mybatis.type-aliases-package=com.song.pojo
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml

UserMapper

// 这个注解表示了这是一个mybatis的mapper类
@Mapper
@Repository
public interface UserMapper {
    List queryUserList();
    User queryUserById();
    int addUser(User user);
    int updateUser(User user);
    int deleteUser(int id);
}

UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>


    
        select * from songyuming.user
    
    
        select * from songyuming.user where id=#{id}
    
    
        insert into songyuming.user (id,name,pwd)
        values (#{id},#{name},#{pwd})
    
    
        update songyuming.user set name=#{name},pwd=#{pwd}
        where id=#{id}
    
    
        delete from songyuming.user where id=#{id}