MySQL：JDBC批量插入（批量更新）DEMO

博风

已于 2025-07-08 11:25:23 修改

阅读量144

点赞数 2

CC 4.0 BY-SA版权

分类专栏： # JDBC 文章标签： mysql 数据库

于 2025-06-24 09:36:32 首次发布

本文链接：https://blog.csdn.net/Bof_jangle/article/details/148863780

JDBC 专栏收录该内容

7 篇文章

订阅专栏

pom：

批量插入：

批量更新：

pom：

<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>
  <groupId>xyz.jangle</groupId>
  <artifactId>jdbc.test</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <dependencies>
  			<dependency>
			    <groupId>mysql</groupId>
			    <artifactId>mysql-connector-java</artifactId>
			    <version>8.0.22</version>
			</dependency>
  </dependencies>
  
  <build>
		<pluginManagement>
			<plugins>
                <!-- 设置MAVEN的编译的JDK版本为1.8 -->
				<plugin>
					<groupId>org.apache.maven.plugins</groupId>
					<artifactId>maven-compiler-plugin</artifactId>
					<version>2.3.2</version>
					<configuration>
						<source>1.8</source>
						<target>1.8</target>
						<encoding>UTF-8</encoding>
					</configuration>
				</plugin>
			</plugins>
		</pluginManagement>
		
	</build>
</project>

批量插入：

package xyz.jangle.jdbc.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

/**
 * JDBC批量插入
 * @author Administrator 2025年6月24日 09:17:25
 *
 */
public class JdbcBatchInsert {

	public static void main(String[] args) {
		
		String url = "jdbc:mysql://127.0.0.1:3306/jangle_test?characterEncoding=UTF8&serverTimezone=Asia/Shanghai";
		String user = "root";
		String password = "111111";
      
      try(Connection con = DriverManager.getConnection(url, user, password);
    		  PreparedStatement ps = con.prepareStatement("insert into demo(name,age) values (?,?) ")){
    	  
    	  for (int i = 0; i < 3; i++) {
    		  ps.setString(1, "test"+i);
    		  ps.setInt(2, i);
    		  ps.addBatch();
    	  }
    	  int[] batch = ps.executeBatch();
    	  for (int i = 0; i < batch.length; i++) {
				System.out.println(batch[i]);
		  }
      } catch (SQLException e) {
		e.printStackTrace();
      }

	}

}

批量更新：

package xyz.jangle.jdbc.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

/**
 * JDBC批量更新
 * @author Administrator
 *
 */
public class JdbcBatchUpdate {

	public static void main(String[] args) {
		
		String url = "jdbc:mysql://127.0.0.1:3306/jangle_test?characterEncoding=UTF8&serverTimezone=Asia/Shanghai";
		String user = "root";
		String password = "111111";
		try(Connection con = DriverManager.getConnection(url, user, password);
			PreparedStatement ps = con.prepareStatement("update demo set age = ? where name = ?")){
			
			for (int i = 0; i < 3; i++) {
				ps.setInt(1, i*i);
				ps.setString(2, "test"+i);
				ps.addBatch();
			}
			int[] batch = ps.executeBatch();
			for (int i = 0; i < batch.length; i++) {
				System.out.println(batch[i]);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

}