insert into tabat213 (KANSHO_CD, KANSHOKA_CD, YOKYUUKETSUKE_NO, GYO_NO, BUHIN_NO, BUNRUIGAEUMU_KBN, MEIREI_UMU, MEIREISYO_NO, MEIREI_YMD, KANRIGAE_KU, SYORI_KU, SEQUENCE, SYSUPDTIME, SYSUPDUSERID, SYSUPDTERMID, SYSUPDPRGRM, ROWID)
values ('888F', '00', 120082, 2, 'CCCC000031', '6', '0', null, null, '3', '2', 0, to_date('25-01-2013 16:57:12', 'dd-mm-yyyy hh24:mi:ss'), 'APPSUSER', 'localhost', '123', 'AAAR7jAAEAAAAFOAAP');
insert into tabat213 (KANSHO_CD, KANSHOKA_CD, YOKYUUKETSUKE_NO, GYO_NO, BUHIN_NO, BUNRUIGAEUMU_KBN, MEIREI_UMU, MEIREISYO_NO, MEIREI_YMD, KANRIGAE_KU, SYORI_KU, SEQUENCE, SYSUPDTIME, SYSUPDUSERID, SYSUPDTERMID, SYSUPDPRGRM, ROWID)
values ('888F', '00', 120082, 2, 'CCCC000031', '6', '0', null, null, '3', '2', 0, to_date('25-01-2013 16:57:12', 'dd-mm-yyyy hh24:mi:ss'), 'APPSUSER', 'localhost', '123', 'AAAR7jAAEAAAAFOAAP');
insert into tabat213 (KANSHO_CD, KANSHOKA_CD, YOKYUUKETSUKE_NO, GYO_NO, BUHIN_NO, BUNRUIGAEUMU_KBN, MEIREI_UMU, MEIREISYO_NO, MEIREI_YMD, KANRIGAE_KU, SYORI_KU, SEQUENCE, SYSUPDTIME, SYSUPDUSERID, SYSUPDTERMID, SYSUPDPRGRM, ROWID)
values ('888F', '00', 120082, 2, 'CCCC000032', '0', '0', null, null, '3', '2', 0, to_date('25-01-2013 16:57:12', 'dd-mm-yyyy hh24:mi:ss'), 'APPSUSER', 'localhost', '123', 'AAAR7jAAEAAAAFOAAW');
替换ROWID 及相对应的值
package test0319;
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
public class Test1 {
/**
* @param args
* @throws IOException
*/
public static void main(String[] args) throws IOException {
// TODO Auto-generated method stub
File file = new File("E:\\test\\TABAT213.txt");
try {
InputStream is = new BufferedInputStream(new FileInputStream(file));
byte arr[] = new byte[3024];
int n = 3000;
while (is.read(arr, 0, n) != -1) {
}
String str = "";
String str1[] = new String(arr).split(";");
for (int j = 0; j < str1.length; j++) {
// ; split
String str2[] = str1[j].split(" ");
for (int i = 0; i < str2.length - 1; i++) {
// , split
if (str2[i + 1].length() > 5 && str2[i + 1].substring(0, 5).equals("ROWID")) {
str2[i] = str2[i]
.substring(0, str2[i].lastIndexOf(","));
str2[i + 1] = str2[i + 1].substring(5);
}
if (str2[i + 1].length() > 4
&& (str2[i + 1].substring(1, 4).equals("AAA") || str2[i + 1]
.equals("ROWID"))) {
str2[i] = str2[i]
.substring(0, str2[i].lastIndexOf(","));
str2[i + 1] = "";
}
System.out.print(str2[i] + " ");
str += str2[i] + " ";
}
if (j < str1.length - 1) {
System.out.print(");");
str += ");";
}
}
is.close();
File file2 = new File("E:\\test\\TABAT213_new.txt");
OutputStream os = new BufferedOutputStream(new FileOutputStream(
file2));
os.write(str.getBytes());
os.flush();
os.close();
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}