常用數據庫JDBC連接寫法大全

　　 MySQL()mmmysqlbinjar

　　ClassforName( orggjtmmmysqlDriver );

　　cn = DriverManagergetConnection( jdbc:mysql://MyDbComputerNameOrIP:/myDatabaseName sUsr sPwd );

　　 PostgreSQL()pgjdbcjar

　　ClassforName( orgpostgresqlDriver );

　　cn = DriverManagergetConnection( jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName sUsr sPwd );

　　 Oracle()classeszip

　　ClassforName( oraclejdbcdriverOracleDriver );

　　cn = DriverManagergetConnection( jdbc:oracle:thin:@MyDbComputerNameOrIP::ORCL sUsr sPwd );

　　 Sybase()jconnjar

　　ClassforName( comsybasejdbcjdbcSybDriver );

　　cn = DriverManagergetConnection( jdbc:sybase:Tds:MyDbComputerNameOrIP: sUsr sPwd );

　　//(DefaultUsername/Password: dba/sql)

　　 Microsoft SQLServer()

　　ClassforName( netsourceforgejtdsjdbcDriver );

　　cn = DriverManagergetConnection( jdbc:jtds:sqlserver://MyDbComputerNameOrIP:/master sUsr sPwd );

　　 Microsoft SQLServer()

　　ClassforName( commicrosoftjdbcsqlserverSQLServerDriver );

　　cn = DriverManagergetConnection( jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:;databaseName=master sUsr sPwd );

　　 ODBC

　　ClassforName( sunjdbcodbcJdbcOdbcDriver );

　　Connection cn = DriverManagergetConnection( jdbc:odbc: + sDsn sUsr sPwd );

　　DB

　　ClassforName(DBDriver);

　　String url=jdbc:db://:/SAMPLE

　　cn = DriverManagergetConnection( url sUsr sPwd );

From:http://tw.wingwit.com/Article/program/Oracle/201311/16557.html