- 浏览: 223773 次
- 性别:
- 来自: 苏州
文章分类
最新评论
-
zhangzijun1984:
非常感谢!
Maven学习——修改Maven的本地仓库路径 -
kehuoshui:
Class.forName("interbase.i ...
JDBC URL and Driver -
assasszt:
classUtils呢?
ObjectUtil.java -
j_yo:
貌似很多都不可以用吧
jdk1.7新特性 -
gangzi162:
java获取外网客户端MAC地址怎么获取呢?
Java获取客户端MAC地址
来源于网上
=====================================================================
1.Oracle数据库
OracleOracle Thin JDBC Driver
驱动程序包名:ojdbc14.jar
驱动程序类名: oracle.jdbc.driver.OracleDriver
JDBC URL:
jdbc:oracle:thin:@//<host>:<port>/ServiceName
或
jdbc:oracle:thin:@<host>:<port>:<SID>
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@localhost:1521:orcle";
String user = "test";
String password = "test";
Connection conn = DriverManager.getConnection(url, user, password);
=====================================================================
2.DB2数据库
IBM DB2IBM DB2 Universal Driver Type 4
驱动程序包名:db2jcc.jar db2jcc_license_cu.jar
驱动程序类名: com.ibm.db2.jcc.DB2Driver
JDBC URL: jdbc:db2://<host>[:<port>]/<database_name>
Class.forName("com.ibm.db2.jdbc.app.DB2Driver").newInstance();
String url = "jdbc:db2://localhost:5000/testDB";
String user = "admin";
String password = "test";
Connection conn = DriverManager.getConnection(url, user, password);
IBM DB2 Universal Driver Type 2
驱动程序包名:db2jcc.jar db2jcc_license_cu.jar
驱动程序类名: com.ibm.db2.jcc.DB2Driver
JDBC URL: jdbc:db2:<database_name>
=====================================================================
3.SQL Server数据库
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDB";
String user = "sa";
String password = "test";
Connection conn = DriverManager.getConnection(url, user, password);
Microsoft SQL ServerMicrosoft SQL Server JDBC Driver (一般用来连接 SQLServer 2000)
驱动程序包名:msbase.jar mssqlserver.jar msutil.jar
驱动程序类名: com.microsoft.jdbc.sqlserver.SQLServerDriver
JDBC URL: jdbc:microsoft:sqlserver://<server_name>:<port>
默认端口1433,如果服务器使用默认端口则port可以省略
Microsoft SQL Server 2005 JDBC Driver
驱动程序包名:sqljdbc.jar
驱动程序类名: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<server_name>:<port>
默认端口1433,如果服务器使用默认端口则port可以省略
Microsoft SQLServer(http://jtds.sourceforge.net) ;
Class.forName( "net.sourceforge.jtds.jdbc.Driver" );
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd );
=====================================================================
4. Sybase数据库
SybaseSybase Adaptive Server Enterprise JDBC Driver
驱动程序包名:jconn2.jar 或jconn3.jar
驱动程序类名: com.sybase.jdbc2.jdbc.SybDriver (com.sybase.jdbc3.jdbc.SybDriver)
JDBC URL: jdbc:sybase:Tds:<host>:<port>默认端口5000
Sybase Adaptive Server Anywhere or Sybase IQ JDBC Driver
驱动程序包名:jconn2.jar 或jconn3.jar
驱动程序类名: com.sybase.jdbc2.jdbc.SybDriver (com.sybase.jdbc3.jdbc.SybDriver)
JDBC URL: jdbc:sybase:Tds:<host>:<port>?ServiceName=<database_name>
默认端口2638
Class.forName("com.sybase.jdbc.SybDriver").newInstance();
String url = "jdbc:sybase:Tds:localhost:5007/testDB";
Properties sysProps = System.getProperties();
sysProps.put("user", "userid");
sysProps.put("password", "user_password");
Connection conn = DriverManager.getConnection(url, sysProps);
=====================================================================
5.Informix数据库
InformixInformix JDBC Driver
驱动程序包名:ifxjdbc.jar
驱动程序类名: com.informix.jdbc.IfxDriver
JDBC URL: jdbc:informix-sqli://{<ip-address>|<host-name>}:<port-number>[/<dbname>]: INFORMIXSERVER=<server-name>
Class.forName("com.infoxmix.jdbc.IfxDriver").newInstance();
String url = "jdbc:infoxmix-sqli://localhost:1533/testDB:INFORMIXSERVER=myserver;user=testuser;password=testpassword";
Connection conn = DriverManager.getConnection(url);
=====================================================================
6.MySQL数据库
MySQLMySQL Connector/J Driver
驱动程序包名:mysql-connector-java-x.x.xx-bin.jar
驱动程序类名: com.mysql.jdbc.Driver
JDBC URL: jdbc:mysql://<host>:<port>/<database_name>
默认端口3306,如果服务器使用默认端口则port可以省略
MySQL Connector/J Driver 允许在URL中添加额外的连接属性jdbc:mysql://<host>:<port>/<database_name>?
property1=value1&property2=value2
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url = "jdbc:mysql://localhost/testDB?
user=testuser&password=testpassword&useUnicode=true&characterEncoding=GB2312";
Connection conn = DriverManager.getConnection(url);
=====================================================================
7.PostgreSQL数据库
PostgreSQLPostgreSQL Native JDBC Driver
驱动程序包名:驱动程序类名: org.postgresql.Driver
JDBC URL: jdbc:postgresql://<host>:<port>/<database_name>
默认端口5432
Class.forName("org.postgresql.Driver").newInstance();
String url = "jdbc:postgresql://localhost/testDB";
String user = "myuser";
String password = "test";
Connection conn = DriverManager.getConnection(url, user, password);
=====================================================================
8 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)
=====================================================================
9 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" );
=====================================================================
10. ODBC
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection cn = DriverManager.getConnection( "jdbc:odbc:" + sDsn, sUsr, sPwd );
=====================================================================
11.access
由于access并不是作为一项服务运行,所以url的方法对他不适用。access可以通过odbc,也可以通过服务器映射路径的形式找到.mdb文件
用纯java连接Access数据库,不是用jdbc-odbc连接池,有个限制就是返回数据最多是1000条
=====================================================================
12 HSqlDB
url: http://hsqldb.sourceforge.net/
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
=====================================================================
TeradataTeradata Driver for the JDBC Interface
驱动程序包名:terajdbc4.jar tdgssjava.jar gui.jar
驱动程序类名: com.ncr.teradata.TeraDriver
JDBC URL:
Type 4: jdbc:teradata://DatabaseServerName/Param1,Param2,...
Type 3: jdbc:teradata://GatewayServerName:PortNumber
/DatabaseServerName/Param1,Param2,...
=====================================================================
NetezzaNetezza JDBC Driver
驱动程序包名:terajdbc4.jar tdgssjava.jar gui.jar
驱动程序类名: org.netezza.Driver
JDBC URL: jdbc:netezza://<host>:<port>/<database_name>
=====================================================================
1.Oracle数据库
OracleOracle Thin JDBC Driver
驱动程序包名:ojdbc14.jar
驱动程序类名: oracle.jdbc.driver.OracleDriver
JDBC URL:
jdbc:oracle:thin:@//<host>:<port>/ServiceName
或
jdbc:oracle:thin:@<host>:<port>:<SID>
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@localhost:1521:orcle";
String user = "test";
String password = "test";
Connection conn = DriverManager.getConnection(url, user, password);
=====================================================================
2.DB2数据库
IBM DB2IBM DB2 Universal Driver Type 4
驱动程序包名:db2jcc.jar db2jcc_license_cu.jar
驱动程序类名: com.ibm.db2.jcc.DB2Driver
JDBC URL: jdbc:db2://<host>[:<port>]/<database_name>
Class.forName("com.ibm.db2.jdbc.app.DB2Driver").newInstance();
String url = "jdbc:db2://localhost:5000/testDB";
String user = "admin";
String password = "test";
Connection conn = DriverManager.getConnection(url, user, password);
IBM DB2 Universal Driver Type 2
驱动程序包名:db2jcc.jar db2jcc_license_cu.jar
驱动程序类名: com.ibm.db2.jcc.DB2Driver
JDBC URL: jdbc:db2:<database_name>
=====================================================================
3.SQL Server数据库
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDB";
String user = "sa";
String password = "test";
Connection conn = DriverManager.getConnection(url, user, password);
Microsoft SQL ServerMicrosoft SQL Server JDBC Driver (一般用来连接 SQLServer 2000)
驱动程序包名:msbase.jar mssqlserver.jar msutil.jar
驱动程序类名: com.microsoft.jdbc.sqlserver.SQLServerDriver
JDBC URL: jdbc:microsoft:sqlserver://<server_name>:<port>
默认端口1433,如果服务器使用默认端口则port可以省略
Microsoft SQL Server 2005 JDBC Driver
驱动程序包名:sqljdbc.jar
驱动程序类名: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<server_name>:<port>
默认端口1433,如果服务器使用默认端口则port可以省略
Microsoft SQLServer(http://jtds.sourceforge.net) ;
Class.forName( "net.sourceforge.jtds.jdbc.Driver" );
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd );
=====================================================================
4. Sybase数据库
SybaseSybase Adaptive Server Enterprise JDBC Driver
驱动程序包名:jconn2.jar 或jconn3.jar
驱动程序类名: com.sybase.jdbc2.jdbc.SybDriver (com.sybase.jdbc3.jdbc.SybDriver)
JDBC URL: jdbc:sybase:Tds:<host>:<port>默认端口5000
Sybase Adaptive Server Anywhere or Sybase IQ JDBC Driver
驱动程序包名:jconn2.jar 或jconn3.jar
驱动程序类名: com.sybase.jdbc2.jdbc.SybDriver (com.sybase.jdbc3.jdbc.SybDriver)
JDBC URL: jdbc:sybase:Tds:<host>:<port>?ServiceName=<database_name>
默认端口2638
Class.forName("com.sybase.jdbc.SybDriver").newInstance();
String url = "jdbc:sybase:Tds:localhost:5007/testDB";
Properties sysProps = System.getProperties();
sysProps.put("user", "userid");
sysProps.put("password", "user_password");
Connection conn = DriverManager.getConnection(url, sysProps);
=====================================================================
5.Informix数据库
InformixInformix JDBC Driver
驱动程序包名:ifxjdbc.jar
驱动程序类名: com.informix.jdbc.IfxDriver
JDBC URL: jdbc:informix-sqli://{<ip-address>|<host-name>}:<port-number>[/<dbname>]: INFORMIXSERVER=<server-name>
Class.forName("com.infoxmix.jdbc.IfxDriver").newInstance();
String url = "jdbc:infoxmix-sqli://localhost:1533/testDB:INFORMIXSERVER=myserver;user=testuser;password=testpassword";
Connection conn = DriverManager.getConnection(url);
=====================================================================
6.MySQL数据库
MySQLMySQL Connector/J Driver
驱动程序包名:mysql-connector-java-x.x.xx-bin.jar
驱动程序类名: com.mysql.jdbc.Driver
JDBC URL: jdbc:mysql://<host>:<port>/<database_name>
默认端口3306,如果服务器使用默认端口则port可以省略
MySQL Connector/J Driver 允许在URL中添加额外的连接属性jdbc:mysql://<host>:<port>/<database_name>?
property1=value1&property2=value2
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url = "jdbc:mysql://localhost/testDB?
user=testuser&password=testpassword&useUnicode=true&characterEncoding=GB2312";
Connection conn = DriverManager.getConnection(url);
=====================================================================
7.PostgreSQL数据库
PostgreSQLPostgreSQL Native JDBC Driver
驱动程序包名:驱动程序类名: org.postgresql.Driver
JDBC URL: jdbc:postgresql://<host>:<port>/<database_name>
默认端口5432
Class.forName("org.postgresql.Driver").newInstance();
String url = "jdbc:postgresql://localhost/testDB";
String user = "myuser";
String password = "test";
Connection conn = DriverManager.getConnection(url, user, password);
=====================================================================
8 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)
=====================================================================
9 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" );
=====================================================================
10. ODBC
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection cn = DriverManager.getConnection( "jdbc:odbc:" + sDsn, sUsr, sPwd );
=====================================================================
11.access
由于access并不是作为一项服务运行,所以url的方法对他不适用。access可以通过odbc,也可以通过服务器映射路径的形式找到.mdb文件
用纯java连接Access数据库,不是用jdbc-odbc连接池,有个限制就是返回数据最多是1000条
=====================================================================
12 HSqlDB
url: http://hsqldb.sourceforge.net/
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
=====================================================================
TeradataTeradata Driver for the JDBC Interface
驱动程序包名:terajdbc4.jar tdgssjava.jar gui.jar
驱动程序类名: com.ncr.teradata.TeraDriver
JDBC URL:
Type 4: jdbc:teradata://DatabaseServerName/Param1,Param2,...
Type 3: jdbc:teradata://GatewayServerName:PortNumber
/DatabaseServerName/Param1,Param2,...
=====================================================================
NetezzaNetezza JDBC Driver
驱动程序包名:terajdbc4.jar tdgssjava.jar gui.jar
驱动程序类名: org.netezza.Driver
JDBC URL: jdbc:netezza://<host>:<port>/<database_name>
- drivers.part1.rar (7.6 MB)
- 下载次数: 56
- drivers.part2.rar (5.8 MB)
- 下载次数: 51
评论
2 楼
kehuoshui
2015-06-02
Class.forName("interbase.interclient.Driver"); 请问 这个需要加载哪个驱动?
1 楼
jackzqz
2012-03-26
非常有用,谢谢!
发表评论
-
Tomcat设置JVM内存及开启远程调试
2012-07-27 09:18 1604(1)设置JVM内存 set JAVA_OPTS=%JAVA_ ... -
JDBC获取DB元数据
2012-03-19 13:54 2982原文地址: http://jiauwu.iteye.com/b ... -
Dom4j and XPath
2012-02-27 13:29 2508很多东西长时间不用, 有些生疏了, 从网上整理了些资料, 丢在 ... -
Pagging
2012-01-12 18:32 9151. Derby http://db.apache.org/ ... -
[转]MySQL start service 1067
2011-06-01 09:00 1305启动mysql服务时报错: 在 本地计算机 无法启动mysq ... -
Java获取客户端MAC地址
2011-03-06 09:41 4679原文地址: http://rodneytt.iteye.com ... -
Java OOM
2011-03-05 00:02 1133原文地址:http://www.blogj ... -
Oracle 字符集的查看和修改
2011-01-03 15:21 1009原文地址: http://www.360doc.com/con ... -
收藏的一些资料
2010-12-23 17:07 934收藏的一些资料 -
ClassInfoUtil.java
2010-12-01 07:31 1063/* * ClassInfoUtil.java ... -
ClassUtil.java
2010-12-01 07:27 1858/* * File:ClassUtil.jav ... -
ObjectUtil.java
2010-12-01 07:26 2813/* * File:ObjectUtil.java ... -
JDK7新增的工具方法列表
2010-09-15 07:02 1227转自:JDK7新增的工具方法列表http://kenwu.me ... -
jdk1.7新特性
2010-09-15 06:58 3091原文地址:http://caowei3047.iteye.co ... -
jdk1.6新特性的介绍
2010-09-15 06:53 1242Java 平台的第六个版本, Standard Edition ... -
[转]JDK1.6.0新特性详解与代码示例
2010-09-15 06:48 1315原文地址: http://www.blogjava.net/r ... -
Web项目重命名
2010-05-28 19:27 1364原来项目名称是 PetStore 部署到tomcat输http ... -
XML 知识
2010-05-18 08:14 1076XML及DTD概览 http://www.iteye.com/ ... -
TDD可以带来好处
2010-05-12 07:47 1281提供明确的目标: 你很清楚, 一旦结束(测试通过), 你的工作 ... -
isNumber
2010-02-09 13:42 985public static boolean isN ...
相关推荐
When the driver is loaded, you can establish a connection by using a connection URL and the getConnection method of the DriverManager class: String connectionUrl = "jdbc:sqlserver://localhost:1433;" ...
When the driver is loaded, you can establish a connection by using a connection URL and the getConnection method of the DriverManager class: String connectionUrl = "jdbc:sqlserver://localhost:1433;" ...
SFTP URL to the SFTP-server directory (syntax: sftp://user:password@hostname[:port]/[dirpath/]mdbfile, also required third-party libraries Commons VFS and JSch for this protocol), e.g.: jdbc:jstels:...
#hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver #hibernate.connection.username ora #hibernate.connection.password ora #hibernate.connection.url jdbc:oracle:thin:@localhost:1521:orcl...
Class.ForName(com.mysql.jdbc.Driver); 2.建立连接 /* String url = "jdbc:mysql://localhost:3306/student"; //3306指你当前数据库的端口号,student指你指定的哪个数据库名字 String user = "root"; //root...
new oracle.jdbc.driver.OracleDriver(); DriverManager.registerDriver(driver); 3.加虚拟机参数jdbc.drivers -Djdbc.drivers=oracle.jdbc.driver.OracleDriver 4.从Jdk6.0以后要求,JDBC 4.0 Drivers ...
# connection-url must me the URL to access Oracle via JDBC. It can be different depending on your environment. # Another example of the URL would be jdbc:oracle:thin:@//ip:port/database. For more ...
jdbc-0.proxool.driver-url=jdbc:oracle:thin:@localhost:1521:orcal jdbc-0.user=cognos jdbc-0.password=cognos 3)打开Cognos configuration 配置configure the Custom Java namespace Type: Custom Java ...
<property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://127.0.0.1:3306/test"/> 此时将<property name="url" value="jdbc:mysql://127.0.0.1:...
jdbcUrl: 数据库的JDBC URL。 jdbcDriver: 对应不同数据库类型的驱动。 jdbcUsername: 连接数据库的用户名。 jdbcPassword: 连接数据库的密码。 基于JDBC参数配置的数据库连接 会使用默认的MyBatis连接池。 ...
java web dbcp2 数据库连接池演示 java web dbcp demo , with jdk 10 , MySQL Connector 8.x and servlet-api 4 demo...url=jdbc:mysql://127.0.0.1:3306/test?useSSL=false&characterEncoding=utf-8&useJDBCCompliantT
<property name="JDBC.Driver" value="org.hsqldb.jdbcDriver"/> <property name="JDBC.ConnectionURL" value="jdbc:hsqldb:data/tutorial"/> <property name="JDBC.Username" value="sa"/> <property name="...
public class Student { public static final String DRIVER="sun.jdbc.odbc.JdbcOdbcDriver"; public static final String URL="jdbc:odbc:student"; public static final String USERNAME="root";//用户名 public...
public class Student { public static final String DRIVER="sun.jdbc.odbc.JdbcOdbcDriver"; public static final String URL="jdbc:odbc:student"; public static final String USERNAME="root";//用户名 public...
public class Student { public static final String DRIVER="sun.jdbc。odbc。JdbcOdbcDriver"; public static final String URL="jdbc:odbc:student"; public static final String USERNAME="root";//用户名 ...
String url="jdbc:mysql://localhost:3306/atao"; String uname="root"; String upass="958672"; Connection conn=null; PreparedStatement stmt=null; ResultSet rs=null; Class.forName(driverclass); ...
</parameter><br/> <parameter><br/> <name>driverClassName</name><br/> <value>org.gjt.mm.mysql.Driver</value><br/> </parameter><br/> <parameter><br/> <name>url</name><br/> <value>jdbc:mysql://localhost/...
- Loaded JDBC driver: com.mysql.jdbc.Driver - Root WebApplicationContext: initialization completed in 1734 ms - Parsing configuration file [struts-default.xml] - Parsing configuration file [struts-...
<parameter><br/> <name>driverClassName</name><br/> <value>org.gjt.mm.mysql.Driver</value><br/> </parameter><br/> <parameter><br/> <name>url</name><br/> <value>jdbc:mysql://localhost/Pagination?...
<property name="url" value="${database.url}"> ${database.username}"> ${database.password}"> class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> $...