public void readRechargeWithdrawTxt(File file, Long noticeId) {
List<CzCheckAccountInfoPO> records = new ArrayList<CzCheckAccountInfoPO>();//
// 将txt格式的数据存入数组
try {
if (file.isFile() && file.exists()) {
InputStreamReader isr = new InputStreamReader(
new FileInputStream(file), "utf-8");
BufferedReader br = new BufferedReader(isr);
String lineTxt = br.readLine();// 读取文件的方法
String[] firstLine = lineTxt.split("\\|"); // 读第一行
String withdrawCount = firstLine[0];
String withdrawAmount = firstLine[1];
String rechargeCount = firstLine[2];
String rechargeAmount = firstLine[3];
while ((lineTxt = br.readLine()) != null) {
String[] arrStrings = lineTxt.split("\\|"); // 用于把一个字符串分割成字符串数组
CzCheckAccountInfoPO record = new CzCheckAccountInfoPO();
record.setSerialNum(String.valueOf(noticeId));
record.setWithdrawCount(Integer.valueOf(withdrawCount));
record.setWithdrawAmount(new BigDecimal(withdrawAmount));
record.setRechargeCount(Integer.valueOf(rechargeCount));
record.setRechargeAmount(new BigDecimal(rechargeAmount));
String ymd = arrStrings[0];
String hms = arrStrings[1];
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMddHHmmss");
Date date = simpleDateFormat.parse(ymd + hms);
record.setTradeTime(date);
record.setMarketSerialNum(arrStrings[2]);
record.setSystemSerialNum(arrStrings[3]);
record.setBankCapitalNum(arrStrings[4]);
record.setTradeType(Integer.valueOf(arrStrings[5]));
record.setOriginator(Integer.valueOf(arrStrings[6]));
record.setAmount(new BigDecimal(arrStrings[7]));
record.setBalance(new BigDecimal(arrStrings[8]));
record.beforeInsert();
records.add(record); // 用set方法将取值分别添加到对应字符串数组 ,用add方法存入list
}
br.close();
} else {
System.out.println("文件不存在!");
}
} catch (Exception e) {
System.out.println("文件读取错误!");
}
if(records!=null &&records.size()>0){
czCheckAccountInfoManage.batchAdd(records);
}
}
JAVA解析TXT格式文本文档
于 2018-10-31 16:41:50 首次发布