![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
办公
疯狂的土豆丶
这个作者很懒,什么都没留下…
展开
-
导入Excel
/** * 添加单位工程信息 * * @param ids * @return */ @RequestMapping(params = "doSaveExcel") @ResponseBody public Map<String, Object> doSaveExcel(HttpServletRequest request) throws IllegalSt...原创 2018-10-15 16:45:40 · 103 阅读 · 0 评论 -
打包下载word+
/*打包下载*/ @RequestMapping(params = "loadZip") public String Files(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String id = request...原创 2018-10-15 16:53:23 · 175 阅读 · 0 评论 -
打包下载PDF
/*打包下载*/ @RequestMapping(params = "loadZipPdf") public String loadZipPdf(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String id =...原创 2018-10-15 16:54:46 · 518 阅读 · 0 评论 -
导出Excel
@RequestMapping(params = "doExcel") public void doExcel(HttpServletRequest request, HttpServletResponse response) { String fxgc = request.getParameter("fxgc"); String sql = "select x.* from (sele...原创 2018-10-15 17:02:44 · 124 阅读 · 0 评论 -
UUID
/** * 获得UUID,保证数据库表ID的唯一性 * */ public static String getUUID(){ String s = UUID.randomUUID().toString(); //去掉“-”符号 return s.substring(0,8)+s.substring(9,13)+s.substri...原创 2018-10-15 17:13:43 · 441 阅读 · 0 评论 -
java设置excel
POI中可能会用到一些需要设置EXCEL单元格格式的操作小结: 先获取工作薄对象: HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(); HSSFCellStyle setBorder = wb.createCellStyle(); 一、设置背景色: setBorder.setF...原创 2018-10-22 10:15:38 · 693 阅读 · 0 评论 -
table表格复选框多选获取ID和字段值
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><%@include file="/context/mytags.jsp"%><t:base type="jquery,easyui,tools">&a原创 2018-11-25 16:38:15 · 3233 阅读 · 0 评论 -
已知两个时间、得出相差几天
// 取得两个日期之间的相差多少天 public static long getDaysBetween(Date date0, Date date1) { long daysBetween = (date0.getTime() - date1.getTime() + 1000000) / 86400000;// 86400000=3600*24*1000 用立即数,减少乘法计算的开销 ...原创 2018-11-25 16:25:42 · 179 阅读 · 0 评论 -
使用Hibernate 的sql 多数据源查询
1、数据库配置:#MySQLjdbc3.driverClassName=com.mysql.jdbc.Driver#jdbc.url=jdbc\:mysql\://0.0.0.0\:3306/sss?useUnicode\=true&characterEncoding\=UTF-8jdbc3.url=jdbc\:mysql\://0.0.0.0\:3306/sss?useUnic...原创 2018-11-25 16:28:11 · 456 阅读 · 0 评论