Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

java netbeans database programming kindly solve the questions in JAVA ( netbeans if applicable ) with steps Part3: Database programming 13. You have connection object

java netbeans database programming
kindly solve the questions in JAVA ( netbeans if applicable ) with steps
image text in transcribed
image text in transcribed
Part3: Database programming 13. You have connection object with MySQL server called con. Give Java code to create statement and performs the following operations: Enjoy programming practice .... Good Luck a. Create table called Emp-data to include the fields of ID, name, salary of type double and B-date of type date. b. Insert into this table the data of employee which has name of "Mohamed Ibraheem" who has ID =1234, salary =1200.5 and his B-date " 12/12/1980. c. Update the person which ID=111 and modify his salary to be 18900.5. d. Get and display data of all records in this table. e. Delete the records for all records have salary less than 5000 . 14. You have connection object with MySQL server called con. Give Java code to create PreparedStatement and performs the following operations: a. Create table called Emp-data to include the fields of ID, name, salary of type double and B-date of type date. b. Give the program to Insert data of employee in a loop into this table until user input ID equal zero value. c. Give the program to display data of all records whom have salaries less than an input value. d. Move all records with salary less than certain given input value into another table called "Small emp".. The table has same structure as current one. e. Update all records with salary less than given input value, by given input for the new salary. f. Store the data in this table for each record except the date field in a RandomAaccessfile called "CiEmp data", Use fixed size for the name equal 30 characters. N.B. : The method String getFixedStrin(String str, int L) takes string str of variable size and return string with size L. g. Convert Data stored in the above RandomAccessfile into new Table called "newDara:. Create this table and take data from the file into the table, then delate the file

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases 28th British National Conference On Databases Bncod 28 Manchester Uk July 2011 Revised Selected Papers Lncs 7051

Authors: Alvaro A.A. Fernandes ,Alasdair J.G. Gray ,Khalid Belhajjame

2011th Edition

3642245765, 978-3642245763

Students also viewed these Databases questions