隨筆檔案(496)

1.到http://www.mysql.com下載MySQL數(shù)據(jù)庫服務器和驅(qū)動程序Jdbc driver for MySQL

2.安裝MySQL數(shù)據(jù)庫，本人下載的是安裝版本的，所以直接點Setup.exe就可以了，當然也可以下載．zip解壓版本的，不過解壓后要設置下環(huán)境變量之類的，麻煩～～

3.設置驅(qū)動程序路徑,本人下載的Jdbc driver for MySQL是mysql-connector-java-5.0.7-bin.jar,將它放到<MySQL_HOME>\,然后在系統(tǒng)環(huán)境變量中的classpath加入mysql-connector-java-5.0.7-bin.jar的路徑,如我加入的是:C:\Program Files\MySQL\MySQL Server 5.0\mysql-connector-java-5.0.7-bin.jar,OK

4.創(chuàng)建數(shù)據(jù)庫,組合鍵Win+R,輸入cmd后回車,進入命令行模式,鍵入mysql -uroot -p你設置的密碼

????? create database mydb01;

????? use mydb01;

????? create table table1(CD int(8) primary key,NAME varchar(10));

????? insert into table1 values(1,'name1');

????? insert into table1 values(2,'name2');

????? insert into table1 values(3,'name3');

????? 輸入命令:select * from table1;如果見到以下內(nèi)容,則說明數(shù)據(jù)庫創(chuàng)建成功.

+------+-------+
| CD????? | NAME???? |
+------+-------+
|?????? 1 | name1 |
|?????? 2 | name2 |
|?????? 3 | name3 |
+------+-------+

5.編寫連接數(shù)據(jù)庫的測試代碼

import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;

public class mysqltest {
?????? public static void main(String[] args) {
?????????? try{
?????????????? Class.forName("com.mysql.jdbc.Driver").newInstance();
?????????????? String url ="jdbc:mysql://localhost:3306/mydb01";
?????????????? Connection conn= DriverManager.getConnection(url,"root","你設置的密碼");
?????????????? Statement stmt=conn.createStatement();
?????????????? String sql="select * from table1";
?????????????? ResultSet rs=stmt.executeQuery(sql);

?????????????? while(rs.next()) {
?????????????????? System.out.print(rs.getInt("CD")+"\t");
?????????????????? System.out.println(rs.getString("NAME"));
?????????????? }

?????????????? System.out.println("Done");
?????????????? rs.close();
?????????????? stmt.close();
?????????????? conn.close();
????????????
????????? }catch(Exception e){
????????????? e.printStackTrace();
????????? }
?????? }
}

6.再次進入命令行模式,測試一下是否連接成功

??? javac mysqltest.java

??? java??? mysqltest