javaÈçºÎ»ñÈ¡Á½ÈÕÆÚÖ®¼äµÄÔ·ÝÊý - Java / Java EE
date1:2010-05-20
date2:2010-06-21
·µ»Ø½á¹ûΪ2¸öÔÂ
date3:2010-05-20
date4:2010-06-20
·µ»Ø½á¹ûΪ1¸öÔÂ
date5:2010-05-20
date6:2010-06-19
·µ»Ø½á¹ûΪ0¸öÔÂ
ÇëÎÊÕâÑùµÄ³ÌÐò¸ÃÔõôд£¿Ð»Ð»£¡
Months_betweenº¯Êý£¬È磺
select Months_between(to_date('2009-12-01','yyyy-mm-dd'), to_date('2008-12-01','yyyy-mm-dd')) from dual;
·µ»Ø12
1. /**
2. * ¼ÆËãÁ½¸öÈÕÆÚÖ®¼äÏà²îµÄÔÂÊý
3. * @param date1
4. * @param date2
5. * @return
6. */
7. private int getMonths(Date date1, Date date2){
8. int iMonth = 0;
9. int flag = 0;
10. try{
11. Calendar objCalendarDate1 = Calendar.getInstance();
12. objCalendarDate1.setTime(date1);
13.
14. Calendar objCalendarDate2 = Calendar.getInstance();
15. objCalendarDate2.setTime(date2);
16.
17. if (objCalendarDate2.equals(objCalendarDate1))
18. return 0;
19. if (objCalendarDate1.after(objCalendarDate2)){
&
Ïà¹ØÎÊ´ð£º
ÇëÎʸ÷λ¸ç¸ç½ã½ã£¬ÈçºÎÔËÓÃÏֳɵÄÄ£°åÀ´ÖÆ×÷ƯÁÁµÄJSPÍøÒ³Ñ½,»ØÕßÓзÖ!
×Ô¼º¶¥Ï£¬×ÜÓиßÊÖ°É,ÆÚ´ýÖÐ......
Èç¹ûÖ±½ÓÒýÓýøÈ¥
¿ÉÒÔÖ±½ÓÓÃjspµÄÖ¸ÁҲ¿ÉÒÔÓÃfreemarkÒýÓ㬼ǵøø·Ö
лл¸÷λÁË£¬¿´À´Î ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......
ÎÒдÁ˸öjspÒ³Ãæ£¬È»ºó¸Ä¶¯ÁËһϣ¬¸Ä¶¯µÄÄÚÈݾÍÊÇÔÚjspÒ³ÃæµÄjsº¯ÊýÀï¼ÓÁ˸öalert()Óï¾ä£¬µ«ÊÇÎÒ·ÃÎÊÕâ¸öÒ³ÃæÊ±£¬ËÀ»î¶¼ÊÇÔÀ´Ò³ÃæµÄÄÚÈÝ£¬ÎÒ¼ÓÁ˺ܶàalertº¯Êý»¹ÊÇû¸Ä¶¯Ç°µÄÒ³ÃæÄÚÈÝ£»tomcatÖØÆôÁË£¬Ò²ÖØÐ²¿ÊðÕâ ......