JDBC驱动上载及连接字符串URL写法
日期：2014-05-16 浏览次数：20494 次
JDBC驱动下载及连接字符串URL写法
以下内容来自互联网
1.?MySQL(http://www.mysql.com )?mysql-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(http://www.de.postgresql.org )?pgjdbc2.jar?;
??Class.forName(?"org.postgresql.Driver"?);?
??cn?=?DriverManager.getConnection(?"jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName",?sUsr,?sPwd?);?
3.?Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/ )?classes12.zip?;
??Class.forName(?"oracle.jdbc.driver.OracleDriver"?);?
??cn?=?DriverManager.getConnection(?"jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL",?sUsr,?sPwd?);?
4.?Sybase(http://jtds.sourceforge.net )?jconn2.jar?;
??Class.forName(?"com.sybase.jdbc2.jdbc.SybDriver"?);?
??cn?=?DriverManager.getConnection(?"jdbc:syb
sun官方网站上的JDBC驱动列表： http://java.sun.com/products/jdbc/reference/industrysupport/index.html
| MySQL ? | http://www.mysql.com/products/connector/j/ ? Shipped.?But?need?to?download?the?latest?for?MySQL?4.1?or?higher. ? |
| Oracle ? | http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html ? Included. ? |
| SQL?Server?by?jTDS ? | http://sourceforge.net/project/showfiles.php?group_id=33291 ? Included.?Support?Microsoft?SQL?Server?(6.5,?7,?2000?and?2005) ? |
| Postgres ? | http://jdbc.postgresql.org/download.html ? Included?7.3?JDBC?3 ? |
| SAP?DB ? | http://www.sapdb.org/sap_db_jdbc.htm ? Included. ? |
| SyBase?by?jTDS ? | http://jtds.sourceforge.net/ ? Included.?Support?Sybase?(10,?11,?12) ? |
以下内容来自互联网
1.?MySQL(http://www.mysql.com )?mysql-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(http://www.de.postgresql.org )?pgjdbc2.jar?;
??Class.forName(?"org.postgresql.Driver"?);?
??cn?=?DriverManager.getConnection(?"jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName",?sUsr,?sPwd?);?
3.?Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/ )?classes12.zip?;
??Class.forName(?"oracle.jdbc.driver.OracleDriver"?);?
??cn?=?DriverManager.getConnection(?"jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL",?sUsr,?sPwd?);?
4.?Sybase(http://jtds.sourceforge.net )?jconn2.jar?;
??Class.forName(?"com.sybase.jdbc2.jdbc.SybDriver"?);?
??cn?=?DriverManager.getConnection(?"jdbc:syb
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
