java Á¬½Ó mysql
µ±È»£¬Ê×ÏÈÒª°²×°ÓÐJDK(Ò»°ãÊÇJDK1.5.X)¡£È»ºó°²×°MySQL£¬ÕâЩ¶¼±È½Ï¼òµ¥£¬¾ßÌå¹ý³Ì¾Í²»ËµÁË¡£ÅäÖúÃÕâÁ½¸ö
»·¾³ºó£¬ÏÂÔØJDBCÇý¶¯mysql-connector-java-5.1.5.zip£¨http://www.ntu-w.lkams.kernel.org/pub/MySQL/Downloads/Connector-J/mysql-connector-java-5.1.5.zip£©¡£È»ºó½«Æä½âѹËõµ½ÈÎһĿ¼¡£ÎÒÊǽâѹµ½DÅÌ£¬È»ºó½«ÆäĿ¼ÏµÄmysql-connector-java-5.0.5-bin.jar¼Óµ½classpathÀ¾ßÌåÈçÏ£º“ÎҵĵçÄÔ”-> “ÊôÐÔ” -> “¸ß¼¶” -> “»·¾³±äÁ¿”£¬ÔÚϵͳ±äÁ¿ÄÇÀï±à¼classpath£¬½«D:\mysql-connector-java-5.0.5\mysql-connector-java-5.0.5-bin.jar¼Óµ½×îºó£¬ÔÚ¼ÓÕâ¸ö×Ö·û´®Ç°Òª¼Ó“;”£¬ÒÔÓëǰһ¸öclasspathÇø·Ö¿ª¡£È»ºóÈ·¶¨¡£»·¾³ÅäÖúÃÁË£¬ºÜ¼òµ¥¡£ÏÖÔÚ£¬ÏÈÅäÖÃMySQL£¬ÉèÆäÓû§ÃûΪ“root”£¬ÃÜÂëΪ“root”¡£ÔÚÃüÁîÐлòÓÃÒ»¸öSQLµÄǰ¶ËÈí¼þ´´½¨Database¡£
ÔÚeclipseÖе¼Èëjdbc¾Í¿ÉÒÔÁË.·½·¨ÈçÏÂ:ÔËÐÐeclipse,´°¿Ú->Ê×Ñ¡Ïî->java->ÒѰ²×°µÄjre->(Ñ¡ÖÐÆäÖÐÒ»¸ö)->±à¼->È¡ÏûϵͳĬÈÏjre->Ìí¼ÓÍⲿjre->ÕÒµ½jdbcÎļþ¼ÐÖеÄmysql-connector-java-5.0.0-beta-bin.jar(¸ÃÏî¿ÉÄܲ»Ëù²»Í¬,²»¹ýûÓйØÏµ)->È·¶¨.ÄÇô¾Í¿ÉÒÔÔÚeclipseÖÐʹjavaÓëmysqlÁ¬½ÓÁË.
ÏÈ´´½¨Êý¾Ý¿â£º
CREATE DATABASE SCUTCS;
½Ó×Å£¬´´½¨±í£º
CREATE TABLE STUDENT
(
SNO CHAR(7) NOT NULL,
SNAME VARCHAR(8) NOT NULL,
SEX CHAR(2) NOT NULL,
BDATE DATE NOT NULL,
HEIGHT DEC(5,2) DEFAULT 000.00,
PRIMARY KEY(SNO)
);
È»ºó²åÈëÊý¾Ý£¬¿ÉÒÔÓÃSQLÓï¾äinsert into <±íÃû> values (value1, value2, ...);
Ò²¿ÉÒÔÓÃSQLyogÀ´²Ù×÷
ºÃÁË£¬´´½¨ºÃÁË¡£
ÏÂÃæ£¬ÎÒÃÇÀ´±àд.javaÎļþÀ´ÑÝʾһÏÂÈçºÎ·ÃÎÊMySQLÊý¾Ý¿â¡£
import java.sql.*;
public class JDBCTest {
public static void main(String[] args){
// Çý¶¯³ÌÐòÃû
String driver = "com.mysql.jdbc.Driver";
&nbs
Ïà¹ØÎĵµ£º
1 ¾ÛºÏ
Ö»ÒªÀàÖнáºÏÁ˶ÔÏóµÄʵÀý£¬ÎÞÂÛ¸öÊý¶àÉÙ¶¼´æÔÚ ¾ÛºÏµÄ¹ØÏµ£¬
¾ÛºÏÊǹØÁªµÄÒ»ÖÖÌØÊâÐÎʽ£¬ËüÒâζ×ÅÒ»ÖÖÕûÌå / ²¿·Ö£¨ whole/part £©µÄ¹ØÏµ¡£
°×É«ÁâÐÎÖ±Ïß´ú±í¾ÛºÏµÄ¹ØÏµ ±íʾWhole ʹÓÃÁËPart
ÀàÖзÃÎÊ¿ØÖÆ
+´ú±í publicµÄÊôÐÔ ......
Java·¢Õ¹µ½ÏÖÔÚ£¬°´Ó¦ÓÃÀ´·ÖÖ÷Òª·ÖΪÈý´ó¿é£ºJ2SE,J2MEºÍJ2EE¡£ÕâÈý¿éÏ໥²¹³ä£¬Ó¦Ó÷¶Î§²»Í¬¡£
J2SE¾ÍÊÇJava2µÄ±ê×¼°æ£¬Ö÷ÒªÓÃÓÚ×ÀÃæÓ¦ÓÃÈí¼þµÄ±à³Ì£»
J2MEÖ÷ÒªÓ¦ÓÃÓÚǶÈëÊÇϵͳ¿ª·¢£¬ÈçÊÖ»úºÍPDAµÄ±à³Ì£»
J2EEÊÇJava2µÄÆóÒµ°æ£¬Ö÷ÒªÓÃÓÚ·Ö²¼Ê½µÄÍøÂç³ÌÐòµÄ¿ª·¢£¬Èçµç×ÓÉÌÎñÍøÕ¾ºÍERPϵͳ¡£
ÏÈѧϰj2se
Ҫѧϰj2ee¾ÍÒ ......
1.ÄãÐèÒª¾«Í¨ÃæÏò¶ÔÏó·ÖÎöÓëÉè¼Æ(OOA/OOD)¡¢É漰ģʽ(GOF£¬J2EEDP)ÒÔ¼°×ÛºÏģʽ¡£ÄãÓ¦¸ÃÊ®·ÖÁ˽âUML£¬ÓÈÆäÊÇclass£¬object£¬interactionÒÔ¼°statediagrams¡£
¡¡¡¡2.ÄãÐèҪѧϰJAVAÓïÑԵĻù´¡ÖªÊ¶ÒÔ¼°ËüµÄºËÐÄÀà¿â(collections£¬serialization£¬streams£¬networking£¬ multithreading ......
¶ÔÓÚÕâ¸öϵÁÐÀïµÄÎÊÌ⣬ÿ¸öѧJavaµÄÈ˶¼Ó¦¸Ã¸ã¶®¡£µ±È»£¬Èç¹ûÖ»ÊÇѧJavaÍæÍæ¾ÍÎÞËùνÁË¡£Èç¹ûÄãÈÏΪ×Ô¼ºÒѾ³¬Ô½³õѧÕßÁË£¬È´²»ºÜ¶®ÕâЩÎÊÌ⣬Ç뽫Äã×Ô¼ºÖعé³õѧÕßÐÐÁС£ÄÚÈݾùÀ´×ÔÓÚCSDNµÄ¾µäÀÏÌù¡£
ÎÊÌâÒ»£ºÎÒÉùÃ÷ÁËʲô£¡
String s = "Hello world!";
¡¡Ðí¶àÈ˶¼×ö¹ýÕâÑùµÄÊÂÇ飬µ«ÊÇ£¬ÎÒÃǵ½µ×ÉùÃ÷ÁËʲô£¿»Ø´ðͨ ......
1£©Õý³£Çé¿öÏÂÎÒÃÇ¿ÉÒÔͨ¹ýÀàʵÀý»¯Ò»¸ö¶ÔÏó£¬ÄÇôͨ¹ý·´Éäʵ¼ÊÉϾͿÉÒÔͨ¹ýÒ»¸ö¶ÔÏóµÃµ½´ËÀàÍêÕûµÄ°ü.ÀàÃû³Æ
JAVA·´Éä»úÖÆÊÇÔÚÔËÐÐ״̬ÖУ¬¶ÔÓÚÈÎÒâÒ»¸öÀ࣬¶¼Äܹ»ÖªµÀÕâ¸öÀàµÄËùÓÐÊôÐԺͷ½·¨£»¶ÔÓÚÈÎÒâÒ»¸ö¶ÔÏ󣬶¼Äܹ»µ÷ÓÃËüµÄÈÎÒâÒ»¸ö·½·¨£»ÕâÖÖ¶¯Ì¬»ñÈ¡µÄÐÅÏ¢ÒÔ¼°¶¯Ì¬µ÷ÓöÔÏóµÄ·½·¨µÄ¹¦ÄܳÆÎªjavaÓïÑԵķ´Éä»úÖÆ¡£
......