1:首先循环得到需要打印的表里面的数据
ServiceImpl
List<Map<String, Object>> list = 你的表.打印数据的方法(需要的参数?);
String tempStr = ""; //定义一个收到表里数据转换为字符形式
String result = ""; //定义需要转换出去的数据
for (Map<String, Object> mp : list) {
String dateTemp = (String.valueOf(mp.get("date")));
String rcvAmount = (String.valueOf(mp.get("rcvAmount")));
String rcvedAmount = (String.valueOf(mp.get("rcvedAmount")));
String balanceAmount = (String.valueOf(mp.get("balanceAmount")));
String quantity = (String.valueOf(mp.get("quantity")));
String maxInvNum = (String.valueOf(mp.get("maxInvNum")));
String minInvNum = (String.valueOf(mp.get("minInvNum")));
String validNum = (String.valueOf(mp.get("validNum")));
String invalidNum = (String.valueOf(mp.get("invalidNum")));
String total = (String.valueOf(mp.get("total")));
String adminUser = (String.valueOf(mp.get("adminUser")));
tempStr = "{\"date\":\"" + dateTemp + "\",\"rcvAmount\":\"" + rcvAmount + "\",\"rcvedAmount\":\""
+ rcvedAmount + "\",\"balanceAmount\":\"" + balanceAmount + "\",\"quantity\":\"" + quantity
+ "\",\"maxInvNum\":\"" + maxInvNum + "\"" + ",\"minInvNum\":\"" + minInvNum + "\",\"validNum\":\""
+ validNum + "\",\"invalidNum\":\"" + invalidNum + "\",\"total\":\"" + total + "\",\"adminUser\":\""
+ adminUser + "\"}"; //打印的格式数据不同所以需要把得到的值转换一下 赋给定义好的tempStr
if (result.isEmpty()) {
//如果获取的数据为空
result = tempStr;
//则给他赋值
} else {
result += "," + tempStr;
}
}
result = PRINT_HEAD + result + PRINT_END;
return result;
}
Service层
PrintService
String 方法名(数据的参数);
Controller 控制层
不需要改动什么 把自己service层的方法放上去,
@ApiOperation(value = "收费日报表打印Excel", notes = "收费日报表打印Excel")
@RequestMapping(value="/printForDailydate",method=RequestMethod.POST)
@DorunTollBody(encode = false, deccode = false, requereAdminLogin = false)
@ResponseBody
public String printForDailydate(Integer orgId, Integer useId, String date) {
try {
PrintService printService = printServiceFactory.getPrintService(orgId);
return printService.printForData(方法的参数);
} catch (DefineException e) {
return e.getMessage();
} catch (Exception e) {
return "系统错误";
}
}
总结
说白了 其实就是得到集合里面的数据 把集合里的数据for循环以及转换成需要打印机打印的格式转换出去就能完成了