MySQL´æ´¢¹ý³ÌÒÔ¼°ÔÚJAVAÖеijÌÐòµ÷ÓÃ

               ´æ´¢¹ý³ÌÊÇÒ»ÖÖ´æ´¢ÔÚÊý¾Ý¿âÖеijÌÐò£¨¾ÍÏñÕý¹æÓïÑÔÀïµÄ×Ó³ÌÐòÒ»Ñù£©£¬×¼È·µÄÀ´Ëµ£¬MySQLÖ§³ÖµÄ“routines£¨Àý³Ì£©”ÓÐÁ½ÖÖ£ºÒ»ÊÇÎÒÃÇ˵µÄ´æ´¢¹ý³Ì£¬ ¶þÊÇÔÚÆäËûSQLÓï¾äÖпÉÒÔ·µ»ØÖµµÄº¯Êý£¨Ê¹ÓÃÆðÀ´ºÍMysqlԤװÔصĺ¯ÊýÒ»Ñù£¬Èçpi()£©¡£±¾ÎÄÊÇΪ³õѧϰMySQL´æ´¢¹ý³ÌµÄÅóÓÑдµÄ£¬ÔÚ±¾ÎÄÖÐÎÒÃÇÒÔÔÚMySQLµÄCLI£¨command line interface£©Öн¨Á¢Ò»¸ö´æ´¢¹ý³ÌµÄʾÀý¿ªÊ¼£¬È»ºóͨ¹ýÔÚJava³ÌÐòÖе÷ÓÃÎÒÃÇ´´½¨ºÃµÄ´æ´¢¹ý³Ì£¬ÈöÁÕ߶ÔMySQLµÄ´æ´¢¹ý³ÌÓиö´ó¸ÅµÄÁ˽âºÍÈëÃÅ¡£
Ò»¡¢´´½¨MySQL´æ´¢¹ý³ÌʾÀý
ÏÂÃæÊǾßÌåµÄ´´½¨¹ý³Ì£º
view plaincopy to clipboardprint?
--Æô¶¯MySQL·þÎñ  
C:\Documents and Settings\Zengming Zhang>net start mysql  
 
MySQL ·þÎñÒѾ­Æô¶¯³É¹¦¡£  
 
--µÇ¼MySQL¿ØÖÆ̨  
C:\Documents and Settings\Zengming Zhang>mysql -u root -p  
Enter password: **********  
Welcome to the MySQL monitor.  Commands end with ; or \g.  
Your MySQL connection id is 1 to server version: 5.0.18-nt  
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.  
 
--Ñ¡ÔñÊý¾Ý¿â  
mysql> use test;  
Database changed  
 
--´´½¨Ê¾ÀýÓÃ±í  
mysql> create table zzm(  
    -> id int primary key auto_increment,  
    -> name varchar(10)  
    -> );  
Query OK, 0 rows affected (0.20 sec)  
mysql> insert into zzm(name) values('zhang');  
Query OK, 1 row affected (0.08 sec)  
 
mysql> insert into zzm(name) values('zeng');  
Query OK, 1 row affected (0.05 sec)  
 
mysql> insert into zzm(name) values('ming');  
Query OK, 1 row affected (0.05 sec)  
 
mysql> select * from zzm;  
+----+-------+  
|