Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ºÍORACLEµÄһЩ²Ù×÷Çø±ð

ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1.×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ´¦Àí
MYSQLÓÐ ......

OracleºÍMySQL¡¢PostgreSQLÌØÐÔ¶Ô±È

¡¡Ëæ×ÅÏÖ´úÊý¾Ý¿â¿ÉÓÃÌØÕ÷¼¯µÄѸËÙÔö¼Ó£¬ºÜÄÑÇø·ÖÊëºÃÊ뻵¡£ÀýÈçOracleÀï¾ÍÓÐÐí¶àÄã¿ÉÄÜ´ÓÀ´¶¼²»ÐèÒªµÄ¸ß¼¶Êý¾Ý²Ö¿âÌØÕ÷¡£´ËÍâÒ²¿ÉÄÜÓÐһЩÆäËü²»¿É»òȱµÄÌØÕ÷±ÈÈçACIDÊÂÎñÌØÐÔ¡£ÎÒÃÇÀ´¿´Ò»¿´Ö÷ÒªµÄһЩÌØÕ÷£¬±ÈÈç´æ´¢¹ý³Ì£¬ÊÓͼ£¬¿ìÕÕ£¬±íÊý¾ÝÀàÐͺÍÊÂÎñµÈµÈ¡£Í¬Ê±ÎÒÃÇ·ÖÎöÒ»ÏÂPostgresql£¬MySQLºÍOracleÕ⼸¸öÊý¾Ý¿â£¬È»º ......

ʹÓà MySQL Workbench ¿ÉÊÓ»¯µÄÉè¼Æ MySQL Êý¾Ý¿â

Ó¢ÎÄÔ­ÎÄ£º
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´æ´¢¹ý³Ì±à³ÌÈëÃÅ

MySQL °æ±¾£º5.0.45    phpMyAdmin°æ±¾£º2.11.3
 
Ê×ÏÈ¿´MySQL 5.0²Î¿¼ÊÖ²áÖйØÓÚ´´½¨´æ´¢¹ý³ÌµÄÓ﷨˵Ã÷£º
 
CREATE
    [DEFINER = { user | CURRENT_USER }]
    PROCEDURE sp_name ([proc_parameter[,...]])
    [characteristic ...] r ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ