Java大文件csv读取写入MySQL_读取大csv文件数据插入到MySql或者Oracle数据库通用处理...

import java.io.BufferedInputStream;

import java.io.BufferedReader;

import java.io.BufferedWriter;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.io.InputStreamReader;

import java.io.OutputStreamWriter;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.util.Properties;

public class TestDao{

static Properties prop = new Properties();

public static void main111(String[] args) {

String filePath = "D:\\shared\\other\\testaa.sql";

String filePathout = "D:\\shared\\other\\sqls\\testaaout";

BufferedReader bufferedReader = null;

BufferedWriter bufferedWriterMain = null;

BufferedWriter bufferedWriter = null;

try {

bufferedReader = new BufferedReader(new InputStreamReader(new FileInputStream(filePath)));

bufferedWriter = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(filePathout+"0.sql")));

bufferedWriterMain = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(filePathout+".sql")));

String line = null;

int i = 0;

int k = 0;

while ((line = bufferedReader.readLine()) != null) {

line = line.replace("`", "");

if (k==10000)

{

i++;

k=0;