Step1:
Here I'm using
mysql dababase
Creating one database schema like "xmldb", in this xmldb schema create a one table like 'persons'
For this table having field names like: id,firstname,lastname,email,address
Step 2: Write one xml file like 'MyxmlP.xml
MyxmlP.xml
<?xml version="1.0" encoding="UTF-8"?>
<persons>
<person age="3">
<id>36 </id>
<firstname>Rama</firstname>
<lastname>Krishna </lastname>
<email>rama@krishna.com</email>
<address>CA</address>
</person>
<person age="4">
<id> 63</id>
<firstname>krishna</firstname>
<lastname>rama</lastname>
<email>krishna@rama</email>
<address>AC</address>
</person>
</persons>
Step 3:
Write one scripting file for the database connection and storing xml file into database:
Step 4:
The filename like:
Xml2DB.groovy
/*
*Stores xml data into mysql database
*
*/
class Xml2DB{
static void main(args){
def sql = Sql.newInstance("jdbc:mysql://localhost:3306/xmldb", "root",
"root", "com.mysql.jdbc.Driver")
def Employee = new XmlParser().parse('MyxmlP.xml')
//set the database table name here.
def set1 = sql.dataSet("persons")
Employee.person.each {
def empId = it.id.text()
def firstName = it.firstname.text()
def lastName = it.lastname.text()
def email = it.email.text()
def empAddress = it.address.text()
set1.add(id:empId,firstname:firstName,lastname:lastName,email:email,address:empAddress)
}
}
}
