Java Programming-SET 3 JDBC

 

JDBC Program

create table

Insert Record 

Select Query 

Write a Java Program to delete details of students whoseinitial character of their name is ‘A’.

Write a JDBC Program to Insert the record into patient table(Use prepared statement)

Write JDBC application to display department wise list ofemployees. Accept dno, dname from user assume suitable data.

 Create JDBC application for product table with fields Id, name & price perform insert operation & display inserted data retrieved from table to the user.

Write a JDBC program to updatethe Doctor (dno, dname, city) information. Update city from ‘Pune’ to ‘Mumbai.

Write a JDBC program to accept rollno from the user and deletea record from student table and display all record after deleting.

Write a JDBC program to accept employee no from the user andupdate an employee record in employee table and display all record ,

Write a JDBC program to insert a record in student table  (rollno,name,course, percentage) and display all records of student table.

Join Query