Develop an user interface that perform the following SQL operations : (i) Select (ii) Insert (iii) Update (iv) Delete

Practical - 4B




output:
run:
Thu Feb 02 00:11:39 IST 2017
Enter Your Choice :
1.Select
2.Insert
3.Update
4.Delete
5.Exit:
1
ID: 1, Name: karan
ID: 2, Name: vatsal
ID: 3, Name: jay
ID: 4, Name: s4
ID: 5, Name: s5
Enter Your Choice :
1.Select
2.Insert
3.Update
4.Delete
5.Exit:
2
Enter Id :
6
Enter Name :
gajjar
Inserted records into the table...
Enter Your Choice :
1.Select
2.Insert
3.Update
4.Delete
5.Exit:
1
ID: 1, Name: karan
ID: 2, Name: vatsal
ID: 3, Name: jay
ID: 4, Name: s4
ID: 5, Name: s5
ID: 6, Name: gajjar
Enter Your Choice :
1.Select
2.Insert
3.Update
4.Delete
5.Exit:
3
Enter Id to update :
5
Enter new name :
newname5
Enter Your Choice :
1.Select
2.Insert
3.Update
4.Delete
5.Exit:
1
ID: 1, Name: karan
ID: 2, Name: vatsal
ID: 3, Name: jay
ID: 4, Name: s4
ID: 5, Name: newname5
ID: 6, Name: gajjar
Enter Your Choice :
1.Select
2.Insert
3.Update
4.Delete
5.Exit:
4
Enter Id to delete :
5
Enter Your Choice :
1.Select
2.Insert
3.Update
4.Delete
5.Exit:
1
ID: 1, Name: karan
ID: 2, Name: vatsal
ID: 3, Name: jay
ID: 4, Name: s4
ID: 6, Name: gajjar
1.Select
2.Insert
3.Update
4.Delete
5.Exit:
1
ID: 1, Name: karan
ID: 2, Name: vatsal
ID: 3, Name: jay
ID: 4, Name: s4
ID: 6, Name: gajjar
Enter Your Choice :
1.Select
2.Insert
3.Update
4.Delete
5.Exit:
4
Enter Id to delete :
5
error !
Enter Your Choice :
1.Select
2.Insert
3.Update
4.Delete
5.Exit:
1
ID: 1, Name: karan
ID: 2, Name: vatsal
ID: 3, Name: jay
ID: 4, Name: s4
ID: 6, Name: gajjar
Enter Your Choice :
1.Select
2.Insert
3.Update
4.Delete
5.Exit:
3
Enter Id to update :
5
Enter new name :
kkk
error !
Enter Your Choice :
1.Select
2.Insert
3.Update
4.Delete
5.Exit:5