try{
String mc = Request.getString("machineCode").trim();
String partNo = Request.getString("partNo").trim();
String filename = application.getRealPath("/" + "importfile/BomPart_list.csv");
FileOutputStream fos = new FileOutputStream(filename);
OutputStreamWriter osw = new OutputStreamWriter(fos,"GB2312");
BufferedWriter bw = new BufferedWriter(osw);
PartRelaApp newPartRelaApp = new PartRelaApp();
PartRela newPartRela = new PartRela();
String whereClause=BuildSQL.getWhere(request);
newPartRelaApp.setWhereClause(whereClause);
List ar = newPartRelaApp.getTopLevelPartList(dbi,mc,partNo,0,0,"");
if(ar.size()==0)
{
out.println("<script language='javascript'> alert('没有符合条件的记录可到导'); history.go(-1); </script>");
}
else
{
bw.write("零件号" + "," + "机型" + "," + "From" + "," + "To" + "," + "Next" + "," + "有效日期" + "\r\n");
for(int i = 0 ; i<ar.size(); i++){
newPartRela = (PartRela)ar.get(i);
String message1 = newPartRela.getChildPartNo();
String message2 = newPartRela.getMachineCode();
String message3 = newPartRela.getFrom();
String message4 = newPartRela.getTo();
String message5 = newPartRela.getNext();
String message6 = newPartRela.getEffectDate().toString();
bw.write(message1 + "," + message2 + "," + message3 + "," + message4 + "," + message5 + "," + message6 + "\r\n" );
}
bw.flush();
bw.close();
osw.close();
fos.close();
pageContext.forward("DownLoadFile.jsp?fileName=" + filename);
}
}catch(IOException e){
e.printStackTrace();
}finally{
}