【java】1000问4SpingBoot如何快速集成mybatis

最新推荐文章于 2025-07-15 22:49:12 发布

fhg1225

最新推荐文章于 2025-07-15 22:49:12 发布

阅读量145

点赞数

CC 4.0 BY-SA版权

文章标签： springboot mybatis

本文链接：https://blog.csdn.net/fhg12225/article/details/105807385

本文详细介绍了如何使用MyBatis集成Spring Boot项目，实现对MySQL数据库的访问。包括添加依赖、创建实体类、映射DAO、设置Service、配置Controller、属性文件、mapper文件及启动类扫描配置。

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

现在要通过集成mybatis来实现对mysql的访问

首先在pom.xml增加依赖

        <dependency>
 		    <groupId>org.mybatis.spring.boot</groupId>
 		    <artifactId>mybatis-spring-boot-starter</artifactId>
 		    <version>2.1.2</version>
 		</dependency>
 	    <dependency>
 	        <groupId>mysql</groupId>
 	        <artifactId>mysql-connector-java</artifactId>
 	    </dependency>

1、创建实体类，统一放在bean下面：

package com.example.demo.bean;
public class UserBase {
 	private String id;
 	private String username;
 	public String getId() {
 		return id;
 	}
 	public void setId(String id) {
 		this.id = id;
 	}
 	public String getUsername() {
 		return username;
 	}
 	public void setUsername(String username) {
 		this.username = username;
 	}
}

2、创建映射Dao

package com.example.demo.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import com.example.demo.bean.UserBase;

@Mapper
public interface UserDao {
    
    List<UserBase> getUserList();
}

3、创建service

package com.example.demo.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.example.demo.bean.UserBase;
import com.example.demo.dao.UserDao;

@Service
public class UserService {

    @Autowired
    private UserDao userDao;
    
    public List<UserBase> getUserList(){
        return userDao.getUserList();
    }
}

4、设置Controller进行引用

package com.example.demo.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.example.demo.bean.UserBase;
import com.example.demo.service.UserService;

@RestController
@RequestMapping("/hello")
public class HelloController {

    @Autowired
    private UserService userService;
    
    @RequestMapping("/getUserList")
    public List<UserBase> getUserList(){
        return userService.getUserList();
    }
    
    @RequestMapping("/index")
    public String index(String id){
        return id;
    }
}

5、配置属性文件

server:
  port: 8081
spring:
  #数据库连接配置
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/byteyun?useUnicode=true&characterEncoding=utf8
    username: root
    password: 123456
#mybatis的相关配置
mybatis:
  #mapper配置文件
  mapper-locations: classpath:mappers/*.xml
  type-aliases-package: com.example.demo.bean
  #开启驼峰命名
  configuration:
    map-underscore-to-camel-case: true

6、配置mapper文件，创建UserMapper.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.demo.dao.UserDao">
 	
 	<select id="getUserList" resultType="UserBase">
 		select id,username from userBase
 	</select>
</mapper>

7、启动类增加扫描配置

package com.example.demo;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.example.demo.dao")
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }

}