数学建模社区-数学中国

标题: 常用数据库连接方法 [打印本页]

作者: 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* dcn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );
/ n4 P! ^- x1 }7 w5 X: ?
/ H6 N: C* |5 Y5 y% L# z2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar
, C) X. X4 K) d" o) p. ]) EClass.forName( "org.postgresql.Driver" );
/ }; B) V* J2 L% x, {3 [$ R, gcn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );6 q; `: v, x3 q9 Y6 l

$ {7 Q8 \; i, F3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
5 z& s" [4 {3 h' P: TClass.forName( "oracle.jdbc.driver.OracleDriver" );
% f& k+ {6 t7 U: F" T9 Ucn = DriverManager.getConnection( "jdbcracle:thinMyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );1 p$ p$ _1 m( z" p. H

9 X  U- x6 w3 l* I0 N; v4. Sybase(http://jtds.sourceforge.net)jconn2.jar
7 L- k) v4 O* mClass.forName( "com.sybase.jdbc2.jdbc.SybDriver" );
; U0 K6 X6 g% j* R- G/ Bcn = 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& rClass.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  ZClass.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( "jdbcdbc:" + 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# ~- dString 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