java csv sql_读取和处理csv文件为sql文件

package csv;

import java.io.BufferedReader;

import java.io.BufferedWriter;

import java.io.FileNotFoundException;

import java.io.FileReader;

import java.io.FileWriter;

import java.io.IOException;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.Iterator;

import java.util.List;

import java.util.Map;

public class ReadCVS {

// public static final String sqlContent="INSERT INTO TOA_BIND_SERVICE (PARTY_NO, SERVICE_ID, FCU,FCD,BINDFLAG,LCD,LCU,ACCOUNT_NO,BIND_SOURCE)";

public static final String sqlContentStr="INSERT INTO TOA_ORANGE_DATA_TEMP (client_no, account_no, ecif_no,party_no,is_oldcfe) values(";

public static final String sqlSelectContent="select party_no,\'orangebank\',\'TOAOPR\',SYSDATE,\'1\',SYSDATE,\'TOAOPR\',\'\',\'E\' from toa_customer where clientno =";

public static void main(String[] args) throws IOException {

ReadCVS obj = new ReadCVS();

obj.run();

}

public void run() throws IOException {

String csvFile = "D:\\test\\orangebank.csv";

BufferedReader br = null;

String line = "";

String cvsSplitBy = ",";

BufferedWriter  bw = new BufferedWriter(new FileWriter("d:\\test\\orangebankNew2.sql", true));

try {

Map maps = new HashMap();

br = new BufferedReader(new FileReader(csvFile));

//           List dataList = null;

//           List targetList = new ArrayList();

int i = 0;

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

if (i == 0 ){

i++;

continue;

}

String[] dataArray = line.split(cvsSplitBy);

String clientNo = dataArray[0];

String accountNo = dataArray[1];

String ecifNo = dataArray[2];

String partyNo = dataArray[3];

String isoldcfe = dataArray[4];

bw.append(sqlContentStr);

bw.append(clientNo.replaceAll("\"", "\'"));

bw.append(",");

bw.append(accountNo.replaceAll("\"", "\'"));

bw.append(",");

bw.append(ecifNo.replaceAll("\"", "\'"));

bw.append(",");

bw.append(partyNo.replaceAll("\"", "\'"));

bw.append(",");

bw.append(isoldcfe.replaceAll("\"", "\'"));

bw.append(")");

bw.append(";");

bw.append("\r\n");

bw.flush();

}

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

} finally {

bw.flush();

if (br != null) {

try {

br.close();

} catch (IOException e) {

e.printStackTrace();

}

}

if((line = br.readLine()) == null){

System.out.println("Done");

bw.append("commit;");

if(bw != null){

bw.close();

}

}

}

}

}