Scribd
Upload
12 views2 pages

Adv Java Internal Sets

The document outlines a series of tasks to be performed using JDBC applications, including creating and manipulating a Student table with various operations such as insertion, updating, and deletion of records using both Statement and Prepared Statement objects. It also includes tasks related to stored procedures for employee records, demonstrating Scrollable and Updatable Result Set functionalities, and testing servlets and JSP files for web applications. Additionally, it covers state management techniques using Cookies, HttpSession, and URL Rewriting.

Uploaded by

raja kondaveti
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
12 views2 pages

Adv Java Internal Sets

The document outlines a series of tasks to be performed using JDBC applications, including creating and manipulating a Student table with various operations such as insertion, updating, and deletion of records using both Statement and Prepared Statement objects. It also includes tasks related to stored procedures for employee records, demonstrating Scrollable and Updatable Result Set functionalities, and testing servlets and JSP files for web applications. Additionally, it covers state management techniques using Cookies, HttpSession, and URL Rewriting.

Uploaded by

raja kondaveti
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1. Write a JDBC application which will interact with Database and perform the following task.

a. Create Student Table with Roll No, Name, and Address field and insert few records.
b. Using Statement Object display the content of Record.
c. Using Statement Object Insert Two Record.
d. Using Statement Object Update One Record.
e. Using Statement Object Delete One Record.
f. Using Statement Object display the content of Record.

2. Write JDBC applications which will interact with Database and perform the following task.
a. Create Student Table with Roll No, Name, and Address field and insert few records.
b. Using Prepared Statement Object display the content of Record.
c. Using Prepared Statement Object Insert Two Record.
d. Using Prepared Statement Object Update One Record.
e. Using Prepared Statement Object Delete One Record.
f. Using Prepared Statement Object display the content of Record

3. Write a JDBC application which will interact with Database and perform the following task.
a. Create a store procedure which will insert one record into employee table.
b. Create a store procedure which will retrieve salary forgiven employee id.
c. Write a java application which will call the above procedure and display appropriate
information on screen.

4. Design a JDBC application which will demonstrate Scrollable Result Set functionality.

5. Design JDBC applications which will demonstrate Updatable Result Set functionality.

6. Write down the Program for testing the Servlet and study deployment descriptor.

7. Write down the program for testing the include action for servlet collaboration.
8. Create login form and perform state management using Cookies, HttpSession and
URL Rewriting.

9. Write down the Program which displays the simple JSP file

10. Write down the program in which input the two numbers in an html file and then
display the addition in JSP file.

11. Perform Database Access through JSP.

You might also like