数学建模社区-数学中国

标题: 常用数据库连接方法 [打印本页]
作者: huashi3483    时间: 2004-9-27 18:57
标题: 常用数据库连接方法
1. MySQL(http://www.mysql.com)mm.mysql-2.0.2-bin.jar; S, ?+ {/ Q* Y3 g5 |" I
Class.forName( "org.gjt.mm.mysql.Driver" );
6 ]1 e: L* P3 J; ncn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );9 G- U7 i& ]; y9 v) _' Y
' {( i; F1 z' e: F% _$ L0 G) r
2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar& J' g  M+ \; G$ q7 }4 ?
Class.forName( "org.postgresql.Driver" );  y* p, E0 J& K8 S' n, H' r5 n
cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );3 P2 E5 [* b$ S4 ?$ v5 C1 X

( n% r: W$ M! U3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip2 m6 ]5 n8 F3 \% y" L$ `
Class.forName( "oracle.jdbc.driver.OracleDriver" );
5 C) O+ O% F  ]! Tcn = DriverManager.getConnection( "jdbcracle:thinMyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );
( r& i/ W0 W4 W3 z! r
: k' `5 Z$ p# d; U" ^, s. D5 Z$ B; ^4. Sybase(http://jtds.sourceforge.net)jconn2.jar- _: X# ~2 h6 R+ _
Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" );
+ Z0 S. b+ w; p+ d& B% T7 X3 m, Mcn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638", sUsr, sPwd );
9 v, d2 l6 T6 W6 r! K* W5 K1 f//(Default-Username/Password: "dba"/"sql")
7 H. L# D: `- W8 Q4 R3 m+ c% e" Z: X5 U7 m4 k+ J
5. Microsoft SQLServer(http://jtds.sourceforge.net)1 T8 ^6 e+ W' T% U( N
Class.forName( "net.sourceforge.jtds.jdbc.Driver" );  X9 y1 b  @# i, G( m
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd );$ h" [9 f. F' U6 X( c) |

2 Y' ~# h4 ~' P* o2 i6 w' \6. Microsoft SQLServer(http://www.microsoft.com)% q; T2 L4 G' q3 x) O
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );0 F! R; p/ |2 Y  |
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd );
7 k: F( B4 }' d/ x. J1 ~% t% r: u# I* q: W% G: T
7. ODBC4 l1 O4 ~+ @0 o
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
: `6 z: j/ r- ~2 o/ ~% aConnection cn = DriverManager.getConnection( "jdbcdbc:" + sDsn, sUsr, sPwd );
5 h" f- v  l/ F' i- P1 e; s9 [
# ]; Q$ N4 o5 b( M1 o9 @# H8.DB29 Y8 X  E# r& u; ?+ T3 }
Class.forName("com.ibm.db2.jdbc.net.DB2Driver");
" |5 ^0 n; _' S+ dString url="jdbc:db2://192.9.200.108:6789/SAMPLE"! L0 }) `, i: E7 T8 i3 `
cn = DriverManager.getConnection( url, sUsr, sPwd );
作者: 446数学建模    时间: 2012-1-16 22:31
楼主辛苦了，可是看不懂啊



欢迎光临 数学建模社区-数学中国 (http://www.madio.net/) Powered by Discuz! X2.5