1、Oracle8/8i/9i数据库(thin模式) 6 V' \3 W) O& j$ L2 l' S/ X3 i6 @
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); * p: Y$ q1 i9 N) I$ X2 C7 E6 }7 C
String url="jdbc:oracle:thin:@localhost:1521:orcl"; //orcl为数据库的SID % u5 A+ ?+ }$ M- c+ E- N3 s
String user="test"; * A3 E1 Z$ ]) B, I9 K ]) I1 |
String password="test"; 8 W" ]1 M" j1 U( H$ \
Connection conn= DriverManager.getConnection(url,user,password);
/ r' z+ R4 `7 ^8 Y6 w2、DB2数据库
/ K1 m9 E" v7 E8 VClass.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance(); % p2 u2 P3 Y- |" G' L9 W9 H/ x. O$ y
String url="jdbc:db2://localhost:5000/sample"; //sample为你的数据库名
. f/ R. k( z. ^" CString user="admin";
# B1 z& Y5 z) CString password="";
* B- V: M* l: A. e, F9 }Connection conn= DriverManager.getConnection(url,user,password);
4 q+ ?5 Y) d# v% @2 X: _3、SQL Server7.0/2000数据库
' n) O' Y: |0 P" C1 o2 M, zClass.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); $ N# W) L+ _! u: o, H
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
K" T9 V7 E6 N+ O9 i! o, D//mydb为数据库
0 N& n1 m& s' _; S7 }2 _String user="sa"; 3 q) X' F' B% ?1 P' w- a. V Q
String password="";
' Z7 x- z. ?7 G QConnection conn= DriverManager.getConnection(url,user,password); / p/ X' X$ k2 R, g; s
4、Sybase数据库 2 B8 D+ P! {+ _) t! t% M' ]
Class.forName("com.sybase.jdbc.SybDriver").newInstance(); ; _+ i* i& F1 O: o" q* K9 `) X2 `# s
String url =" jdbc:sybase:Tds:localhost:5007/myDB";//myDB为你的数据库名
' ~; _- n _. _Properties sysProps = System.getProperties();
! D2 R0 G4 L2 s2 t0 ]1 d, b- e1 ^SysProps.put("user","userid"); / M0 Z4 C) j0 H) Y! V
SysProps.put("password","user_password"); 0 V9 A6 ]" D2 B3 h
4 i9 u9 L$ a @) W" _1 `' B9 H+ dConnection conn= DriverManager.getConnection(url, SysProps); |