Question: Assignment - 2 I want A java program for this assignment 2 2 3 C C S , Group Number : Student ID: q ,

Assignment-2
I want A java program for this assignment
223CCS, Group Number :
Student ID: q,
Write a JDBC program with DataSource Name "Alnasser"
Create a table "Players" with following fields
Player_ID Integer
First_Name String
Last_Name String
Age Integer
Insert the following records into the table
Player_ID FirstName LastName Age
\table[[100,Ahmed,Khalid,19],[101,Ali,Saeed,23],[102,Yasser,Saleh,19]]
Display all the records
Display records with only Player_ID whoes age is greater than 20
Update the age of Player_ID 102 as 24
Display all the records
Delete the record with age 19
Display all the records
Program:
Output:
 Assignment-2 I want A java program for this assignment 223CCS, Group

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!