The java.sql package provides classes and interfaces for connecting Java applications with relational databases. It is a core Java package used to perform database operations such as inserting, updating, deleting, and retrieving data. It provides the JDBC (Java Database Connectivity) API for communicating with databases. The package contains important interfaces such as Connection, Statement, PreparedStatement, and ResultSet. It also provides classes such as DriverManager, Date, Time, and Timestamp for database-related operations. Using java.sql, Java programs can execute SQL queries and process the results returned by a database. It forms the basic foundation for database connectivity in Java applications.
Interfaces of java.sql
| Interface |
Description |
Connection |
Represents a connection between a Java application and a database. |
Statement |
Used to execute simple SQL statements against a database. |
PreparedStatement |
Used to execute precompiled SQL statements with parameters. |
CallableStatement |
Used to execute stored procedures in a database. |
ResultSet |
Represents the data returned by executing a SQL query. |
ResultSetMetaData |
Provides information about the columns of a ResultSet. |
DatabaseMetaData |
Provides information about the database, driver, tables, and supported features. |
SQLData |
Allows Java classes to represent SQL user-defined types. |
SQLInput |
Provides methods for reading SQL structured or distinct types. |
SQLOutput |
Provides methods for writing SQL structured or distinct types. |
Savepoint |
Represents a point within a transaction to which the transaction can be rolled back. |
Wrapper |
Provides methods for accessing an object that implements a specific interface. |
Driver |
Defines methods that database drivers must implement to communicate with a database. |
| |
|
Classes of java.sql
| Class |
Description |
DriverManager |
Manages JDBC drivers and provides methods for establishing database connections. |
Date |
Represents a SQL DATE value. |
Time |
Represents a SQL TIME value. |
Timestamp |
Represents a SQL TIMESTAMP value. |
Types |
Contains constants representing SQL data types. |
SQLException |
Represents an exception that occurs during database operations. |
SQLWarning |
Represents warnings related to database access. |
Blob |
Represents a SQL Binary Large Object (BLOB). |
Clob |
Represents a SQL Character Large Object (CLOB). |
SQLXML |
Represents an SQL XML value. |
Array |
Represents an SQL array value. |
Ref |
Represents a reference to an SQL structured type. |
Struct |
Represents an SQL structured type. |
DriverPropertyInfo |
Provides information about properties supported by a JDBC driver. |
BatchUpdateException |
Represents an exception occurring during a batch update operation. |
SQLClientInfoException |
Represents an error while setting or retrieving client information. |
SQLFeatureNotSupportedException |
Indicates that a JDBC feature is not supported by the driver. |
