FreeBSD 上,安装好Connector/J,并设置 classpath。
mysql-connector-java-5.1.12 MySQL Connector/J: JDBC interface for MySQL
export CLASSPATH=/usr/local/share/java/classes/mysql-connector-java.jar:$CLASSPATH
Java 6 之前,要想起用某个 driver,需要 Class.forName("com.somejdbcvendor.TheirJdbcDriver");
现在不需要了,因为 .jar 中自带了 driver 的描述:
$ jar xf /usr/local/share/java/classes/mysql-connector-java.jar
$ cat META-INF/services/java.sql.Driver
com.mysql.jdbc.Driver
------------------------------------------------------
import java.sql.*;
public class TestJDBC {
public static void main(String[] args) throws SQLException {
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testdb", "root", "root");
try {
Statement stmt = conn.createStatement();
try {
stmt.executeUpdate("CREATE TABLE mytable (Name varchar(255))");
} finally {
try { stmt.close(); } catch (Throwable ignore) { }
}
} finally {
try { conn.close(); } catch (Throwable ignore) { }
}
}
}
------------------------------------------------------
import java.sql.*;
import java.util.Enumeration;
public class AllDriver {
public static void main(String[] args) {
Enumeration<Driver> drivers = DriverManager.getDrivers();
while (drivers.hasMoreElements()) {
Driver d = drivers.nextElement();
System.out.println(d.getClass().getName());
}
}
}
------------------------------------------------------
有了 Connection,自然需要 Connection Pool,一些参考:
评论