数学建模社区-数学中国
标题:
常用数据库连接方法
[打印本页]
作者:
huashi3483
时间:
2004-9-27 18:57
标题:
常用数据库连接方法
1. MySQL(http://www.mysql.com)mm.mysql-2.0.2-bin.jar
/ C1 n! H7 b' W, X8 ^4 v1 ~
Class.forName( "org.gjt.mm.mysql.Driver" );
9 I, z$ L! z. n! B* d
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );
/ n4 P! ^- x1 }7 w5 X: ?
/ H6 N: C* |5 Y5 y% L# z
2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar
, C) X. X4 K) d" o) p. ]) E
Class.forName( "org.postgresql.Driver" );
/ }; B) V* J2 L% x, {3 [$ R, g
cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );
6 q; `: v, x3 q9 Y6 l
$ {7 Q8 \; i, F
3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
5 z& s" [4 {3 h' P: T
Class.forName( "oracle.jdbc.driver.OracleDriver" );
% f& k+ {6 t7 U: F" T9 U
cn = DriverManager.getConnection( "jdbc
racle:thin
MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );
1 p$ p$ _1 m( z" p. H
9 X U- x6 w3 l* I0 N; v
4. Sybase(http://jtds.sourceforge.net)jconn2.jar
7 L- k) v4 O* m
Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" );
; U0 K6 X6 g% j* R- G/ B
cn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638", sUsr, sPwd );
* U3 s0 f3 S: s7 p0 G
//(Default-Username/Password: "dba"/"sql")
% N8 C2 f$ F! i6 i7 v
, [' I+ @3 t- |0 i7 Y
5. Microsoft SQLServer(http://jtds.sourceforge.net)
) r% t" t- y6 s! y; p* W& r
Class.forName( "net.sourceforge.jtds.jdbc.Driver" );
; p! S; N; G M! ?5 y
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd );
8 E, F2 |) e% r+ j0 r1 F" B
7 U# E7 S' y2 x. V& l: U
6. Microsoft SQLServer(http://www.microsoft.com)
+ O' T. |- M) X" l/ Z' t4 G Z
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
- Y5 V9 r4 m9 e. z- ?
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd );
5 ^9 p9 Q! U) @
0 w0 b# S: o! O3 l+ L
7. ODBC
$ F3 r. V1 B' P" \" y
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
( D6 P* Q8 D* ]4 o; o
Connection cn = DriverManager.getConnection( "jdbc
dbc:" + sDsn, sUsr, sPwd );
. u4 k+ B6 J1 @, C I5 W5 ^
' E* c9 u( W) O9 _3 Y$ `( y
8.DB2
% g. Q1 u9 T9 E; Q. ]
Class.forName("com.ibm.db2.jdbc.net.DB2Driver");
9 W3 b& a S% `$ i1 J5 f# ~- d
String url="jdbc:db2://192.9.200.108:6789/SAMPLE"
% q5 [+ \8 _, F. J8 C5 K5 L6 M
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 );1 p$ p$ _1 m( z" p. Hdbc:" + sDsn, sUsr, sPwd );