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ÀàÐÍ×ֶνøÐÐÌ
Ïà¹ØÎĵµ£º
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 ......
×î½ü¹«Ë¾Òª¿ª·¢Windowsƽ̨ÉϵIJúÆ·£¨ÓÉÓÚÉæ¼°µ½ÉÌÒµ»úÃÜ£¬ËùÒÔĿǰÎÞ·¨¶ÔÕâ¸ö²úÆ·×öÏêϸ½éÉÜ£©£¬²ÉÓÃ.Net¼¼Êõ½øÐпª·¢£¬ÎÒ¸ºÔðµÄÊÇ»ùÓÚ Visual Studio²å¼þ»úÖÆµÄÐÐÒµ¿ª·¢¹¤¾ßµÄ¿ª·¢¡£´Ó¿ªÊ¼½Ó´¥.Netµ½ÏÖÔÚÒѾÓнüÈý¸öÔÂÁË£¬¶øÇÒÒ²¿ª·¢³öÁ˵ÚÒ»¸ö°æ±¾£¬¶Ô.NetÒѾÓÐÁËһЩÈÏʶ£¬ÓÉÓÚÒÔǰÖ÷ÒªÓÃJava¡¢PythonµÈÓïÑ ......
1¡¢¶ÔÏóÊǰ´ÒýÓô«µÝµÄ---´ø"="ºÅµÄ¸³Öµ²Ù×÷
2¡¢Java Ó¦ÓóÌÐòÓÐÇÒ½öÓеÄÒ»ÖÖ²ÎÊý´«µÝ»úÖÆ£¬¼´°´Öµ´«µÝ---ÓÉ"º¯Êýµ÷ÓÃ"ÒýÆðµÄ
3¡¢°´Öµ´«µÝÒâζ×ŵ±½«Ò»¸ö²ÎÊý´«µÝ¸øÒ»¸öº¯Êýʱ£¬º¯Êý½ÓÊÕµÄÊÇÔʼֵµÄÒ»¸ö¸±±¾
4¡¢°´ÒýÓô«µÝÒâζ×ŵ±½«Ò»¸ö²ÎÊý´«µÝ¸øÒ»¸öº¯Êýʱ£¬º¯Êý½ÓÊÕµÄÊÇÔʼֵµÄÄÚ´æµØÖ·£¬¶ø²»ÊÇÖµ µÄ¸±±¾
5¡¢×¢ ......
µ¥Ì¬¶¨Òå:
SingletonģʽÖ÷Òª×÷ÓÃÊDZ£Ö¤ÔÚJavaÓ¦ÓóÌÐòÖУ¬Ò»¸öÀàClassÖ»ÓÐÒ»¸öʵÀý´æÔÚ¡£
Singletonģʽ¾ÍΪÎÒÃÇÌṩÁËÕâÑùʵÏֵĿÉÄÜ¡£Ê¹ÓÃSingletonµÄºÃ´¦»¹ÔÚÓÚ¿ÉÒÔ½ÚÊ¡Äڴ棬ÒòΪËüÏÞÖÆÁËʵÀýµÄ¸öÊý£¬ÓÐÀûÓÚJavaÀ¬»ø»ØÊÕ£¨garbage c ......