springboot整合mybatis最简单demo

micro_cloud_fly

于 2022-07-25 11:45:30 发布

阅读量233

点赞数

本文链接：https://blog.csdn.net/silk_java/article/details/125971946

版权

Java 专栏收录该内容

61 篇文章

订阅专栏

本文展示了如何使用Spring Boot、MyBatis和MySQL进行简单数据操作。配置了Spring Boot的jdbc和web依赖，引入了MyBatis框架，并创建了User Dao、Service及Impl，实现了根据ID获取User信息的接口。在 UserController中，通过UserService获取指定ID的User并返回。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

依赖


        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

properties


spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/car
spring.datasource.password=root
spring.datasource.username=root

UserDao

package cn.juhe.dao;

import cn.juhe.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author micro.cloud.fly
 * @date 2022/7/25 11:26 上午
 * @desc
 */
@Mapper
public interface UserDao {

    @Select("select * from users where id=#{id}")
    User select(String id);
}

UserService

package cn.juhe.service;

import cn.juhe.entity.User;

/**
 * @author micro.cloud.fly
 * @date 2022/7/25 11:27 上午
 * @desc
 */
public interface UserService {

    User select(String id);
}

UserServiceImpl

package cn.juhe.service.impl;

import cn.juhe.dao.UserDao;
import cn.juhe.entity.User;
import cn.juhe.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * @author micro.cloud.fly
 * @date 2022/7/25 11:27 上午
 * @desc
 */
@Service
public class UserServiceImpl implements UserService {
    @Autowired
    UserDao userDao;

    @Override
    public User select(String id) {
        return userDao.select(id);
    }
}

User

package cn.juhe.entity;

import lombok.Data;

/**
 * @author micro.cloud.fly
 * @date 2022/7/25 11:31 上午
 * @desc
 */
@Data
public class User {
    int id;
    String name;
}

UserController

package cn.juhe.controller;

import cn.juhe.entity.User;
import cn.juhe.service.UserService;
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.RestController;

/**
 * @author micro.cloud.fly
 * @date 2022/7/25 11:33 上午
 * @desc
 */
@RestController
public class UserController {

    @Autowired
    UserService userService;

    @GetMapping("/get/{id}")
    public User get(@PathVariable("id") String id) {
        return userService.select(id);
    }
}