Java向mysql批量存储数据_java使用jdbc向mysql数据库批量插入大量数据详解

要求就是向mysql数据库插入到数据库里大量的数据 比如10W 或者 100W 而且要求内存稳定.

首先说下代码:

数据库MySQL

CREATE TABLE `users` (

`id` int(11) NOT NULL auto_increment,

`firstname` varchar(50) NOT NULL,

`lastname` varchar(50) NOT NULL,

`age` int(11) NOT NULL,

PRIMARY KEY  (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

数据库辅助类

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public final class DBUtils {

private static String mysqlurl = "jdbc:mysql://localhost:3306/mytest";

private static String accessurl = "jdbc:mysql://localhost:3306/mytest";

private static String user = "root";

private static String password = "root";

// 获得连接

public static Connection getAccessConn() throws SQLException {

return DriverManager.getConnection(accessurl, user, password);

}

public static Connection getMySqlConn() throws SQLException {

return DriverManager.getConnection(mysqlurl, user, password);

}

// 释放连接

public static void free(ResultSet rs, PreparedStatement ps, Connection conn) {

try {

if