常用JDBC连接字符串

zJun's Tech Weblog

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帛罗阁阅读(867) 评论(0) 编辑收藏所属分类: 数据库、Java基础


只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻知识库 C++博客博问管理
相关文章: MySQL修改root密码查看Oracle中锁表的sql语句 [转] 破解MySQL的MD5函数 Oracle SQL 3则 [深入浅出Hibernate笔记] Hibernate中的继承关系 [深入浅出Hibernate笔记] Oracle中的大字段 Blob/Clob [Oracle] Oracle中的日期格式常用JDBC连接字符串 [Oracle] Sequence简单介绍 Informix技巧4则

Dev@Free