complex xml parsing and storing in database

Ads
 

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

Did You get the answer.

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 file in jsp
parsing xml file in jsp  example that pars XML file in JSP
parsing xml with jquery
parsing xml with jquery  Please explain how to parse a xml file into jquery. Thanks
storing csv into oracle database
storing csv into oracle database  i want jsp code for storing csv file into oracle database
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
parsing xml file using java code
parsing xml file using java code  parsing a xml file using java code
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
to fetch data from ms word and storing into database
to fetch data from ms word and storing into database  i want to know how to fetch datafields from ms word and storing into database??? please answer soon .its urgent
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
Store XML file into Sqlserver Database
Store XML file into Sqlserver Database  Code for storing a typical XML file into SQl server database in 1 or more tables using asp.net using C
Produces XML file but format not correct for storing data using JSP and XML
Produces XML file but format not correct for storing data using JSP and XML  hii I have created a project using JSP and XML as database to store data entered by user in XML file ,It stores data entered in XML file
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
storing records which of a file into a table of mssql database
storing records which of a file into a table of mssql database  I have a requirement like this, A file contains some records with headers same as column names of a table. I have to store those records into a table
getting problem in storing & retrieving value in database
getting problem in storing & retrieving value in database  Hello everyone i am doing a project where my back end is ms access & i want to store value like 5353250214 so if i store it as long int in access it wont take it &
How to convert XML file to database ?
How to convert XML file to database ?  How to convert XML file to database
storing details in database on clicking submit button - JSP-Servlet
storing details in database on clicking submit button  I am using JSP in NetBeans and have developed an application form which has fileds naming... database on clicking submit button. I am unable to do this.Can u tell me how to code
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

Ads