2016/1/7文件上传下载代码

主页面表单代码

public void initGrid2(){

   gridModel=grid2.getModel();
gridModel.setColumnCount(2);
gridModel.setRowCount(list.size()+1);
gridModel.setRowHeight(0, 40);
gridModel.setColumnWidth(1, 500);
GridCell wjqk;
        gridModel.getGridCell(1, 0).setShowText("文件");
        int i=1;
for(final WjqkBean wj:list){
gridModel.setRowHeight(i, 25);
Button button = new Button(grid2, JWT.LINK);
   button.setText(wj.getWjxz());
   gridModel.getGridCell(1, i).setControl(button);
   button.addActionListener(new ActionListener() {        
public void actionPerformed(ActionEvent arg0) {             
             getDisplay().exportFile(wj.getWjxz(), "text/plain", -1,new ExporterWithContext(){
               public void run(Context context, OutputStream outputStream)
               throws IOException {
             outputStream.write(wj.getData());
             outputStream.flush();
           }
         });
}
       });
i++;
}

}

对应服务代码

//查询对应附件
public List<WjqkBean> wjqk(Context context,String zxbm){
StringBuffer sql = new StringBuffer();
List<WjqkBean>list= new ArrayList<WjqkBean>();
sql.append(" define query fpzjQuery() \r\n");
sql.append(" begin \r\n");
sql.append(" select m.enclosurename,m.enclosuredata,m.billid from G1038_ENCLOSURE as m \r\n");
sql.append(" where m.enclosurename  ");
sql.append(" in(select distinct(t.enclosurename)  from G1038_ENCLOSURE as t right join zx_fjb as f on f.fjrecid=t.billid where f.zxbx='"+zxbm +"' ) \r\n");
sql.append(" and m.billid in(select f.fjrecid  from G1038_ENCLOSURE as t right join zx_fjb as f on f.fjrecid=t.billid where f.zxbx='"+zxbm +"') \r\n");
sql.append(" end");
StatementDeclare query =context.parseStatement(sql.toString());
       try
{
RecordSet rs = null;
   rs = context.openQuery((QueryStatementDeclare)query);// 查询全部结果集   
WjqkBean wjqk = null;
while(rs.next())
{
wjqk= new WjqkBean();
wjqk.setWjxz(rs.getFields().get(0).getString());//文件名字
wjqk.setData(rs.getFields().get(1).getBytes());//文件的数据
wjqk.setBillid(rs.getFields().get(2).getGUID());//文件的biilid
list.add(wjqk);
}
}finally
{
}
return list;
}