浅析JAVA常用JDBC连接数据库的方法总结

一JDBC连接DB

复制代码 代码如下:
ClassforName("ComibmdbjdbcnetDBDriver");
String url="jdbc:db://dburl:port/DBname"
cn = DriverManagergetConnection( url sUsr sPwd );
ClassforName("ComibmdbjdbcnetDBDriver");
String url="jdbc:db://dburl:port/DBname"
cn = DriverManagergetConnection( url sUsr sPwd );

二JDBC连接Microsoft SQLServer(microsoft)

复制代码 代码如下:
ClassforName( "commicrosoftjdbcsqlserverSQLServerDriver" );
cn = DriverManagergetConnection( "jdbc:microsoft:sqlserver://DBServerIP:;databaseName=master" sUsr sPwd );
ClassforName( "commicrosoftjdbcsqlserverSQLServerDriver" );
cn = DriverManagergetConnection( "jdbc:microsoft:sqlserver://DBServerIP:;databaseName=master" sUsr sPwd );

三JDBC连接Sybase(jconnjar)

复制代码 代码如下:
ClassforName( "comsybasejdbcjdbcSybDriver" );
cn = DriverManagergetConnection( "jdbc:sybase:Tds:DBServerIP:" sUsr sPwd );
ClassforName( "comsybasejdbcjdbcSybDriver" );
cn = DriverManagergetConnection( "jdbc:sybase:Tds:DBServerIP:" sUsr sPwd );

四JDBC连接MySQL(mmmysqlbinjar)

复制代码 代码如下:
ClassforName( "orggjtmmmysqlDriver" );
cn = DriverManagergetConnection( "jdbc:mysql://DBServerIP:/myDatabaseName" sUsr sPwd );
ClassforName( "orggjtmmmysqlDriver" );
cn = DriverManagergetConnection( "jdbc:mysql://DBServerIP:/myDatabaseName" sUsr sPwd );

五JDBC连接PostgreSQL(pgjdbcjar)

复制代码 代码如下:
ClassforName( "orgpostgresqlDriver" );
cn = DriverManagergetConnection( "jdbc:postgresql://DBServerIP/myDatabaseName" sUsr sPwd );
ClassforName( "orgpostgresqlDriver" );
cn = DriverManagergetConnection( "jdbc:postgresql://DBServerIP/myDatabaseName" sUsr sPwd );

六JDBC连接Oracle(classesjar)

复制代码 代码如下:
ClassforName( "oraclejdbcdriverOracleDriver" );
cn = DriverManagergetConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP::ORCL" sUsr sPwd );
ClassforName( "oraclejdbcdriverOracleDriver" );
cn = DriverManagergetConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP::ORCL" sUsr sPwd );

七JDBC连接ODBC

复制代码 代码如下:

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