mercredi 6 mai 2015

Jdbc sqlserver update query

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