pom.xml文件中导入需要用到的包:
<!--mybatis的启动器 -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<!-- 数据库驱动,如mysql驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
1.创建实体类,用于映射表
package com.mybatis.po;
import lombok.Data;
@Data
public class Role {
private Long id;
private String role_name;
private String note;
}
对应的表:
2.创建操作表的接口,使用@Mapper注解或者使用@MapperScan注解
package com.mybatis.mapper;
import com.mybatis.po.Role;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface RoleMapper {
public void insertRole(Role role);
}
3.创建全局配置xml
<?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>
</configuration>
4.创建映射配置xml,namespace是接口的类的全称,id是接口中的方法。
<?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.mybatis.mapper.RoleMapper">
<insert id="insertRole">
insert into role (role_name,note) values (#{role_name},#{note})
</insert>
</mapper>
5.在application.properties中配置数据源和mybatis配置文件
数据源:
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://localhost:3306/palmap?serverTimezone=UTC #palmap是数据库实例名
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
mybatis配置文件
mybatis.config-location=classpath:mybatis/mybatis-config.xml #配置mybatis的全局配置文件
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml #配置mybatis的映射文件
6.使用@Autowired将接口注入就可以使用了
package com.mybatis.controller;
import com.mybatis.mapper.RoleMapper;
import com.mybatis.po.Role;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class RoleController {
@Autowired
RoleMapper roleMaper;
@GetMapping("/insert")
public Role InsertRole()
{
Role role=new Role();
role.setRole_name("张三");
role.setNote("test");
roleMaper.insertRole(role);
return role;
}
}
测试代码地址
提取码:d5rs