要求就是向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