Spring Boot集成Mybatis和MySQL对数据库进行操作

yiridancan

于 2024-03-21 14:12:48 发布

阅读量342

点赞数

本文链接：https://blog.csdn.net/yiridancan/article/details/136906295

版权

Spring Boot 同时被 2 个专栏收录

1 篇文章 0 订阅

订阅专栏

Mybatis

1 篇文章 0 订阅

订阅专栏

本文介绍了如何在SpringBoot项目中引入Maven依赖，配置MySQL数据库连接、Druid连接池，并展示了如何使用MyBatis进行SQL映射和编写测试类，以导入Excel数据到数据库。

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

引入Maven依赖

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.6.10</version>
		<relativePath/>
	</parent>
	<groupId>com.demo</groupId>
	<artifactId>importExcel</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>importExcel</name>
	<description>导入Excel百万数据到数据库</description>
	<properties>
		<java.version>8</java.version>
	</properties>
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>

		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.3.1</version>
		</dependency>

		<!--MySQL-->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.47</version>
		</dependency>

		<!--连接池-->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.1.3</version>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

</project>

application.yml

tips：这里将properties修改成了yml文件（个人习惯，看个人）

spring:
  #MySQL
  datasource:
      driver-class-name: com.mysql.jdbc.Driver
      url: jdbc:mysql://127.0.0.1:3306/test?allowMultiQueries=true
      username: root
      password: 123456
      type: com.alibaba.druid.pool.DruidDataSource
#mybatis
mybatis:
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.demo.importExcel.entity

编写实现层

实体类：

public class User {

    private String id;

    private String name;

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
}

UserMapper.java

@Mapper
public interface UserMapper {

    List<User> findAllUser();
}

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.demo.importExcel.mapper.UserMapper">

    <select id="findAllUser" resultType="com.demo.importExcel.entity.User">
        select * from t_user
    </select>
</mapper>

测试类

import com.demo.importExcel.mapper.UserMapper;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
class ImportExcelApplicationTests {

	@Autowired
	private UserMapper userMapper;

	@Test
	void contextLoads() {
		userMapper.findAllUser().forEach(e-> System.out.println(e.getName()));
	}

}