1、Oracle8/8i/9i数据库(thin模式) Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();; u7 h) l# R1 c1 ], N% ~
String url="jdbc:oracle:thin:@localhost:1521:orcl"; //orcl为数据库的SID
8 G4 [( Q* [* I W1 @* X String user="test";
1 |6 z6 e+ Q, {3 n8 [ String password="test";7 g: h+ f# \9 t6 K, G& k
Connection conn= DriverManager.getConnection(url,user,password);
7 H" N! P; W+ v( e2、DB2数据库 % b# r" z( N5 `* C
Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance();. Z7 M! ?3 a( W# |$ `/ s2 v) K) A
String url="jdbc:db2://localhost:5000/sample"; //sample为你的数据库名4 c2 Q1 P7 Z9 k, @0 u* C
String user="admin";
- T n r9 c- G; {" e String password="";" h+ v% \) k1 K" L1 S9 \
Connection conn= DriverManager.getConnection(url,user,password);; H! ~% R! y& H! N w5 m
3、SQL Server7.0/2000数据库 : J6 W1 W, T6 G. w+ ^4 \; O1 ~
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
0 }6 z6 S$ ?* m8 p) l String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";: t+ [/ J. `0 O* t' L! e
//mydb为数据库* |! d2 H) }3 e" L+ I) X0 ^
String user="sa";& L. R+ V2 o. \6 r4 g
String password="";1 {+ O# y9 s6 `/ _9 S
Connection conn= DriverManager.getConnection(url,user,password);
: i% L# F$ p6 h! P4、Sybase数据库 ; ^. }4 O0 Y" A4 j: x0 o0 s
Class.forName("com.sybase.jdbc.SybDriver").newInstance();
1 R5 s- T0 u% U4 p! T7 g4 ]) z String url =" jdbc:sybase:Tds:localhost:5007/myDB";//myDB为你的数据库名8 m: {4 k* b+ |
Properties sysProps = System.getProperties();
, H. [* X: o9 ~$ Z( [8 w* c SysProps.put("user","userid");8 R$ R+ l* W/ E$ r5 h% R
SysProps.put("password","user_password");
/ M, G8 L& O: p; v" y! ]8 |% @3 S8 a- A5 f* l+ M' J+ G1 [( E [
Connection conn= DriverManager.getConnection(url, SysProps); |