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
Ïà¹ØÎĵµ£º
input stream Out stream
DataInputStream DataIOutStream
BufferedInputStream BufferedOutStream
LineNumberInputStream PrintStream
PushbackInputStream
ÒÔ×Ö½ÚΪµ¼
ÏòµÄ stream
----------(ÎÞ ......
ÔÚÆÊÎö¸ÃÎÊÌâǰÇë¿´ÈçÏ´úÂë
public static String bytes2HexString(byte[] b) {
String ret = "";
for (int i = 0; i < b.length; i++) {
String hex = Integer.toHexString(b[ i ] & 0xFF);
if (hex.length() == 1) {
hex = '0' ......
ÉùÃ÷£ºJavaEyeÐÂÎÅÎÄÕµİæÈ¨ÊôÓÚJavaEyeÍøÕ¾ËùÓУ¬ÑϽûÈκÎÍøÕ¾×ªÔØ±¾ÎÄ£¬·ñÔò±Ø½«×·¾¿·¨ÂÉÔðÈΣ¡
ÍÆ¼öÊ®¸ö×îºÃµÄJavaÐÔÄܹÊÕÏÅųý¹¤¾ß£º
1.jconsoleÊÇËæ×ÅJDK 1.5¶øÍƳöµÄ¡£ÕâÊÇÒ»¸öJava¼à²âºÍ¹ÜÀí¿ØÖÆÌ¨-JMX¼æÈݵÄͼÐι¤¾ßÀ´¼à²âJavaÐéÄâ»ú¡£ËüÄܹ»Í¬Ê±¼à²â±¾µØºÍÔ¶³ÌµÄJVMs¡£ÏêÇé¿É²é¿´£ºjconsole¹¤¾ß½ ......
Ò»£¬ÍøÂç±à³ÌÖÐÁ½¸öÖ÷ÒªµÄÎÊÌâ
Ò»¸öÊÇÈçºÎ׼ȷµÄ¶¨Î»ÍøÂçÉÏһ̨»ò¶ą̀Ö÷»ú£¬ÁíÒ»¸ö¾ÍÊÇÕÒµ½Ö÷»úºóÈçºÎ¿É¿¿¸ßЧµÄ½øÐÐÊý¾Ý´«Êä¡£
ÔÚTCP/IPÐÒéÖÐIP²ãÖ÷Òª¸ºÔðÍøÂçÖ÷»úµÄ¶¨Î»£¬Êý¾Ý´«ÊäµÄ·ÓÉ£¬ÓÉIPµØÖ·¿ÉÒÔΨһµØÈ·¶¨InternetÉϵÄһ̨Ö÷»ú¡£
¶øTCP²ãÔòÌá¹©ÃæÏòÓ¦ÓõĿɿ¿µÄ»ò·Ç¿É¿¿µÄÊý¾Ý´«Êä»úÖÆ£¬ÕâÊÇÍøÂç±à³ÌµÄÖ÷Òª¶Ô ......
Java±àÒë»·¾³°²×°
1¡¢JDK
JDK-6-windows-i586.exe°²×°¡£
ÆäÖУ¬JDK°üº¬ÁËJRE¡¢JVM¡£
A¡¢JRE
B¡¢JVM
JavaÐéÄâ»ú
ʲôÊÇJavaÐéÄâ»ú
JavaÐéÄâ»úÊÇÒ»¸öÏëÏóÖеĻúÆ÷,ÔÚʵ¼ÊµÄ¼ÆËã»úÉÏͨ¹ýÈí¼þÄ£ÄâÀ´ÊµÏÖ¡£Java ......