Hey guys, i am facing a huge problem in my update form
Like when I click on 1101, it show the records of 1101 to be updated.
But when I click on 1102, it still show the 1101 record instead of 1102. Which mean whatever product I click on it will still be the same 1101 record
My servlets codes are:
I can think of a couple causes:
1) You shouldn't have the single quotes around the '?'. PreparedStatements take care of that for you and it could cause the database confusing.
2) Is there whitespace in the id in the database? If so, you'll need to call trim() in your SQL statement.
Also, does that query return no data for record 1001 as well or just 1002? The answer will narrow down the field of problems a bit.