jdbc assignment beginners question solved and unsolved with solution or without

1. Implement
(a)Type 1 Driver and connect to the Oracle.
(B)Type2 Driver
(b)Type 3 Driver using IDS server and connect to mdb or oracle.
(c)Type 4 Driver and connect to Oracle and MySQL.

2. Implement Type-4 driver with
(a) Statement
(b) PreparedStatement
(c) CallableStatement

3. Use PreparedStatement to fetch results based on the some input taken from user inside a loop.

4. Use CallableStatement to call a stored procedure which takes empno and increment (salary) of that employee, as input, and returns the incremented salary as the output.

6. Write a program which takes input as the empno and salary.
a.) If the empno already exist and salary>2000, update the salary of the employee.
b.) If the empno doesn’t exist, ask for the all other column values in that table, retrieved using metadata programming.
c.) Insert empno and other values taken as input as part of (b.)
d.) If hiredate of employee is before year 1981, delete the record from the table.

7. Write a program to show use of all the methods for the Scrollable and Updatable ResultSets.

you will find solution on my next post