Import data from word into db2
Copy data from word into Excel.Edit data in Excel, and Save as CSV.
Directly Import the data from csv in Control Center
.
Generate the SQL script from the csv file in Java.
public static void generateInsertScript() throws Exception {
// input/output file names
String inputFileName= "insert.csv";
String outputFileName = "insertScript.sql";
// Create FileReader Object
FileReader inputFileReader = new FileReader(inputFileName);
FileWriter outputFileReader= new FileWriter(outputFileName);
// Create Buffered/PrintWriter Objects
BufferedReader inputStream = new BufferedReader(inputFileReader);
PrintWriter outputStream= new PrintWriter(outputFileReader);
String deleteStatement = "DELETE FROM ESHLOG.MAP_IDD_MSGFLOW;";
outputStream.println(deleteStatement);
try {
String inLine = null;
String[] values = new String;
while ((inLine = inputStream.readLine()) != null) {
values = inLine.split(",");
String queryBasic = "INSERT INTO TABLENAME (COLUMN1, COLUMN2, COLUMN3, COLUMN4, COLUMN5) VALUES (%s, %s, %s, %s, '0');";
String statement = "";
values = values.replace("'", "''");
values = values.replace("'", "''");
values = values.replace("'", "''");
values = values.replace("'", "''");
statement = String.format(queryBasic, "'" + values + "'", "'" +values + "'", "'" + values + "'", "'" + values + "'");
}
outputStream.println(statement);
}
} catch (Exception e) {
throw e;
} finally {
outputStream.close();
inputStream.close();
}
}
Execute the SQL script in DB2CMD
db2 -tvsf insertScript.sql
页:
[1]