3
Reply

Store a typical xml file into database

Satyavani gudimetla

Satyavani gudimetla

Apr 23 2012 5:37 AM
2.5k
XML file is Like below.

<?xml version="1.0" ?>
  <!DOCTYPE PubmedArticleSet (View Source for full doctype...)>
- <PubmedArticleSet>
- <PubmedArticle>
- <MedlineCitation Owner="NLM" Status="In-Data-Review">
  <PMID Version="1">22500280</PMID>
- <DateCreated>
  <Year>2012</Year>
  <Month>04</Month>
  <Day>13</Day>
  </DateCreated>
- <Article PubModel="Print-Electronic">
- <Journal>
  <ISSN IssnType="Electronic">2093-6516</ISSN>
- <JournalIssue CitedMedium="Internet">
  <Volume>45</Volume>
  <Issue>2</Issue>
- <PubDate>
  <Year>2012</Year>
  <Month>Apr</Month>
  </PubDate>
  </JournalIssue>
  <Title>The Korean journal of thoracic and cardiovascular surgery</Title>
  <ISOAbbreviation>Korean J Thorac Cardiovasc Surg</ISOAbbreviation>
  </Journal>
  <ArticleTitle>Analysis.</ArticleTitle>
- <Pagination>
  <MedlinePgn>101-9</MedlinePgn>
  </Pagination>
- <Abstract>
  <AbstractText Label="BACKGROUND" NlmCategory="BACKGROUND">small cell lung cancer.</AbstractText>
  <AbstractText Label="MATERIALS AND METHODS" NlmCategory="METHODS"> molecular markers were selected.</AbstractText>
  <AbstractText Label="RESULTS" NlmCategory="RESULTS"> recurrence.</AbstractText>
  <AbstractText Label="CONCLUSION" NlmCategory="CONCLUSIONS"> disease-free survival.</AbstractText>
  </Abstract>
  <Affiliation>Korea.</Affiliation>
- <AuthorList CompleteYN="Y" Type="authors">
- <Author ValidYN="Y">
  <LastName>Cho</LastName>
  <ForeName>Sukki</ForeName>
  <Initials>S</Initials>
  </Author>
- <Author ValidYN="Y">
  <LastName>Park</LastName>
  <ForeName>Tae In</ForeName>
  <Initials>TI</Initials>
  </Author>
- <Author ValidYN="Y">
  <LastName>Lee</LastName>
  <ForeName>Eung-Bae</ForeName>
  <Initials>EB</Initials>
  </Author>
- <Author ValidYN="Y">
  <LastName>Son</LastName>
  <ForeName>Shin-Ah</ForeName>
  <Initials>SA</Initials>
  </Author>
  </AuthorList>
  <Language>eng</Language>
- <PublicationTypeList>
  <PublicationType>Journal Article</PublicationType>
  </PublicationTypeList>
- <ArticleDate DateType="Electronic">
  <Year>2012</Year>
  <Month>04</Month>
  <Day>03</Day>
  </ArticleDate>
  </Article>
- <MedlineJournalInfo>
  <Country>Korea (South)</Country>
  <MedlineTA>Korean J Thorac Cardiovasc Surg</MedlineTA>
  <NlmUniqueID>101563922</NlmUniqueID>
  <ISSNLinking>2233-601X</ISSNLinking>
  </MedlineJournalInfo>
  </MedlineCitation>
- <PubmedData>
- <History>
- <PubMedPubDate PubStatus="received">
  <Year>2011</Year>
  <Month>9</Month>
  <Day>09</Day>
  </PubMedPubDate>
- <PubMedPubDate PubStatus="revised">
  <Year>2011</Year>
  <Month>9</Month>
  <Day>28</Day>
  </PubMedPubDate>
- <PubMedPubDate PubStatus="accepted">
  <Year>2011</Year>
  <Month>10</Month>
  <Day>16</Day>
  </PubMedPubDate>
- <PubMedPubDate PubStatus="epublish">
  <Year>2012</Year>
  <Month>4</Month>
  <Day>03</Day>
  </PubMedPubDate>
- <PubMedPubDate PubStatus="entrez">
  <Year>2012</Year>
  <Month>4</Month>
  <Day>14</Day>
  <Hour>6</Hour>
  <Minute>0</Minute>
  </PubMedPubDate>
- <PubMedPubDate PubStatus="pubmed">
  <Year>2012</Year>
  <Month>4</Month>
  <Day>14</Day>
  <Hour>6</Hour>
  <Minute>0</Minute>
  </PubMedPubDate>
- <PubMedPubDate PubStatus="medline">
  <Year>2012</Year>
  <Month>4</Month>
  <Day>14</Day>
  <Hour>6</Hour>
  <Minute>0</Minute>
  </PubMedPubDate>
  </History>
  <PublicationStatus>ppublish</PublicationStatus>
- <ArticleIdList>
  <ArticleId IdType="doi">10.5090/kjtcs.2012.45.2.101</ArticleId>
  <ArticleId IdType="pubmed">22500280</ArticleId>
  </ArticleIdList>
  </PubmedData>
  </PubmedArticle>

<PubmedArticle>
    <MedlineCitation Owner="NLM" Status="In-Data-Review">
        <PMID Version="1">22518365</PMID>
        <DateCreated>
            <Year>2012</Year>
            <Month>04</Month>
            <Day>20</Day>
        </DateCreated>
        <Article PubModel="Print">
            <Journal>
                <ISSN IssnType="Print">1203-6765</ISSN>
                <JournalIssue CitedMedium="Print">
                    <Volume>17</Volume>
                    <Issue>1</Issue>
                    <PubDate>
                        <MedlineDate>2012 Jan-Feb</MedlineDate>
                    </PubDate>
                </JournalIssue>
                <Title>Pain research &amp; management : the journal of the Canadian Pain Society = journal de la société canadienne pour le traitement de la douleur</Title>
                <ISOAbbreviation>Pain Res Manag</ISOAbbreviation>
            </Journal>
            <ArticleTitle>The hot foot syndrome: Evans' sign and the old way.</ArticleTitle>
            <Pagination>
                <MedlinePgn>31-4</MedlinePgn>
            </Pagination>
            <Abstract>
                <AbstractText Label="BACKGROUND" NlmCategory="BACKGROUND">escribed.</AbstractText>
                <AbstractText Label="OBJECTIVE" NlmCategory="OBJECTIVE">examination.</AbstractText>
                <AbstractText Label="METHODS" NlmCategory="METHODS"> mortality.</AbstractText>
                <AbstractText Label="RESULTS" NlmCategory="RESULTS">group.</AbstractText>
                <AbstractText Label="DISCUSSION" NlmCategory="CONCLUSIONS">carried out.</AbstractText>
                <AbstractText Label="CONCLUSION" NlmCategory="CONCLUSIONS">successful treatment.</AbstractText>
            </Abstract>
            <AuthorList CompleteYN="Y">
                <Author ValidYN="Y">
                    <LastName>Evans</LastName>
                    <ForeName>R J</ForeName>
                    <Initials>RJ</Initials>
                </Author>
                <Author ValidYN="Y">
                    <LastName>Watson</LastName>
                    <ForeName>C Peter N</ForeName>
                    <Initials>CP</Initials>
                </Author>
            </AuthorList>
            <Language>eng</Language>
            <PublicationTypeList>
                <PublicationType>Journal Article</PublicationType>
            </PublicationTypeList>
        </Article>
        <MedlineJournalInfo>
            <Country>Canada</Country>
            <MedlineTA>Pain Res Manag</MedlineTA>
            <NlmUniqueID>9612504</NlmUniqueID>
            <ISSNLinking>1203-6765</ISSNLinking>
        </MedlineJournalInfo>
        <CitationSubset>IM</CitationSubset>
    </MedlineCitation>
    <PubmedData>
        <History>
            <PubMedPubDate PubStatus="entrez">
                <Year>2012</Year>
                <Month>4</Month>
                <Day>21</Day>
                <Hour>6</Hour>
                <Minute>0</Minute>
            </PubMedPubDate>
            <PubMedPubDate PubStatus="pubmed">
                <Year>2012</Year>
                <Month>4</Month>
                <Day>21</Day>
                <Hour>6</Hour>
                <Minute>0</Minute>
            </PubMedPubDate>
            <PubMedPubDate PubStatus="medline">
                <Year>2012</Year>
                <Month>4</Month>
                <Day>21</Day>
                <Hour>6</Hour>
                <Minute>0</Minute>
            </PubMedPubDate>
        </History>
        <PublicationStatus>ppublish</PublicationStatus>
        <ArticleIdList>
            <ArticleId IdType="pubmed">22518365</ArticleId>
        </ArticleIdList>
    </PubmedData>
</PubmedArticle>

  </PubmedArticleSet>

Answers (3)