常用数据库连接方法

huashi3483

1. MySQL(http://www.mysql.com)mm.mysql-2.0.2-bin.jar
( B) m3 A! v- T& P$ _0 kClass.forName( "org.gjt.mm.mysql.Driver" );
1 |* v: h  @% ^2 ]cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );
3 U3 n8 y) F  i  R$ q, {9 H
) T% m8 a# R( Z: Q$ q2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar
Class.forName( "org.postgresql.Driver" );
cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );
( L  S" u  F) s4 ?5 o
3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
Class.forName( "oracle.jdbc.driver.OracleDriver" );
cn = DriverManager.getConnection( "jdbcracle:thinMyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );
% M: Y, z# d6 Z- H4 E/ @  k
. h& h# a/ a) v  }. T$ O4. Sybase(http://jtds.sourceforge.net)jconn2.jar
Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" );
+ x$ h9 ?$ w( p# ocn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638", sUsr, sPwd );
//(Default-Username/Password: "dba"/"sql")

5. Microsoft SQLServer(http://jtds.sourceforge.net)
Class.forName( "net.sourceforge.jtds.jdbc.Driver" );
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd );
6 i; Z6 Q* b( J& @  ~
# D! l* Q7 [) p1 I. C/ ]1 }/ B6. Microsoft SQLServer(http://www.microsoft.com)
* a, ?0 c6 @" q& nClass.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
% `; l  a: S" C. bcn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd );

9 Y0 `# F% L5 D7. ODBC
  k# U5 D5 {3 l: ~1 G* CClass.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection cn = DriverManager.getConnection( "jdbcdbc:" + sDsn, sUsr, sPwd );
: [5 Y0 _: j& z2 G. e- y) p' {
( }1 t; ^) S% [3 F1 z5 W8.DB2
Class.forName("com.ibm.db2.jdbc.net.DB2Driver");
String url="jdbc:db2://192.9.200.108:6789/SAMPLE"
cn = DriverManager.getConnection( url, sUsr, sPwd );

446数学建模

楼主辛苦了，可是看不懂啊