JAVA¶¯Ì¬´úÀíÄÚ²¿ÊµÏÖ
Ò»¡¡´úÀíÉè¼ÆÄ£Ê½
´úÀíģʽΪĿ±ê¶ÔÏóÌṩһÖÖ´úÀíÒÔ¿ØÖƶÔʵ¼Ê¶ÔÏóµÄ·ÃÎÊ¡£ÔÚijЩÇé¿öÏ£¬Ò»¸ö¿Í»§²»Ïë»òÕß²»ÄÜÖ±½ÓÒýÓÃÁíÒ»¸ö¶ÔÏ󣬶ø´úÀí¶ÔÏó¿ÉÒÔÔÚ¿Í»§¶ËºÍÄ¿±ê¶ÔÏóÖ®¼äÆðµ½ÖнéµÄ×÷Óá£
ΪÁ˱£³ÖÐÐΪµÄÒ»ÖÂÐÔ£¬´úÀíÀàºÍʵ¼ÊίÍÐÀàͨ³£»áʵÏÖÏàͬµÄ½Ó¿Ú£¬ËùÒÔÔÚ·ÃÎÊÕß¿´À´Á½ÕßûÓÐË¿ºÁµÄÇø±ð¡£
¡¡´úÀíģʽÀàͼ¡¡¡¡
³£¼ûµÄ´úÀíÓÐ:
1) Ô¶³Ì´úÀí(Remote proxy)£º¶ÔÒ»¸öλÓÚ²»Í¬µÄµØÖ·¿Õ¼ä¶ÔÏóÌṩһ¸ö¾ÖÓò´ú±í¶ÔÏó£¬ÈçRMIÖеÄstub¡£¡¡
2)
ÐéÄâ´úÀí(Virtual proxy)£º¸ù¾ÝÐèÒª½«Ò»¸ö×ÊÔ´ÏûºÄºÜ´ó»òÕ߱Ƚϸ´ÔӵĶÔÏó£¬ÑÓ³Ù¼ÓÔØ£¬ÔÚÕæÕýÐèÒªµÄʱºò²Å´´½¨¡£
3) ±£»¤´úÀí(Protect or Access Proxy)£º¿ØÖƶÔÒ»¸ö¶ÔÏóµÄ·ÃÎÊȨÏÞ¡£
4) ÖÇÄÜÒýÓÃ(Smart Reference Proxy)£ºÌṩ±ÈÄ¿±ê¶ÔÏó¶îÍâµÄ·þÎñºÍ¹¦ÄÜ¡£
ͨ¹ý´úÀíÀàÕâÒ»Öмä²ã£¬Äܹ»ÓÐЧ¿ØÖƶÔʵ¼ÊίÍÐÀà¶ÔÏóµÄÖ±½Ó·ÃÎÊ£¬Ò²¿ÉÒԺܺõØÒþ²ØºÍ±£»¤Êµ¼Ê¶Ô£¬ÊµÊ©²»Í¬µÄ¿ØÖƲßÂÔ£¬´Ó¶øÔÚÉè¼ÆÉÏ»ñµÃÁ˸ü´óµÄÁé»îÐÔ¡£
¶þ¡¡¶¯Ì¬´úÀíʹÓÃ
JAVA¶¯Ì¬´úÀí»úÖÆÒÔÇÉÃîµÄ·½Ê½ÊµÏÖÁË´úÀíģʽµÄÉè¼ÆÀíÄî¡£
¶¯Ì¬´úÀíÀàͼ
¶¯Ì¬´úÀíÔÚ´úÀíProxySubjectºÍRealSubjectÖ®¼äÔö¼ÓÁËInvocationHandler£¬ÕâÊÇÒ»ÖÖͨÐż ......
JAVAÖÐÓÃÓÚ´¦Àí×Ö·û´®µÄ“ÈýÐֵܔ
JAVAÖÐÓÃÓÚ´¦Àí×Ö·û´®³£ÓõÄÓÐÈý¸öÀࣺjava.lang.String¡¢java.lang.StringBuffer¡¢java.lang.StringBuilder£¬ÕâÈýÕߵĹ²Í¬Ö®´¦¶¼ÊÇfinalÀ࣬²»ÔÊÐí±»¼Ì³Ð£¬ÕâÖ÷ÒªÊÇ´ÓÐÔÄܺͰ²È«ÐÔÉÏ¿¼Âǵģ¬ÒòΪÕ⼸¸öÀà¶¼ÊǾ³£±»Ê¹ÓÃ×ŵģ¬ÇÒ¿¼Âǵ½·ÀÖ¹ÆäÖеIJÎÊý±»ÐÞ¸ÄÓ°Ïìµ½ÆäËüµÄÓ¦Óá£StringBufferÓëStringBuilderÁ½¸ö»ù±¾Éϲ¶à£¬Ö»ÊÇStringBufferÊÇḬ̈߳²È«£¬¿ÉÒÔ²»ÐèÒª¶îÍâµÄͬ²½ÓÃÓÚ¶àÏß³ÌÖУ»StringBuilderÊÇ·Çͬ²½£¬ÔËÐÐÓÚ¶àÏß³ÌÖоÍÐèҪʹÓÃ×ŵ¥¶Àͬ²½´¦Àí£¬µ«ÊÇËٶȾͱÈStringBuffer¿ì¶àÁË£»¶þÕßÖ®¼äµÄ¹²Í¬µã¶¼¿ÉÒÔͨ¹ýappend¡¢insert½øÐÐ×Ö·û´®µÄ²Ù×÷¡£
StringʵÏÖÁËÈý¸ö½Ó¿Ú£ºSerializable¡¢Comparable<String>¡¢CharSequence£¬¶øStringBuffer¼°StringBuilderֻʵÏÖÁËÁ½¸ö½Ó¿ÚSerializable¡¢CharSequence£¬Ïà±ÈÖ®ÏÂStringµÄʵÀý¿ÉÒÔͨ¹ýcompareTo·½·¨½øÐбȽϣ¬¶øÆäËüÁ½¸ö¾Í²»¿ÉÒÔ¡£
ÒÔÏÂÊÇJDKÖжÔString¡¢StringBuffer¡¢StringBuilderµÄÏêϸ½éÉÜ£º
String£º
String Àà´ú±í×Ö·û´®¡£Java ³ÌÐòÖеÄËùÓÐ×Ö·û´®×ÖÃæÖµ£¨Èç "abc" £©¶¼×÷Ϊ´ËÀàµÄʵÀýʵÏÖ¡£
×Ö·û´®Êdz£Á¿£»ËüÃǵÄÖµÔÚ´´½¨Ö®ºó²»Äܸü¸Ä¡£×Ö·û´®»º³åÇøÖ§ ......
¡¡ÏÖÔÚʹÓÃMySQLµÄÔ½À´Ô½¶àÁË£¬ÎÒÒ²ÓÃËü×öÁË×ÔÒѵÄÁôÑÔ°å¡£ÔÚʹÓùý³ÌÖУ¬
ÂýÂýµØ
¾ÍÒªÇó¶ÔËüµÄ¹ÜÀí
¹¦ÄÜÐèÒª½üÒ»²½µÄÕÆÎÕ£¬²»½öÊÇÎÒ£¬Ò²ÊǺܶàÍøÓѵÄÒªÇó¡£ÏÖÔÚÓÐһЩÎÊÌâÊǹØ
ÓÚÈçºÎ
´ÓMySQLÖе¼³öÊý¾Ý£¬
ÒÔ±ãÓÃÔÚ±¾µØ»òÆäËüµÄÊý¾Ý¿âϵͳ֮ÉÏ£»ÒÔ¼°½«ÏÖÓÐÊý¾Ýµ¼ÈëMySQLÊý¾Ý¿âÖС£ÏÖ
ÔÚ¾ÍÎÒ
ѧϰµÄÇé¿ö£¬¾ÍÕâ
Á½¸öÎÊÌâ×÷Ò»ÏÂС½á£¬ÄÚÈݲ»ÊǺÜÏêϸ¡£ÆäʵMySQLµÄÊÖ²áÊǺÜÏêϸµÄ£¬Ö»²»¹ýÎÒ
°ÑÓйØ
ÕâÁ½·½ÃæµÄ¶«Î÷Ìá
È¡³öÀ´£¬¼ÓÉÏÁËÒ»µã×ÔÒѵÄÀí½â£¬¸üÏêϸµÄÇë²Î¿¼Êý¾Ý¿âµÄÏàÓ¦Õ½ڡ£
Êý¾Ýµ¼³ö
¡¡¡¡Êý¾Ýµ¼³öÖ÷ÒªÓÐÒÔϼ¸ÖÖ·½·¨£º
ʹÓÃselect into outfile 'filename'Óï¾ä
ʹÓÃmysqldumpʵÓóÌÐò
ʹÓÃselect into outfile 'filename'Óï¾ä
¡¡¡¡¿ÉÒÔÔÚmysqlµÄÃüÁîÐÐÏ»òÔÚphp³ÌÐòÖÐÖ´ÐÐËü¡£ÎÒÏÂÃæÒÔÔÚmysqlÃüÁîÐÐÏÂΪ
Àý¡£ÔÚ
phpÖÐʹÓÃʱ£¬½«Æä
¸Ä³ÉÏàÓ¦µÄ²éѯ½øÐд¦Àí¼´¿É¡£²»¹ýÔÚʹÓÃÕâ¸öÃüÁîʱ£¬ÒªÇóÓû§ÓµÓÐfileµÄȨ
ÏÞ¡£Èç
ÎÒÃÇÓÐÒ»¸ö¿âΪ
phptest£¬ÆäÖÐÓÐÒ»¸ö±íΪ ......
1¡¢½«Êý¾Ý¿âÉèÖÃΪdefault-character-set=gb2312
2¡¢½«¿ØÖÆÃæ°å/¹ÜÀí¹¤¾ß/ÅäÖúõÄÊý¾ÝÔ´/ÅäÖÃ/Ïêϸ/MiscOPtions/Character:gb2312
3¡¢´úÂëΪ GB2312;
±£Ö¤ÕâÈý¸öµØ·½Í³Ò»£¬ÂÒ×Ö·û½â¾ö¡£
ÎÒ×ö³ö²»°Ù˼²»µÃÆä½â£¬¾ÍÊǺöÂÔÁ˵Ú2µã¡£ ......
Ò»¡¢²é¿´Óû§
1¡¢ÏÔʾµ±Ç°Ê¹ÓõÄuser¼°host£º
mysql>select USER();
2¡¢ÏÔʾ¸ÃÊý¾Ý¿âÊÚȨµÇ½µÄÓû§Ãû(²»ÏÔÊ¾ÖØ¸´Óû§Ãû)£º
mysql>use mysql;
mysql>select distinct(User) from user;
3¡¢ÏÔʾ¸ÃÊý¾Ý¿âÊÚȨµÇ½µÄÓû§Ãû¼°hostÏÞÖÆ£º
£¨1£©·½·¨Ò»£º
mysql>use mysql;
mysql>select User,host from user;
£¨2£©·½·¨¶þ
mysql>select user,host from mysql.user;
4¡¢ÏÔʾ¸ÃÊý¾Ý¿âÊÚȨµÇ½µÄÓû§µÄÈ«²¿ÐÅÏ¢£º
mysql>select * from mysql.user;
5¡¢ÁгöΪijMySQLÓû§ÕË»§¸´ÖÆÈ¨ÏÞʱ±ØÐë·¢²¼µÄGRANTÓï¾ä£º
mysql>show grants for 'username'@'yourhost';
¶þ¡¢Ìí¼ÓÓû§
1¡¢Ìí¼ÓÒ»¸ö±¾µØ¹ÜÀíÔ±Óû§:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'somepassword' WITH GRANT OPTION;
2¡¢Ìí¼ÓijÊý¾Ý¿âµÄ¹ÜÀíÔ±Óû§:
mysql> GRANT ALL PRIVILEGES ON databasename.* TO username@localhost IDENTIFIED BY 'somepassword';
3¡¢Ìí¼ÓÔ¶³ÌÓû§:
mysql> GRANT ALL PRIVILEGES ON *.* TO username@192.168.8.9 IDENTIFIED BY 'somepassword';
4¡¢Ìí¼ÓÈκλúÆ÷¶¼ÄܵǼµÄÓû§:
mysql> GRANT ALL PRI ......
mysqlµÄÊý¾Ý´¢´æÄ¿Â¼ÔÚmysqlµÄÅäÖÃÎļþmy.iniÎļþÉèÖ㬸ñʽÈçÏ£º
# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = d:/cyoa/mysql_cy/
datadir = d:/cyoa/mysql_cy/data/
ÆäÖÐdatadirĿ¼¶¨ÒåÁËmysqlµÄÊý¾Ý´æ´¢Î»Öã¬MySQLµÄÿ¸öÊý¾Ý¿â¶¼¶ÔÓ¦´æ·ÅÔÚÒ»¸öÓëÊý¾Ý¿âͬÃûµÄÎļþ¼ÐÖÐ(¸ÃĿ¼ÏÂdatadir²ÎÊý¶ÔÓ¦µÄĿ¼ÏÂ)£¬MySQLÊý¾Ý¿âÎļþ°üÀ¨MySQLËù½¨Êý¾Ý¿âÎļþºÍMySQLËùÓô洢ÒýÇæ´´½¨µÄÊý¾Ý¿âÎļþ¡£
MySQLÈç¹ûʹÓÃMyISAM´æ´¢ÒýÇæ£¬Êý¾Ý¿âÎļþÀàÐ;ͰüÀ¨.frm¡¢.MYD¡¢.MYI
MySQLÈç¹ûʹÓÃInnoDB´æ´¢ÒýÇæ£¬Êý¾Ý¿âÎļþÀàÐ;ͰüÀ¨.frm¡¢ibdata1¡¢.ibd£¬´æ·ÅλÖÃÓÐÁ½¸ö£¬ibdata1¡¢.ibdÎļþĬÈÏ´æ·ÅλÖÃÊÇMySQL°²×°Ä¿Â¼ÏµÄdataÎļþ¼Ð
1¡¢MySQL´´½¨²¢¹ÜÀíµÄÊý¾Ý¿âÎļþ£º
.frmÎļþ£º´æ´¢Êý¾Ý±íµÄ¿ò¼Ü½á¹¹£¬ÎļþÃûÓë±íÃûÏàͬ£¬Ã¿¸ö±í¶ÔÓ¦Ò»¸öͬÃûfrmÎļþ£¬Óë²Ù×÷ϵͳºÍ´æ´¢ÒýÇæÎ޹أ¬¼´²»¹ÜMySQLÔËÐÐÔÚºÎÖÖ²Ù×÷ϵͳÉÏ£¬Ê¹ÓúÎÖÖ´æ´¢ÒýÇæ£¬¶¼ÓÐÕâ¸öÎļþ¡£
³ýÁ˱ØÓеÄ.frmÎļþ£¬¸ù¾ÝMySQLËùʹÓõĴ洢ÒýÇæµÄ²»Í¬£¨MySQL³£ÓõÄÁ½¸ö´æ´¢ÒýÇæÊÇMyISAMºÍInnoDB£©£¬´æ´¢ÒýÇæ»á´´½¨¸÷×Ô²»Í¬µÄÊý¾Ý¿â ......