I have 3 tables 1)Problem 2)CategoryDefinition 3)SubCategoryDefinition below
Problem
PROBLEMID
CATEGORYID
SUBCATEGORYID
CategoryDefinition
CATEGORYID
CATEGORYNAME
SubCategoryDefinition
SUBCATEGORYID
SUBCATEGORYNAME
Requirement: My Input to the Query is PROBLEMID and the actual requirement is,I need to update CATEGORYNAME AND SUBCATEGORYNAME For that what i have done is In java JDBC executed below queries
1)select CATEGORYID,SUBCATEGORYID from Problem where PROBLEMID=?
2)UPDATE CategoryDefinition SET CATEGORYNAME=? WHERE CATEGORYID=?
3)UPDATE SubCategoryDefinitioN SET SUBCATEGORYNAME=? WHERE SUBCATEGORYID=?
I am able to update CategoryName and Subcategoryname fields related to CATEGORYID and SUBCATEGORYID in database(those update values are reflecting database)
But when comes to User(when we click on problem tab in webpage) Interface these fields are not updating related to PROBLEMID
Could any one help?
Aucun commentaire:
Enregistrer un commentaire