感謝beansoft提供的《MyEclipse 6 Java 開發(fā)中文教程》，使我受益匪淺。
1、首先，當(dāng)然要準(zhǔn)備JDBC驅(qū)動啦
可以到mysql官方網(wǎng)站下載mysql-connector-java-5.1.6-bin.jar
2、
CREATE TABLE `student` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(200) NOT NULL,
`password` varchar(20) NOT NULL,
`age` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=gbk;
/**
* @(#)JDBCTest.java
*
*
* @author keer2345
* @version 1.00 2008/8/11
*/
import java.sql.*;
public class JDBCTest {
public static void main(String[] args) {
// 1. 注冊驅(qū)動
try {
Class.forName("com.mysql.jdbc.Driver");
} catch(ClassNotFoundException ex) {
ex.printStackTrace();
}
// 聲明變量，使用，而后關(guān)閉
Connection conn = null; //數(shù)據(jù)庫連接
Statement stmt = null; //數(shù)據(jù)庫表達(dá)式
ResultSet rs = null; //結(jié)果集
try {
//2. 獲取數(shù)據(jù)庫的連接
conn = DriverManager.getConnection
("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=GBK","root","");
//3. 獲取表達(dá)式
stmt = conn.createStatement();
// 插入數(shù)據(jù)
stmt.executeUpdate("insert into Student (username, password, age) values ('張三','1234',20)");
//4. 執(zhí)行SQL
rs = stmt.executeQuery("select * from Student");
//5. 現(xiàn)實結(jié)果集里面的數(shù)據(jù)
while(rs.next()) {
System.out.println("編號=" + rs.getInt(1));
System.out.println("姓名=" + rs.getString("username"));
System.out.println("密碼=" + rs.getString("password"));
System.out.println("年齡=" + rs.getString("age"));
System.out.println("---------------");
}
}
catch (Exception ex) {
ex.printStackTrace();
}
finally {
try {
if(rs != null) {
rs.close();
}
if(sm != null) {
sm.close();
}
if(conn != null) {
conn.close();
}
} catch(Exception ex) {
ex.printStackTrace();
}
}
}
}