word的 Map result = (Map) dao.queryForObject("internshipnew.getsxba2moban", dto); Date date = new Date(); SimpleDateFormat formatter = new SimpleDateFormat("yyyy年MM月dd日"); String YGBHDQ = formatter.format(date); String YGBHDP = formatter.format(date); result.put("ygbhdq", YGBHDQ); result.put("ygbhdp", YGBHDP); return result;
excel的 DateUtils.getChangeDate(map.get(JgyxFieldTableConstant.YGBHDP)), DateUtils.getChangeDate(map.get(JgyxFieldTableConstant.YGBHDQ)),
public static String getChangeDate(String strDate) throws ParseException { SimpleDateFormat sm = new SimpleDateFormat("yyyy-MM-dd"); Calendar cal = Calendar.getInstance(); cal.setTime(sm.parse(strDate)); int year = cal.get(Calendar.YEAR); int month = cal.get(Calendar.MONTH); int day = cal.get(Calendar.DATE); return year + "年" + (month+1) + "月" + day + "日"; }
public static String getChangeDatett(String strDate) throws ParseException { SimpleDateFormat sm = new SimpleDateFormat("yyyyMMdd"); Calendar cal = Calendar.getInstance(); cal.setTime(sm.parse(strDate)); int year = cal.get(Calendar.YEAR); int month = cal.get(Calendar.MONTH); int day = cal.get(Calendar.DATE); return year + "年" + (month+1) + "月" + day + "日"; }