Results 1 to 6 of 6
  1. #1
    nitish0401 is offline Member
    Join Date
    Nov 2011
    Posts
    2
    Rep Power
    0

    Post exporting data from .xml file to mysql

    Hi,

    I am using a tool that gives output in xml format and i want to save that output data in Mysql,
    Can anyone explain me the procedure to export data from .xml to mysql.

    Thanks in advance
    Nitish

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    8

    Default Re: exporting data from .xml file to mysql

    Parse it using an xml parser (there are some built into the java language) and use jdbc to insert it into the db. See the tutorials on both of those items, and then combine them.

  3. #3
    nitish0401 is offline Member
    Join Date
    Nov 2011
    Posts
    2
    Rep Power
    0

    Post Re: exporting data from .xml file to mysql

    Hi,thank you so much for your help.
    Actually im not very good in java and need to do things at the earliest so if you can provide me code for that,i will be highly obliged.
    Thank you
    Nitish

  4. #4
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    8

    Default Re: exporting data from .xml file to mysql

    I'll bet you would be, since you then would not have had to do anything. Hint, tutorials have code in them.

  5. #5
    AlphaSupport Guest

    Default Re: exporting data from .xml file to mysql

    Not related to Java, but this might be useful: 12.2.7. LOAD XML Syntax

  6. #6
    jacobblack is offline Member
    Join Date
    Dec 2011
    Posts
    5
    Rep Power
    0

    Default Re: exporting data from .xml file to mysql

    Dear all
    i am having a mysql database which is fed with a php form. i want to add an additional featute to the form: enter the data in mysql database using an xml file.

    The XML file may contain 1-10,000 enteries and each entry should form a unique entry in the mysql database. Please help me how can i
    1) enter the xml data directly into the mysql db
    2) Enter data from XML file using a php form.



    Any of the methods to enter the data are welcome.

    I am attaching a sample XML file which contains a number of enteries. Each entry starts with <PubmedArticle> tag and ends with </PubmedArticle> tag.

    Thanks in advance.

Similar Threads

  1. Exporting and Importing TableModels from File
    By CJC in forum AWT / Swing
    Replies: 0
    Last Post: 08-18-2011, 05:44 PM
  2. Replies: 0
    Last Post: 03-18-2011, 10:26 AM
  3. Problem with exporting csv file using template
    By trongcuong1710 in forum Networking
    Replies: 1
    Last Post: 12-08-2010, 03:40 AM
  4. Exporting to a executable JAR file
    By Drun in forum Eclipse
    Replies: 4
    Last Post: 03-27-2010, 03:16 PM
  5. Exporting WAR File Issue
    By bsimic in forum Eclipse
    Replies: 0
    Last Post: 12-29-2009, 03:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •