java - How to convert xml file into mysql? -

i have xml file created mysql database 1 table.
<database_name>
    <table_name>
        <col1>row1</col1>
        <col2>row1</col1>
    </table_name>
    <table_name>
        <col1>row2</col1>
        <col2>row2</col2>
    </table_name>
</database_name>
need convert xml file mysql database. how can using java?

you use xml parsing library dom4j, parse file, loop through results , emit text file contains list of inserts.

do know schema or need inferred data?

so resultant text file like

create table ()  insert (c1,...cn) values (v1,...vn) 

then use mysqldump push file db

mysqldump -u [username] [databasename] < output.sql