一开始尝试了单条插入,13万条记录差不多2个半钟才能完全从文件中读取到数据库中,后来用了批量插入,用时29秒!
代码如下:
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class DataToMysql {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/cityzendb";
String username = "root";
String password = "";
PreparedStatement ps =null;
Connection conn=null;
InputStreamReader inputStreamReader = null;
BufferedReader bufferedReader = null;
File file=new File("E:\\data.txt");
int currentInsert = 0;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getCo