JAVA DATABASE CONNECTIVITY

Improved performance

Platform independence

Easy integration with databases

All of the above

Statement

ResultSet

Connection

DriverManager

executeQuery()

executeUpdate()

execute()

executeBatch()

Create, Retrieve, Update, Delete

Connect, Retrieve, Update, Disconnect

Compile, Run, Update, Debug

Collect, Register, Update, Delete

Using the next() method

Using the get() methods

Using the fetch() method

Using the retrieve() method

INSERT INTO

UPDATE

SELECT

CREATE

To improve performance by precompiling SQL statements

To handle SQL exceptions

To retrieve data from the database

To create database tables

It provides metadata about the ResultSet object, such as column names and types.

It executes SQL statements.

It establishes a connection with the database.

It retrieves data from the database.

Type 1

Type 2

Type 3

Type 4

Using the commit() method

Using the rollback() method

Using the setAutoCommit() method

All of the above