±¾ÎÄ·ÖÊ®ËĸöÀà±ð¶ÔÕýÔò±í´ïʽµÄÒâÒå½øÐÐÁ˽âÊÍ£¬ÕâÊ®Ëĸ÷Àà±ðÊÇ£º×Ö·û/×Ö·ûÀà/Ô¤¶¨Òå×Ö·ûÀà/POSIX×Ö·ûÀà/java.lang.CharacterÀà/Unicode¿éºÍÀà±ðµÄÀà/±ß½çÆ¥ÅäÆ÷/GreedyÊýÁ¿´Ê/ReluctantÊýÁ¿´Ê/PossessiveÊýÁ¿´Ê/LogicalÔËËã·û/BackÒýÓÃ/ÒýÓÃ/ÌØÊâ¹¹Ôì¡£
1.1.×Ö·û
x ×Ö·û x¡£ÀýÈça±íʾ×Ö·ûa
\\ ·´Ð±Ïß×Ö·û¡£ÔÚÊéдʱҪдΪ\\\\¡££¨×¢Ò⣺ÒòΪjavaÔÚµÚÒ»´Î½âÎöʱ°Ñ\\\\½âÎö³ÉÕýÔò±í´ïʽ\\£¬ÔÚµÚ¶þ´Î½âÎöʱÔÙ½âÎöΪ\£¬ËùÒÔ·²ÊDz»ÊÇ1.1Áоٵ½µÄתÒå×Ö·û£¬°üÀ¨1.1µÄ\\,¶øÓÖ´øÓÐ\µÄ¶¼ÒªÐ´Á½´Î£©
\0n ´øÓа˽øÖÆÖµ 0µÄ×Ö·û n (0 <= n <= 7)
\0nn ´øÓа˽øÖÆÖµ 0µÄ×Ö·û nn (0 <= n <= 7)
\0mnn ´øÓа˽øÖÆÖµ 0µÄ×Ö·û mnn£¨0 <= m <= 3¡¢0 <= n <= 7£©
\xhh ´øÓÐÊ®Áù½øÖÆÖµ 0xµÄ×Ö·û hh
\uhhhh ´øÓÐÊ®Áù½øÖÆÖµ 0xµÄ×Ö·û hhhh
\t ÖÆ±í·û ('\u0009')
\n ÐÂÐУ¨»»ÐУ©·û ('\u000A')
\r »Ø³µ·û ('\u000D')
\f »»Ò³·û ('\u000C')
\a&n ......
È·¶¨ÄãµÄjdk»·¾³±äÁ¿ÅäÖÃÊÇÕýÈ·µÄ¡£
¶ÔÓÚjava³õѧÕßÀ´Ëµ£¬±àÒëºÍÔËÐÐjava³ÌÐòÊÇÒ»¼þºÜÍ·Ì۵Ķ«Î÷¡£
ÏÔÈ»£¬ÔÚÃüÁʽϱàÒëºÍÔËÐÐjava³ÌÐòÓþÃÁË£¬È·ÊµÊǺÜÂé·³£¬
¶øÎÒÃÇÓÖ²»ÏëʹÓôóÐ͵Ŀª·¢¹¤¾ßʱ£¬UltraEditÊÇÒ»¸ö²»´íµÄÑ¡Ôñ£¬
ºÜ¶à³õѧÕß¶¼ÊÇÓÃËüÀ´±àдjavaÔ´ÎļþµÄ£¬¿ÉÒÔ¸ßÁÁ¶ÈÏÔʾ¹Ø¼ü×Ö¡£
1¡£¹Ø¼ü×Ö¸ßÁÁ¶ÈÏÔʾ¡£
´ò¿ªUltraEdit£>ÊÓͼ£>¸ßÁÁÏÔʾÀàÐÍ->java;
´ËʱÔÚUltraEditÊäÈëjava³ÌÐòʱ£¬¹Ø¼ü×ÖºÍjava°üϵÄÀà¿ÉÒÔ¸ßÁÁ¶ÈÏÔʾ£¬
»¹ÓÐ×¢ÊÍÒ²Êǰ¡£¬Èç¹ûÄ㲻ϲ»¶ËüµÄĬÈÏÉ«²Ê£¬¿ÉÒÔ×Ô¼º¸ü¸Ä¡£
ÔÚ¶¥²ãµÄ²Ëµ¥À¸ÖÐÑ¡Ôñ ¸ß¼¶->ÅäÖÃ->Óï·¨¸ßÁÁ£¨¶Ô»°¿òµÄÒ»¸öÑ¡Ï£©->ÓïÑÔ->java
Äã¾Í¿ÉÒÔÅä×ÓÄã×Ô¼ºÏ²»¶µÄÉ«²ÊÁË¡£
2.javacºÍjava¼¯³Éµ½UltraEdit¹¤¾ßÀ¸ÉÏ¡£
°ÑjavacºÍjava¼¯³Éµ½UltraEditÉÏ£¬Äã²»ÓÃÿ´Î¶¼µ½dosÏÂÈ¥Ö´ÐÐÄãµÄjava³ÌÐò
£¬¿ÉÒÔÏñVCÄÇÑùдÍêC++³ÌÐòÖ±½ÓBuildºÍrunһϾͿÉÒÔÁË¡£ÎÒÃÇ¿ªÊ¼ÁË£¡
¸ß¼¶£>¹¤¾ßÅäÖà //µ¯³öÒ»¸ö¶Ô»°¿ò£¬Îª ¹¤¾ßÅäÖÃ
ÔÚ ÃüÁîÐÐÊäÈë javac %n%e//%n±íʾµ±Ç°Â·¾¶£¬%e±íʾִÐеĵ±Ç°ÎļþÃû¡£
¹¤×÷Ŀ¼ÏÂÊäÈë %p
²Ëµ¥ÏîÄ¿Ãû³Æ£¬×Ô¼ºÆðÒ»¸öºÃÌýµÄ¡£
¸´Ñ¡¿òºÍµ¥Ñ¡¿òÑ¡Èý¸ö£º±£´æ»î¶¯Îļþ£¬Êä³öµ½Áб ......
JAVAÖÐStringÓëStringBuffer ¡¢StringBuilderµÄÇø±ð
Ò»¡¢StringºÍStringBufferµÄÇø±ð
ÔÚjavaÖÐÓÐ3¸öÀàÀ´¸ºÔð×Ö·ûµÄ²Ù×÷¡£
1.Character ÊǽøÐе¥¸ö×Ö·û²Ù×÷µÄ£¬
2.String ¶ÔÒ»´®×Ö·û½øÐвÙ×÷¡£²»¿É±äÀà¡£
3.StringBuffer Ò²ÊǶÔÒ»´®×Ö·û½øÐвÙ×÷£¬µ«ÊǿɱäÀà¡£
StringÊôÐÔ:
*ÊǶÔÏó²»ÊÇÔʼÀàÐÍ.
*Ϊ²»¿É±ä¶ÔÏó,Ò»µ©±»´´½¨,¾Í²»ÄÜÐÞ¸ÄËüµÄÖµ.
*¶ÔÓÚÒѾ´æÔÚµÄString¶ÔÏóµÄÐ޸ͼÊÇÖØÐ´´½¨Ò»¸öеĶÔÏó,È»ºó°ÑеÄÖµ±£´æ½øÈ¥.
*String ÊÇfinalÀà,¼´²»Äܱ»¼Ì³Ð.
StringBufferÊôÐÔ:
*ÊÇÒ»¸ö¿É±ä¶ÔÏó,µ±¶ÔËû½øÐÐÐ޸ĵÄʱºò²»»áÏñStringÄÇÑùÖØÐ½¨Á¢¶ÔÏó
*ËüÖ»ÄÜͨ¹ý¹¹Ô캯ÊýÀ´½¨Á¢,ÈçStringBuffer sb = new StringBuffer();
*²»ÄÜͨ¹ý¸¶Öµ·ûºÅ¶ÔËû½øÐи¶Öµ.sb = "welcome to here!";//error
*¶ÔÏó±»½¨Á¢ÒÔºó,ÔÚÄÚ´æÖоͻá·ÖÅäÄÚ´æ¿Õ¼ä,²¢³õʼ±£´æÒ»¸önull.
*ÏòStringBufferÖи¶ÖµµÄʱºò¿ÉÒÔͨ¹ýËüµÄappend·½·¨:sb.append("hello");
StringºÍStringBufferµÄ±È½Ï£º
×Ö·û´®Á¬½Ó²Ù×÷ÖÐStringBufferµÄЧÂÊÒª±ÈString¸ß:
String str = new String("welcome to ");
str += "here";
µÄ´¦Àí²½Öèʵ¼ÊÉÏÊÇͨ¹ý½¨Á¢Ò»¸öStringBuffer,È»ºóµ÷ÓÃappend(),×îºó
ÔÙ½«StringBu ......
ʹÓÃmysqlÓÖÓöµ½ÎÊÌâÁË£¬Õâ´ÎÊǹØÓÚÂÒÂëµÄ...
ÆäʵÎÒÒ²±È½ÏÁ˽â±àÂëµÄÎÊÌ⣬Ҳ֪µÀÂÒÂë²úÉúµÄÔÀí£¬¶øÇÒÍøÉ϶ÔmysqlµÄÂÒÂëÎÊÌâÒ²ÓбȽ϶àµÄ½â´ð£¬
µ«ÊǽñÌìÎÒÓöµ½µÄÕâ¸öÂÒÂëÈ´±È½ÏÆæ¹Ö,ÔÚwhenÓï¾äÖвúÉúÁËÆæ¹ÖµÄÂÒÂë¡£
create table my_table(id int, name varchar(50), born DateTime);
insert into my_table values(1, 'ÕÅÈý', 1986-9-9);
insert into my_table values(2, 'ÀîËÄ', 1987-9-10);
insert into my_table values(3, 'ÍõÎå', 1988-9-11);
select case when id like '1' then born when id like '2' then concat(name, born) end from my_table
ÈçÉÏÓï¾äÖ´ÐÐÖ®ºó£¬idΪ2µÄÄÇÐеđÕÅÈý’¾ÍÊÇÂÒÂë¡£¸ÄΪ£º
select case when id like '1' then convert(born, char) when id like '2' then concat(name, born) end from my_table
ÎÊÌâ¼´¿É½â¾ö¡£ÄѵÀwhenÓï¾ä´ÓµÚÒ»¸öÌõ¼þÅж¨Êä³öµÄ±àÂ룿 ......
È¡mysql±íºÍ×Ö¶Î×¢Ê͵ÄÓï¾ä
1¡¢È¡×Ö¶Î×¢ÊÍ
Select COLUMN_NAME ÁÐÃû, DATA_TYPE ×Ö¶ÎÀàÐÍ, COLUMN_COMMENT ×Ö¶Î×¢ÊÍ
from INFORMATION_SCHEMA.COLUMNS
Where table_name = 'companies'##±íÃû
AND table_schema = 'testhuicard'##Êý¾Ý¿âÃû
AND column_name LIKE 'c_name'##×Ö¶ÎÃû
2¡¢È¡µÃ±í×¢ÊÍ
Select table_name ±íÃû,TABLE_COMMENT ±í×¢ÊÍ from INFORMATION_SCHEMA.TABLES Where table_schema = 'testhuicard' ##Êý¾Ý¿âÃû
AND table_name LIKE 'companies'##±íÃû
²Î¿¼http://dev.mysql.com/doc/refman/5.1/zh/information-schema.html.
mysqlÊֲ᣺23.1. INFORMATION_SCHEMA±í
3¡¢È¡µÃijÊý¾Ý¿âÏÂËùÓбíµÄ×¢ÊÍ
$tt = mysql_query("show table status;");
$table_info£½array();
while($re = mysql_fetch_array($tt,MYSQL_ASSOC)){
//$re["Comment"],Õâ¸ö¾ÍÊDZ ......
http://linux.chinaitlab.com/MYSQL/524755_2.html
http://bbs.chinaunix.net/archiver/?tid-809159.html
ÔÚApache, PHP,
MySQLµÄÌåϵ¼Ü¹¹ÖУ¬MySQL¶ÔÓÚÐÔÄܵÄÓ°Ïì×î´ó£¬Ò²ÊǹؼüµÄºËÐIJ¿·Ö¡£¶ÔÓÚDiscuz!ÂÛ̳³ÌÐòÒ²ÊÇÈç´Ë£¬MySQLµÄÉèÖÃÊÇ·ñºÏÀíÓÅ»¯£¬Ö±½Ó
Ó°Ïìµ½ÂÛ̳µÄËٶȺͳÐÔØÁ¿£¡Í¬Ê±£¬MySQLÒ²ÊÇÓÅ»¯ÄѶÈ×î´óµÄÒ»¸ö²¿·Ö£¬²»µ«ÐèÒªÀí½âһЩMySQLרҵ֪ʶ£¬Í¬Ê±»¹ÐèÒª³¤Ê±¼äµÄ¹Û²ìͳ¼Æ²¢ÇÒ¸ù¾Ý¾Ñé
½øÐÐÅжϣ¬È»ºóÉèÖúÏÀíµÄ²ÎÊý¡£
ÏÂÃæÎÒÃÇÁ˽âÒ»ÏÂMySQLÓÅ»¯µÄһЩ»ù´¡£¬MySQLµÄÓÅ»¯ÎÒ·ÖΪÁ½¸ö²¿·Ö£¬Ò»ÊÇ·þÎñÆ÷ÎïÀíÓ²¼þµÄÓÅ»¯£»¶þÊÇMySQL×ÔÉí(my.cnf)µÄÓÅ»¯¡£
(1) ·þÎñÆ÷Ó²¼þ¶ÔMySQLÐÔÄܵÄÓ°Ïì
a)
´ÅÅÌѰµÀÄÜÁ¦£¨´ÅÅÌI/O£©,ÒÔĿǰ¸ßתËÙSCSIÓ²ÅÌ(7200ת/Ãë)ΪÀý£¬ÕâÖÖÓ²ÅÌÀíÂÛÉÏÿÃëѰµÀ7200´Î£¬ÕâÊÇÎïÀíÌØÐÔ¾ö¶¨µÄ£¬Ã»Óа취¸Ä±ä¡£
MySQLÿÃëÖÓ¶¼ÔÚ½øÐдóÁ¿¡¢¸´ÔӵIJéѯ²Ù×÷£¬¶Ô´ÅÅ̵ĶÁдÁ¿¿ÉÏë¶øÖª¡£ËùÒÔ£¬Í¨³£ÈÏΪ´ÅÅÌI/OÊÇÖÆÔ¼MySQLÐÔÄܵÄ×î´óÒòËØÖ®Ò»£¬¶ÔÓÚÈÕ¾ù·ÃÎÊÁ¿
ÔÚ100ÍòPVÒÔÉϵÄDiscuz!ÂÛ̳£¬ÓÉÓÚ´ÅÅÌI/OµÄÖÆÔ¼£¬MySQLµÄÐÔÄÜ»á·Ç³£µÍÏ£¡½â¾öÕâÒ»ÖÆÔ¼ÒòËØ¿ÉÒÔ¿¼ÂÇÒÔϼ¸ÖÖ½â¾ö·½°¸£º
ʹÓÃRAID-0+1´ÅÅÌÕóÁУ¬×¢Òâ²»Òª³¢ÊÔʹÓÃRAID-5£¬M ......