SpringBoot 整合 Mybatis
- SpringBoot-Mybatis
10.1 导入 MyBatis 所需要的依赖
org.mybatis.spring.boot
mybatis-spring-boot-starter
2.2.0
10.2 配置数据库信息
spring.datasource.username=root
spring.datasource.password=aadzj
spring.datasource.url=jdbc:mysql://localhost:3306/userdb?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
mybatis整合 全限定类别名,关联配置文件
mybatis.type-aliases-package=com.dzj.pojo
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
10.3 测试数据库连接
10.4 创建实体类
导入lombok 依赖
org.projectlombok
lombok
创建实体类Student
文件路径:java–com–dzj–pojo–Student.java
package com.dzj.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Student {
private String sno;
private String sname;
private String sclass;
private String cname;
}
10.5 创建 Mapper 接口
文件路径:java–com–dzj–mapper–StudentMapper.java
package com.dzj.mapper;
import com.dzj.pojo.Student;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import java.util.List;
// 这个注解表示了这是一个Mybatis的mapper类
@Mapper
@Repository
public interface StudentMapper {
List queryStudentList();
Student queryByStudentId(int sno);
int addStudent(Student student);
int updateStudent(Student student);
int deleteStudent(int sno);
}
10.6 对应的Mapper映射文件
文件路径:resource–mybatis–mapper–StudentMapper.xml
select * from student
select * from student where sno=#{sno}
insert into student(sno,sname,class,cname) values(#{sno},#{sname},#{sclass},#{cname})
update student set sname=#{sname},class=#{sclass},cname=#{cname} where sno = #{sno}
delete from student where sno = #{sno}
10.7 maven配置资源过滤问题
src/main/java
**/*.xml
true
10.8 编写 StudentController进行测试
package com.dzj.controller;
import com.dzj.mapper.StudentMapper;
import com.dzj.pojo.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
@RestController
public class StudentController {
@Autowired
private StudentMapper studentMapper;
@RequestMapping("/listStudent")
public List queryStudentList(){
List students = studentMapper.queryStudentList();
for (Student student : students) {
System.out.println(student);
}
return students;
}
@GetMapping("/queryStudent/{sno}")
public Student queryStudent(@PathVariable("sno")int sno){
Student student = studentMapper.queryByStudentId(sno);
return student;
}
@GetMapping("/addStudent")
public String addStudent(){
int i = studentMapper.addStudent(new Student("105", "dengzi", "5班", "English"));
return "添加成功";
}
@GetMapping("/deleteStudent/{id}")
public String deleteStudent(@PathVariable("id")int id){
studentMapper.deleteStudent(id);
return "删除成功";
}
@GetMapping("/updateStudent")
public String updateStudent(){
studentMapper.updateStudent(new Student("101","wenliu","2班","语文"));
return "修改成功";
}
}
Original: https://www.cnblogs.com/aadzj/p/15636759.html
Author: 小公羊
Title: SpringBoot-Mybatis
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/612315/
转载文章受原作者版权保护。转载请注明原作者出处!