complex xml parsing and storing in database
Hi Experts ,i want to parse my xml document and store it in mysql database. This is my code. How to parse this complex data.
<?xml version="1.0"?>
<ZFLO_IDOC>
<IDOC BEGIN="1">
<EDI_DC40 SEGMENT="1">
<TABNAM>EDI_DC40</TABNAM>
<MANDT>800</MANDT>
<DOCNUM>0000000000557748</DOCNUM>
<DOCREL>620</DOCREL>
<STATUS>30</STATUS>
<DIRECT>1</DIRECT>
<OUTMOD>2</OUTMOD>
<IDOCTYP>ZFLO_IDOC</IDOCTYP>
<MESTYP>ZFLO_IDOC</MESTYP>
<STDMES>ZFLO_I</STDMES>
<SNDPOR>SAPDD5</SNDPOR>
<SNDPRT>LS</SNDPRT>
<SNDPRN>T90CLNT090</SNDPRN>
<RCVPOR>JIDOCPORT</RCVPOR>
<RCVPRT>LS</RCVPRT>
<RCVPRN>JAVAIDOC</RCVPRN>
<CREDAT>20100204</CREDAT>
<CRETIM>033500</CRETIM>
<SERIAL>20100130063646</SERIAL>
</EDI_DC40>
<Z1EDK01 SEGMENT="1">
<MANDT>800</MANDT>
<EXTID>0000000407</EXTID>
</Z1EDK01>
<E1EDK02 SEGMENT="1">
<QUALF>001</QUALF>
<BELNR>test</BELNR>
<DATUM>00000000</DATUM>
</E1EDK02>
<E1EDK02 SEGMENT="1">
<QUALF>002</QUALF>
<BELNR>0000008168</BELNR>
<DATUM>20090416</DATUM>
</E1EDK02>
<E1EDK14 SEGMENT="1">
<QUALF>008</QUALF>
<ORGID>3000</ORGID>
</E1EDK14>
<E1EDK14 SEGMENT="1">
<QUALF>012</QUALF>
<ORGID>TA</ORGID>
</E1EDK14>
<E1EDK14 SEGMENT="1">
<QUALF>016</QUALF>
<ORGID>3030</ORGID>
</E1EDK14>
<E1EDKA1 SEGMENT="1">
<PARVW>AG</PARVW>
<PARTN>0000003201</PARTN>
</E1EDKA1>
<E1EDKA1 SEGMENT="1">
<PARVW>WE</PARVW>
<PARTN>0000003201</PARTN>
</E1EDKA1>
<Z1EDK02 SEGMENT="1">
<QUALF>001</QUALF>
<FILRT> 0.000</FILRT>
</Z1EDK02>
<Z1EDK02 SEGMENT="1">
<QUALF>002</QUALF>
<FILRT> 9.771</FILRT>
</Z1EDK02>
<Z1EDK02 SEGMENT="1">
<QUALF>003</QUALF>
<FILRT> 9.090</FILRT>
</Z1EDK02>
<Z1EDP01 SEGMENT="1">
<POSEX>000010</POSEX>
<IDTNR>FG-01</IDTNR>
<KTEXT>fg-01</KTEXT>
<NETWR> 5000000.00</NETWR>
<CURCY>USD</CURCY>
<MENGE> 20000.000</MENGE>
<MENEE>ST</MENEE>
<WERKS>3000</WERKS>
<VSTEL>3000</VSTEL>
<OPQTY> 19985.000</OPQTY>
<FLAGM>s</FLAGM>
<Z1EDP20 SEGMENT="1">
<ETENR>0001</ETENR>
<MENGE> 20000.000</MENGE>
<ABFTZ>15.000</ABFTZ>
<LFIMG> 15.000</LFIMG>
<MENEE>ST</MENEE>
<Z1EDP03 SEGMENT="1">
<IDDAT>111</IDDAT>
<DATUM>20090427</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>112</IDDAT>
<DATUM>20091223</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>113</IDDAT>
<DATUM>20091222</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>114</IDDAT>
<DATUM>20091221</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>115</IDDAT>
<DATUM>20091222</DATUM>
</Z1EDP03>
</Z1EDP20>
<Z1EDP20 SEGMENT="1">
<ETENR>0002</ETENR>
<MENGE> 0.000</MENGE>
<ABFTZ>22.000</ABFTZ>
<LFIMG> 0.000</LFIMG>
<MENEE>ST</MENEE>
<Z1EDP03 SEGMENT="1">
<IDDAT>111</IDDAT>
<DATUM>20091223</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>112</IDDAT>
<DATUM>20091223</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>113</IDDAT>
<DATUM>20091222</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>114</IDDAT>
<DATUM>20091221</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>115</IDDAT>
<DATUM>20091222</DATUM>
</Z1EDP03>
</Z1EDP20>
</Z1EDP01>
<Z1EDP01 SEGMENT="1">
<POSEX>000020</POSEX>
<IDTNR>FG-88</IDTNR>
<KTEXT>Flatscreen LE 50 P</KTEXT>
<NETWR> 0.00</NETWR>
<CURCY>USD</CURCY>
<MENGE> 1000.000</MENGE>
<MENEE>ST</MENEE>
<WERKS>3000</WERKS>
<VSTEL>3000</VSTEL>
<OPQTY> 1000.000</OPQTY>
<FLAGM>s</FLAGM>
<Z1EDP20 SEGMENT="1">
<ETENR>0001</ETENR>
<MENGE> 1000.000</MENGE>
<ABFTZ> 0.000</ABFTZ>
<LFIMG> 0.000</LFIMG>
<MENEE>ST</MENEE>
<Z1EDP03 SEGMENT="1">
<IDDAT>111</IDDAT>
<DATUM>20090427</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>112</IDDAT>
<DATUM>20091223</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>113</IDDAT>
<DATUM>20091222</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>114</IDDAT>
<DATUM>20091221</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>115</IDDAT>
<DATUM>20091222</DATUM>
</Z1EDP03>
</Z1EDP20>
<Z1EDP20 SEGMENT="1">
<ETENR>0002</ETENR>
<MENGE> 0.000</MENGE>
<ABFTZ>87.000</ABFTZ>
<LFIMG> 0.000</LFIMG>
<MENEE>ST</MENEE>
<Z1EDP03 SEGMENT="1">
<IDDAT>111</IDDAT>
<DATUM>20091223</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>112</IDDAT>
<DATUM>20091223</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>113</IDDAT>
<DATUM>20091222</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>114</IDDAT>
<DATUM>20091221</DATUM>
</Z1EDP03>
<Z1EDP03 SEGMENT="1">
<IDDAT>115</IDDAT>
<DATUM>20091222</DATUM>
</Z1EDP03>
</Z1EDP20>
</Z1EDP01>
</IDOC>
</ZFLO_IDOC>
View Answers
August 14, 2012 at 10:32 AM
Ads
Related Tutorials/Questions & Answers:
complex xml parsing and storing in database - XML
complex xml parsing and
storing in database Hi Experts ,i want to parse my
xml document and store it in mysql
database. This is my code. How to parse this
complex data.
EDI_DC40
800
0000000000557748
XML parsing to Mysql database
XML parsing to Mysql database Can someone please post the code for
parsing an
XML file into Mysql
database using SAX
Advertisements
xml document parsing
xml document
parsing Hi Guys,
Xml document has been inserted into the
database,how do i parse the
xml document stored in
database,so that
xml document can be retrieved on to JSP file using jdbc/odbc connection.
Please help me
Xml parsing
Xml parsing Hi..i tried the above code but I unable to know where can i place the
xml file
xml parsing
xml parsing my task is when i wll give java file to a program that program interpret that file separate each and every keywords and indentifiers...
xml.. please anyone of you give some idea
parsing xml using sax
parsing xml using sax how to get values if the root elements are same and their attributes are different
Uploading a Software and storing in the database
Uploading a Software and
storing in the database I want to upload a software(may be of maximum 20mb) through JSP, and store it in the
database.
The coding present in the site for uploading and
storing in the
database
Truncating issue while parsing XML with SAX Parser.
Truncating issue while
parsing XML with SAX Parser. I am
Parsing one
xml file and after
parsing I have to enter the data into the
database using hibernate. The problem is while
parsing some elements, its not getting the complete
problems in parsing the xml with the special characters
problems in
parsing the
xml with the special characters Hi,
I have a problem, in while
parsing the
xml with special characters apstrophe('). I am... parse this string in
xml path. i am not able to fetch the adam's string in the
xml
XML Parsing from php web server in J2ME
XML Parsing from php web server in J2ME Hello Team,
You gave some tips for
XML parsing in java, i need some additional tips for
xml parsing from php web server in j2me...
Thanks and Regards
Alagu
XML Parsing Using Sax Parser in J2ME for serverside
XML Parsing Using Sax Parser in J2ME for serverside Hai team,
i have doubt in
Parsing using sax parser in serverside plz help me for
xml parsing in j2me using sax parser on server side
thanks in advance...
regards
Selva
Problem facing in SAX Parsing - XML
Problem facing in SAX Parsing I have facing the issue in SAX
Parsing like i have got the
xml and the
xml structure is like below... can find the above
xml there is no CountryCode in the second record and 4th
XML Parsing Using Sax Parser in J2ME
XML Parsing Using Sax Parser in J2ME Hai team,
I hope you, You should help me, I have trouble in
Xml parsing...
I have decoded value, what... to do
xml parsing help me for that...
Regards
Alagu
Read Complex XML using DOM/SAX Parser.
Read
Complex XML using DOM/SAX Parser. I have a
XML file which is having two types of Items. I want to extract all details of a type only. My
XML goes something like this
<Movie>
<Bollywood>
<Actor>
Shah Rukh
getting and storing dropdown list in database in jsp
getting and
storing dropdown list in
database in jsp i have a drop down list to select book from
database. i'm able to retrieve dropdown list from... lyk this. but it
storing null value in the
database. :\
what to do
Question about parsing XML document with DOM in JAVA.
Question about
parsing XML document with DOM in JAVA. Hi, I need to parse a
XML file witch has info about classes. So i have for each class to have... it with multiple for loops, one iside the other but it doesnt work. My
XML is this below
database data in xml format
database data in
xml format HI,
i want to display the
database data in the
xml format(not as
xml file ) on the console using DOM. help will be appreciated.
THANKS
K.K
Storing records of a file inside database table in java
Storing records of a file inside
database table in java Here is my requirement,
I have a file which contains some number of records like... the records inside the
database except headings (Here sid,sname,age are headings
How to implement xml parsing in iphone ? -RV
How to implement
xml parsing in iphone ? -RV In .h file
@interface RootViewController : UITableViewController<NSXMLParserDelegate>{
IBOutlet UITableView *page1;
NSMutableArray *titlearray
retrieving xml document from database
retrieving
xml document from database Hi Guys,
I want to retrieve the
xml document stored in the
database on to a jsp page using jdbc/odbc connnection.Please help me in implementing this feature.
Thank You
Madhu