# Practical 4

1. Write a program to perform CRUD operation. [Source Code](https://github.com/sthsuyash/CSIT_Labs/blob/main/7th_Semester/Advanced%20Java%20Programming/Lab%20Codes/Lab/src/main/java/Practical4/Crud.java)
2. Write a program to perform CRUD operation using prepared statement. [Source Code](https://github.com/sthsuyash/CSIT_Labs/blob/main/7th_Semester/Advanced%20Java%20Programming/Lab%20Codes/Lab/src/main/java/Practical4/PreparedStatementCrud.java)
3. Demonstrate the use of row set and updatable and scrollable result set. [Source Code](https://github.com/sthsuyash/CSIT_Labs/blob/main/7th_Semester/Advanced%20Java%20Programming/Lab%20Codes/Lab/src/main/java/Practical4/RowSet.java)
4.  Create one complete form using swing (id username password, gender (radio button), course (check box), country (combo box), submit and reset button). validate the form (check for emptiness, password and should be equal) and insert the data into database using prepared statement. After this create a login form with fields username, password and submit button. if username and password matched with database record then display all the record of table using rowset or scrollable ad updateable result set. Also perform following operation:

    * Update the name of student to "sanu" and
    * course to "BCA"
    * whose id is 3.

    [Source Code](https://github.com/sthsuyash/CSIT_Labs/blob/main/7th_Semester/Advanced%20Java%20Programming/Lab%20Codes/Lab/src/main/java/Practical4/FormDemo.java)
