对账文件导出

if ("datafile".equals(billForm.getAction())){
String date = request.getParameter("date");
System.out.println("date="+date);
if(date ==null){

}else{
List l =this.getBill2Service().getPayData(date);
StringBuffer sb=new StringBuffer();
for(int i=0;i<l.size();i++){
WtPepBillpay w =(WtPepBillpay)l.get(i);
/*参考号+交易传输时间+主账号+交易金额+交易类型码+转入卡卡号（19位）+原始交易的系统跟踪号+原始交易的日期时间+
原始交易金额+商户手续费+收款人姓名+收款人帐号+开户行*/
sb.append(Util.getNewString(w.getPayJsck(), 12)+",");//参考号
sb.append(Util.getNewString(w.getPayDate(), 10)+",");//交易传输时间
sb.append(Util.getNewString(w.getPayCard(), 19)+",");//主账号
sb.append(Util.getAMT(""+(Integer.valueOf(w.getTranamt().trim())+Integer.valueOf(w.getFee().trim())))+",");//交易金额
sb.append("S34,"); //交易类型码
sb.append(Util.getNewString(w.getBankCard(), 19)+",");//转入卡卡号（19位）
sb.append(Util.getNewString(w.getPayXtls(), 6)+",");//原始交易的系统跟踪号
sb.append(Util.getNewString(w.getPayDate(), 10)+",");//原始交易的日期时间
sb.append(Util.getNewString(w.getTranamt(), 12)+",");//原始交易金额
sb.append(Util.getNewString(w.getFee(), +",");//商户手续费
sb.append(Util.getNewString(w.getBankName(), 12)+",");//收款人姓名
sb.append(Util.getNewString(w.getBankCard(), 19)+",");//收款人帐号
sb.append(Util.getNewString(w.getOpeningBank(), 50));//收款人帐号
sb.append("\n");
}
response.setContentType("octets/stream");
response.addHeader("Content-Disposition",
"attachment;filename="+date+"PUB");
try {
OutputStream fileOut = response.getOutputStream();
fileOut.write(sb.toString().getBytes());
fileOut.flush();
fileOut.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println(sb.toString());
return null;
}
return mapping.findForward("dataFile");
}