数学建模社区-数学中国
标题:
常用数据库连接方法
[打印本页]
作者:
huashi3483
时间:
2004-9-27 18:57
标题:
常用数据库连接方法
1. MySQL(http://www.mysql.com)mm.mysql-2.0.2-bin.jar
# F7 e* D2 h$ z: y$ a4 F
Class.forName( "org.gjt.mm.mysql.Driver" );
$ ]! q5 l+ R( P2 n$ s+ y# ?* {- Y
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );
6 j& A+ b: p5 U* B
) B+ v& P+ P6 \) h9 l3 ^- L2 T! U' [
2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar
+ A6 N* F0 T& l# u1 _
Class.forName( "org.postgresql.Driver" );
4 f2 N1 v0 G5 {8 \' ~! p
cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );
1 ?0 c3 G2 d$ m. p
& E7 B' s( w( T; }* Z
3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
g i# _: V1 K; K. ?$ d% D
Class.forName( "oracle.jdbc.driver.OracleDriver" );
" x. J7 t( i, {2 C' B E
cn = DriverManager.getConnection( "jdbc
racle:thin
MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );
7 R6 A8 L" ^6 n5 `. o
$ `; E) c8 U! g' E) a
4. Sybase(http://jtds.sourceforge.net)jconn2.jar
( P* Q2 U+ v/ P" |2 B
Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" );
! Q) L; }! q, x8 ^
cn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638", sUsr, sPwd );
( y6 }# A8 `$ ?8 H
//(Default-Username/Password: "dba"/"sql")
* v4 |' e. d; K3 p
. q# x* A# p8 o& a8 l9 a- u0 X
5. Microsoft SQLServer(http://jtds.sourceforge.net)
6 p, E& o9 T0 x: q( y! q
Class.forName( "net.sourceforge.jtds.jdbc.Driver" );
$ W z6 |5 c; p8 `3 @- T9 ]
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd );
( v" `. K4 ?+ v3 R
+ T" \* W' }, m
6. Microsoft SQLServer(http://www.microsoft.com)
4 J6 I; L t( }+ f# X
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
5 {% y8 s; O& L M6 o- |) j9 w
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd );
0 z% M% ^9 |/ G# f
/ R0 e/ L; V' Z5 _4 I6 l
7. ODBC
9 Q5 s) o, e" B. f/ j' U2 R$ |( y; M
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
c+ g+ }0 G2 S* v' p. ]
Connection cn = DriverManager.getConnection( "jdbc
dbc:" + sDsn, sUsr, sPwd );
8 b( Z+ b+ z$ S2 }/ v
" o5 ]2 W1 d3 D1 Q- ~& ~9 b1 e1 |5 |4 Q
8.DB2
0 `- g" k" S3 G3 R1 ^6 I) E# Z
Class.forName("com.ibm.db2.jdbc.net.DB2Driver");
" S0 ?6 [/ w1 m3 L/ u% u
String url="jdbc:db2://192.9.200.108:6789/SAMPLE"
$ N7 q& o2 r/ O) s: o8 U$ @7 Y
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 );7 R6 A8 L" ^6 n5 `. odbc:" + sDsn, sUsr, sPwd );8 b( Z+ b+ z$ S2 }/ v