Java JDBCÁ¬½ÓMYSQLÊý¾Ý¿âʵÏÖ
´Ë±à³ÌÎÊÌâÏàÐźܶà¸ßÊÖÔø¾¹ý£¬Ð¡µÜÔڴ˰àÃÅŪ¸«£¬ÌØÉÏ´«Çå²â¹ý³Ì¹²´ó¼Òѧϰ£¡Ïêϸ¹ý³Ì¼ûÏÂÎÄ£º
²½ÖèÒ»
£º
ÏÂÔØ²¢
MYSQL
Êý¾Ý¿â£¬
MYSQL driver for Java,
¿ÉÊÓ»¯²Ù×÷Èí¼þ°´¡£±¾ÈË¿ª·¢»·¾³
:Windows XP ,Eclipse3.4,JDK1.6,MYSQL5.0, mysql-connector-java-5.0.4-bin.jar
£¬
Toad for MySQL 4.1 Freeware
¡£Ïêϸ°²×°·½Ê½·½·¨£¬ÇëÖ±½ÓÎÊ
www.g.cn
.
ÔÚ´ËÎҾͲ»¶à½²À²£¡
²½Öè¶þ£º
½¨Á¢²âÊÔÊý¾Ý¿âÏà¹Ø£¬ÓÐÁ½ÖÖ·½Ê½£º
·½Ê½1.
´ò¿ª
MYSQL
Command Line ClientÃüÁîÐÐ,
¼üÈëÒÔÏÂ
MYSQL
ÃüÁ
CREATE DATABASE
test; //
½¨Á¢²âÊÔÊý¾Ý¿â
USE
test; //
ʹÓÃÊý¾Ý¿â
/*
½¨Á¢²âÊÔ±í¸ñ
account*/
CREATE
TABLE
`
account
` (
`id` int
(
11
)
NOT
NULL
auto_increment
,
`password` varchar
(
15
)
NOT
NULL
,
`userName` varchar
(
20
)
NOT
NULL
,
PRIMARY
KEY
(`id`)
)
ENGINE
=
InnoDB
DEFAULT
CHARSET
=
utf8
;
·½Ê½2.
ÔËÐÐ
Toad for MySQL 4.1 Freeware
ÔÚ¿ÉÊÓ»¯½çÃæÏ´´½¨Êý¾Ý¿â£¬±í¸ñ¡£
×¢ÒâÊÂÏÒÔÉϽ¨Á¢
accout
±í¸ñ½Å±¾ÃüÁîÐÐ
` `
·ûºÅΪ·´ÒýºÅ£¬¶ø·Çµ¥ÒýºÅ
’ ’
£¬Èç¹ûÄã²»ÏëÌýµ½
MYSQL
±¨´í·¢³ö²»Óä¿ìµÄÉùÒô£¬Çë¼Çס£¬ÔÚ´Ë´¦±¾ÈË»¨Á˰ëСʱ¡£Ï£Íû´ó¼Ò¼Çס¡£
²½ÖèÈý£º
´´½¨Ò»¸ö
Java Projece
ÃûΪ
JDBCDemo
¹¤³Ì£¬´´½¨Ò»¸öÃûΪ
JDBCDemo
²âÊÔÀࣺ
ÔÚ
src
Ŀ¼ÏÂÃæ´´½¨Ò»¸öÃûΪ
jdbc_mysql.properties
ÊôÐÔÎļþÆäÄÚÈÝΪ£º
driver = com.mysql.jdbc.Driver
url = jdbc:mysql://localhost:3306/test
user = root
password = 123
×¢ÒâÊÂÏÅäÖÃÏîµÈºÅºóÃæÖµ¾ùÎÞË«ÒýºÅ
””
£¬·ñÔòÄãµÄ³ÌÐòÖ´ÐÐÁ˲»»á±¨´í£¬µ«ÊÇûÓÐÈκη´Ó³£¬×Ô¶¯ÖÕÖ¹¡£
²½ÖèËÄ£º
µ¼Èë
Ïà¹ØÎĵµ£º
Ê×ÏÈһЩ±»³õʼ»¯¶ÔÏóµÄ¸ÅÄ
Àà±äÁ¿£¨Àྲ̬³ÉÔ±£©£º Àà±»¼ÓÔØÊ±²úÉú£»ËüµÄÉú´æÆÚÊÇÀàµÄÉú´æÆÚ£»×Ô¶¯³õʼ»¯£¨Àà±»¼ÓÔØ£©
³ÉÔ±±äÁ¿£¨Àà³ÉÔ±£©£º ÔÚʹÓÃnew´´½¨¸ÃÀàʵÀýʱ²úÉú£»ËüµÄÉú´æÆÚÓë¸ÃÀàʵÀý¶ÔÏóµÄÉú´æÆÚÏàͬ£»
×Ô¶¯³õʼ»¯£¨¹¹Ôì·½·¨±»µ÷Óã©
¾Ö²¿±äÁ¿£¨ÀàµÄ·½·¨ÖеıäÁ¿£©£º ¸Ã·½·¨±»µ÷ÓÃÊ ......
ÔÚMySQL 3.23.44°æ±¾ºó£¬InnoDBÒýÇæÀàÐ͵ıíÖ§³ÖÁËÍâ¼üÔ¼Êø¡£
Íâ¼üµÄʹÓÃÌõ¼þ£º
1.Á½¸ö±í±ØÐëÊÇInnoDB±í£¬MyISAM±íÔÝʱ²»Ö§³ÖÍâ¼ü£¨¾Ý˵ÒÔºóµÄ°æ±¾ÓпÉÄÜÖ§³Ö£¬µ«ÖÁÉÙĿǰ²»Ö§³Ö£©£»
2.Íâ¼üÁбØÐ뽨Á¢ÁËË÷Òý£¬MySQL 4.1.2ÒÔºóµÄ°æ±¾ÔÚ½¨Á¢Íâ¼üʱ»á×Ô¶¯´´½¨Ë÷Òý£¬µ«Èç¹ûÔÚ½ÏÔçµÄ°æ±¾ÔòÐèÒªÏÔʾ½¨Á¢£»
3.Íâ¼ü¹ØÏ ......