MyEclipse6.6 Á¬½ÓMySQLµÄÊý¾Ý¿âÅäÖÃ
1¡¢´ò¿ªMyEclipse6.6
2¡¢Ñ¡Ôñ²Ëµ¥£ºWindow/Open Perspective/MyEclipse Database Explorer£¬µã»÷OK£¬ÔÚ×ó±ß´ò¿ªDB Brower´°¿Ú¡£
3¡¢ÔÚDB Brower´°¿ÚÄÚÈÎÒâ¿Õ°×´¦»÷ÓÒ¼ü£¬Ñ¡ÔñNewÃüÁµ¯³öDatabase Driver´°¿Ú
4¡¢±¾´°¿Ú¸÷Ïî˵Ã÷£º
Driver template: MySQL Connector/J Ñ¡ÔñÇý¶¯Ä£°å
Driver name: mybook ÈκÎÆð¸öÃû×Ö
Connection URL:jdbc:mysql://127.0.0.1:3306/book (bookÒª¸Ä³ÉÄãÒªÁ¬Êý¾Ý¿âµÄÃû×Ö)
User name:root (ÄãÊý¾Ý¿âµÄÓû§Ãû)
Password:root (ÄãÊý¾Ý¿âµÄ¿ÚÁî)
Driver JARs:µã»÷Add JARsÑ¡ÔñÄãµÄÇý¶¯°üËùÔÚ·¾¶ £¨°üÀ¨°üÃû£©
Driver classname:com.mysql.jdbc.Driver
5¡¢µã»÷Finish£¬½¨Á¢Íê³É¡£
6¡¢½øÐÐÁ¬½Ó£¬ÔÚDB Brower´°¿ÚÑ¡ÖÐÄã¸Õ½¨µÄmybook£¬µã»÷DB Brower´°¿Ú±êÌâÀ¸ÓÒ²àµÄÈý½ÇÐÎͼ±ê£¬¹â±êÒƶ¯µ½ÆäÉÏʱ£¬»áÏÔʾ“Open Connection”Ìáʾ¡£
7¡¢¸ù¾ÝÌáʾÊäÈëÃÜÂë:root (Ñ¡ÖÐsave passwordºóÏ´ξͲ»ÓÃÊäÈëÃÜÂëÁË)£¬µã»÷OK
8¡¢ÕâʱDB Brower´°¿ÚÖеÄmybook¾Í¿ÉÕ¹¿ªÁË£¬Ò»Ö±µ½±í¡£
9¡¢TABLEÏÂÃæÊÇ±í£¬ÓÒ»÷Ò»¸ö±í£¬Ñ¡ÔñGenerate/Select Statement£¬ÔÚÓұߴò¿ªsql²Ù×÷´°¿Ú
10¡¢´ò¿ªµÄsql²Ù×÷´°¿ÚÀï×Ô¶¯²úÉú²éѯÓï¾ä£¬µã»÷ÉÏÃæµÄºìÉ«Èý½ÇÐμ´¿ÉÖ´ÐÐsql¡£
Ïà¹ØÎĵµ£º
ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1.×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ´¦Àí
MYSQLÓÐ ......
¡¡Ëæ×ÅÏÖ´úÊý¾Ý¿â¿ÉÓÃÌØÕ÷¼¯µÄѸËÙÔö¼Ó£¬ºÜÄÑÇø·ÖÊëºÃÊ뻵¡£ÀýÈçOracleÀï¾ÍÓÐÐí¶àÄã¿ÉÄÜ´ÓÀ´¶¼²»ÐèÒªµÄ¸ß¼¶Êý¾Ý²Ö¿âÌØÕ÷¡£´ËÍâÒ²¿ÉÄÜÓÐһЩÆäËü²»¿É»òȱµÄÌØÕ÷±ÈÈçACIDÊÂÎñÌØÐÔ¡£ÎÒÃÇÀ´¿´Ò»¿´Ö÷ÒªµÄһЩÌØÕ÷£¬±ÈÈç´æ´¢¹ý³Ì£¬ÊÓͼ£¬¿ìÕÕ£¬±íÊý¾ÝÀàÐͺÍÊÂÎñµÈµÈ¡£Í¬Ê±ÎÒÃÇ·ÖÎöÒ»ÏÂPostgresql£¬MySQLºÍOracleÕ⼸¸öÊý¾Ý¿â£¬È»º ......
Ó¢ÎÄÔÎÄ£º
http://www.packtpub.com/article/visual-mysql-database-design-in-mysql-workbench
ÏÂÃæÊDz¿·Ö·Òë¹ýÀ´µÄ£¬×ªÔØ×Ô£ºhttp://zuolo.info/2008/11/%e4%bd%bf%e7%94%a8-mysql-workbench-%e5%8f%af%e8%a7%86%e5%8c%96%e7%9a%84%e8%ae%be%e8%ae%a1-mysql-%e6%95%b0%e6%8d%ae%e5%ba%93-1%e8%af%91%e6%96%87/
MySQL ......
MySQL °æ±¾£º5.0.45 phpMyAdmin°æ±¾£º2.11.3
Ê×ÏÈ¿´MySQL 5.0²Î¿¼ÊÖ²áÖйØÓÚ´´½¨´æ´¢¹ý³ÌµÄÓ﷨˵Ã÷£º
CREATE
[DEFINER = { user | CURRENT_USER }]
PROCEDURE sp_name ([proc_parameter[,...]])
[characteristic ...] r ......