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

来源：互联网发布：设计师为什么要用mac 编辑：程序博客网时间：2024/05/10 03:21

主页面表单代码

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

0 0