数学建模社区-数学中国

标题: 常用数据库连接方法 [打印本页]

作者: 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 ?/ i2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar
0 D; L: {8 x8 q+ b" sClass.forName( "org.postgresql.Driver" );
" {1 N+ y8 a) T1 z. ncn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );$ y- W1 H! o: o3 n9 c

5 z+ O$ ~6 Z! X! a; {% n3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
# X6 @% B% f% H. X/ y% P" d' hClass.forName( "oracle.jdbc.driver.OracleDriver" );
- i/ i- B- O- {% h- Ccn = DriverManager.getConnection( "jdbcracle:thinMyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );
$ d$ b; H: F& y) W( t7 i8 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 ocn = 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& g5. Microsoft SQLServer(http://jtds.sourceforge.net)
9 ]' y  ~6 q" R4 v3 bClass.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! V2 ^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' PClass.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. ODBC8 b8 f8 M  f1 R& p+ k3 S8 D5 ?
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
, d8 a7 j2 ?! r2 g0 ]2 N- TConnection cn = DriverManager.getConnection( "jdbcdbc:" + sDsn, sUsr, sPwd );' j  B3 l7 w- f9 I2 o- Y  K

. Z5 _4 C# d5 M- e' [: t8.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