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

ʵÏÖJavaÁ¬½Ómysql£¨Ô´Â룩£¡

JavaÁ¬½ÓmysqlÊý¾Ý¿â£¬´úÂë¾­¹ýÔËÐÐ׼ȷÎÞÎó¡£
ÏÂÃæÎªÊµÀý---->
ÓÃÊý¾Ý¿â²Ù×ݹ¤¾ß£¨Àý£ºSQLyogEnt£©²Ù×Ýmysql½¨±í£¬»òdosϽ¨£¬ÈçÏ£º
Êý¾Ý¿âÃû£ºscutcs
±íÃû£ºstudent
±íÄÚÈÝ£º
sno  char[7]  NO NULL Primary Key;
sname  varchar[8]  NO NULL;
sex  char[2]  NO NULL;
bdate  date   NO NULL;
height  decimal[10,0] ;
-------------------------------------------------------------------------
java³ÌÐò£º
import java.sql.*;
public class JDBCTest {
public static void main(String[] args){
           String driver = "com.mysql.jdbc.Driver";         // Çý¶¯³ÌÐòÃû
           String url = "jdbc:mysql://localhost/scutcs";     // URLÖ¸ÏòÒª·ÃÎʵÄÊý¾Ý¿âÃûscutcs 
           String user = "........";       // MySQLÅäÖÃʱµÄÓû§Ãû
           String password = "........";      // MySQLÅäÖÃʱµÄÃÜÂë
           try {
            Class.forName(driver);    // ¼ÓÔØÇý¶¯³ÌÐò
            Connection conn = DriverManager.getConnection(url, user, password);      // Á¬ÐøÊý¾Ý¿â
            if(!conn.isClosed())
             System.out.println("Succeeded connecting to the Database!");     //ÑéÖ¤ÊÇ·ñÁ¬½Ó³É¹¦
            Statement statement = conn.createStatement();           &


Ïà¹ØÎĵµ£º

²é¿´mysql°æ±¾µÄËÄÖÖ·½·¨

ת×Ô£ºhttp://www.yayu.org/look.php?id=113
1£ºÔÚÖÕ¶ËÏ£ºmysql -V¡£
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
[shengting@login ~]$ mysql -V
mysql  Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686)
    2£ºÔÚmysqlÖУºmysql> status;
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
mysql> status;
--------------
mysql  ......

MySQL°²×°

MysqlµÄ°²×°Îļþ¿ÉÒÔÖ±½Óµ½ http://www.mysql.com ÏÂÔØ£¬»ñµÃfor win32µÄ.zip°ü£¬½¨ÒéÑ¡Ôñ4.0.20d°æ±¾¡£ÕâÀï²»Ïêϸ˵Ã÷¡£
¡¡¡¡ÏÂÔØ»ñµÃMysqlµÄfor win32°²×°°üºó£¬ÓÃwinzip½âѹËõ£¬Ö±½ÓÔËÐÐsetup.exe£¬ÐèҪעÒâµÄÊÇÑ¡ÔñÒ»¸ö°²×°Â·¾¶£¬µ±È»£¬°²×°Â·¾¶¿ÉÒÔÈÎÒ⣬½¨ÒéÑ¡ÔñC:\MySQLĿ¼¡£°²×°Íê³ÉºóMySQLÒ²¾ÍÍê³ÉÁË¡£Ä¬ÈϵÄÓû ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ