I have tried to use to java api prepared statement example which relates to coffee sales.
Ideally I would like to make a method that passes enough arguments into the SQL to populate a full row. Basically like my code that I have put in the top code box which populates the entire database row with fixed data but by using passed arguments instead.
The ability to create a method which updates the 'AssignedEngineer' field within the database table for a particular 'faultno' with the new assigned engineer submitted by the engineer is my main aim.
Once I have one example I will be able to copy and modify the method signatures to update the other fields.
Thankyou very much for the help so far.
I appreciate it