首先得确保己安装好jdk和mysql，然后下载一个mysql驱动mysql-connector-java-5.1.6.tar.gz，解压后将一个mysql-connector-java-5.1.6-bin.jar文件放在JRE的库扩展目录里，如：/usr/local/jdk1.6.0_20/jre/lib/ext目录下，这样就OK啦
^_^
然后创建数据库winnie中的表格roommate，内容如下：
|
name
| age |
| liuyang
| 21
|
| huangxuan | 20
|
| huangyang | 21
|
| tangtuo
| 20
|
1 import
java.sql.*;
2 public
class SampleIntro {
3
public
static void main(String[] args) {
4
try {
5
Connection conn;
6
Statement stmt;
7
ResultSet res;
8
Class.forName("com.mysql.jdbc.Driver").newInstance();
9
conn =
DriverManager.getConnection("jdbc:mysql://localhost:3306/winnie",
"root", "password");
10
stmt = conn.createStatement();
11
res = stmt.executeQuery("select * from roommate");
12
while(res.next()) {
13
String name = res.getString("name");
14
System.out.println(name);
15
}
16
res.close();
17
}catch (Exception e) {
18
System.out.println("Error : " + e.toString());
19
}
20
}
21
}
liuyang
huangxuan
huangyang
tangtuo
