script creator - gsnaidujava/pp GitHub Wiki
package com.firstdata;
import java.io.BufferedReader; import java.io.BufferedWriter; import java.io.File; import java.io.FileReader; import java.io.FileWriter; import java.io.IOException; import java.util.Scanner;
public class ScriptCreator {
private final static String NEWLINE = System.getProperty("line.separator");
public void createScript(String inputFile, String outputFile) throws IOException {
BufferedReader bufferReader = new BufferedReader(new FileReader( inputFile)); Scanner scanner = new Scanner(new File(inputFile)); String tableName = ""; String columnNames = ""; String columnvalues = ""; long numberOfLines = 0; String insertQuery = null; StringBuffer inserScript = new StringBuffer(); BufferedWriter bufferedWriter = null;
// to find number of lines in a file. while ((bufferReader.readLine()) != null) { numberOfLines++; }
try { while (scanner.hasNextLine()) { tableName = scanner.nextLine(); columnNames = scanner.nextLine(); bufferedWriter = new BufferedWriter(new FileWriter( outputFile )); for (int i = 1; i < numberOfLines-2; i++) { if ((columnvalues = scanner.nextLine()) != null) { insertQuery = "insert into" + tableName + "(" + columnNames + ")values(" + columnvalues + ");"; inserScript.append(insertQuery + NEWLINE); } else { break; } } bufferedWriter.write(inserScript.toString()); bufferedWriter.close(); break; } } catch (Exception e) { e.printStackTrace(); } }
public static void main(String ar[]) throws IOException{
ScriptCreator scriptCreator = new ScriptCreator(); scriptCreator.createScript("C:\\Users\\F50RJZR\\Desktop\\data.csv", "C:\\Users\\F50RJZR\\Desktop\\insertScript.txt"); }
}