BCA Semester 6 – Advanced Java Programming – Unit 2: Database Programming (7Hrs)

Question 1

How do you execute SQL statements using JDBC? Explain with an example.

Marks: 5

Year: 2021 Final TU FOHSS

Executing SQL Statements Using JDBC Definition JDBC (Java Database Connectivity) is an API that allows Java programs to connect to a database and execute SQL statements such as SELECT, INSERT, UPDATE

Question 2

Compare result set with row set. Explain a prepared statement with an example.

Marks: 5

Year: 2021 Final TU FOHSS

1. Difference Between ResultSet and RowSet Definition - ResultSet: An object that holds data retrieved from a database after executing a SQL SELECT query. - RowSet: A JavaBean component that represen

Question 3

How the data can be accessed through a resultset object? Explain forward only, scroll-insensitive and scroll-sensitive resultsets.

Marks: 5

Year: 2022 Final TU FOHSS

Accessing Data Through a ResultSet Definition A ResultSet object in JDBC holds the data retrieved from a database after executing a SELECT query. It provides methods to read and navigate through th

Question 4

What is the use of RowSet interface? Explain connected and disconnected rowsets.

Marks: 5

Year: 2023 Final TU FOHSS

Use of RowSet Interface Definition The RowSet interface is a part of JDBC that represents a set of rows from a database in a more flexible and user-friendly way than ResultSet. It is a JavaBean com

Question 5

Explain JDBC architecture. Write a program to insert three records into a table Item which is in the database Shop and contains the columns ItemID, Name, UnitPrice, Units and ExpiryDate.

Marks: 10

Year: 2023 Final TU FOHSS

JDBC Architecture Definition JDBC (Java Database Connectivity) is an API that allows Java programs to connect to a database, execute SQL statements, and retrieve results. --- Components of JDBC Arch

Question 6

What is the use of PreparedStatement? Differentiate between Statement and PreparedStatement.

Marks: 5

Year: 2024 Final TU FOHSS

PreparedStatement in Java Definition: PreparedStatement is a precompiled SQL statement in JDBC that allows you to execute parameterized queries. It is used to improve performance, security, and read

Question 7

Why do we need to use layout managers in GUI programming? Write a program to create a GUI form that takes data about a customer including cid, name, address, email and age and insert these data into t

Marks: 10

Year: 2024 Final TU FOHSS

Importance of Layout Managers in Java GUI Definition: A layout manager is an object that controls the size and position of components inside a container (like JFrame or JPanel) automatically. Why La