数学建模社区-数学中国
标题:
常用数据库连接方法
[打印本页]
作者:
huashi3483
时间:
2004-9-27 18:57
标题:
常用数据库连接方法
1. MySQL(http://www.mysql.com)mm.mysql-2.0.2-bin.jar
, |1 i. k7 ^2 W$ F9 U
Class.forName( "org.gjt.mm.mysql.Driver" );
2 b; Q5 V) G8 }7 R: T! {: \
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );
]% I- ?3 ?" ]% x; r1 f
+ p$ A1 c/ }& X7 ?/ i
2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar
0 D; L: {8 x8 q+ b" s
Class.forName( "org.postgresql.Driver" );
" {1 N+ y8 a) T1 z. n
cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );
$ y- W1 H! o: o3 n9 c
5 z+ O$ ~6 Z! X! a; {% n
3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
# X6 @% B% f% H. X/ y% P" d' h
Class.forName( "oracle.jdbc.driver.OracleDriver" );
- i/ i- B- O- {% h- C
cn = DriverManager.getConnection( "jdbc
racle:thin
MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );
$ d$ b; H: F& y) W( t7 i
8 j1 [( l) e q) G$ A
4. Sybase(http://jtds.sourceforge.net)jconn2.jar
: J1 \" O* G: }/ I2 |- a
Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" );
8 i/ N& t( Q A4 j9 o
cn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638", sUsr, sPwd );
* F: Z% Y1 [: j4 \- q) H
//(Default-Username/Password: "dba"/"sql")
8 D5 N0 p% |% d. j5 \
4 g/ G: i$ S `) L( B& g
5. Microsoft SQLServer(http://jtds.sourceforge.net)
9 ]' y ~6 q" R4 v3 b
Class.forName( "net.sourceforge.jtds.jdbc.Driver" );
' ?6 o) M% P7 L5 _1 C' {: d
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd );
" W5 }( B) ~ c! A5 r! V
2 ^4 g9 S+ f* i& T! Y0 F$ }
6. Microsoft SQLServer(http://www.microsoft.com)
6 F! m# U4 z* z# v7 W7 j: i4 S' P
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
g+ `! h# Y- z( x, H' @
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd );
" y" c# a M |% {- L
& b' H6 E# Y* P+ C
7. ODBC
8 b8 f8 M f1 R& p+ k3 S8 D5 ?
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
, d8 a7 j2 ?! r2 g0 ]2 N- T
Connection cn = DriverManager.getConnection( "jdbc
dbc:" + sDsn, sUsr, sPwd );
' j B3 l7 w- f9 I2 o- Y K
. Z5 _4 C# d5 M- e' [: t
8.DB2
y" j; L9 U+ |& S0 t5 y( }0 M) L4 m
Class.forName("com.ibm.db2.jdbc.net.DB2Driver");
3 l) v( j0 t& k) H s/ Z, X
String url="jdbc:db2://192.9.200.108:6789/SAMPLE"
j: ?1 X ? N# z$ d# v0 X
cn = DriverManager.getConnection( url, sUsr, sPwd );
作者:
446数学建模
时间:
2012-1-16 22:31
楼主辛苦了，可是看不懂啊
欢迎光临 数学建模社区-数学中国 (http://www.madio.net/)
Powered by Discuz! X2.5
racle:thin
MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );dbc:" + sDsn, sUsr, sPwd );' j B3 l7 w- f9 I2 o- Y K