2022年2022年各种数据库的JDBC驱动下载及连接字符串URL写法 .pdf

各种数据库的JDBC驱动下载及连接字符串URL 写法sun 官方网站上的JDBC 驱动列表：url=http:/ 据 库说明MySQL url=http:/ Shipped. But need to download the latest for MySQL 4.1 or higher. Oracle url=http:/ SQL Server by jTDS url=http:/ Support Microsoft SQL Server (6.5, 7, 2000 and 2005) Postgres url=http:/jdbc.postgresql.org/download.htmlhttp:/jdbc.postgresql.org/download.html/url Included 7.3 JDBC 3 SAP DB url=http:/www.sapdb.org/sap_db_jdbc.htmhttp:/www.sapdb.org/sap_db_jdbc.htm /url Included. SyBase by jTDS url=http:/ Support Sybase (10, 11, 12) 以下内容来自互联网1. MySQL( url=http:/http:/ m ysql-connector-java-2.0.14-bin.jar ; Class.forName( org.gjt.mm.mysql.Driver ); cn =DriverManager.getConnection( jdbc:mysql:/MyDbComputerNameOrIP:3306/myDatabaseName, sUsr, sPwd ); 2. PostgreSQL( url=http:/www.de.postgresql.orghttp:/www.de.postgresql.org/url) pgjdbc2.jar ; Class.forName( org.postgresql.Driver ); cn =DriverManager.getConnection( jdbc:postgresql:/MyDbComputerNameOrIP/myDatabaseName, sUsr, sPwd ); 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 1 页，共 6 页 - - - - - - - - - 3. Oracle( url=http:/ classes12.zip ; Class.forName( oracle.jdbc.driver.OracleDriver ); cn =DriverManager.getConnection( jdbc:oracle:thin:MyDbComputerNameOrIP:1521:ORCL, sUsr, sPwd ); 4. Sybase( url=http:/http:/ jconn2.jar ; Class.forName( com.sybase.jdbc2.jdbc.SybDriver ); cn =DriverManager.getConnection( jdbc:sybase:Tds:MyDbComputerNameOrIP:2638, sUsr, sPwd ); /(Default-Username/Password: dba/sql) 5. Microsoft SQLServer( url=http:/http:/ ; Class.forName( net.sourceforge.jtds.jdbc.Driver ); cn =DriverManager.getConnection( jdbc:jtds:sqlserver:/MyDbComputerNameOrIP:1433/master, sUsr, sPwd ); 6. Microsoft SQLServer( url=http:/http:/ ; Class.forName( com.mic rosoft.jdbc.sqlserver.SQLServerDriver ); cn =DriverManager.getConnection( jdbc:microsoft:sqlserver:/MyDbComputerNameOrIP:1433;databaseName=master, sUsr, sPwd ); 7. ODBC Class.forName( sun.jdbc.odbc.JdbcOdbcDriver ); Connection cn = DriverManager.getConnection( jdbc:odbc: + sDsn, sUsr, sPwd ); 8.DB2 Class.forName(.DB2Driver); String url=jdbc:db2:/192.9.200.108:6789/SAMPLE cn = DriverManager.getConnection( url, sUsr, sPwd ); 9.access由于 access并不是作为一项服务运行，所以url 的方法对他不适用。access可以通过 odbc ，也可以通过服务器映射路径的形式找到.mdb文件 , 参见url=http:/rmijdbc.objectweb.org/Access/access.htmlhttp:/rmijdbc.objectweb.org/Access/access.html/urlJDBC API的使用方法(1) 登记并加载JDBC 驱动程序；两种方法：名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 2 页，共 6 页 - - - - - - - - - Class.forName(String drivername);DriverManager.registerDriver(Driver driver)(2) 建立与 SQL 数据库的连接；DriverManager的 getConnection()方法：Connection getConnection(String url):url表示数据库地址字符串；Connection getConnection(String url,String user,String pwd)Connection getConnection(String url,Properties info)(3) 传送一个SQL 查询；Connection的 createStatement()方法：Statement createStatement(); Statement 可以执行SQL 语句，得到SQL 查询结果。(4) 获得结果集。Statement 的执行 SQL 语句方法：ResultSet executeQuery(String sql):执行 select语句int executeUpdate(String sql)：执行更新语句，如insert,delete,update. (5) 检索查询结果。ResultSet的方法：boolean next():没有行时返回false; String getString(String columnName)：返回列名对应的值。posted on 2007-07-01 16:09 和田雨阅读 (153) 评论 (1) 编辑收藏引用所属分类 : JDBC 评论# re: 各种数据库的JDBC驱动下载及连接字符串URL 写法2007-07-02 19:28 和田雨为了方便大家查找，整理内容如下：1. MySQL( url=http:/)mm.mysql-2.0.2-bin.jarhttp:/)mm.m ysql-2.0.2-bin.jar/url Class.forName( org.gjt.mm.mysql.Driver ); cn =DriverManager.getConnection( jdbc:mysql:/MyDbComputerNameOrIP:3306/myDatabaseName, sUsr, sPwd ); 2. PostgreSQL( url=http:/www.de.postgresql.org)pgjdbc2.jarhttp:/www.de.postgresql.org)pgjdbc2.jar/url Class.forName( org.postgresql.Driver ); cn =DriverManager.getConnection( jdbc:postgresql:/MyDbComputerNameOrIP/myDatabaseName, sUsr, sPwd ); 3. Oracle( url=http:/ - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 3 页，共 6 页 - - - - - - - - - Class.forName( oracle.jdbc.driver.OracleDriver ); cn =DriverManager.getConnection( jdbc:oracle:thin:MyDbComputerNameOrIP:1521:ORCL, sUsr, sPwd ); 4. Sybase( url=http:/)jconn2.jarhttp:/)jconn2.jar/url Class.forName( com.sybase.jdbc2.jdbc.SybDriver ); cn =DriverManager.getConnection( jdbc:sybase:Tds:MyDbComputerNameOrIP:2638, sUsr, sPwd ); /(Default-Username/Password: dba/sql) 5. Microsoft SQLServer( url=http:/http:/ Class.forName( net.sourceforge.jtds.jdbc.Driver ); cn =DriverManager.getConnection( jdbc:jtds:sqlserver:/MyDbComputerNameOrIP:1433/master, sUsr, sPwd ); 6. Microsoft SQLServer( url=http:/http:/ Class.forName( com.microsoft.jdbc.sqlserver.SQLServerDriver ); cn =DriverManager.getConnection( jdbc:microsoft:sqlserver:/MyDbComputerNameOrIP:1433;databaseName=master, sUsr, sPwd ); 7. ODBC Class.forName( sun.jdbc.odbc.JdbcOdbcDriver ); Connection cn = DriverManager.getConnection( jdbc:odbc: + sDsn, sUsr, sPwd ); 8.DB2(新添加 ) Class.forName(.DB2Driver); String url=jdbc:db2:/192.9.200.108:6789/SAMPLE cn = DriverManager.getConnection( url, sUsr, sPwd ); 9.Microsoft SQL Server series (6.5, 7.x and 2000) and Sybase 10 JDBC Name: jTDS URL: url=http:/ 0.5.1 Download URL: url=http:/ - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 4 页，共 6 页 - - - - - - - - - : Class.forName(net.sourceforge.jtds.jdbc.Driver ); Connection con =DriverManager.getConnection(jdbc:jtds:sqlserver:/host:port/database,user,password); or Connection con =DriverManager.getConnection(jdbc:jtds:sybase:/host:port/database,user,password); 10.Postgresql JDBC Name: PostgreSQL JDBC URL: url=http:/jdbc.postgresql.org/http:/jdbc.postgresql.org/urlVersion: 7.3.3 build 110 Download URL: url=http:/jdbc.postgresql.org/download.htmlhttp:/jdbc.postgresql.org/download.html/url 语法 : Class.forName(org.postgresql.Driver); Connection con=DriverManager.getConnection(jdbc:postgresql:/host:port/database,user,password); 11.IBM AS400主机在用的JDBC 语法有装 V4R4以上版本的Client Access Express 可以在 C:Program FilesIBMClient Accessjt400lib 找到driver 档案jt400.zip，并更改扩展名成为jt400.jar 语法 : java.sql.DriverManager.registerDriver (new com .ibm.as400.access.AS400JDBCDriver (); Class.forName(com.ibm.as400.access.AS400JDBCConnection); con = DriverManager.getConnection(jdbc:as400:/IP,user,password); 12.informix Class.forName(com.informix.jdbc.IfxDriver).newInstance(); String url = jdbc:informix-sqli:/123.45.67.89:1533/testDB:INFORMIXSERVER=myserver; user= testuser;password=testpassword; Lib ：jdbcdrv.zip Class.forName( com.sybase.jdbc.SybDriver ) url=jdbc:sybase:Tds:127.0.0.1:2638/asademo; SybConnection connection=名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 5 页，共 6 页 - - - - - - - - - (SybConnection)DriverManager.getConnection(url,dba,sql); 13.SAP DB Class.forName (com.sap.dbtech.jdbc.DriverSapDB); java.sql.Connection connection =java.sql.DriverManager.getConnection ( jdbc:sapdb:/ + host + / + database_name,user_name, password) 14.InterBase String url = jdbc:interbase:/localhost/e:/testbed/database/employee.gdb; Class.forName(interbase.interclient.Driver); /Driver d = new interbase.interclient.Driver (); /* this will also work if you do not want the line above */ Connection conn = DriverManager.getConnection( url, sysdba, masterkey ); 15.HSqlDB url: url=http:/ driver: org.hsqldb.jdbcDriver 连接方式有4 种，分别为：con-str（内存） : jdbc:hsqldb. con-str（本地） : jdbc:hsqldb:/path/to/the/db/dir con-str（http）: jdbc:hsqldb:http:/dbsrv con-str（hsql ） : jdbc:hsqldb:hsql:/dbsrv 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 6 页，共 6 页 - - - - - - - - -