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 ......
PHPµÄÒ»¸öÊý¾Ý¿â²Ù×÷Àà,ÒÔUTF8¸ñʽдÈë,Êý¾Ý¿âÄÚÖ±½ÓÏÔʾÕý³£ÖÐÎÄ,·ÀÖ¹²éѯ³ö´í
/**
* @author xggxnn
* ±¾ÀàÓÃÓÚʵÏÖÓйØÊý¾Ý¿âµÄ·ÃÎÊ
*
*/
class DBConnection {
private $host = "";
private $user = "";
private $pass = "";
private $DBname = "";
public $isConnected = false;
/**
* ¹¹Ôìº ......
½Å±¾±äÁ¿ÊÇʹÓà var »ò def ¹Ø¼ü×ÖÉùÃ÷µÄ¡£
¶þÕßÖ®¼äµÄÇø±ðÔÚÓÚ£ºÔڽű¾µÄÕû¸öÉúÃüÖÜÆÚÄÚ¶¼¿ÉÒÔΪ var ±äÁ¿¸³ÓèÐÂÖµ£¬
¶ø def ±äÁ¿ÔÚ±»Ê״θ³ÓèÐÂÖµºó½«±£³Ö²»±ä£»
def numOne = 100;
def numTwo = 2;
var result;
add();
subtract();
multiply();
divide();
function add() {
result = numOne + numTwo; ......
ÓÐʱºòÎÒÃÇ»áÓöµ½java³ÌÐòʹÓÃÄÚ´æ¹ý¶àµÄÇé¿ö£¬ÕâÖÖÇé¿öÒ»°ãÊÇÒòΪ³ÌÐòÓÐÄÚ´æÐ¹Â©£¬ÄÇôÈçºÎ·ÖÎöÊÇ·ñÓÐÄÚ´æÐ¹Â©ÄØ£¿ÆäʵÔÒò±È½Ï¼òµ¥£¬ÏÈÓÃjmapÀ´Éú³ÉÒ»¸ö½ø³ÌµÄÄÚ´æ¿ìÕÕ£¬È»ºóÀûÓÃheapAnalyzer»òÕßMod4JÀ´¶ÔÕâ¸ö¿ìÕÕ½øÐзÖÎö£¬ÕÒµ½ÄÚ´æÊ¹ÓÃ×î¶àµÄ¶ÔÏ󡣯äʵÓÐÎÞÄÚ´æÐ¹Â©µÄÒ»¸ö±íÏÖ¾ÍÊÇÄÚ´æ·Ö²¼ÊÇ·ñ¾ùÔÈ£¬Èç¹û²»¾ùÔÈ£¬Ò»°ãÀ ......