成人福利视频,日韩一区二区三区精品,蜜臀99久久精品久久久久久软件

zJun's Tech Weblog

常用JDBC連接字符串

1.MySQL

Class.forName(? " org.gjt.mm.mysql.Driver " ?);

Connection?conn? = ?DriverManager.getConnection(? " jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName " ,?sUsr,?sPwd?);

2.Microsoft SQLServer

Class.forName(? " com.microsoft.jdbc.sqlserver.SQLServerDriver " ?);

Connection?conn? = ?DriverManager.getConnection(? " jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master " ,?sUsr,?sPwd?);

3.Oracle

Class.forName(? " oracle.jdbc.driver.OracleDriver " ?);

Connection?conn? = ?DriverManager.getConnection(? " jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL " ,?sUsr,?sPwd?);

4.DB2

Class.forName( " com.ibm.db2.jdbc.net.DB2Driver " );

String?url = " jdbc:db2://192.9.200.108:6789/SAMPLE "

Connection?conn? = ?DriverManager.getConnection(?url,?sUsr,?sPwd?);

5.ODBC

Class.forName(? " sun.jdbc.odbc.JdbcOdbcDriver " ?);

Connection?conn? = ?DriverManager.getConnection(? " jdbc:odbc: " ? + ?sDsn,?sUsr,?sPwd?);

6.PostgreSQL

Class.forName(? " org.postgresql.Driver " ?);

Connection?conn? = ?DriverManager.getConnection(? " jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName " ,?sUsr,?sPwd?);

posted on 2006-07-27 14:45 zJun's帛羅閣閱讀(875) 評論(0) 編輯收藏所屬分類: 數據庫、Java基礎


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關文章: MySQL修改root密碼查看Oracle中鎖表的sql語句 [轉] 破解MySQL的MD5函數 Oracle SQL 3則 [深入淺出Hibernate筆記] Hibernate中的繼承關系 [深入淺出Hibernate筆記] Oracle中的大字段 Blob/Clob [Oracle] Oracle中的日期格式常用JDBC連接字符串 [Oracle] Sequence簡單介紹 Informix技巧4則