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{
       
 }