SpringBoot整合Mybatis

最新推荐文章于 2024-08-12 22:51:08 发布

学不会_

最新推荐文章于 2024-08-12 22:51:08 发布

阅读量114

点赞数

分类专栏：小技能

本文链接：https://blog.csdn.net/CSDNkai/article/details/109689823

版权

小技能专栏收录该内容

2 篇文章 0 订阅

订阅专栏

该博客展示了如何在Spring Boot应用中集成MyBatis进行数据访问。配置了Druid连接池、MySQL数据库连接，并通过Mapper接口及XML文件实现了增删查改操作。在Service层和Controller层进行了业务逻辑处理。

摘要由CSDN通过智能技术生成

依赖

        <!--热加载-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <optional>true</optional>
        </dependency>
        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
        </dependency>
        <!--连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>
        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

entity dao service controller xml

//不加这个注解只加扫描注解 创建容器对象会爆红 但不影响执行
@Repository
public interface AirMapper {
   List<Air> findAll();
   Air find();
   Air findById(Integer id);
}

2.service

public interface AirService {
   List selectAir();
   Air selelctAirById(Integer id);
}

3.serviceImp

@Service
public class AirServiceImp implements AirService {
    @Autowired
    AirMapper airMapper;
    @Override
    public List selectAir() {
        List<Air> all = airMapper.findAll();
        for (Air air : all) {
            System.out.println(air);
        }
        return all;
    }

    @Override
    public Air selelctAirById(Integer id) {
        return  airMapper.findById(id);
    }
}

4.Mapper.xml

<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.demo.dao.AirMapper">

    <!--        List<Air> findAll();-->
    <select id="findAll" resultType="Air">
        select * from air
    </select>
    <select id="findById" parameterType="Integer" resultType="Air">
        select * from air where id = #{id}
    </select>
    <select id="find" resultType="Air">
        select * from air
    </select>
</mapper>

5.controller

//转化json数据的，如果用@Controller，下面要加上@ResponseBody
@RestController

public class airController {

    @Autowired
    private AirService airService;

    @RequestMapping("findid")
    public Air findid(Integer id){
        Air air = airService.selelctAirById(id);
        return air;
    }
    @RequestMapping("find")
    public List find(){
        List list = airService.selectAir();
        return list;
    }

在这里插入图片描述

配置文件

# mybatis
mybatis:
  mapper-locations: classpath:dao/*.xml
  type-aliases-package: com.example.demo.entity
  configuration:
    map-underscore-to-camel-case: true

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/air
    username: root
    password: root
    type: com.alibaba.druid.pool.DruidDataSource