Java°æµÄdatediff
¡¡¡¡MSSQLÖÐÌṩÁ˸ödatediffº¯ÊýÓÃÀ´¶ÔÁ½¸öʱ¼ä½øÐмõ·¨²Ù×÷£¬µ«ÔÚJavaÖÐȴûÓУ¬Èç¹ûÎÒÃÇÏëÖªµÀÁ½¸öÈÕÆÚ¼äÏà¸ôÁ˶àÉÙÌ죬»òÊÇÏà¸ôÁ˶àÉÙ¸öСʱÔòÒªÊÖ¹¤¼ÆËã¡£ÏÂÃæ´úÂëÄ£·ÂMSSQLµÄdatediffº¯ÊýÌṩÁËʹÓò»Í¬Ê±¼ä¼ä¸ôÀ´¼ÆËãÁ½¸öʱ¼äÏà²îµÄʱ¼ä¼ä¸ôµÄÊýÄ¿£¬±ÈÈçtimeIntervalΪdayÔò·µ»ØÏà²îµÄÌìÊý£¬ÎªmonthÔò·µ»ØÏà²îµÄÔÂÊý¡£×ܹ²Ö§³Öyear,quarter,month,week,day,hour,minute,secondÕ⼸ÖÖʱ¼ä¼ä¸ô£¬date1ºÍdate2ΪҪ¼ÆËãµÄÁ½¸öʱ¼ä£¬½á¹ûΪdate1¼õÈ¥date2ºóµÄÖµ¡£
/**
* °´Ö¸¶¨ÈÕÆÚµ¥Î»¼ÆËãÁ½¸öÈÕÆÚ¼äµÄ¼ä¸ô
*
* @param timeInterval
* @param date1
* @param date2
* @return
*/
public static long dateDiff(String timeInterval, Date date1, Date date2) {
if (timeInterval.equals("year")) {
Calendar calendar = Calendar.getInstance();
calendar.setTime(date1);
int time = calendar.get(Calendar.YEAR);
calendar.setTime(date2);
return time - calendar.get(Calendar.YEAR);
}
if (timeInterval.equals("quarter")) {
Calendar calendar = Calendar.getInstance();
calendar.setTime(date1);
int time = calendar.get(Calendar.YEAR) * 4;
calendar.setTime(date2);
time -= calendar.get(Calendar.YEAR) * 4;
calendar.setTime(date1);
time += calendar.get(Calendar.MONTH) / 4;
calendar.setTime(date2);
return time - calendar.get(Calendar.MONTH) / 4;
}
if (timeInterval.equals("month")) {
Calendar calendar = Calendar.getInstance();
calendar.setTime(date1);
int time = calendar.get(Calendar.YEAR) * 12;
calendar.setTime(date2);
time -= calendar.get(Calendar.YEAR) * 12;
calendar.setTime(date1);
time += calendar.get(Calendar.MONT
Ïà¹ØÎĵµ£º
ÔÚ Java ÀíÂÛºÍʵ¼ù µÄ Ç°Ò»ÆÚÎÄÕ ÖУ¬Java™ Çå½à¹¤³Ìʦ Brian Goetz ̽¾¿ÁËÈõÒýÓã¨weak references£©£¬ËüÈÃÄú¾¯¸æÀ¬»øÊÕ¼¯Æ÷£¬ÄúÏëҪά»¤Ò»¸ö¶ÔÏóµÄÒýÓ㬶ø²»»á×èÖ¹¸Ã¶ÔÏó±»À¬»øÊÕ¼¯¡£ÔÚ±¾ÆÚÎÄÕÂÖУ¬Ëû½«½âÊÍ Reference ¶ÔÏóµÄÁíÍâÒ»ÖÖÐÎʽ£¬¼´ÈíÒýÓã¨soft references£©£¬ÓÃÓÚ°ïÖúÀ¬»øÊÕ¼¯Æ÷¹ÜÀíÄÚ´æʹÓúÍÏû³ýÇ ......
×¼±¸¹¤×÷
Ê×ÏÈ£¬²Ù×÷ϵͳÖа²×°ºÃSQL Server 2000/2005£¬Èç¹ûϵͳÖж¼×°ÓÐ2000ºÍ2005°æ£¬¼ÇµÃÍ£ÓÃÒ»¸ö£¬Ö»¿ªÒ»¸öÐÐÁË¡£
È»ºó£¬µ½Î¢ÈíÍøÕ¾ÏÂÔØMicrosoft SQL Server 2005 JDBC Driver 1.1
£¬Ò²¿ÉÒÔʹÓÃÕâ¸öµØÖ·Ö±½ÓÏÂÔØ
¡£
½âѹsqljdbc_1.1.1501.101_chs.exe£¬°Ñsqljdbc_1.1¸´ÖƵ½%ProgramFiles%£¨Èç¹ûϵͳÔÚCÅÌÔòΪC:\ ......
¡¡¡¡Í¨³£ÔÚÓÃJAVA¿ª·¢Èí¼þµÄ¹ý³ÌÖУ¬ÎÒÃdz£³£»áÓöµ½ÐèÒª°ÑһЩϵͳµÄÅäÖòÎÊý±£´æµ½Êý¾Ý¿âÖÐÒÔ·ÀÖ¹¶ªÊ§£¬´«Í³µÄ·½·¨Êǽ«Ã¿¸öÅäÖòÎÊý×÷Ϊ¶ÔÏóÀ´½¨Á¢Êý¾Ý¿âÄ£ÐÍ£¬Ï൱ÓÚ°ÑÄ£ÐÍÖеĶÔÏó°ó¶¨µ½Êý¾Ý±íµÄÿ¸ö×Ö¶ÎÉÏ£¬µ«ÕâÑù×öµÄ»°Áé»î¶ÈÌ«µÍ£¬µ±ÐèÒªÌí¼ÓÅäÖòÎÊýʱÏȵÃÍùÊý¾Ý±íÌí¼Ó×ֶΣ¬ÔÙÐÞ¸ÄÊý¾Ý¿âÄ£ÐͺÍÏà¹ØµÄÓ³ÉäÎļþ¡£ÄÜ·ñ ......