一个简单的输入输出替换问题

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();
		}
	}

}


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值