首先,建立一个示例表:Student,SQL语句如下:
CREATE TABLE Student(
id int NOT NULL auto_increment,
username varchar(200) NOT NULL,
password varchar(20) NOT NULL,
age int,
PRIMARY KEY (id)
)DEFAULT CHARSET=GBK
一. MySQL
Driver:com.mysql.jdbc.Driver
Url:jdbc:mysql://<hostname>[<:3306>]/<dbname>
连接示例:
public static void main(String args[]){
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
java.sql.Connection conn = null;
java.sql.Statement stmt = null;
java.sql.ResultSet rs = null;
try {
//建立jdbc连接
conn = java.sql.DriverManager.getConnection(
"jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=GBK","root","tiger"
);
stmt = conn.createStatement();
//省略
.........................
...................................
..............................................
...........................................................
二. SQLServer
Driver:com.microsoft.jdbc.sqlserver.SQLServerDriver
Url:jdbc:microsoft:sqlserver://<server_name>:<1433>
三. ORACLE
Driver:oracle.jdbc.driver.OracleDriver
Url:jdbc:oracle:thin:@<server>[:<1521>]:<database_name>
四. Derby
Derby数据库现在称为Java DB,已经成为JDK1.6的一部分,它也是一款开源免费的数据库,所不同的是它是基于纯Java进行开发的。
Driver:org.apache.derby.jdbc.ClientDriver
Url:jdbc:derby://<server_name>:<port>/<databaseName>