Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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·¶ÐÍ

     ´Ójdk1.5¿ªÊ¼£¬JavaÖпªÊ¼Ö§³Ö·¶ÐÍÁË¡£·¶ÐÍÊÇÒ»¸öºÜÓÐÓõıà³Ì¹¤¾ß£¬¸øÎÒÃÇ´øÀ´Á˼«´óµÄÁé»îÐÔ¡£ÔÚ¿´ÁË¡¶javaºËÐıà³Ì¡·Ö®ºó£¬ÎÒСÓÐÊÕ»ñ£¬Ð´³öÀ´Óë´ó¼Ò·ÖÏí¡£ 
     Ëùν·¶ÐÍ£¬Îҵĸоõ¾ÍÊÇ£¬²»Óÿ¼ÂǶÔÏóµÄ¾ßÌåÀàÐÍ£¬¾Í¿ÉÒÔ¶Ô¶ÔÏó½øÐÐÒ»¶¨µÄ²Ù×÷£¬¶ÔÈκζÔÏó¶¼Ä ......

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


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

JAVA ¾«È·¼ÆËãʱµÄÏÝÚå troy

ÔÚjava.math°üÖÐÓиöBigDecimalÀ࣬ͨ¹ýÕâ¸öÀà¿ÉÒÔ½øÐо«È·¼ÆËã. ÎÒÃÇÖªµÀBigDecimalÓиösetScale(int ¾«¶È,int ÉáÈëģʽ)·½·¨£¬ËæÖ®¶øÀ´ÎÊÌâ³öÏÖÁË£¬µ±ÔËÐÐÈçÏ´úÂëʱ£º
/**
 * @author troy(J2EE)
 * @version 1.0
 */
import java.math.*;
 
public class Test{  
  & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ