Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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();           &


Ïà¹ØÎĵµ£º

ÓÉdzÈëÉî½²½âMySQLÊý¾Ý¿âË÷ÒýµÄÑ¡ÔñÐÔ Êý¾Ý¿âË÷Òý

ÔÚMySQLÖУ¬¶ÔÓÚË÷ÒýµÄʹÓò¢ÊÇÒ»Ö±¶¼²ÉÓÃÕýÈ·µÄ¾ö¶¨¡£
¡¡¡¡¼òµ¥±íµÄʾÀý£º
¡¡¡¡create TABLE `r2` (
¡¡¡¡ID` int(11) DEFAULT NULL,
¡¡¡¡ID1` int(11) DEFAULT NULL,
¡¡¡¡CNAME` varchar(32) DEFAULT NULL,
¡¡¡¡KEY `ID1` (`ID1`)
¡¡¡¡) ENGINE=MyISAM DEFAULT charSET=latin1
¡¡¡¡select count(*) from r2;
¡¡ ......

[Õª³­/¼Ç¼]MySQLµ¼Èë/µ¼³ö.sqlÎļþ

µ¼³ö.sqlÎļþ
 
1.½«Êý¾Ý¿âtransfer_server_dbµ¼³öµ½transfSRV.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db > /home/eric/transfSRV.sql
2.½«Êý¾Ý¿âtransfer_server_dbÖеÄdevice_info_tableµ¼³öµ½table.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db device_info_table > /home/eric/ta ......

MySQL°²×°

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

JavaÈí¼þ¼Ü¹¹Ê¦ÐèÒªµÄ¶«Î÷


×÷ΪJava³ÌÐòÔ±À´Ëµ£¬×îÍ´¿àµÄÊÂÇéιýÓÚ¿ÉÒÔÑ¡ÔñµÄ·¶Î§Ì«¹ã£¬¿ÉÒÔ¶ÁµÄÊéÌ«¶à£¬ÍùÍùÈÝÒ×ÎÞËùÊÊ´Ó¡£¸ù¾ÝÎҵľ­Ñ飬°´ÕÕѧϰµÄÏȺó˳Ðò£¬ÍƼö¸ø´ó¼Ò£¬ÌرðÊÇÄÇЩÏë²»¶ÏÌá¸ß×Ô¼º¼¼ÊõˮƽµÄJava³ÌÐòÔ±ÃÇ¡£
Ò»¡¢Java±à³ÌÈëÃÅÀà
¶ÔÓÚûÓÐJava±à³Ì¾­ÑéµÄ³ÌÐòÔ±ÒªÈëÃÅ£¬Ëæ±ã¶ÁʲôÈëÃÅÊé¼®¶¼Ò»Ñù£¬Õâ¸ö½×¶ÎÐèÒªÄã¿ìËÙµÄÕÆÎÕJava ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ