/** * 从数据库查询信息供写文件使用 * * @return JSONArray */ public JSONArray loadInfo() { JSONArray jsonArray = new JSONArray(); try { List<Asset> assetList = assetService.findAllAssetList(); for (int i = 0; i < assetList.size(); i++) { JSONObject jsonObject = new JSONObject(); Asset asset = new Asset(); asset = assetList.get(i); jsonObject.put("number", asset.getNumber()); jsonObject.put("name", asset.getName()); jsonObject.put("uses", asset.getUses()); jsonObject.put("category", asset.getCategory()); jsonObject.put( "entryTime", new SimpleDateFormat("yyyy-MM-dd").format(asset.getEntryTime())); jsonObject.put("status", asset.getStatus()); jsonObject.put("remarks", asset.getRemarks()); jsonObject.put( "edit", "<a href='javascript:void(0)' onclick='editAsset(" + '"' + asset.getId() + '"' + ")'>编辑</>/<a href='javascript:void(0)' onclick='deleteAsset(" + '"' + asset.getId() + '"' + ")'>删除</>"); jsonArray.add(jsonObject); } } catch (Exception e) { e.printStackTrace(); } return jsonArray; }