spring+hibernate，自己封装了原生sql的处理，模仿mybatis使用

package com.cn.commoms; import java.text.DateFormat; import java.text.ParsePosition; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.Date; import java.util.GregorianCalendar; import java.util.List; import java.util.regex.Pattern; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; public class DateUtil { protected static Log logger = LogFactory.getLog(DateUtil.class); /** 格式：年－月－日 小时：分钟：秒 **/ public static final String FORMAT_ONE = "yyyy-MM-dd HH:mm:ss"; /** 格式：年－月－日 小时：分钟 **/ public static final String FORMAT_TWO = "yyyy-MM-dd HH:mm"; /** 格式：年月日 小时分钟秒 **/ public static final String FORMAT_THREE = "yyyyMMdd-HHmmss"; /** 格式：年－月－日 **/ public static final String LONG_DATE_FORMAT = "yyyy-MM-dd"; /** 格式：月－日 **/ public static final String SHORT_DATE_FORMAT = "MM-dd"; /** 格式：小时：分钟：秒 **/ public static final String LONG_TIME_FORMAT = "HH:mm:ss"; /** yyyyMMddHHmmss 紧凑类型 **/ public static final String LONG_DATE_COMPACT_FORMAT = "yyyyMMddHHmmss" ; // 年的加减 public static final int SUB_YEAR = Calendar.YEAR; // 月加减 public static final int SUB_MONTH = Calendar.MONTH; // 天的加减 public static final int SUB_DAY = Calendar.DATE; // 小时的加减 public static final int SUB_HOUR = Calendar.HOUR; // 分钟的加减 public static final int SUB_MINUTE = Calendar.MINUTE; // 秒的加减 public static final int SUB_SECOND = Calendar.SECOND; // 用来全局控制 上一周，本周，下一周的周数变化 private int weeks = 0; private int MaxDate;// 一月最大天数 private int MaxYear;// 一年最大天数 public DateUtil() { } /** * 把符合日期格式的字符串转换为日期类型 * * @param dateStr * @return */ public static java.util.Date StringtoDate(String dateStr, String format) { Date d = null; SimpleDateFormat formater = new SimpleDateFormat(format); try { formater.setLenient(false); d = formater.parse(dateStr); } catch (Exception e) { // log.error(e); d = null; } return d; } /** * 把符合日期格式的字符串转换为日期类型 */ public static java.util.Date StringtoDate(String dateStr, String format, ParsePosition pos) { Date d = null; SimpleDateFormat formater = new SimpleDateFormat(format); try { formater.setLenient(false); d = formater.parse(dateStr, pos); } catch (Exception e) { // log.error(e); d = null; } return d; } /** * 把日期转换为字符串 * * @param date * @return */ public static String DateToString(java.util.Date date, String format) { String result = ""; SimpleDateFormat formater = new SimpleDateFormat(format); try { result = formater.format(date); } catch (Exception e) { // log.error(e); } return result; } /** * 获取当前时间的指定格式 * * @param format * @return */ public static String getCurrDate(String format) { return DateToString(new Date(), format); } /** * * @param dateStr * @param amount * @return */ public static String DateSub(int dateKind, String dateStr, int amount) { Date date = StringtoDate(dateStr, FORMAT_ONE); Calendar calendar = Calendar.getInstance(); calendar.setTime(date); calendar.add(dateKind, amount); return DateToString(calendar.getTime(), FORMAT_ONE); } /** * 两个日期相减 * * @param firstTime * @param secTime * @return 相减得到的秒数 */ public static long TimeSub(String firstTime, String secTime) { long first = StringtoDate(firstTime, FORMAT_ONE).getTime(); long second = StringtoDate(secTime, FORMAT_ONE).getTime(); return (second - first) / 1000; } /** * 获得某月的天数 * * @param year * int * @param month * int * @return int */ public static int getDaysOfMonth(String year, String month) { int days = 0; if (month.equals("1") || month.equals("3") || month.equals("5") || month.equals("7") || month.equals("8") || month.equals("10") || month.equals("12")) { days = 31; } else if (month.equals("4") || month.equals("6") || month.equals("9") || month.equals("11")) { days = 30; } else { if ((Integer.parseInt(year) % 4 == 0 && Integer.parseInt(year) % 100 != 0) || Integer.parseInt(year) % 400 == 0) { days = 29; } else { days = 28; } } return days; } /** * 获取某年某月的天数 * * @param year * int * @param month * int 月份[1-12] * @return int */ public static int getDaysOfMonth(int year, int month) { Calendar calendar = Calendar.getInstance(); calendar.set(year, month - 1, 1); return calendar.getActualMaximum(Calendar.DAY_OF_MONTH); } /** * 获得当前日期 * * @return int */ public static int getToday() { Calendar calendar = Calendar.getInstance(); return calendar.get(Calendar.DATE); } /** * 获得当前月份 * * @return int */ public static int getToMonth() { Calendar calendar = Calendar.getInstance(); return calendar.get(Calendar.MONTH) + 1; } /** * 获得当前年份 * * @return int */ public static int getToYear() { Calendar calendar = Calendar.getInstance(); return calendar.get(Calendar.YEAR); } /** * 返回日期的天 * * @param date * Date * @return int */ public static int getDay(Date date) { Calendar calendar = Calendar.getInstance(); calendar.setTime(date); return calendar.get(Calendar.DATE); } /** * 返回日期的年 * * @param date * Date * @return int */ public static int getYear(Date date) { Calendar calendar = Calendar.getInstance(); calendar.setTime(date); return calendar.get(Calendar.YEAR); } /** * 返回日期的月份，1-12 * * @param date * Date * @return int */ public static int getMonth(Date date) { Calendar calendar = Calendar.getInstance(); calendar.setTime(date); return calendar.get(Calendar.MONTH) + 1; } /** * 计算两个日期相差的天数，如果date2 > date1 返回正数，否则返回负数 * * @param date1 * Date * @param date2 * Date * @return long */ public static long dayDiff(Date date1, Date date2) { return (date2.getTime() - date1.getTime()) / 86400000; } /** * 比较两个日期的年差 * * @param befor * @param after * @return */ public static int yearDiff(String before, String after) { Date beforeDay = StringtoDate(before, LONG_DATE_FORMAT); Date afterDay = StringtoDate(after, LONG_DATE_FORMAT); return getYear(afterDay) - getYear(beforeDay); } /** * 比较指定日期与当前日期的差 * * @param befor * @param after * @return */ public static int yearDiffCurr(String after) { Date beforeDay = new Date(); Date afterDay = StringtoDate(after, LONG_DATE_FORMAT); return getYear(beforeDay) - getYear(afterDay); } public static int getFirstWeekdayOfMonth(int year, int month) { Calendar c = Calendar.getInstance(); c.setFirstDayOfWeek(Calendar.SATURDAY); // 星期天为第一天 c.set(year, month - 1, 1); return c.get(Calendar.DAY_OF_WEEK); } public static int getLastWeekdayOfMonth(int year, int month) { Calendar c = Calendar.getInstance(); c.setFirstDayOfWeek(Calendar.SATURDAY); // 星期天为第一天 c.set(year, month - 1, getDaysOfMonth(year, month)); return c.get(Calendar.DAY_OF_WEEK); } /** * 获得当前日期字符�