SpringBoot结合mybatis,向数据库中批量添加

SpringBoot结合mybatis,向数据库中批量添加,sql使用foreach

依赖

<?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.7.12</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.qf</groupId>
	<artifactId>bootmp03</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>bootmp03</name>
	<description>Demo project for Spring Boot</description>
	<properties>
		<java.version>1.8</java.version>
	</properties>
	<dependencies>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</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>
		<dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>mybatis-plus-generator</artifactId>
			<version>3.4.1</version>
		</dependency>

		<!-- 模板引擎 -->
		<dependency>
			<groupId>org.apache.velocity</groupId>
			<artifactId>velocity-engine-core</artifactId>
			<version>2.0</version>
		</dependency>
		<dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>mybatis-plus-boot-starter</artifactId>
			<version>3.4.0</version>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.18</version>
		</dependency>
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid-spring-boot-starter</artifactId>
			<version>1.1.10</version>
		</dependency>
			<dependency>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-devtools</artifactId>
				<optional>true</optional>
			</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
				<configuration>
					<excludes>
						<exclude>
							<groupId>org.projectlombok</groupId>
							<artifactId>lombok</artifactId>
						</exclude>
					</excludes>
				</configuration>
			</plugin>
		</plugins>
	</build>

</project>

配置文件
mybatis-plus:
mapper-locations: classpath:mapper/*.xml
type-aliases-package: com.qf.bootmp03.pojo
server:
port: 8011
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql:///ssm_pro?serverTimezone=UTC&useUnicode=true&&characterEncoding=utf-8
username: root
password: admin
type: com.alibaba.druid.pool.DruidDataSource
devtools:
restart:
enabled: true

首先实体类

@Data
@EqualsAndHashCode(callSuper = false)
@TableName("admin")
@NoArgsConstructor
@AllArgsConstructor
@ToString
public class Admin implements Serializable {

    private static final long serialVersionUID = 1L;

      @TableId(value = "Admin_Id", type = IdType.AUTO)
    private Integer adminId;

    @TableField("Admin_Name")
    private String adminName;

    @TableField("Admin_Pass")
    private String adminPass;

    @TableField("Admin_Level")
    private Integer adminLevel;

    @TableField("Approve")
    private Integer approve;

    public Admin(String adminName, String adminPass, Integer adminLevel) {
        this.adminName = adminName;
        this.adminPass = adminPass;
        this.adminLevel = adminLevel;
    }
}

mapper数据层

@Mapper
@Repository
public interface AdminMapper extends BaseMapper<Admin> {
 public int addAdmins(@Param("admins") List<Admin> admins);

}

mapper映射文件

<?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.qf.bootmp03.mapper.AdminMapper">
    <insert id="addAdmins" parameterType="com.qf.bootmp03.pojo.Admin">
        insert into admin(admin_Name,admin_Pass,admin_Level) values
        <foreach collection="admins" item="Admin" separator=",">
            (#{Admin.adminName},#{Admin.adminPass},#{Admin.adminLevel})
        </foreach>
    </insert>
</mapper>

测试

@SpringBootTest
@MapperScan("com.qf.bootmp03.mapper")
class Bootmp03ApplicationTests {
@Autowired
private AdminMapper mapper;
    @Test
    void contextLoads() throws IOException {
       List<Admin> admins = Arrays.asList(new Admin("QQ","121212",1),new Admin("QQ","121212",1),new Admin("QQ","121212",1));
        mapper.addAdmins(admins);
        }
        }

注意

1.映射文件的namespace命名空间要要和mapper.java文件的路径一致
2.插入语句的id要和mapper接口的方法一直 ,collection的集合名要和方法的参数名一致
3.target这个目录也要有一样的mapper包
4.还有注释别忘了添加
5.