JDBC连接各种数据库方法

1.Oracle8/8i/9i数据库(瘦模式)
class . for name(" Oracle . JDBC . driver . Oracle driver ")。new instance()；
String URL = " JDBC:Oracle:thin:@ localhost:1521:orcl "；
//orcl是数据库的SID
string user = " test "；
String password = " test "；
Connection conn = driver manager . get Connection(URL，user，password)；
2、DB2数据库
class . forname(" com . IBM . DB2 . JDBC . app . db 2 driver ")。new instance()；
String URL = " JDBC:DB2://localhost:5000/sample "；
//sample是您的数据库名称
String user = " admin "；
String password = " "；
Connection conn = driver manager . get Connection(URL，user，password)；
3、SQL Server7.0/2000数据库
class . for name(" com . Microsoft . JDBC . SQL server . SQL server driver ")。new instance()；
String URL = " JDBC:Microsoft:SQL server://localhost:1433；DatabaseName = mydb "；
//mydb是数据库
String user = " sa "；
String password = " "；
Connection conn = driver manager . get Connection(URL，user，password)；
4、Sybase数据库
class . forname(" com . Sybase . JDBC . syb driver ")。new instance()；
String URL = " JDBC:Sybase:Tds:localhost:5007/myDB "；
//myDB是您的数据库名称
properties sysprops = system . get properties()；
SysProps.put("user "，" userid ")；
SysProps.put("password "，" user _ password ")；
Connection conn = driver manager . get Connection(URL，SysProps)；
5。Informix database
class . forname(" com。Informix.jdbc.ifxdriver”)。new instance()；
String URL =
" JDBC:Informix-sqli://123 . 45 . 67 . 89:1533/myDB:Informix server = my server；
user = testuser；密码=测试密码"；
//myDB是数据库名称
connection conn = driver manager . getconnection(URL)；
6、MySQL数据库
class . forname(" org . gjt . mm . MySQL . driver ")。new instance()；
String URL = " JDBC:MySQL://localhost/myDB？user = soft & password = soft 1234 & use unicod
e = true & character coding = 8859 _ 1 "
/mydb是数据库名称
connection conn = driver manager . getconnection(URL)；
7、PostgreSQL数据库
class . forname(" org . PostgreSQL . driver ")。new instance()；
String URL = " JDBC:PostgreSQL://localhost/mydb "
/mydb是数据库名称
String user = " my user "；
String password = " my password "；
Connection conn = driver manager . get Connection(URL，user，password)；