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 ......
´Ójdk1.5¿ªÊ¼£¬JavaÖпªÊ¼Ö§³Ö·¶ÐÍÁË¡£·¶ÐÍÊÇÒ»¸öºÜÓÐÓõıà³Ì¹¤¾ß£¬¸øÎÒÃÇ´øÀ´Á˼«´óµÄÁé»îÐÔ¡£ÔÚ¿´ÁË¡¶javaºËÐıà³Ì¡·Ö®ºó£¬ÎÒСÓÐÊÕ»ñ£¬Ð´³öÀ´Óë´ó¼Ò·ÖÏí¡£
Ëùν·¶ÐÍ£¬Îҵĸоõ¾ÍÊÇ£¬²»Óÿ¼ÂǶÔÏóµÄ¾ßÌåÀàÐÍ£¬¾Í¿ÉÒÔ¶Ô¶ÔÏó½øÐÐÒ»¶¨µÄ²Ù×÷£¬¶ÔÈκζÔÏó¶¼Ä ......
µ¥Ì¬¶¨Òå:
SingletonģʽÖ÷Òª×÷ÓÃÊDZ£Ö¤ÔÚJavaÓ¦ÓóÌÐòÖУ¬Ò»¸öÀàClassÖ»ÓÐÒ»¸öʵÀý´æÔÚ¡£
Singletonģʽ¾ÍΪÎÒÃÇÌṩÁËÕâÑùʵÏֵĿÉÄÜ¡£Ê¹ÓÃSingletonµÄºÃ´¦»¹ÔÚÓÚ¿ÉÒÔ½ÚÊ¡Äڴ棬ÒòΪËüÏÞÖÆÁËʵÀýµÄ¸öÊý£¬ÓÐÀûÓÚJavaÀ¬»ø»ØÊÕ£¨garbage c ......
ÔÚjava.math°üÖÐÓиöBigDecimalÀ࣬ͨ¹ýÕâ¸öÀà¿ÉÒÔ½øÐо«È·¼ÆËã. ÎÒÃÇÖªµÀBigDecimalÓиösetScale(int ¾«¶È,int ÉáÈëģʽ)·½·¨£¬ËæÖ®¶øÀ´ÎÊÌâ³öÏÖÁË£¬µ±ÔËÐÐÈçÏ´úÂëʱ£º
/**
* @author troy(J2EE)
* @version 1.0
*/
import java.math.*;
public class Test{
& ......