java 防止并发入库demo
时间: 2023-04-06 20:01:43 浏览: 64
以下是一个简单的 Java 并发入库的示例代码:
```
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.concurrent.ExecutorService;
import java.util.concurrent.Executors;
public class ConcurrentInsertDemo {
private static final String DB_URL = "jdbc:mysql://localhost:3306/test";
private static final String DB_USER = "root";
private static final String DB_PASSWORD = "password";
private static final String INSERT_SQL = "INSERT INTO user (name, age) VALUES (?, ?)";
private static final int THREAD_COUNT = 10;
private static final int INSERT_COUNT = 1000;
public static void main(String[] args) {
ExecutorService executorService = Executors.newFixedThreadPool(THREAD_COUNT);
for (int i = 0; i < THREAD_COUNT; i++) {
executorService.execute(() -> {
try {
Connection connection = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
PreparedStatement statement = connection.prepareStatement(INSERT_SQL);
for (int j = 0; j < INSERT_COUNT; j++) {
statement.setString(1, "user" + j);
statement.setInt(2, j);
statement.executeUpdate();
}
statement.close();
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
});
}
executorService.shutdown();
}
}
```
这个示例代码使用了线程池来并发地向数据库中插入数据。每个线程都会创建一个数据库连接,并使用 PreparedStatement 来执行插入操作。为了防止并发问题,每个线程都会插入一定数量的数据,而不是一条一条地插入。