Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySqlÓëJavaµÄʱ¼äÀàÐÍ

MySqlµÄʱ¼äÀàÐÍÓР         JavaÖÐÓëÖ®¶ÔÓ¦µÄʱ¼äÀàÐÍ
date                                           java.sql.Date
Datetime                                    java.sql.Timestamp
Timestamp                                  java.sql.Timestamp
Time                                          java.sql.Time
Year                                           java.sql.Date
 
 
¶ÔÆä½øÐзÖÎö
²Î¿¼MySql µÄreference manual
Date:
A date. The supported range is '1000-01-01' to '9999-12-31'. MySQL displays DATE values in 'YYYY-MM-DD' format, but allows you to assign values to DATE columns using either strings or numbers.
Ö»¼Ç¼ÈÕÆÚÐÅÏ¢£¬±íʾ·¶Î§Îª1000-01-01 ÖÁ 9999-12-31¡£
MySql °´ÕÕYYYY-MM-DD µÄ·½Ê½½øÐиÃÀà×ֶεÄÏÔʾ¡£Ìí¼Ó¸ÃÀà×Ö¶ÎÊý¾Ý£¬¼´¿ÉÒÔʹÓÃ×Ö·û´®ÀàÐÍ£¬Ò²¿ÉÒÔʹÓÃÊý×ÖÀàÐÍ
 
ÓÉÓÚDateÀàÐ͵Ä×Ö¶ÎÖ»¼Ç¼ÈÕÆÚÐÅÏ¢£¬ËùÒÔÈç¹ûÌí¼ÓµÄÊý¾ÝÖаüº¬ÁËʱ¼äÐÅÏ¢£¬¸Ãʱ¼äÐÅÏ¢½«»á×Ô¶¯±»½Ø¶Ï¡£
Èç¹ûÒª±£´æÊ±¼äÐÅÏ¢£¬¿ÉÒÔ¿¼ÂÇʹÓÃDateTimeÀàÐÍ¡£
¾­¹ý²âÊÔ£¬·¢ÏÖÈçÏÂ2ÖÖ·½Ê½¿ÉÒÔ¶ÔDateÀàÐÍ×ֶνøÐÐÌ


Ïà¹ØÎĵµ£º

JAVAºÍPHP»ñÈ¡mysql×îºó²åÈëµÄ×ÔÔöidÖµ

phpºÍjavaͨÓÃsqlÓï¾ä·¨
SELECT max(id) from table
¸Ã·½·¨ÔÚ¶àÏ̵߳ÈÇé¿öÏ¿ÉÄÜ»áÔì³É²»ÕýÈ·¡£
javaÈýÖÖ·½·¨
1¡¢¸ù¾ÝpsµÄgetGeneratedKeys
PreparedStatement ps = conn.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS); //ºìÉ«Êǹؼü
ps.executeUpdate(); //Ö´Ðкó
ResultSet rs = ps.getGeneratedKeys ......

javaµ¥Ì¬Ä£Ê½½²½â


µ¥Ì¬¶¨Òå:
        SingletonģʽÖ÷Òª×÷ÓÃÊDZ£Ö¤ÔÚJavaÓ¦ÓóÌÐòÖУ¬Ò»¸öÀàClassÖ»ÓÐÒ»¸öʵÀý´æÔÚ¡£
        Singletonģʽ¾ÍΪÎÒÃÇÌṩÁËÕâÑùʵÏֵĿÉÄÜ¡£Ê¹ÓÃSingletonµÄºÃ´¦»¹ÔÚÓÚ¿ÉÒÔ½ÚÊ¡Äڴ棬ÒòΪËüÏÞÖÆÁËʵÀýµÄ¸öÊý£¬ÓÐÀûÓÚJavaÀ¬»ø»ØÊÕ£¨garbage c ......

Java ÔËËã·ûÓÅÏȼ¶


ÓÅÏȼ¶
ÔËËã·û
Ãû³Æ
1
( )
À¨ºÅ
2
[ ] , ¡£
ºó׺ÔËËã·û
3
- (Ò»ÔªÔËËã·û£¬È¡¸ºÊý) , ! , ~ , ++ , --
Ò»ÔªÔËËã·û
4
* , / , %
³Ë£¬³ý£¬È¡Ä£
5
+, -
¼Ó£¬¼õ
6
>> , << , >>>
ÒÆÎ»ÔËËã·û
7
> , < , >= , <= , instanceof
¹ØÏµÔËËã·û
8
==,!=
µÈÓÚ£¬²»µÈÓÚ
9
......

Nutz Java ±àÂë¹æ·¶ (V1.0)

Nutz Java ±àÂë¹æ·¶ (V1.0) By:zozoh 0. ¹æ·¶µÄ¹æ·¶ 1. ´úÂë¸ñʽ 2.1 °ü 2.2 ÀàºÍ½Ó¿Ú 2.3 ³ÉÔ±±äÁ¿ 2.4 ³£Á¿ 2.5 ¾Ö²¿±äÁ¿ 2.6 ³ÉÔ±º¯ÊýºÍ¾²Ì¬º¯Êý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ