数据库版本:mysql5.6
在创建好的Spring Boot项目加入mybatis-spring-boot-starter
和mysql-connector-java
依赖
pom.xml
加入
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.12</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.3</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
在application.properties
中配置mysql
的连接配置
spring.datasource.url=jdbc:mysql://localhost:3306/db1
spring.datasource.username=root
spring.datasource.password=12345
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
创建测试数据表student
CREATE TABLE `student` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
创建student表的映射模型Student
:
package com.example.demo.model;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
public class Student {
private Long id;
private String name;
public Student(String name) {
this.name = name;
}
}
创建student表的映射对象StudentMapper
:
package com.example.demo.mapper;
import com.example.demo.model.Student;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.annotations.Delete;
@Mapper
public interface StudentMapper {
@Select("SELECT * FROM student WHERE NAME = #{name}")
Student findByName(@Param("name") String name);
@Insert("INSERT INTO student(name) VALUES(#{name})")
int insert(@Param("name") String name);
@Update("UPDATE student SET name=#{name} WHERE id=#{id}")
void update(Student student);
@Delete("DELETE FROM student WHERE id =#{id}")
void delete(Long id);
}
在控制器里测试
package com.example.demo.controller;
import com.example.demo.mapper.StudentMapper;
import com.example.demo.model.Student;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController
@RequestMapping("/student")
public class StudentController {
@Autowired
StudentMapper studentMapper;
@RequestMapping("/find-by-name")
public Student findByName(){
studentMapper.insert("jack");
Student student = studentMapper.findByName("jack");
return student;
}
}