数学建模社区-数学中国
标题:
常用数据库连接方法
[打印本页]
作者:
huashi3483
时间:
2004-9-27 18:57
标题:
常用数据库连接方法
1. MySQL(http://www.mysql.com)mm.mysql-2.0.2-bin.jar
0 O4 ]* |: w3 z' e2 s$ ]
Class.forName( "org.gjt.mm.mysql.Driver" );
: O& }! f" G$ k4 n
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );
# N- ~% n* M% ~
* s8 W( a! z! n
2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar
( ?8 { E5 r4 J; e* }8 T
Class.forName( "org.postgresql.Driver" );
! x% O9 i8 M& L/ X% N
cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );
$ |5 h% c ^$ M0 M' Z5 e
, k/ @3 D9 O5 w! A: ]* H( K
3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
: l* A @7 R6 p5 M: q. n& [
Class.forName( "oracle.jdbc.driver.OracleDriver" );
# s% Z1 I& \4 e: t, u
cn = DriverManager.getConnection( "jdbc
racle:thin
MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );
. f/ p! o8 o: W
" E" C" E7 ^" N! U4 s
4. Sybase(http://jtds.sourceforge.net)jconn2.jar
4 A* i9 }+ @. n. `* t
Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" );
; |1 ^/ ~0 M: @' x+ K0 I
cn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638", sUsr, sPwd );
. w3 s* {- `7 @: S4 S1 N: C/ w8 R( b
//(Default-Username/Password: "dba"/"sql")
/ y4 D8 n& q2 L8 o
" l" k7 n$ T5 M: v% J
5. Microsoft SQLServer(http://jtds.sourceforge.net)
) ~' Q* L! U0 s1 Y- _5 t
Class.forName( "net.sourceforge.jtds.jdbc.Driver" );
9 o9 c$ C0 Y2 C8 N$ \7 c
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd );
0 T! R0 O5 l3 A* x
3 i* y! Q# D' C4 [ Y' |
6. Microsoft SQLServer(http://www.microsoft.com)
* t" r o+ c9 t% `
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
% |5 K4 g: T7 C, X5 J3 i* Z1 Z
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd );
( _0 t' N9 N! L# j0 t
* F8 Z6 P/ C6 G! e% Q
7. ODBC
; C8 {3 E# |( a# P" n0 h% x
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
) g2 |, K* E2 U0 i
Connection cn = DriverManager.getConnection( "jdbc
dbc:" + sDsn, sUsr, sPwd );
n8 ~3 ~+ t9 D
2 L$ \8 ^: f/ p8 [/ Y
8.DB2
% a( h( p; O7 ^+ ?+ w! T' H
Class.forName("com.ibm.db2.jdbc.net.DB2Driver");
D" b) q8 c/ Q+ @; e4 u
String url="jdbc:db2://192.9.200.108:6789/SAMPLE"
" J8 L* A" i8 f9 j8 J, P6 ] h: h
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 );. f/ p! o8 o: Wdbc:" + sDsn, sUsr, sPwd ); n8 ~3 ~+ t9 D