springboot整合mybatis

最新推荐文章于 2024-10-02 06:14:43 发布

寻找三叶

最新推荐文章于 2024-10-02 06:14:43 发布

阅读量35

点赞数

文章标签： mysql sql 数据库 java spring

本文链接：https://blog.csdn.net/zcj_dmw/article/details/113861981

版权

导入mybatis官方starter依赖

<!--整合mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>

写接口和实现

@Mapper//所有的mapper接口需要有mapper注解
public interface EmpDao {
    public Emp selectEmpById(Integer 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.jun.demo.dao.EmpDao">
    <select id="selectEmpById" resultType="com.jun.demo.bean.Emp">
        SELECT * FROM emp WHERE id =#{id}
    </select>
</mapper>

目录结构

在这里插入图片描述

yml配置

#配置相关配置文件位置
mybatis:
  config-location: classpath:mybatis/mybatis-config.xml
  mapper-locations: classpath:mybatis/mapper/*.xml

测试

package com.jun.demo.controller;

import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.jun.demo.bean.Emp;
import com.jun.demo.dao.EmpDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

@Controller
public class DataTestController {
    @Autowired
    EmpDao dao;
    @RequestMapping("gandler01")
    @ResponseBody
    public String handler01() throws JsonProcessingException {
        Emp emp = dao.selectEmpById(1);
        System.out.println(emp);
        return new ObjectMapper().writeValueAsString(emp);
    }
}