该用户从未签到
|
1连接SqlServer2000 msbase.jar msutil.jar mssqlserver.jar7 _" u1 k6 A- M3 e% O4 M
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
! K0 {! z5 ~( m+ @ String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=tempdb"; $ t2 T1 }( O8 C& X- O
2连接SqlServer2005 sqljdbc.jar: y+ M! P( `. s
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 5 o' ?2 A% w: \& ?' R/ i: E
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=tempdb"; 1 x0 Z+ w0 c B/ X$ F
" E2 [6 F6 E" L
3. MySQL mysql-connector-java-5.0.7-bin.jar: M# t1 L# M2 f9 O" X
Class.forName( "com.mysql.jdbc.Driver" );9 |. h) \4 V7 h- Q- D; I( H# j
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName?useUnicode=true;characterEncoding=GBK ", sUsr, sPwd );) w5 m ~% q$ W: T
1 Q( q' a) C' T; B- B- ?- | 4. Oracle(
. s; ?% X3 g, z( G3 y2 ~4 p3 n //注意把oracle下的classes12.zip 改名为classes12.jar,然后拷贝到tomcat的common/lib下
9 b& C' A% I7 c1 d% S' B Class.forName("oracle.jdbc.driver.OracleDriver");
, ?) {' {: D' \2 s7 v/ T Connection conn= DriverManager.getConnection("jdbcracle:thinlocalhost:1521rcl",user,password);
3 l' o5 M* H+ o. t7 u4 I
$ n% i. Y! |! @) C3 y 5. 使用jtds连接SQLServer2000 jtds-1.2.jar
, f9 P/ t5 I$ m. { Class.forName( "net.sourceforge.jtds.jdbc.Driver" );/ E% V. X& |/ L7 G. H" G8 n
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/数据库名", sUsr, sPwd );) n) o$ L6 y" ?5 A
: R/ I. M- }% |6 u9 f
' \( A1 ?$ O: L+ S3 k% w
6. ODBC1 X" O5 {% S0 Z+ e
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
. [( I, e/ Q2 ^% b2 U# ]: { Connection cn = DriverManager.getConnection( "jdbcdbc:数据源名", sUsr, sPwd );7 n* {3 `' I( b8 U7 {
( M) U/ }8 q5 m% [8 J3 {/ H: T8 a 7.DB23 x, T$ _) I- ?% v/ h! ?# r6 S5 a6 W6 j: b
Class.forName("Com.ibm.db2.jdbc.app.DB2Driver");
$ t# A' B' u$ H- O- F6 g String url="jdbc:db2://192.9.200.108:6789/数据库名"
0 Q) w8 ^: M! i% h: x7 }9 y, | cn = DriverManager.getConnection( url, sUsr, sPwd );
7 i" @+ ?" N% S7 f/ i
! f6 r" ^8 p( i+ G 8. PostgreSQL) U# Q! W0 J3 v7 W6 {
Class.forName( "org.postgresql.Driver" );3 I3 a) r4 N3 }" }- _# u( F+ e* V
cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );
- d% H. B3 M) r Z5 i 5 ?, X% ^& s6 X, j
9. Sybase
" k$ D$ W; e( C: y Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" );' b* F% h% M1 l7 {! S) }$ b7 p
cn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638", sUsr, sPwd );( O: W" q5 ^8 z8 S7 D
//(Default-Username/Password: "dba"/"sql")
8 G* J$ D3 H* u8 p1 `' j 4 P* U. u; N; X
; ^, i, Z- V) u; E |
|