数学建模社区-数学中国
标题:
常用数据库连接方法
[打印本页]
作者:
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; n
cn = 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! U
3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
2 m6 ]5 n8 F3 \% y" L$ `
Class.forName( "oracle.jdbc.driver.OracleDriver" );
5 C) O+ O% F ]! T
cn = DriverManager.getConnection( "jdbc
racle:thin
MyDbComputerNameOrIP: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, M
cn = 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. ODBC
4 l1 O4 ~+ @0 o
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
: `6 z: j/ r- ~2 o/ ~% a
Connection cn = DriverManager.getConnection( "jdbc
dbc:" + sDsn, sUsr, sPwd );
5 h" f- v l/ F' i- P1 e; s9 [
# ]; Q$ N4 o5 b( M1 o9 @# H
8.DB2
9 Y8 X E# r& u; ?+ T3 }
Class.forName("com.ibm.db2.jdbc.net.DB2Driver");
" |5 ^0 n; _' S+ d
String 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