常用的JDBC驱动名字和URL列表

红太狼 2022-08-03 03:06 274阅读 0赞

<table style="word-wrap:break-word; table-layout:fixed"> 
 <tbody style="word-wrap:break-word"> 
 <tr style="word-wrap:break-word"> 
 <td style="word-wrap:break-word; margin:0px; padding:0px"> 
 <div style="word-wrap:break-word">
 常用 JDBC 驱动名字和 URL 列表&nbsp; 
 
 
 ODBC driver 
 sun.jdbc.odbc.JdbcOdbcDriver 
 jdbc:odbc:name&nbsp; 
 
 用 COM.ibm.db2.jdbc.net.DB2Driver 连接到 DB2 数据库 
 一个 DB2 URL 的示例: 
 jdbc:db2://aServer.myCompany.com:50002/name&nbsp; 
 
 用 com.sybase.jdbc.SybDriver连接到 Sybase 数据库 
 一个 Sybase URL 的示例: 
 jdbc:sybase:Tds:aServer.myCompany.com:2025&nbsp; 
 
 
 MySQL driver 
 com.mysql.jdbc.Driver 
 jdbc:mysql://hostname:3306/dbname?useUnicode=true&amp;characterEncoding=GBK&nbsp; 
 
 
 Microsoft SQL Server Driver 
 com.microsoft.jdbc.sqlserver.SQLServerDriver 
 jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=WapSvc;User=sa;Password=pwd&nbsp; 
 
 
 Informix 
 com.informix.jdbc.IfxDriver 
 jdbc:informix-sqli://hostname:1526/dbname:INFORMIXSERVER=informixservername;user=username;password=password&nbsp; 
 
 
 Oracle 
 oracle.jdbc.driver.OracleDriver 
 jdbc:oracle:thin:@hostname:1521:&nbsp; 
 
 
 Postgresql 
 org.postgresql.Driver 
 jdbc:postgresql://localhost/soft&nbsp; 
 
 Apache Derby/Java DB 
 org.apache.derby.jdbc.ClientDriver 
 jdbc:derby://localhost:1527/databaseName;create=true&nbsp; 
 
 Access 是通过 ODBC 连接的. Excel 也可以. 甚至可以动态构造连接字符串:&nbsp; 
 
 这样可以直接连接到 Access 数据库文件.&nbsp; 
 
 jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\mydata.mdb&nbsp; 
 
 类似的 Excel 文件也可以用类似方法:&nbsp; 
 
 jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=.\mydata.xls 
 
 </div> 
 <div style="word-wrap:break-word">
 &nbsp; 
 </div> 
 <div style="word-wrap:break-word">
 &nbsp; 
 </div> 
 <div style="word-wrap:break-word">
 &nbsp; 
 </div> 
 <div style="word-wrap:break-word">
 &nbsp; 
 </div> </td> 
 </tr> 
 </tbody> 
</table>

<table style="word-wrap:break-word; color:rgb(102,102,102); font-family:宋体,Arial; font-size:16px; line-height:26px; border-collapse:collapse"> 
 <tbody style="word-wrap:break-word"> 
 <tr style="word-wrap:break-word"> 
 <td style="word-wrap:break-word; margin:0px; padding:0px"> <code style="word-wrap:break-word"> /* Java 连接mysql ---已验证 */ Class.forName("com.mysql.jdbc.Driver");&nbsp; conn&nbsp;=&nbsp;DriverManager.getConnection("jdbc:mysql://localhost:3306/",&nbsp;"root",&nbsp;"root");</code> </td> 
 </tr> 
 </tbody> 
</table>

<table style="word-wrap:break-word; color:rgb(102,102,102); font-family:宋体,Arial; font-size:16px; line-height:26px; border-collapse:collapse"> 
 <tbody style="word-wrap:break-word"> 
 <tr style="word-wrap:break-word"> 
 <td style="word-wrap:break-word; margin:0px; padding:0px"><code style="word-wrap:break-word"></code> Class.forName("com.mysql.jdbc.Driver");&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/*驱动的名称*/ Connection&nbsp;conn=DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&amp;password=286772"); <code style="word-wrap:break-word"></code>&nbsp; </td> 
 </tr> 
 </tbody> 
</table>