熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

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

2022-06-13   來源: Oracle 

   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
    推薦文章
    Copyright © 2005-2022 電腦知識網 Computer Knowledge   All rights reserved.