how to parse below xml in java

_infels

New Member
I have my xml as ,\[code\]<staff> <staffId>S008</staffId> <lastname>abc</lastname> <salary>100000</salary></staff><staff> <staffId>S005</staffId> <lastname>pqr</lastname> <salary>200000</salary></staff><staff> <staffId>S003</staffId> <lastname>zzz</lastname> <salary>150000</salary></staff>\[/code\]Now I have table in which I have two columns STAFFID,XMLDATA.I am succeeded in popualting STAFFID column by parsing above xml.But in XMLDATA column I want to store like,for staffId - S008\[code\]<staff> <staffId>S008</staffId> <lastname>mook kim</lastname> <nickname>mkyong</nickname> <salary>100000</salary></staff>\[/code\]for staffId - S005\[code\]<staff> <staffId>S005</staffId> <lastname>yin fong</lastname> <nickname>fong fong</nickname> <salary>200000</salary></staff>\[/code\]for staffId - S003\[code\]<staff> <staffId>S003</staffId> <lastname>zzz</lastname> <salary>150000</salary></staff>\[/code\]Can anybody tell me how I can do this ?Thanks.
 
Back
Top