Create database name using your student ID (small letter) Eg: ca18127 2. Create table name ca12321users contain 4 field as below a. ca18127id b. ca18127name c. ca18127gender d. ca18127age

1. Create JAVA project in Netbean using your student ID number (Eg: CA18127) as name of the project. Setup JAVA connector for the project. 2. Setup JDBC driver and test the connection of your project to MYSQL database.

Create 4 Class including Main I. TestdbConnectionClass Set and validate connection to database [5 Marks] II. InsertTodbclass Inserting data to database [5 Marks] III. QueryFromdb Query data from database [5 Marks] IV. MainClass calling method from all classes to check, insert and query from/to database base on instruction in Question 4, Question 5, Question 6. [3 Marks] (Class in I to III must have try, catch statement for SQLException) 4. Using SQL in JAVA, Insert name, gender and age of at least 5 users to database including male and female with various age between 10 to 40 years old. [3 Marks] 5. Using SQL in JAVA, Query name, gender and age of users under 20 years old. [3 Marks] 6. Using SQL in JAVA, Query name, gender and age of female user.

u can solve some its ok specillay 1st and 2nd qustion its important