mysql连接Java的API文档_Java使用JDBC DriverManager 接口连接MySQL数据库

1､注册MySQL Connector代码import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

// 注意, 不需要import com.mysql.jdbc.*

// 否则会有问题

public class LoadDriver {

public static void main(String[] args) {

try {

// The newInstance() call is a work around for some

// broken Java implementations

Class.forName("com.mysql.jdbc.Driver").newInstance();

} catch (Exception ex) {

// handle the error

}

}

}

2､获取特定数据库连接

在驱动程序注册后 DriverManager，您可以Connection通过调用DriverManager.getConnection()以下命令获取连接到特定数据库的实例：import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

Connection conn = null;

...

try {

conn =

DriverManager.getConnection("jdbc:mysql://localhost/test?" +

"user=minty&password=greatsqldb");

// Do something with the Connection

...

} catch (SQLException ex) {

// handle any errors

System.out.println("SQLException: " + ex.getMessage());

System.out.println("SQLState: " + ex.getSQLState());

System.out.println("VendorError: " + ex.getErrorCode());

}