MySQL Connector/J Developer's Guide
Abstract
This manual describes how to install, configure, and develop
database applications using MySQL Connector/J, the JDBC driver for
communicating with MySQL servers.
For release notes detailing the changes in each release of
Connector/J, see MySQL Connector/J Release Notes
(http://dev.mysql.com/doc/relnotes/connector-j/en/).
Document generated on: 2013-01-25 (revision: 34037)
_______________________________________________________
Preface and Legal Notices
This manual describes how to install, configure, and develop
database applications using MySQL Connector/J, the JDBC driver for
communicating with MySQL servers.
Legal Notices
Copyright (c) 1997, 2013, Oracle and/or its affiliates. All rights
reserved.
This software and related documentation are provided under a
license agreement containing restrictions on use and disclosure
and are protected by intellectual property laws. Except as
expressly permitted in your license agreement or allowed by law,
you may not use, copy, reproduce, translate, broadcast, modify,
license, transmit, distribute, exhibit, perform, publish, or
display any part, in any form, or by any means. Reverse
engineering, disassembly, or decompilation of this software,
unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without
notice and is not warranted to be error-free. If you find any
errors, please report them to us in writing.
If this software or related documentation is delivered to the U.S.
Government or anyone licensing it on behalf of the U.S.
Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related
documentation and technical data delivered to U.S. Government
customers are "commercial computer software" or "commercial
technical data" pursuant to the applicable Federal Acquisition
Regulation and agency-specific supplemental regulations. As such,
the use, duplication, disclosure, modification, and adaptation
shall be subject to the restrictions and license terms set forth
in the applicable Government contract, and, to the extent
applicable by the terms of the Government contract, the additional
rights set forth in FAR 52.227-19, Commercial Computer Software
License (December 2007). Oracle USA, Inc., 500 Oracle Parkway,
Redwood City, CA 94065.
This software is developed for general use in a variety of
information management applications. It is not developed or
intended for use in any inherently dangerous applications,
including applications which may create a risk of personal injury.
If you use this software in dangerous applications, then you shall
be responsible to take all appropriate fail-safe, backup,
redundancy, and other measures to ensure the safe use of this
software. Oracle Corporation and its affiliates disclaim any
liability for any damages caused by use of this software in
dangerous applications.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. MySQL is a trademark of Oracle Corporation and/or its
affiliates, and shall not be used without Oracle's express written
authorization. Other names may be trademarks of their respective
owners.
This software and documentation may provide access to or
information on content, products, and services from third parties.
Oracle Corporation and its affiliates are not responsible for and
expressly disclaim all warranties of any kind with respect to
third-party content, products, and services. Oracle Corporation
and its affiliates will not be responsible for any loss, costs, or
damages incurred due to your access to or use of third-party
content, products, or services.
This document in any form, software or printed matter, contains
proprietary information that is the exclusive property of Oracle.
Your access to and use of this material is subject to the terms
and conditions of your Oracle Software License and Service
Agreement, which has been executed and with which you agree to
comply. This document and information contained herein may not be
disclosed, copied, reproduced, or distributed to anyone outside
Oracle without prior written consent of Oracle or as specifically
provided below. This document is not part of your license
agreement nor can it be incorporated into any contractual
agreement with Oracle or its subsidiaries or affiliates.
This documentation is NOT distributed under a GPL license. Use of
this documentation is subject to the following terms:
You may create a printed copy of this documentation solely for
your own personal use. Conversion to other formats is allowed as
long as the actual content is not altered or edited in any way.
You shall not publish or distribute this documentation in any form
or on any media, except if you distribute the documentation in a
manner similar to how Oracle disseminates it (that is,
electronically for download on a Web site with the software) or on
a CD-ROM or similar medium, provided however that the
documentation is disseminated together with the software on the
same medium. Any other use, such as any dissemination of printed
copies or use of this documentation, in whole or in part, in
another publication, requires the prior written consent from an
authorized representative of Oracle. Oracle and/or its affiliates
reserve any and all rights to this documentation not expressly
granted above.
For more information on the terms of this license, or for details
on how the MySQL documentation is built and produced, please visit
MySQL Contact & Questions (http://dev.mysql.com/contact/).
For additional licensing information, including licenses for
third-party libraries used by MySQL products, see "Preface and
Legal Notices."
For help with using MySQL, please visit either the MySQL Forums
(http://forums.mysql.com) or MySQL Mailing Lists
(http://lists.mysql.com) where you can discuss your issues with
other MySQL users.
For additional documentation on MySQL products, including
translations of the documentation into other languages, and
downloadable versions in variety of formats, including HTML and
PDF formats, see the MySQL Documentation Library
(http://dev.mysql.com/doc).
Chapter 1. MySQL Connector/J
This section explains how to configure and develop Java
applications with MySQL Connector/J, the JDBC driver that is
integrated with MySQL.
For release notes detailing the changes in each release of
Connector/J, see MySQL Connector/J Release Notes
(http://dev.mysql.com/doc/relnotes/connector-j/en/).
Chapter 2. Connector/J Versions
There are currently four versions of MySQL Connector/J available:
* Connector/J 5.1 is the Type 4 pure Java JDBC driver, which
conforms to the JDBC 3.0 and JDBC 4.0 specifications. It
provides compatibility with all the functionality of MySQL,
including 4.1, 5.0, 5.1, 5.4 and 5.5. Connector/J 5.1 provides
ease of development features, including auto-registration with
the Driver Manager, standardized validity checks, categorized
SQLExceptions, support for the JDBC-4.0 XML processing, per
connection client information, NCHAR
(http://dev.mysql.com/doc/refman/5.5/en/char.html), NVARCHAR
(http://dev.mysql.com/doc/refman/5.5/en/char.html) and NCLOB
types. This release also includes all bug fixes up to and
including Connector/J 5.0.6.
* Connector/J 5.0 provides support for all the functionality
offered by Connector/J 3.1 a
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
JDBC概念: Java DataBase Connectivity,Java数据库连接,也就是用Java语言操作数据库。 JDBC本质:是官方定义的一套操作所有关系型数据库的规则,即接口。各个数据库厂商去实现这套接口,提供数据库驱动 jar 包。我们可以使用这套接口(JDBC)编程,真正执行的代码是驱动 jar 包中的实现类。 JDBC编程六步 1.注册驱动(通知java程序我们即将要连接的是那个品牌的数据库) 2.获取数据库连接(java进程和mysql进程,两个进程之间的通道开启了)(java进程可能在北京,mysql进程在上海) 3.获取数据库操作对象 这个对象很重要,用这个对象执行SQL 4.执行SQL语句,执行CRUD操作 5.处理查询结果集(如果第四步是select语句,才有第五步) 6.释放资源 关闭所有的资源(因为JDBC是进程之间的通信,占用很多资源,需要关闭) 注意:如果连接的是oracle数据库,你需要从网上下载Oracle的jar包,mysql-connector-java-5.1.23-bin.jar 这个jar包有一个专业的术语:mysql
资源详情
资源评论
资源推荐
收起资源包目录
JDBC驱动jar包 5.1.23版本 (279个子文件)
CHANGES 210KB
COPYING 18KB
tb2-data.txt.gz 232KB
connector-j.html 395KB
mysql-connector-java-5.1.23-bin.jar 823KB
c3p0-0.9.1-pre6.jar 519KB
ant-contrib.jar 190KB
jboss-common-jdbc-wrapper.jar 49KB
jboss-common-jdbc-wrapper-src.jar 35KB
slf4j-api-1.6.1.jar 25KB
DatabaseMetaData.java 264KB
ResultSetImpl.java 240KB
StatementRegressionTest.java 188KB
MysqlIO.java 180KB
ConnectionImpl.java 175KB
PreparedStatement.java 164KB
ConnectionPropertiesImpl.java 160KB
ResultSetRegressionTest.java 143KB
ConnectionRegressionTest.java 137KB
MetaDataRegressionTest.java 108KB
MysqlErrorNumbers.java 107KB
StatementImpl.java 85KB
ServerPreparedStatement.java 85KB
UpdatableResultSet.java 79KB
CallableStatement.java 75KB
CallableStatementWrapper.java 73KB
LoadBalancedMySQLConnection.java 72KB
ConnectionWrapper.java 72KB
ReplicationConnection.java 69KB
DatabaseMetaDataUsingInfoSchema.java 63KB
ConnectionTest.java 61KB
TimeUtil.java 58KB
StatementsTest.java 57KB
CallableStatementRegressionTest.java 57KB
StringUtils.java 51KB
CharsetMapping.java 51KB
SQLError.java 49KB
ResultSetRow.java 44KB
ConnectionProperties.java 37KB
PreparedStatementWrapper.java 34KB
JDBC4CallableStatementWrapper.java 32KB
LoadBalancingConnectionProxy.java 32KB
BaseTestCase.java 29KB
MetadataTest.java 29KB
NonRegisteringDriver.java 28KB
Field.java 28KB
StringRegressionTest.java 28KB
SyntaxRegressionTest.java 27KB
JDBC4MysqlSQLXML.java 27KB
StatementsTest.java 27KB
ResultSetMetaData.java 22KB
EscapeProcessor.java 22KB
MysqlXAConnection.java 21KB
StatementWrapper.java 21KB
BufferRow.java 20KB
JDBC4UpdatableResultSet.java 20KB
BlobFromLocator.java 18KB
JDBC4ResultSet.java 18KB
JDBC4PreparedStatementWrapper.java 17KB
Buffer.java 17KB
CharsetTests.java 17KB
Util.java 16KB
MysqlDefs.java 16KB
DataSourceRegressionTest.java 16KB
MicroPerformanceRegressionTest.java 14KB
DateTest.java 14KB
StandardSocketFactory.java 14KB
Connection.java 14KB
CallableStatementTest.java 13KB
XATest.java 13KB
PooledConnectionRegressionTest.java 13KB
UnreliableSocketFactory.java 13KB
Blob.java 13KB
ProfilerEvent.java 12KB
RowDataDynamic.java 12KB
RowDataCursor.java 12KB
LoadStorePerfTest.java 11KB
JDBC4ConnectionWrapper.java 11KB
ExportControlled.java 10KB
MysqlDataSource.java 10KB
BlobRegressionTest.java 10KB
UpdatabilityTest.java 9KB
Security.java 9KB
JDBC4DatabaseMetaData.java 9KB
ServerController.java 9KB
JDBC4Connection.java 9KB
SingleByteCharsetConverter.java 9KB
JDBC4CallableStatement.java 8KB
Clob.java 8KB
ByteArrayRow.java 8KB
ResultSetTest.java 8KB
ConnectionGroup.java 8KB
CompressedInputStream.java 8KB
NumbersRegressionTest.java 8KB
MysqlPooledConnection.java 8KB
BaseBugReport.java 8KB
StressRegressionTest.java 7KB
RetrievalPerfTest.java 7KB
Jdk14Logger.java 7KB
ReadAheadInputStream.java 7KB
共 279 条
- 1
- 2
- 3
码头整点儿薯条
- 粉丝: 4504
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0