[Link].
(Computer Science and Engineering)
Semester-VI
Subject: Advance Programming in Java (BCO037B) Marks: 64
Instructions:
• Answer all questions.
• All questions carry equal marks.
• Write answers neatly and clearly.
• Marks will be awarded for both correctness and clarity of explanation.
Assignment #1
Section A (5*2=10 marks)
1. What is JDBC?
2. Explain the JDBC Architecture.
3. Difference between JDBC and ODBC.
4. Use of executeBatch method
5. What are the steps for connecting to Database with java application or programme?
Section B (7x3=21Marks)
1. Explain Java GUI. Why it is important in Software development?
2. How do the DriverManager and Driver interfaces work together to establish a database
connection in Java? Provide a step-by-step explanation of the process.
3. Discuss the role of prepared statements and callable statements in JDBC.
Section C (11x3=33Marks)
1. Write a Java program that demonstrates how jdbc is used to connect with a relational
database, also insert new records and update existing records in a table using prepared
statement. Include error handling and resource cleanup in your code.
2. What are the key components of a Java GUI application? Explain the role of containers
and components in GUI design.
3. Discuss the various types of JDBC drivers (Type 1, Type 2, Type 3, and Type 4) and their
advantages and disadvantages. Give examples of situations where each type of driver would
be most suitable.