|

楼主 |
发表于 2017-12-7 11:35:40
|
显示全部楼层
按照这个写,前台看到的是一个url
- public static Table printExpertMessages(String zjbh){
- zjbh = "695";
- String data_model = "/XGDXMGL/ExpertReview/data";
- String sql = "select * from t_pms_expertdefine where bh = '"+zjbh+"' ";
- Table tab = SQL.select(sql, null, data_model);
- System.out.println(sql);
- System.out.println(tab.size());
- System.out.println("=======================================================");
- Iterator<Row> it = tab.iterator();
- if(tab.size()>0){
- while(it.hasNext()){
- Row row = it.next();
- String zp = row.getString("ZP");// 取出照片字段
- String ID = row.getString("ID");// 获取主键值
- String operateType = "browse";
- System.out.println("ZP========="+zp);
- if(zp.length()>2){
- System.out.println("ZP========="+zp);
- JSONArray ja = JSONArray.parseArray(zp);// 把图片字段信息转换为json对象
- JSONObject jsonObject = ja.getJSONObject(0);
- String realFileName = jsonObject.getString("realFileName");// 获取json对象中realFileName的值
- String storeFileName = jsonObject.getString("storeFileName");// 获取json对象中storeFileName的值
- String url = "/UI2/system/service/doc/common/simpleFileStore.j?realFileName=" + realFileName + "&storeFileName=" + storeFileName + "&ownerID=" + ID + "&operateType="
- + operateType; // 通过获取的主键值、realFileName、storeFileName的值拼接url
- row.setString("ZP", url); // 将url存入table对象
- System.out.println("url======"+url);
- }
- }
- }
- return tab;
- }
复制代码
|
|