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
Ïà¹ØÎĵµ£º
reflection: Ö¸ÎÒÃÇ¿ÉÒÔÓÚjava³ÌÐòÖ´ÐÐÆÚÔØÈ롢֪̽¡¢Ê¹ÓñàÒëÆÚ¼äÍêȫδ֪µÄclasses.»»¾ä»°Ëµ£¬java³ÌÐò¿ÉÒÔÔØÈëÒ»¸öÖ´ÐÐÆÚ²ÅµÃÖªÃû³ÆµÄclass,»ñϤÆäÍêÕû¹¹Ô죨µ«²»°üÀ¨methods¶¨Ò壩£¬²¢Éú³ÉʵÌå¡¢»ò¶ÔÆäfieldsÉèÖµ¡¢»ò»½ÆðÆämethods¡£ ......
JavaÔÚJDK1.3Ö®ºó¼ÓÈëÁË¿ÉÐÖú¿ª·¢¶¯Ì¬´úÀí¹¦ÄܵÄAPI.ʹÓö¯Ì¬´úÀí£¬¿ÉÒÔʹһ¸ö´¦ÀíÕߣ¨´úÀí£©·þÎñÓÚ¸÷¸ö¶ÔÏó¡£´´½¨Ò»¸ö¶¯Ì¬´úÀíÀàÖ»ÐèʵÏÖjava.lang.reflect.InvocationHandler½Ó¿Ú¡£
ÏÂÃæ´´½¨Ò»¸ö´¦ÀíÈÕÖ¾µÄ¶¯Ì¬´úÀíÀàLogHandlerÈ¥´úÀíHelloSpeakerÀà
Ê×ÏÈ´´½¨HelloSpeakerµÄ½Ó¿Ú
pa ......
¸ø Java SE ×¢Èë½Å±¾ÓïÑԵĻîÁ¦
Mustang µÄ½Å±¾ÓïÑÔÐÂÌØÐÔ
ÎĵµÑ¡Ïî
½«´ËÒ³×÷Ϊµç×ÓÓʼþ·¢ËÍ
½«´ËÒ³×÷Ϊµç×ÓÓʼþ·¢ËÍ
¼¶±ð£º Öм¶
Îâ 玥ò« (wuyuehao@cn.ibm.com), Èí¼þ¹¤³Ìʦ, IBM
2006 Äê 10 ÔÂ 30 ÈÕ
ÔÚ¼´½«·¢²¼µÄ Java SE6£¨Mustang£©ÖУ¬Ôö¼ÓÁ˶Խű¾ÓïÑÔµÄÖ§³Ö¡£Í¨¹ý¶Ô½Å± ......
¾¹ýÁËÒ»ÖܵÄŬÁ¦£¬³É¹¦Ç©ÏÂÁËÉϺ£±¦ÐÅÈí¼þÎ÷°²·Ö¹«Ë¾¡£
ÔÚÕâÀ¼òµ¥·ÖÏíÒ»ÏÂÕâ´ÎµÄ¾Àú¡£
Ê×Ïȼòµ¥³ÂÊöϸöÈ˵ÄһЩ»ù±¾ÐÅÏ¢£¬Õý¹æÍ³Õб¾¿Æ·Ç¼ÆËã»úרҵ£¬2008-2009Äê8Ô½ÓÊܶ«·½±ê×¼Èí¼þ¹¤³ÌʦÅàѵ£¬Íê³ÉÁËһЩ±È½ÏÍêÕûµÄÏîÄ¿£¬ÕÆÎÕÁË»ù±¾µÄJ2EE¿ª·¢µÄºËÐļ¼Êõ¡£Åàѵ½áÊøÁË£¬²Î¼ÓÁËһЩ֪ÃûÆóÒµµÄУ԰ ......
×¼±¸¹¤×÷
Ê×ÏÈ£¬²Ù×÷ϵͳÖа²×°ºÃ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:\ ......