SpringBoot整合Mybatis
一、准备工作
二、案例实现
准备工作
1.创建一个纯净的SpringBoot项目
2.这里不需要勾选,直接finish
得到的项目结构
3.添加依赖
- 不要忘记添加web依赖*
配置文件
案例实现
数据库表
项目结构
实体类Employee
package com.example.test.entity;
import java.util.Date;
public class Employee {
private Integer eno;
private String ename;
private Double salary;
private String dname;
private Date hireDate;
public Employee() {
}
public Integer getEno() {
return eno;
}
public void setEno(Integer eno) {
this.eno = eno;
}
public String getEname() {
return ename;
}
public void setEname(String ename) {
this.ename = ename;
}
public Double getSalary() {
return salary;
}
public void setSalary(Double salary) {
this.salary = salary;
}
public String getDname() {
return dname;
}
public void setDname(String dname) {
this.dname = dname;
}
public Date getHireDate() {
return hireDate;
}
public void setHireDate(Date hireDate) {
this.hireDate = hireDate;
}
@Override
public String toString() {
return "Employee{" +
"eno=" + eno +
", ename='" + ename + '\'' +
", salary=" + salary +
", dname='" + dname + '\'' +
", hireDate=" + hireDate +
'}';
}
}
编写接口EmployeeMapper
package com.example.test.mapper;
import com.example.test.entity.Employee;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
@Mapper
public interface EmployeeMapper {
public Employee getById(@Param("param") Integer id);
}
编写对应的Xml文件
<?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.example.test.mapper.EmployeeMapper">
<select id="getById" resultType="com.example.test.entity.Employee">
select *
from employee
where eno = #{param}
</select>
</mapper>
服务层
package com.example.test.service;
import com.example.test.entity.Employee;
public interface EmployeeService {
public Employee getById(Integer eno);
}
服务层实现
package com.example.test.service.impl;
import com.example.test.entity.Employee;
import com.example.test.mapper.EmployeeMapper;
import com.example.test.service.EmployeeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class EmployeeServiceImpl implements EmployeeService {
@Autowired
EmployeeMapper employeeMapper;
@Override
public Employee getById(Integer eno) {
return employeeMapper.getById(eno);
}
}
接口Controller
package com.example.test.controller;
import com.example.test.entity.Employee;
import com.example.test.service.EmployeeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class EmployeeController {
@Autowired
EmployeeService employeeService;
@GetMapping("/getEmployee")
public Employee test(Integer eno){
return employeeService.getById(eno);
}
}
结果展示
控制台打印的sql
至此,SpringBoot整合Mybatis 的操作就全部结束了,谢谢大家!