JDBC -DAY 13
JDBC, which stands for Java Database Connectivity, is a Java API (Application Programming Interface) that allows Java programs to interact with databases. It provides a standard interface for connecting to relational databases, executing SQL queries, and retrieving results.
Here's an overview of key concepts and functionalities in JDBC:
Driver Manager: The DriverManager class is responsible for managing a list of database drivers. It helps in establishing a connection to the database by selecting an appropriate driver from the available set of drivers.
JDBC Drivers: JDBC drivers are categorized into four types:
Type 1: JDBC-ODBC bridge driver
Type 2: Native API driver
Type 3: Network Protocol driver
Type 4: Thin driver (pure Java driver)
Connection: The Connection interface represents a connection to the database. It is obtained using the DriverManager class. Connections are used to create Statement, PreparedStatement, and CallableStatement objects.
Statement: The Statement interface is used to execute SQL queries and retrieve results. There are three types of Statement objects:
Statement: Used for executing simple SQL queries.
PreparedStatement: Used for executing parameterized SQL queries.
CallableStatement: Used for executing stored procedures.
ResultSet: The ResultSet interface represents the result set of a SQL query. It provides methods to traverse through the rows and retrieve column values.
SQL Exception Handling: JDBC methods can throw SQLException, which needs to be handled appropriately in Java programs.