SpringBoot整合Mybatis

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 的操作就全部结束了，谢谢大家！