/* * Copyright (c) 1998, 2018, Oracle and/or its affiliates. All rights reserved. * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * * This code is free software; you can redistribute it and/or modify it * under the terms of the GNU General Public License version 2 only, as * published by the Free Software Foundation. Oracle designates this * particular file as subject to the "Classpath" exception as provided * by Oracle in the LICENSE file that accompanied this code. * * This code is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License * version 2 for more details (a copy is included in the LICENSE file that * accompanied this code). * * You should have received a copy of the GNU General Public License version * 2 along with this work; if not, write to the Free Software Foundation, * Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA. * * Please contact Oracle, 500 Oracle Parkway, Redwood Shores, CA 94065 USA * or visit www.oracle.com if you need additional information or have any * questions. */ /** * * Provides the API for accessing and processing data stored in a * data source (usually a relational database) using the * Java™ programming language. * This API includes a framework whereby different * drivers can be installed dynamically to access different data sources. * Although the JDBC™ API is mainly geared * to passing SQL statements to a database, it provides for reading and * writing data from any data source with a tabular format. * The reader/writer facility, available through the * javax.sql.RowSet group of interfaces, can be customized to * use and update data from a spread sheet, flat file, or any other tabular * data source. * *

What the JDBC™ 4.3 API Includes

* The JDBC™ 4.3 API includes both * the java.sql package, referred to as the JDBC core API, * and the javax.sql package, referred to as the JDBC Optional * Package API. This complete JDBC API * is included in the Java™ Standard Edition (Java SE™), version 7. * The javax.sql package extends the functionality of the JDBC API * from a client-side API to a server-side API, and it is an essential part * of the Java™ Enterprise Edition * (Java EE™) technology. * *

Versions

* The JDBC 4.3 API incorporates all of the previous JDBC API versions: * *

* Classes, interfaces, methods, fields, constructors, and exceptions * have the following "since" tags that indicate when they were introduced * into the Java platform. When these "since" tags are used in * Javadoc™ comments for the JDBC API, * they indicate the following: *

*

* NOTE: Many of the new features are optional; consequently, there is * some variation in drivers and the features they support. Always * check your driver's documentation to see whether it supports a feature before * you try to use it. *

* NOTE: The class SQLPermission was added in the * Java™ 2 SDK, Standard Edition, * version 1.3 release. This class is used to prevent unauthorized * access to the logging stream associated with the DriverManager, * which may contain information such as table names, column data, and so on. * *

What the java.sql Package Contains

* The java.sql package contains API for the following: * * *

java.sql and javax.sql Features Introduced in the JDBC 4.3 API

* * *

java.sql and javax.sql Features Introduced in the JDBC 4.2 API

* * *

java.sql and javax.sql Features Introduced in the JDBC 4.1 API

* *

java.sql and javax.sql Features Introduced in the JDBC 4.0 API

* * * *

java.sql and javax.sql Features Introduced in the JDBC 3.0 API

* * *

java.sql Features Introduced in the JDBC 2.1 Core API

* * *

javax.sql Features Introduced in the JDBC 2.0 Optional * Package API

* * * *

Custom Mapping of UDTs

* A user-defined type (UDT) defined in SQL can be mapped to a class in the Java * programming language. An SQL structured type or an SQL DISTINCT * type are the UDTs that may be custom mapped. The following three * steps set up a custom mapping: *
    *
  1. Defining the SQL structured type or DISTINCT type in SQL *
  2. Defining the class in the Java programming language to which the * SQL UDT will be mapped. This class must implement the * SQLData interface. *
  3. Making an entry in a Connection object's type map * that contains two things: * *
*

* When these are in place for a UDT, calling the methods * ResultSet.getObject or CallableStatement.getObject * on that UDT will automatically retrieve the custom mapping for it. Also, the * PreparedStatement.setObject method will automatically map the * object back to its SQL type to store it in the data source. * *

Package Specification

* * * *

Related Documentation

* * */ package java.sql;