锘??xml version="1.0" encoding="utf-8" standalone="yes"?>五月天婷亚洲天综合网精品偷,噜噜综合亚洲AV中文无码,国产精品亚洲一区二区在线观看 http://www.tkk7.com/adamduan/zh-cnMon, 12 May 2025 02:39:55 GMTMon, 12 May 2025 02:39:55 GMT60Jquery鎿嶄綔selecthttp://www.tkk7.com/adamduan/archive/2012/04/05/373368.html孌墊棴孌墊棴Thu, 05 Apr 2012 06:00:00 GMThttp://www.tkk7.com/adamduan/archive/2012/04/05/373368.htmlhttp://www.tkk7.com/adamduan/comments/373368.htmlhttp://www.tkk7.com/adamduan/archive/2012/04/05/373368.html#Feedback0http://www.tkk7.com/adamduan/comments/commentRss/373368.htmlhttp://www.tkk7.com/adamduan/services/trackbacks/373368.html闃呰鍏ㄦ枃

孌墊棴 2012-04-05 14:00 鍙戣〃璇勮
]]>
Oracle鍏ㄨ澶夋彌http://www.tkk7.com/adamduan/archive/2012/03/27/372839.html孌墊棴孌墊棴Tue, 27 Mar 2012 10:52:00 GMThttp://www.tkk7.com/adamduan/archive/2012/03/27/372839.htmlhttp://www.tkk7.com/adamduan/comments/372839.htmlhttp://www.tkk7.com/adamduan/archive/2012/03/27/372839.html#Feedback0http://www.tkk7.com/adamduan/comments/commentRss/372839.htmlhttp://www.tkk7.com/adamduan/services/trackbacks/372839.htmlSELECT 

               UTL_I18N.TRANSLITERATE (TO_MULTI_BYTE(NAME), 'KANA_HIRAGANA') NAME--鍗婅銈偪銈儕銉昏嫳鏁板瓧-->鍏ㄨ銇層倝銇嬨仾
             , UTL_I18N.TRANSLITERATE (TO_MULTI_BYTE(KANA), 'KANA_FWKATAKANA') KANA--鍗婅銈偪銈儕-->鍏ㄨ銈偪銈儕
             , UTL_I18N.TRANSLITERATE (TO_MULTI_BYTE(SEIKINAME), 'KANA_HIRAGANA') SEIKINAME--鍗婅銈偪銈儕-->鍏ㄨ銇層倝銇嬨仾
             , UTL_I18N.TRANSLITERATE (TO_MULTI_BYTE(SEIKIKANA), 'HIRAGANA_HWKATAKANA') SEIKIKANA --鍏ㄨ銇層倝銇嬨仾銉匯偒銈褲偒銉?->鍗婅銈褲偒
             , UTL_I18N.TRANSLITERATE (TO_MULTI_BYTE(ZYUSHO), 'KANA_HIRAGANA') ZYUSHO--鍗婅銈偪銈儕-->鍏ㄨ銇層倝銇嬨仾



孌墊棴 2012-03-27 18:52 鍙戣〃璇勮
]]>
mysql 鍙栨暣鍑芥暟http://www.tkk7.com/adamduan/archive/2012/03/07/371415.html孌墊棴孌墊棴Wed, 07 Mar 2012 08:32:00 GMThttp://www.tkk7.com/adamduan/archive/2012/03/07/371415.htmlhttp://www.tkk7.com/adamduan/comments/371415.htmlhttp://www.tkk7.com/adamduan/archive/2012/03/07/371415.html#Feedback0http://www.tkk7.com/adamduan/comments/commentRss/371415.htmlhttp://www.tkk7.com/adamduan/services/trackbacks/371415.html

1.ceil 錛堬級 /ceiling錛堬級 鍚戜笂鍙栨暣

    ex錛?ceil錛?.2錛?= 2

 2.floor 錛堬級 鍚戜笅鍙栨暣

     ex錛?floor錛?.2錛?= 1

 3.round錛堬級 鍥涜垗浜斿叆



孌墊棴 2012-03-07 16:32 鍙戣〃璇勮
]]>
mysql 鏃ユ湡http://www.tkk7.com/adamduan/archive/2012/03/07/371414.html孌墊棴孌墊棴Wed, 07 Mar 2012 08:31:00 GMThttp://www.tkk7.com/adamduan/archive/2012/03/07/371414.htmlhttp://www.tkk7.com/adamduan/comments/371414.htmlhttp://www.tkk7.com/adamduan/archive/2012/03/07/371414.html#Feedback0http://www.tkk7.com/adamduan/comments/commentRss/371414.htmlhttp://www.tkk7.com/adamduan/services/trackbacks/371414.html

榪欓噷鏄竴涓嬌鐢ㄦ棩鏈熷嚱鏁扮殑渚嬪瓙銆備笅闈㈢殑鏌ヨ閫夋嫨浜嗘墍鏈夎褰曪紝鍏禿ate_col鐨勫兼槸鍦ㄦ渶鍚?0澶╀互鍐咃細

mysql> SELECT something FROM table 
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30;

DAYOFWEEK(date) 
榪斿洖鏃ユ湡date鐨勬槦鏈熺儲寮?1=鏄熸湡澶╋紝2=鏄熸湡涓, ……7=鏄熸湡鍏?銆傝繖浜涚儲寮曞煎搴斾簬ODBC鏍囧噯銆?nbsp;
mysql> select DAYOFWEEK('1998-02-03'); 
-> 3

WEEKDAY(date) 
榪斿洖date鐨勬槦鏈熺儲寮?0=鏄熸湡涓錛?=鏄熸湡浜? ……6= 鏄熸湡澶?銆?nbsp;
mysql> select WEEKDAY('1997-10-04 22:23:00'); 
-> 5 
mysql> select WEEKDAY('1997-11-05'); 
-> 2

DAYOFMONTH(date) 
榪斿洖date鐨勬湀浠戒腑鏃ユ湡錛屽湪1鍒?1鑼冨洿鍐呫?nbsp;
mysql> select DAYOFMONTH('1998-02-03'); 
-> 3

DAYOFYEAR(date) 
榪斿洖date鍦ㄤ竴騫翠腑鐨勬棩鏁? 鍦?鍒?66鑼冨洿鍐呫?nbsp;
mysql> select DAYOFYEAR('1998-02-03'); 
-> 34

MONTH(date) 
榪斿洖date鐨勬湀浠斤紝鑼冨洿1鍒?2銆?nbsp;
mysql> select MONTH('1998-02-03'); 
-> 2

DAYNAME(date) 
榪斿洖date鐨勬槦鏈熷悕瀛椼?nbsp;
mysql> select DAYNAME("1998-02-05"); 
-> 'Thursday'

MONTHNAME(date) 
榪斿洖date鐨勬湀浠藉悕瀛椼?nbsp;
mysql> select MONTHNAME("1998-02-05"); 
-> 'February'

QUARTER(date) 
榪斿洖date涓騫翠腑鐨勫搴︼紝鑼冨洿1鍒?銆?nbsp;
mysql> select QUARTER('98-04-01'); 
-> 2

WEEK(date)

WEEK(date,first) 
瀵逛簬鏄熸湡澶╂槸涓鍛ㄧ殑絎竴澶╃殑鍦版柟錛屾湁涓涓崟涓弬鏁幫紝榪斿洖date鐨勫懆鏁幫紝鑼冨洿鍦?鍒?2銆?涓弬鏁板艦寮廤EEK()鍏佽 
浣犳寚瀹氭槦鏈熸槸鍚﹀紑濮嬩簬鏄熸湡澶╂垨鏄熸湡涓銆傚鏋滅浜屼釜鍙傛暟鏄?錛屾槦鏈熶粠鏄熸湡澶╁紑濮嬶紝濡傛灉絎簩涓弬鏁版槸1錛?nbsp;
浠庢槦鏈熶竴寮濮嬨?nbsp;
mysql> select WEEK('1998-02-20'); 
-> 7 
mysql> select WEEK('1998-02-20',0); 
-> 7 
mysql> select WEEK('1998-02-20',1); 
-> 8

YEAR(date) 
榪斿洖date鐨勫勾浠斤紝鑼冨洿鍦?000鍒?999銆?nbsp;
mysql> select YEAR('98-02-03'); 
-> 1998

HOUR(time) 
榪斿洖time鐨勫皬鏃訛紝鑼冨洿鏄?鍒?3銆?nbsp;
mysql> select HOUR('10:05:03'); 
-> 10

MINUTE(time) 
榪斿洖time鐨勫垎閽燂紝鑼冨洿鏄?鍒?9銆?nbsp;
mysql> select MINUTE('98-02-03 10:05:03'); 
-> 5

SECOND(time) 
鍥炴潵time鐨勭鏁幫紝鑼冨洿鏄?鍒?9銆?nbsp;
mysql> select SECOND('10:05:03'); 
-> 3

PERIOD_ADD(P,N) 
澧炲姞N涓湀鍒伴樁孌礟錛堜互鏍煎紡YYMM鎴朰YYYMM)銆備互鏍煎紡YYYYMM榪斿洖鍊箋傛敞鎰忛樁孌靛弬鏁癙涓嶆槸鏃ユ湡鍊箋?nbsp;
mysql> select PERIOD_ADD(9801,2); 
-> 199803

PERIOD_DIFF(P1,P2) 
榪斿洖鍦ㄦ椂鏈烶1鍜孭2涔嬮棿鏈堟暟錛孭1鍜孭2搴旇浠ユ牸寮廦YMM鎴朰YYYMM銆傛敞鎰忥紝鏃舵湡鍙傛暟P1鍜孭2涓嶆槸鏃ユ湡鍊箋?nbsp;
mysql> select PERIOD_DIFF(9802,199703); 
-> 11

DATE_ADD(date,INTERVAL expr type)

DATE_SUB(date,INTERVAL expr type)

ADDDATE(date,INTERVAL expr type)

SUBDATE(date,INTERVAL expr type) 
榪欎簺鍔熻兘鎵ц鏃ユ湡榪愮畻銆傚浜嶮ySQL 3.22錛屼粬浠槸鏂扮殑銆侫DDDATE()鍜孲UBDATE()鏄疍ATE_ADD()鍜孌ATE_SUB()鐨勫悓涔夎瘝銆?nbsp;
鍦∕ySQL 3.23涓紝浣犲彲浠ヤ嬌鐢?鍜?鑰屼笉鏄疍ATE_ADD()鍜孌ATE_SUB()銆傦紙瑙佷緥瀛愶級date鏄竴涓寚瀹氬紑濮嬫棩鏈熺殑 
DATETIME鎴朌ATE鍊鹼紝expr鏄寚瀹氬姞鍒板紑濮嬫棩鏈熸垨浠庡紑濮嬫棩鏈熷噺鍘葷殑闂撮殧鍊間竴涓〃杈懼紡錛宔xpr鏄竴涓瓧絎︿覆錛涘畠鍙互浠?nbsp;
涓涓?#8220;-”寮濮嬭〃紺鴻礋闂撮殧銆倀ype鏄竴涓叧閿瘝錛屾寚鏄庤〃杈懼紡搴旇濡備綍琚В閲娿侲XTRACT(type FROM date)鍑芥暟浠庢棩鏈?nbsp;
涓繑鍥?#8220;type”闂撮殧銆備笅琛ㄦ樉紺轟簡type鍜宔xpr鍙傛暟鎬庢牱琚叧鑱旓細 type鍊?鍚箟 鏈熸湜鐨別xpr鏍煎紡 
SECOND 縐?SECONDS 
MINUTE 鍒嗛挓 MINUTES 
HOUR 鏃墮棿 HOURS 
DAY 澶?DAYS 
MONTH 鏈?MONTHS 
YEAR 騫?YEARS 
MINUTE_SECOND 鍒嗛挓鍜岀 "MINUTES:SECONDS" 
HOUR_MINUTE 灝忔椂鍜屽垎閽?"HOURS:MINUTES" 
DAY_HOUR 澶╁拰灝忔椂 "DAYS HOURS" 
YEAR_MONTH 騫村拰鏈?"YEARS-MONTHS" 
HOUR_SECOND 灝忔椂, 鍒嗛挓錛?"HOURS:MINUTES:SECONDS" 
DAY_MINUTE 澶? 灝忔椂, 鍒嗛挓 "DAYS HOURS:MINUTES" 
DAY_SECOND 澶? 灝忔椂, 鍒嗛挓, 縐?"DAYS HOURS:MINUTES:SECONDS"

MySQL鍦╡xpr鏍煎紡涓厑璁鎬換浣曟爣鐐瑰垎闅旂銆傝〃紺烘樉紺虹殑鏄緩璁殑鍒嗛殧絎︺傚鏋渄ate鍙傛暟鏄竴涓狣ATE鍊煎茍涓斾綘鐨勮綆椾粎浠?nbsp;
鍖呭惈YEAR銆丮ONTH鍜孌AY閮ㄥ垎(鍗籌紝娌℃湁鏃墮棿閮ㄥ垎)錛岀粨鏋滄槸涓涓狣ATE鍊箋傚惁鍒欑粨鏋滄槸涓涓狣ATETIME鍊箋?/p>

mysql> SELECT "1997-12-31 23:59:59" + INTERVAL 1 SECOND; 
-> 1998-01-01 00:00:00 
mysql> SELECT INTERVAL 1 DAY + "1997-12-31"; 
-> 1998-01-01 
mysql> SELECT "1998-01-01" - INTERVAL 1 SECOND; 
-> 1997-12-31 23:59:59 
mysql> SELECT DATE_ADD("1997-12-31 23:59:59", 
INTERVAL 1 SECOND); 
-> 1998-01-01 00:00:00 
mysql> SELECT DATE_ADD("1997-12-31 23:59:59", 
INTERVAL 1 DAY); 
-> 1998-01-01 23:59:59 
mysql> SELECT DATE_ADD("1997-12-31 23:59:59", 
INTERVAL "1:1" MINUTE_SECOND); 
-> 1998-01-01 00:01:00 
mysql> SELECT DATE_SUB("1998-01-01 00:00:00", 
INTERVAL "1 1:1:1" DAY_SECOND); 
-> 1997-12-30 22:58:59 
mysql> SELECT DATE_ADD("1998-01-01 00:00:00", 
INTERVAL "-1 10" DAY_HOUR); 
-> 1997-12-30 14:00:00 
mysql> SELECT DATE_SUB("1998-01-02", INTERVAL 31 DAY); 
-> 1997-12-02 
mysql> SELECT EXTRACT(YEAR FROM "1999-07-02"); 
-> 1999 
mysql> SELECT EXTRACT(YEAR_MONTH FROM "1999-07-02 01:02:03"); 
-> 199907 
mysql> SELECT EXTRACT(DAY_MINUTE FROM "1999-07-02 01:02:03"); 
-> 20102

濡傛灉浣犳寚瀹氬お鐭殑闂撮殧鍊?涓嶅寘鎷瑃ype鍏抽敭璇嶆湡鏈涚殑闂撮殧閮ㄥ垎)錛孧ySQL鍋囪浣犵渷鎺変簡闂撮殧鍊肩殑鏈宸﹂潰閮ㄥ垎銆備緥濡傦紝 
濡傛灉浣犳寚瀹氫竴涓猼ype鏄疍AY_SECOND錛屽糴xpr琚笇鏈涙湁澶┿佸皬鏃躲佸垎閽熷拰縐掗儴鍒嗐傚鏋滀綘璞?1:10"榪欐牱鎸囧畾鍊鹼紝 
MySQL鍋囪鏃ュ瓙鍜屽皬鏃墮儴鍒嗘槸涓㈠け鐨勫茍涓斿間唬琛ㄥ垎閽熷拰縐掋傛崲鍙ヨ瘽璇達紝"1:10" DAY_SECOND浠ュ畠絳変環浜?1:10" MINUTE_SECOND 
鐨勬柟寮忚В閲婏紝榪欏閭ySQL瑙i噴TIME鍊艱〃紺虹粡榪囩殑鏃墮棿鑰岄潪浣滀負涓澶╃殑鏃墮棿鐨勬柟寮忔湁浜屼箟鎬с傚鏋滀綘浣跨敤紜疄涓嶆紜殑鏃ユ湡錛?nbsp;
緇撴灉鏄疦ULL銆傚鏋滀綘澧炲姞MONTH銆乊EAR_MONTH鎴朰EAR騫朵笖緇撴灉鏃ユ湡澶т簬鏂版湀浠界殑鏈澶у煎ぉ鏁幫紝鏃ュ瓙鍦ㄦ柊鏈堢敤鏈澶х殑澶╄皟鏁淬?/p>

mysql> select DATE_ADD('1998-01-30', Interval 1 month); 
-> 1998-02-28

娉ㄦ剰錛屼粠鍓嶉潰鐨勪緥瀛愪腑璇岻NTERVAL鍜宼ype鍏抽敭璇嶄笉鏄尯鍒嗗ぇ灝忓啓鐨勩?nbsp;
TO_DAYS(date) 
緇欏嚭涓涓棩鏈焏ate錛岃繑鍥炰竴涓ぉ鏁?浠?騫寸殑澶╂暟)銆?nbsp;
mysql> select TO_DAYS(950501); 
-> 728779 
mysql> select TO_DAYS('1997-10-07'); 
-> 729669

TO_DAYS()涓嶆墦綆楃敤浜庝嬌鐢ㄦ牸鍒楅珮閲屽巻(1582)鍑虹幇鍓嶇殑鍊箋?/p>

FROM_DAYS(N) 
緇欏嚭涓涓ぉ鏁癗錛岃繑鍥炰竴涓狣ATE鍊箋?nbsp;
mysql> select FROM_DAYS(729669); 
-> '1997-10-07'

TO_DAYS()涓嶆墦綆楃敤浜庝嬌鐢ㄦ牸鍒楅珮閲屽巻(1582)鍑虹幇鍓嶇殑鍊箋?/p>

DATE_FORMAT(date,format) 
鏍規嵁format瀛楃涓叉牸寮忓寲date鍊箋備笅鍒椾慨楗扮鍙互琚敤鍦╢ormat瀛楃涓蹭腑錛?%M 鏈堝悕瀛?January……December) 
%W 鏄熸湡鍚嶅瓧(Sunday……Saturday) 
%D 鏈夎嫳璇墠緙鐨勬湀浠界殑鏃ユ湡(1st, 2nd, 3rd, 絳夌瓑銆傦級 
%Y 騫? 鏁板瓧, 4 浣?nbsp;
%y 騫? 鏁板瓧, 2 浣?nbsp;
%a 緙╁啓鐨勬槦鏈熷悕瀛?Sun……Sat) 
%d 鏈堜喚涓殑澶╂暟, 鏁板瓧(00……31) 
%e 鏈堜喚涓殑澶╂暟, 鏁板瓧(0……31) 
%m 鏈? 鏁板瓧(01……12) 
%c 鏈? 鏁板瓧(1……12) 
%b 緙╁啓鐨勬湀浠藉悕瀛?Jan……Dec) 
%j 涓騫翠腑鐨勫ぉ鏁?001……366) 
%H 灝忔椂(00……23) 
%k 灝忔椂(0……23) 
%h 灝忔椂(01……12) 
%I 灝忔椂(01……12) 
%l 灝忔椂(1……12) 
%i 鍒嗛挓, 鏁板瓧(00……59) 
%r 鏃墮棿,12 灝忔椂(hh:mm:ss [AP]M) 
%T 鏃墮棿,24 灝忔椂(hh:mm:ss) 
%S 縐?00……59) 
%s 縐?00……59) 
%p AM鎴朠M 
%w 涓涓槦鏈熶腑鐨勫ぉ鏁?0=Sunday ……6=Saturday 錛?nbsp;
%U 鏄熸湡(0……52), 榪欓噷鏄熸湡澶╂槸鏄熸湡鐨勭涓澶?nbsp;
%u 鏄熸湡(0……52), 榪欓噷鏄熸湡涓鏄槦鏈熺殑絎竴澶?nbsp;
%% 涓涓枃瀛?#8220;%”銆?/p>

鎵鏈夌殑鍏朵粬瀛楃涓嶅仛瑙i噴琚鍒跺埌緇撴灉涓?/p>

mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y'); 
-> 'Saturday October 1997' 
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s'); 
-> '22:23:00' 
mysql> select DATE_FORMAT('1997-10-04 22:23:00', 
'%D %y %a %d %m %b %j'); 
-> '4th 97 Sat 04 10 Oct 277' 
mysql> select DATE_FORMAT('1997-10-04 22:23:00', 
'%H %k %I %r %T %S %w'); 
-> '22 22 10 10:23:00 PM 22:23:00 00 6' 
MySQL3.23涓紝鍦ㄦ牸寮忎慨楗扮瀛楃鍓嶉渶瑕?銆傚湪MySQL鏇存棭鐨勭増鏈腑錛?鏄彲閫夌殑銆?/p>

TIME_FORMAT(time,format) 
榪欒薄涓婇潰鐨凞ATE_FORMAT()鍑芥暟涓鏍蜂嬌鐢紝浣嗘槸format瀛楃涓插彧鑳藉寘鍚鐞嗗皬鏃躲佸垎閽熷拰縐掔殑閭d簺鏍煎紡淇グ絎︺?nbsp;
鍏朵粬淇グ絎︿駭鐢熶竴涓狽ULL鍊兼垨0銆?nbsp;
CURDATE()

CURRENT_DATE 
浠?YYYY-MM-DD'鎴朰YYYMMDD鏍煎紡榪斿洖浠婂ぉ鏃ユ湡鍊鹼紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鏁板瓧涓婁笅鏂囪浣跨敤銆?nbsp;
mysql> select CURDATE(); 
-> '1997-12-15' 
mysql> select CURDATE() + 0; 
-> 19971215

CURTIME()

CURRENT_TIME 
浠?HH:MM:SS'鎴朒HMMSS鏍煎紡榪斿洖褰撳墠鏃墮棿鍊鹼紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鍦ㄦ暟瀛楃殑涓婁笅鏂囪浣跨敤銆?nbsp;
mysql> select CURTIME(); 
-> '23:50:26' 
mysql> select CURTIME() + 0; 
-> 235026

NOW()

SYSDATE()

CURRENT_TIMESTAMP 
浠?YYYY-MM-DD HH:MM:SS'鎴朰YYYMMDDHHMMSS鏍煎紡榪斿洖褰撳墠鐨勬棩鏈熷拰鏃墮棿錛屽彇鍐充簬鍑芥暟鏄湪涓涓瓧絎︿覆榪樻槸鍦ㄦ暟瀛楃殑 
涓婁笅鏂囪浣跨敤銆?nbsp;
mysql> select NOW(); 
-> '1997-12-15 23:50:26' 
mysql> select NOW() + 0; 
-> 19971215235026

UNIX_TIMESTAMP()

UNIX_TIMESTAMP(date) 
濡傛灉娌℃湁鍙傛暟璋冪敤錛岃繑鍥炰竴涓猆nix鏃墮棿鎴寵(浠?1970-01-01 00:00:00'GMT寮濮嬬殑縐掓暟)銆傚鏋淯NIX_TIMESTAMP()鐢ㄤ竴 
涓猟ate鍙傛暟琚皟鐢紝瀹冭繑鍥炰粠'1970-01-01 00:00:00' GMT寮濮嬬殑縐掓暟鍊箋俤ate鍙互鏄竴涓狣ATE瀛楃涓層佷竴涓狣ATETIME 
瀛楃涓層佷竴涓猅IMESTAMP鎴栦互YYMMDD鎴朰YYYMMDD鏍煎紡鐨勬湰鍦版椂闂寸殑涓涓暟瀛椼?nbsp;
mysql> select UNIX_TIMESTAMP(); 
-> 882226357 
mysql> select UNIX_TIMESTAMP('1997-10-04 22:23:00'); 
-> 875996580

褰揢NIX_TIMESTAMP琚敤浜庝竴涓猅IMESTAMP鍒楋紝鍑芥暟灝嗙洿鎺ユ帴鍙楀鹼紝娌℃湁闅愬惈鐨?#8220;string-to-unix-timestamp”鍙樻崲銆?/p>

FROM_UNIXTIME(unix_timestamp) 
浠?YYYY-MM-DD HH:MM:SS'鎴朰YYYMMDDHHMMSS鏍煎紡榪斿洖unix_timestamp鍙傛暟鎵琛ㄧず鐨勫鹼紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆 
榪樻槸鎴栨暟瀛椾笂涓嬫枃涓浣跨敤銆?nbsp;
mysql> select FROM_UNIXTIME(875996580); 
-> '1997-10-04 22:23:00' 
mysql> select FROM_UNIXTIME(875996580) + 0; 
-> 19971004222300

FROM_UNIXTIME(unix_timestamp,format) 
榪斿洖琛ㄧず Unix 鏃墮棿鏍囪鐨勪竴涓瓧絎︿覆錛屾牴鎹甪ormat瀛楃涓叉牸寮忓寲銆俧ormat鍙互鍖呭惈涓嶥ATE_FORMAT()鍑芥暟鍒楀嚭鐨勬潯 
鐩悓鏍風殑淇グ絎︺?nbsp;
mysql> select FROM_UNIXTIME(UNIX_TIMESTAMP(), 
'%Y %D %M %h:%i:%s %x'); 
-> '1997 23rd December 03:43:30 x'

SEC_TO_TIME(seconds) 
榪斿洖seconds鍙傛暟錛屽彉鎹㈡垚灝忔椂銆佸垎閽熷拰縐掞紝鍊間互'HH:MM:SS'鎴朒HMMSS鏍煎紡鍖栵紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鍦ㄦ暟瀛?nbsp;
涓婁笅鏂囦腑琚嬌鐢ㄣ?nbsp;
mysql> select SEC_TO_TIME(2378); 
-> '00:39:38' 
mysql> select SEC_TO_TIME(2378) + 0; 
-> 3938

TIME_TO_SEC(time) 
榪斿洖time鍙傛暟錛岃漿鎹㈡垚縐掋?nbsp;
mysql> select TIME_TO_SEC('22:23:00'); 
-> 80580 
mysql> select TIME_TO_SEC('00:39:38'); 
-> 2378
DATE_FORMAT(date,format) 
鏍規嵁format瀛楃涓叉牸寮忓寲date鍊箋備笅鍒椾慨楗扮鍙互琚敤鍦╢ormat瀛楃涓蹭腑錛?%M 鏈堝悕瀛?January……December) 
%W 鏄熸湡鍚嶅瓧(Sunday……Saturday) 
%D 鏈夎嫳璇墠緙鐨勬湀浠界殑鏃ユ湡(1st, 2nd, 3rd, 絳夌瓑銆傦級 
%Y 騫? 鏁板瓧, 4 浣?nbsp;
%y 騫? 鏁板瓧, 2 浣?nbsp;
%a 緙╁啓鐨勬槦鏈熷悕瀛?Sun……Sat) 
%d 鏈堜喚涓殑澶╂暟, 鏁板瓧(00……31) 
%e 鏈堜喚涓殑澶╂暟, 鏁板瓧(0……31) 
%m 鏈? 鏁板瓧(01……12) 
%c 鏈? 鏁板瓧(1……12) 
%b 緙╁啓鐨勬湀浠藉悕瀛?Jan……Dec) 
%j 涓騫翠腑鐨勫ぉ鏁?001……366) 
%H 灝忔椂(00……23) 
%k 灝忔椂(0……23) 
%h 灝忔椂(01……12) 
%I 灝忔椂(01……12) 
%l 灝忔椂(1……12) 
%i 鍒嗛挓, 鏁板瓧(00……59) 
%r 鏃墮棿,12 灝忔椂(hh:mm:ss [AP]M) 
%T 鏃墮棿,24 灝忔椂(hh:mm:ss) 
%S 縐?00……59) 
%s 縐?00……59) 
%p AM鎴朠M 
%w 涓涓槦鏈熶腑鐨勫ぉ鏁?0=Sunday ……6=Saturday 錛?nbsp;
%U 鏄熸湡(0……52), 榪欓噷鏄熸湡澶╂槸鏄熸湡鐨勭涓澶?nbsp;
%u 鏄熸湡(0……52), 榪欓噷鏄熸湡涓鏄槦鏈熺殑絎竴澶?nbsp;
%% 涓涓枃瀛?#8220;%”銆?鎵鏈夌殑鍏朵粬瀛楃涓嶅仛瑙i噴琚鍒跺埌緇撴灉涓?/p>

mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y'); 
-> 'Saturday October 1997' 
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s'); 
-> '22:23:00' 
mysql> select DATE_FORMAT('1997-10-04 22:23:00', 
'%D %y %a %d %m %b %j'); 
-> '4th 97 Sat 04 10 Oct 277' 
mysql> select DATE_FORMAT('1997-10-04 22:23:00', 
'%H %k %I %r %T %S %w'); 
-> '22 22 10 10:23:00 PM 22:23:00 00 6' 
MySQL3.23涓紝鍦ㄦ牸寮忎慨楗扮瀛楃鍓嶉渶瑕?銆傚湪MySQL鏇存棭鐨勭増鏈腑錛?鏄彲閫夌殑銆?/p>

TIME_FORMAT(time,format) 
榪欒薄涓婇潰鐨凞ATE_FORMAT()鍑芥暟涓鏍蜂嬌鐢紝浣嗘槸format瀛楃涓插彧鑳藉寘鍚鐞嗗皬鏃躲佸垎閽熷拰縐掔殑閭d簺鏍煎紡淇グ絎︺?/p>

鍏朵粬淇グ絎︿駭鐢熶竴涓狽ULL鍊兼垨0銆?nbsp;
CURDATE()

CURRENT_DATE 
浠?YYYY-MM-DD'鎴朰YYYMMDD鏍煎紡榪斿洖浠婂ぉ鏃ユ湡鍊鹼紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鏁板瓧涓婁笅鏂囪浣跨敤銆?nbsp;
mysql> select CURDATE(); 
-> '1997-12-15' 
mysql> select CURDATE() + 0; 
-> 19971215

CURTIME()

CURRENT_TIME 
浠?HH:MM:SS'鎴朒HMMSS鏍煎紡榪斿洖褰撳墠鏃墮棿鍊鹼紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鍦ㄦ暟瀛楃殑涓婁笅鏂囪浣跨敤銆?nbsp;
mysql> select CURTIME(); 
-> '23:50:26' 
mysql> select CURTIME() + 0; 
-> 235026

NOW()

SYSDATE()

CURRENT_TIMESTAMP 
浠?YYYY-MM-DD HH:MM:SS'鎴朰YYYMMDDHHMMSS鏍煎紡榪斿洖褰撳墠鐨勬棩鏈熷拰鏃墮棿錛屽彇鍐充簬鍑芥暟鏄湪涓涓瓧絎︿覆榪樻槸鍦ㄦ暟瀛楃殑 
涓婁笅鏂囪浣跨敤銆?nbsp;
mysql> select NOW(); 
-> '1997-12-15 23:50:26' 
mysql> select NOW() + 0; 
-> 19971215235026

UNIX_TIMESTAMP()

UNIX_TIMESTAMP(date) 
濡傛灉娌℃湁鍙傛暟璋冪敤錛岃繑鍥炰竴涓猆nix鏃墮棿鎴寵(浠?1970-01-01 00:00:00'GMT寮濮嬬殑縐掓暟)銆傚鏋淯NIX_TIMESTAMP()鐢ㄤ竴涓猟ate鍙傛暟琚皟鐢紝瀹冭繑鍥炰粠'1970-01-01 00:00:00' GMT寮濮嬬殑縐掓暟鍊箋俤ate鍙互鏄竴涓狣ATE瀛楃涓層佷竴涓狣ATETIME瀛楃涓層佷竴涓猅IMESTAMP鎴栦互YYMMDD鎴朰YYYMMDD鏍煎紡鐨?鏈湴鏃墮棿鐨勪竴涓暟瀛椼?nbsp;
mysql> select UNIX_TIMESTAMP(); 
-> 882226357 
mysql> select UNIX_TIMESTAMP('1997-10-04 22:23:00'); 
-> 875996580

褰揢NIX_TIMESTAMP琚敤浜庝竴涓猅IMESTAMP鍒楋紝鍑芥暟灝嗙洿鎺ユ帴鍙楀鹼紝娌℃湁闅愬惈鐨?#8220;string-to-unix-timestamp”鍙樻崲 www.knowsky.com銆?/p>

FROM_UNIXTIME(unix_timestamp) 
浠?YYYY-MM-DD HH:MM:SS'鎴朰YYYMMDDHHMMSS鏍煎紡榪斿洖unix_timestamp鍙傛暟鎵琛ㄧず鐨勫鹼紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鎴栨暟瀛椾笂涓嬫枃涓浣跨敤銆?nbsp;
mysql> select FROM_UNIXTIME(875996580); 
-> '1997-10-04 22:23:00' 
mysql> select FROM_UNIXTIME(875996580) + 0; 
-> 19971004222300

FROM_UNIXTIME(unix_timestamp,format) 
榪斿洖琛ㄧず Unix 鏃墮棿鏍囪鐨勪竴涓瓧絎︿覆錛屾牴鎹甪ormat瀛楃涓叉牸寮忓寲銆俧ormat鍙互鍖呭惈涓嶥ATE_FORMAT()鍑芥暟鍒楀嚭鐨勬潯鐩悓鏍風殑淇グ絎︺?nbsp;
mysql> select FROM_UNIXTIME(UNIX_TIMESTAMP(), 
'%Y %D %M %h:%i:%s %x'); 
-> '1997 23rd December 03:43:30 x'

SEC_TO_TIME(seconds) 
榪斿洖seconds鍙傛暟錛屽彉鎹㈡垚灝忔椂銆佸垎閽熷拰縐掞紝鍊間互'HH:MM:SS'鎴朒HMMSS鏍煎紡鍖栵紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鍦ㄦ暟瀛椾笂涓嬫枃涓浣跨敤銆?nbsp;
mysql> select SEC_TO_TIME(2378); 
-> '00:39:38' 
mysql> select SEC_TO_TIME(2378) + 0; 
-> 3938

TIME_TO_SEC(time) 
榪斿洖time鍙傛暟錛岃漿鎹㈡垚縐掋?nbsp;
mysql> select TIME_TO_SEC('22:23:00'); 
-> 80580 
mysql> select TIME_TO_SEC('00:39:38'); 
-> 2378



孌墊棴 2012-03-07 16:31 鍙戣〃璇勮
]]>
鏋勫緩jQuery瀵硅薄http://www.tkk7.com/adamduan/archive/2012/02/22/370513.html孌墊棴孌墊棴Wed, 22 Feb 2012 05:10:00 GMThttp://www.tkk7.com/adamduan/archive/2012/02/22/370513.htmlhttp://www.tkk7.com/adamduan/comments/370513.htmlhttp://www.tkk7.com/adamduan/archive/2012/02/22/370513.html#Feedback0http://www.tkk7.com/adamduan/comments/commentRss/370513.htmlhttp://www.tkk7.com/adamduan/services/trackbacks/370513.html(function( window, undefined ) {

   

    var jQuery = (function() {

       // 鏋勫緩jQuery瀵硅薄

       var jQuery = function( selector, context ) {

           return new jQuery.fn.init( selector, context, rootjQuery );

       }

   

       // jQuery瀵硅薄鍘熷瀷

       jQuery.fn = jQuery.prototype = {

           constructor: jQuery,

           init: function( selector, context, rootjQuery ) {

              // selector鏈変互涓?/span>7縐嶅垎鏀儏鍐碉細

              // DOM鍏冪礌

              // body錛堜紭鍖栵級

              // 瀛楃涓詫細HTML鏍囩銆?/span>HTML瀛楃涓層?/span>#id銆侀夋嫨鍣ㄨ〃杈懼紡

              // 鍑芥暟錛堜綔涓?/span>ready鍥炶皟鍑芥暟錛?/span>

              // 鏈鍚庤繑鍥炰吉鏁扮粍

           }

       };

   

       // Give the init function the jQuery prototype for later instantiation

       jQuery.fn.init.prototype = jQuery.fn;

   

       // 鍚堝茍鍐呭鍒扮涓涓弬鏁頒腑錛屽悗緇ぇ閮ㄥ垎鍔熻兘閮介氳繃璇ュ嚱鏁版墿灞?/span>

       // 閫氳繃jQuery.fn.extend鎵╁睍鐨勫嚱鏁幫紝澶ч儴鍒嗛兘浼氳皟鐢ㄩ氳繃jQuery.extend鎵╁睍鐨勫悓鍚嶅嚱鏁?/span>

       jQuery.extend = jQuery.fn.extend = function() {};

      

       // 鍦?/span>jQuery涓婃墿灞曢潤鎬佹柟娉?/span>

       jQuery.extend({

           // ready bindReady

           // isPlainObject isEmptyObject

           // parseJSON parseXML

           // globalEval

           // each makeArray inArray merge grep map

           // proxy

           // access

           // uaMatch

           // sub

           // browser

       });

 

        // 鍒拌繖閲岋紝jQuery瀵硅薄鏋勯犲畬鎴愶紝鍚庤竟鐨勪唬鐮侀兘鏄jQuery鎴?/span>jQuery瀵硅薄鐨勬墿灞?/span>

       return jQuery;

   

    })();

   

    window.jQuery = window.$ = jQuery;

})(window);



孌墊棴 2012-02-22 13:10 鍙戣〃璇勮
]]>
甯哥敤姝e垯寮?/title><link>http://www.tkk7.com/adamduan/archive/2012/02/22/370497.html</link><dc:creator>孌墊棴</dc:creator><author>孌墊棴</author><pubDate>Wed, 22 Feb 2012 02:57:00 GMT</pubDate><guid>http://www.tkk7.com/adamduan/archive/2012/02/22/370497.html</guid><wfw:comment>http://www.tkk7.com/adamduan/comments/370497.html</wfw:comment><comments>http://www.tkk7.com/adamduan/archive/2012/02/22/370497.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/adamduan/comments/commentRss/370497.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/adamduan/services/trackbacks/370497.html</trackback:ping><description><![CDATA[<div>甯哥敤鐨勬暟瀛楁鍒欙紙涓ユ牸鍖歸厤錛?/div> <div></div> <div>姝e垯<span style="white-space:pre"> </span>鍚箟</div> <div>^[1-9]\d*$<span style="white-space:pre"> </span>鍖歸厤姝f暣鏁?/div> <div>^-[1-9]\d*$<span style="white-space:pre"> </span>鍖歸厤璐熸暣鏁?/div> <div>^-?[1-9]\d*$<span style="white-space:pre"> </span>鍖歸厤鏁存暟</div> <div>^[1-9]\d*|0$<span style="white-space:pre"> </span>鍖歸厤闈炶礋鏁存暟錛堟鏁存暟 + 0錛?/div> <div>^-[1-9]\d*|0$<span style="white-space:pre"> </span>鍖歸厤闈炴鏁存暟錛堣礋鏁存暟 + 0錛?/div> <div>^[1-9]\d*\.\d*|0\.\d*[1-9]\d*$<span style="white-space:pre"> </span>鍖歸厤姝f誕鐐規暟</div> <div>^-([1-9]\d*\.\d*|0\.\d*[1-9]\d*)$<span style="white-space:pre"> </span>鍖歸厤璐熸誕鐐規暟</div> <div>^-?([1-9]\d*\.\d*|0\.\d*[1-9]\d*|0?\.0+|0)$ <span style="white-space:pre"> </span>鍖歸厤嫻偣鏁?/div> <div>^[1-9]\d*\.\d*|0\.\d*[1-9]\d*|0?\.0+|0$<span style="white-space:pre"> </span>鍖歸厤闈炶礋嫻偣鏁幫紙姝f誕鐐規暟 + 0錛?/div> <div>^(-([1-9]\d*\.\d*|0\.\d*[1-9]\d*))|0?\.0+|0$<span style="white-space:pre"> </span>鍖歸厤闈炴嫻偣鏁幫紙璐熸誕鐐規暟 + 0錛?br /> </div><div><br />甯哥敤瀛楃涓叉鍒?/div><div>姝e垯<span style="white-space:pre"> </span>鍚箟<span style="white-space:pre"> </span>琛ュ厖</div><div>^[A-Za-z]+$<span style="white-space:pre"> </span>鍖歸厤鐢?6涓嫳鏂囧瓧姣嶇粍鎴愮殑瀛楃涓?span style="white-space:pre"> </span>鎴?/^[a-z]+$/i</div><div>^[A-Z]+$<span style="white-space:pre"> </span>鍖歸厤鐢?6涓嫳鏂囧瓧姣嶇殑澶у啓緇勬垚鐨勫瓧絎︿覆<span style="white-space:pre"> </span></div><div>^[a-z]+$<span style="white-space:pre"> </span>鍖歸厤鐢?6涓嫳鏂囧瓧姣嶇殑灝忓啓緇勬垚鐨勫瓧絎︿覆<span style="white-space:pre"> </span></div><div>^[A-Za-z0-9]+$<span style="white-space:pre"> </span>鍖歸厤鐢辨暟瀛楀拰26涓嫳鏂囧瓧姣嶇粍鎴愮殑瀛楃涓?span style="white-space:pre"> </span>娉ㄦ剰\w鍖呭惈涓嬪垝綰縚</div><div>^\w+$<span style="white-space:pre"> </span>鍖歸厤鐢辨暟瀛椼?6涓嫳鏂囧瓧姣嶆垨鑰呬笅鍒掔嚎緇勬垚鐨勫瓧絎︿覆<span style="white-space:pre"> </span></div><div><br />鍖歸厤涓枃瀛楃</div><div>鏅亶浣跨敤鐨勬鍒欐槸[\u4e00-\u9fa5]錛屼絾榪欎釜鑼冨洿騫朵笉瀹屾暣銆備緥濡傦細</div><div>/[\u4e00-\u9fa5]/.test( '饣? ) // 嫻嬭瘯閮ㄩ饣忥紝榪斿洖false</div><div>鏍規嵁Unicode 5.0鐗堢紪鐮侊紝瑕佸噯紜殑鍒ゆ柇涓涓腑鏂囧瓧絎﹁鍖呮嫭錛?/div><div>鑼冨洿<span style="white-space:pre"> </span>鍚箟<span style="white-space:pre"> </span>鑼冨洿<span style="white-space:pre"> </span>鍚箟</div><div>2E80-2EFF<span style="white-space:pre"> </span>CJK 閮ㄩ琛ュ厖<span style="white-space:pre"> </span>2F00-2FDF<span style="white-space:pre"> </span>搴風啓瀛楀吀閮ㄩ</div><div>3000-303F<span style="white-space:pre"> </span>CJK 絎﹀彿鍜屾爣鐐?span style="white-space:pre"> </span>31C0-31EF<span style="white-space:pre"> </span>CJK 絎旂敾</div><div>3200-32FF<span style="white-space:pre"> </span>灝侀棴寮?CJK 鏂囧瓧鍜屾湀浠?span style="white-space:pre"> </span>3300-33FF<span style="white-space:pre"> </span>CJK 鍏煎</div><div>3400-4DBF<span style="white-space:pre"> </span>CJK 緇熶竴琛ㄦ剰絎﹀彿鎵╁睍 A<span style="white-space:pre"> </span>4DC0-4DFF<span style="white-space:pre"> </span>鏄撶粡鍏崄鍥涘崷絎﹀彿</div><div>4E00-9FBF<span style="white-space:pre"> </span>CJK 緇熶竴琛ㄦ剰絎﹀彿<span style="white-space:pre"> </span>F900-FAFF<span style="white-space:pre"> </span>CJK 鍏煎璞″艦鏂囧瓧</div><div>FE30-FE4F<span style="white-space:pre"> </span>CJK 鍏煎褰㈠紡<span style="white-space:pre"> </span>FF00-FFEF<span style="white-space:pre"> </span>鍏ㄨASCII銆佸叏瑙掓爣鐐?/div><div>鍥犳錛屾紜殑鍖歸厤涓枃瀛楃姝e垯琛ㄨ揪寮忎負錛?/div><div>var rcjk = /[\u2E80-\u2EFF\u2F00-\u2FDF\u3000-\u303F\u31C0-\u31EF\u3200-\u32FF\u3300-\u33FF\u3400-\u4DBF\u4DC0-\u4DFF\u4E00-\u9FBF\uF900-\uFAFF\uFE30-\uFE4F\uFF00-\uFFEF]+/g;</div><div>濡傛灉涓嶅笇鏈涘尮閰嶆爣鐐廣佺鍙鳳紝鍦ㄦ鍒欎腑鍘繪帀瀵瑰簲鐨勮寖鍥村嵆鍙細</div><div>3000-303F<span style="white-space:pre"> </span>CJK 絎﹀彿鍜屾爣鐐?span style="white-space:pre"> </span>FF00-FFEF<span style="white-space:pre"> </span>鍏ㄨASCII銆佸叏瑙掓爣鐐?/div><div><div><br />鍖歸厤鍙屽瓧鑺傚瓧絎?鍖呮嫭姹夊瓧鍦ㄥ唴)</div><div>[^\x00-\xff]錛屽彲浠ョ敤鏉ヨ綆楀瓧絎︿覆鐨勯暱搴︼紙涓涓弻瀛楄妭瀛楃闀垮害璁?錛孉SCII瀛楃璁?錛夛紝浠g爜紺轟緥濡備笅錛?/div><div>console.info( "abc".replace( /[^\x00-\xff]/g,"aa" ).length ) // 3</div><div>console.info( "姹夊瓧".replace( /[^\x00-\xff]/g,"aa" ).length ) // 4</div><div>console.info( "abc姹夊瓧".replace( /[^\x00-\xff]/g,"aa").length ) // 7</div></div><br /><img src ="http://www.tkk7.com/adamduan/aggbug/370497.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/adamduan/" target="_blank">孌墊棴</a> 2012-02-22 10:57 <a href="http://www.tkk7.com/adamduan/archive/2012/02/22/370497.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>JQuery鎬諱綋鏋舵瀯http://www.tkk7.com/adamduan/archive/2012/02/22/370493.html孌墊棴孌墊棴Wed, 22 Feb 2012 02:43:00 GMThttp://www.tkk7.com/adamduan/archive/2012/02/22/370493.htmlhttp://www.tkk7.com/adamduan/comments/370493.htmlhttp://www.tkk7.com/adamduan/archive/2012/02/22/370493.html#Feedback0http://www.tkk7.com/adamduan/comments/commentRss/370493.htmlhttp://www.tkk7.com/adamduan/services/trackbacks/370493.html // 鏋勯爅Query瀵硅薄
var jQuery = function( selector, context ) {
return new jQuery.fn.init( selector, context, rootjQuery );
}
// 宸ュ叿鍑芥暟 Utilities
// 寮傛闃熷垪 Deferred
// 嫻忚鍣ㄦ祴璇?Support
// 鏁版嵁緙撳瓨 Data
// 闃熷垪 queue
// 灞炴ф搷浣?Attribute
// 浜嬩歡澶勭悊 Event
// 閫夋嫨鍣?Sizzle
// DOM閬嶅巻
// DOM鎿嶄綔
// CSS鎿嶄綔
// 寮傛璇鋒眰 Ajax
// 鍔ㄧ敾 FX
// 鍧愭爣鍜屽ぇ灝?br /> window.jQuery = window.$ = jQuery;
})(window);
浠庝笂杈圭殑娉ㄩ噴鐪嬶紝jQuery鐨勬簮鐮佺粨鏋勭浉褰撴竻鏅般佹潯鐞嗭紝涓嶅儚浠g爜閭h埇鏅︽訂鍜岃浜虹籂緇撱?img src ="http://www.tkk7.com/adamduan/aggbug/370493.html" width = "1" height = "1" />

孌墊棴 2012-02-22 10:43 鍙戣〃璇勮
]]>
鑷皟鐢ㄥ尶鍚嶅嚱鏁?self-invoking anonymous functionhttp://www.tkk7.com/adamduan/archive/2012/02/22/370463.html孌墊棴孌墊棴Wed, 22 Feb 2012 02:41:00 GMThttp://www.tkk7.com/adamduan/archive/2012/02/22/370463.htmlhttp://www.tkk7.com/adamduan/comments/370463.htmlhttp://www.tkk7.com/adamduan/archive/2012/02/22/370463.html#Feedback0http://www.tkk7.com/adamduan/comments/commentRss/370463.htmlhttp://www.tkk7.com/adamduan/services/trackbacks/370463.html

(function( window, undefined ) {

    // jquery code

})(window);

1.榪欐槸涓涓?/span>鑷皟鐢ㄥ尶鍚嶅嚱鏁?/span>銆備粈涔堜笢涓滃憿錛熷湪絎竴涓嫭鍙峰唴錛屽垱寤轟竴涓尶鍚嶅嚱鏁幫紱絎簩涓嫭鍙鳳紝绔嬪嵆鎵ц

2.涓轟粈涔堣鍒涘緩榪欐牱涓涓?#8220;鑷皟鐢ㄥ尶鍚嶅嚱鏁?#8221;鍛紵

閫氳繃瀹氫箟涓涓尶鍚嶅嚱鏁幫紝鍒涘緩浜嗕竴涓?#8220;縐佹湁”鐨勫懡鍚嶇┖闂達紝璇ュ懡鍚嶇┖闂寸殑鍙橀噺鍜屾柟娉曪紝涓嶄細鐮村潖鍏ㄥ眬鐨勫懡鍚嶇┖闂淬傝繖鐐歸潪甯告湁鐢ㄤ篃鏄竴涓狫S妗嗘灦蹇呴』鏀寔鐨勫姛鑳斤紝jQuery琚簲鐢ㄥ湪鎴愬崈涓婁竾鐨凧avaScript紼嬪簭涓紝蹇呴』紜繚jQuery鍒涘緩鐨勫彉閲忎笉鑳藉拰瀵煎叆浠栫殑紼嬪簭鎵浣跨敤鐨勫彉閲忓彂鐢熷啿紿併?/span>

3.鍖垮悕鍑芥暟浠庤娉曚笂鍙嚱鏁扮洿鎺ラ噺錛孞avaScript璇硶闇瑕佸寘鍥村尶鍚嶅嚱鏁扮殑鎷彿錛屼簨瀹炰笂鑷皟鐢ㄥ尶鍚嶅嚱鏁版湁涓ょ鍐欐硶錛堟敞鎰忔爣綰簡鐨勫彸鎷彿錛夛細

(function() {

    console.info( this );

    console.info( arguments );

 }( window ) 
);

(function() {

    console.info( this );

    console.info( arguments );

 }
)( window );

4.涓轟粈涔堣浼犲叆window鍛紵

閫氳繃浼犲叆window鍙橀噺錛屼嬌寰梬indow鐢卞叏灞鍙橀噺鍙樹負灞閮ㄥ彉閲忥紝褰撳湪jQuery浠g爜鍧椾腑璁塊棶window鏃訛紝涓嶉渶瑕佸皢浣滅敤鍩熼摼鍥為鍒伴《灞備綔鐢ㄥ煙錛岃繖鏍峰彲浠ユ洿蹇殑璁塊棶window錛涜繖榪樹笉鏄叧閿墍鍦紝鏇撮噸瑕佺殑鏄紝灝唚indow浣滀負鍙傛暟浼犲叆錛屽彲浠ュ湪鍘嬬緝浠g爜鏃惰繘琛屼紭鍖栵紝鐪嬬湅jquery-1.6.1.min.js錛?/span>

 

(function(a,b){})(window); // window 琚紭鍖栦負 a   

5.涓轟粈涔堣鍦ㄥ湪鍙傛暟鍒楄〃涓鍔爑ndefined鍛紵

鍦?nbsp;鑷皟鐢ㄥ尶鍚嶅嚱鏁?/span> 鐨勪綔鐢ㄥ煙鍐咃紝紜繚undefined鏄湡鐨勬湭瀹氫箟銆傚洜涓簎ndefined鑳藉琚噸鍐欙紝璧嬩簣鏂扮殑鍊箋?br />

  undefined = "now it's defined";

  alert( undefined );

嫻忚鍣ㄦ祴璇曠粨鏋滐細

嫻忚鍣?/strong>

嫻嬭瘯緇撴灉

 緇撹

ie

    now it's defined    

  鍙互鏀瑰彉

firefox

undefined

  涓嶈兘鏀瑰彉

chrome

now it's defined

  鍙互鏀瑰彉

opera

now it's defined

  鍙互鏀瑰彉


 6. 娉ㄦ剰鍒版簮鐮佹渶鍚庣殑鍒嗗彿浜嗗悧錛?/span>

鍒嗗彿鏄彲閫夌殑錛屼絾鐪佺暐鍒嗗彿騫朵笉鏄竴涓ソ鐨?/span>緙栫▼涔犳儻錛涗負浜嗘洿濂界殑鍏煎鎬у拰鍋ュ.鎬э紝璇峰湪姣忚浠g爜鍚庡姞涓婂垎鍙峰茍鍏繪垚涔犳儻銆?/span>

 

 



孌墊棴 2012-02-22 10:41 鍙戣〃璇勮
]]>
jquery璁劇疆鍏冪礌鐨剅eadonly鍜宒isabledhttp://www.tkk7.com/adamduan/archive/2012/02/21/370415.html孌墊棴孌墊棴Tue, 21 Feb 2012 07:29:00 GMThttp://www.tkk7.com/adamduan/archive/2012/02/21/370415.htmlhttp://www.tkk7.com/adamduan/comments/370415.htmlhttp://www.tkk7.com/adamduan/archive/2012/02/21/370415.html#Feedback0http://www.tkk7.com/adamduan/comments/commentRss/370415.htmlhttp://www.tkk7.com/adamduan/services/trackbacks/370415.html

Jquery鐨刟pi涓彁渚涗簡瀵瑰厓绱犲簲鐢╠isabled鍜宺eadonly灞炴х殑鏂規硶錛屽湪榪欓噷璁板綍涓嬨傚涓嬶細
 1.readonly
  銆銆$('input').attr("readonly","readonly")//灝唅nput鍏冪礌璁劇疆涓簉eadonly
  銆銆$('input').removeAttr("readonly");//鍘婚櫎input鍏冪礌鐨剅eadonly灞炴?br />  
 銆銆 if($('input').attr("readonly")==true)//鍒ゆ柇input鍏冪礌鏄惁宸茬粡璁劇疆浜唕eadonly灞炴?/p>

 

 銆銆 瀵逛簬涓哄厓绱犺緗畆eadonly灞炴у拰鍙栨秷readonly灞炴х殑鏂規硶榪樻湁濡備笅涓ょ錛?br />  銆銆$('input').attr("readonly",true)//灝唅nput鍏冪礌璁劇疆涓簉eadonly
  銆銆$('input').attr("readonly",false)//鍘婚櫎input鍏冪礌鐨剅eadonly灞炴?/p>

 

  銆銆$('input').attr("readonly","readonly")//灝唅nput鍏冪礌璁劇疆涓簉eadonly
  銆銆$('input').attr("readonly","")//鍘婚櫎input鍏冪礌鐨剅eadonly灞炴?br /> 2.disabled
 

銆銆  $('input').attr("disabled","disabled")//灝唅nput鍏冪礌璁劇疆涓篸isabled
  銆銆$('input').removeAttr("disabled");//鍘婚櫎input鍏冪礌鐨刣isabled灞炴?br />  
  銆銆if($('input').attr("disabled")==true)//鍒ゆ柇input鍏冪礌鏄惁宸茬粡璁劇疆浜哾isabled灞炴?/p>

  

銆銆瀵逛簬涓哄厓绱犺緗甦isabled灞炴у拰鍙栨秷disabled灞炴х殑鏂規硶榪樻湁濡備笅涓ょ錛?br />  銆銆$('input').attr("disabled",true)//灝唅nput鍏冪礌璁劇疆涓篸isabled
  銆銆$('input').attr("disabled",false)//鍘婚櫎input鍏冪礌鐨刣isabled灞炴?/p>

 

  銆銆$('input').attr("disabled","disabled")//灝唅nput鍏冪礌璁劇疆涓篸isabled
  銆銆$('input').attr("disabled","")//鍘婚櫎input鍏冪礌鐨刣isabled灞炴?/p>

孌墊棴 2012-02-21 15:29 鍙戣〃璇勮
]]>
緗戝弸鏁寸悊涓変簹闃插鏀葷暐鎵嬪唽 http://www.tkk7.com/adamduan/archive/2012/01/30/369035.html孌墊棴孌墊棴Mon, 30 Jan 2012 09:12:00 GMThttp://www.tkk7.com/adamduan/archive/2012/01/30/369035.htmlhttp://www.tkk7.com/adamduan/comments/369035.htmlhttp://www.tkk7.com/adamduan/archive/2012/01/30/369035.html#Feedback0http://www.tkk7.com/adamduan/comments/commentRss/369035.htmlhttp://www.tkk7.com/adamduan/services/trackbacks/369035.html銆銆閽堝寰崥鐑鐨?#8220;涓変簹鏃呮父琚”緇忓巻錛屾柊嫻梾娓告牴鎹綉鍙嬬暀璦鍙婅瘎璁烘暣鐞嗕簡涓浠戒笁浜氭嫆緇濇尐瀹版敾鐣ャ?/p>

銆銆璺熷洟娓?/strong>

銆銆鍥㈤槦鏃呰涓紝鏈澶у潡鐨勬尐瀹拌垂涓昏鏄喘鐗╁簵銆佺儳棣?灝忕殑璐圭敤涓昏鏄湅浜哄銆佹綔姘淬佷簰鍔ㄨ妭鐩傛諱箣鏈鍚庝綘鐨勮姳閿寰堝彲鑳借秴鍑哄洟璐廣?/p>

銆銆鏈変簺浜哄湪褰撳湴鎶ュ悕鍙傚姞“涓鏃ユ父”絳夛紝甯歌鐨勮瀹版柟寮忔槸浠庤繖瀹舵梾琛岀ぞ琚?#8220;鍗?#8221;鍒板彟涓瀹舵梾琛岀ぞ錛屽彲鑳借繕瑕佸繊鍙楅潪甯告伓鍔g殑鏈嶅姟鎬佸害銆?/p>

銆銆闃插鏀葷暐錛?/p>

銆銆1.閫夋嫨姝h銆佽妯″ぇ鐨勬梾琛岀ぞ銆?/p>

銆銆2.鍦ㄧ璁㈠悎鍚岀殑鏃跺欙紝緇嗚妭涓瀹氳闂竻妤氾紝鏈変簺涓滆タ闇瑕侀澶栨敞鏄庡湪鍚堝悓涓紝浠ョ‘淇濊嚜韜殑鍒╃泭鑳藉寰楀埌淇濋殰銆?/p>

銆銆3.鍦ㄥ垏韜埄鐩婂彈鍒頒鏡瀹崇殑鏃跺欙紝绔嬪埢鎷ㄦ墦鐩稿叧鎶曡瘔鐢佃瘽錛屽繀瑕佹椂鎶ヨ銆?/p>

銆銆鑷姪娓?/strong>

銆銆銆愬悆嫻烽矞銆?/p>

銆銆瑕佷箞緙烘枻鐭袱錛岃涔堝氨鏄澶╀環鐨勬搗椴滄墍“鎵撹觸”錛屽皯鍒欏嚑鐧撅紝澶氬垯鍑犲崈錛屾櫘閫氭父瀹㈤毦浠ユ壙鍙椼?/p>

銆銆闃插鏀葷暐錛?/p>

銆銆1.濡傛灉鏈夊娓搞佸嚭縐熻濺鍙告満銆佹懇鎵樿濺澶佷笁杞濺澶悜浣犳瀬鍔涙帹鑽愭煇鏌愭搗椴滃簵錛岃澶氱暀涓績鐪鹼紝鎴栬鍒頒簡閭i噷浣犲氨韜笉鐢卞繁浜?#8230;…涓嶈鍚俊璺竟鍙戝箍鍛娿佸彂鍚嶇墖鐨勬父璇淬?/p>

銆銆2.鍚冩搗椴滃彲浠ヨ冭檻嫻烽矞甯傚満銆傚彲浠ヤ拱嫻烽矞鐩存帴鍔犲伐錛屾垚鏈浉瀵逛綆寤夛紝鏂逛究涓斾究瀹溿?/p>

銆銆3.榪滅榛戝績嫻烽矞搴椼?/p>

銆銆榛戝績嫻烽矞搴椾竴鑸垎甯冨湪楂樼閰掑簵鏃佹垨鑰呯甯傚尯杈冭繙鐨勫湴鏂癸紝楠椾漢鐨勬柟娉曟湁鐨勬瀬鍏跺じ寮犮?/p>

銆銆A.褰撲綘鎸囧悜涓涓笢瑗褲侀棶浠鋒牸鐨勬椂鍊欙紝灝忎簩欏哄娍鎷垮嚭灝卞湪浣犵溂鍓嶆媿姝伙紝浣犺繕娌″洖榪囩榪欎釜涓滆タ宸茬粡闇瑕佷綘鏉ヤ拱鍗曚簡!

銆銆B.浣犻棶浠鋒牸鐨勬椂鍊欙紝鑰佹澘鐑儏鍦板憡璇変綘涓嶈吹鍟︽墠4鍏冩瘡鏂ゅ暒錛屼絾絳変綘緇撹處鐨勬椂鍊欏彲鑳芥槸40鍏冩瘡鏂ゆ垨鑰?00鍏冩瘡鏂ゃ?/p>

銆銆C.涓ラ噸緙烘枻鐭袱銆?/p>

銆銆銆愪拱姘存灉銆?/p>

銆銆鍦ㄤ笁浜氫拱緹庡懗鐨勭儹甯︽按鏋滐紝涔熻鏍煎娉ㄦ剰銆?/p>

銆銆1.鑷甫灝忕Г銆?/p>

銆銆緙烘枻鐭袱鏄皬鍟嗚穿浠渶鎯敤鐨勪紟淇╋紝鑰屾垜浠篃搴旇鍚屾牱緇嗗績涓浜涳紝縐頒竴縐版墍璐拱鐨勭墿鍝佸埌搴曞閲?鍏堣皥浠烽挶鍐嶄寒縐?銆?/p>

銆銆2.鍘繪瑙勭殑姘存灉甯傚満錛屽簵閾哄錛屽競鍦虹鐞嗙浉瀵瑰畬鍠勩?/p>

銆銆3.濡傛灉褰撳湴鏈夌啛浜猴紝鍙互璁╀粬甯︿綘鍘諱拱銆?/p>

銆銆銆愭櫙鐐規父鐜┿?/p>

銆銆1.緗戜笂鎻愬墠璁㈤棬紲ㄣ備竴鑸綉緇滆紲ㄨ兘鏇翠紭鎯狅紝寤鴻鎻愬墠璐エ銆?/p>

銆銆2.涓嶅繀姣忎釜鏅偣閮藉幓錛屽幓涓浜涢噸鐐瑰拰鏈変唬琛ㄦх殑鏅偣渚垮彲銆?/p>

銆銆3.鍏呭垎鍒╃敤鍏氦杞︺佹梾娓鎬笓綰垮反澹佹満鍦哄反澹瓑鍏叡璧勬簮銆?/p>

銆銆4.鍖呰濺綰胯礬涓瀹氳鑷繁璁捐錛屽惁鍒欏鏄撹瀹般?/p>

銆銆5.鎱庝拱鐝嶇彔銆佹按鏅剁瓑銆?/p>

銆銆6.涓夎疆杞﹀拰涓よ疆鎽╃殑錛屽緩璁笉瑕佷箻鍧愶紝鍗遍櫓騫朵笖寰堝鏄撹“瀹?#8221;銆?/p>

銆銆7.浣忓皬閰掑簵錛屽緩璁笉瑕佽鏈嶅姟鍛樺府浣犲彨杞︼紝璇翠笉瀹氫細鍙潵璺熶粬浠湁鍒╃泭閾炬潯鐨勭浉鍏寵濺杈嗐?/p>

銆銆8.鏃犳嫑鑳滄湁鎷涖傚湪浜氶緳婀俱佹搗媯犳咕鐨勯厭搴楀敖鎯呬韓鍙楅槼鍏夛紝灝介噺閬垮厤澶栧嚭銆?/p>

孌墊棴 2012-01-30 17:12 鍙戣〃璇勮
]]>
主站蜘蛛池模板: 国产婷婷综合丁香亚洲欧洲| 国产精品白浆在线观看免费| 亚洲精品电影在线| 久99精品视频在线观看婷亚洲片国产一区一级在线 | 成人无码精品1区2区3区免费看| 亚洲ⅴ国产v天堂a无码二区| 无码专区一va亚洲v专区在线| 免费无码A片一区二三区| 伊人久久免费视频| 国产在线观a免费观看| 色妞www精品视频免费看| 亚洲永久在线观看| 亚洲国产日韩在线| 亚洲一区二区电影| 久久久无码精品亚洲日韩蜜桃| 亚洲国产精品无码久久久久久曰| 免费黄色网址入口| 成人毛片18女人毛片免费视频未| 永久黄色免费网站| 在线观看免费中文视频| 女人体1963午夜免费视频| 久久高潮一级毛片免费| 一出一进一爽一粗一大视频免费的| 亚洲高清一区二区三区电影| 亚洲熟女综合一区二区三区| 国产91在线|亚洲| 亚洲av成人一区二区三区| 亚洲国色天香视频| 亚洲伦理一二三四| 亚洲婷婷天堂在线综合| 亚洲精品影院久久久久久| 亚洲色图古典武侠| 久久亚洲AV成人无码软件| 亚洲高清不卡视频| 亚洲国产成人久久精品app| 亚洲理论在线观看| 亚洲黄色免费电影| 亚洲精品视频免费在线观看| 亚洲成人免费网站| 亚洲色中文字幕在线播放| 亚洲AV无码成人精品区日韩|