从XML读取并使用grails将值存储在数据库中 [英] Reading from XML and storing the values in database using grails
问题描述
可能存在重复:
将XML导入Grails域类
说有像下面的XML文件,
现在我想插入这些firstname,deptname和empid到数据库使用grails
任何人都可以提出一个想法。
$ b < employees>
< employee>
< firstname> Marios< / firstname>
< deptname> ITdepartment< / deptname>
< empid> 123< / empid>
< / employee>
< employee>
< firstname> Ben< / firstname>
< deptname>管理< / deptname>
< empid> 124< / empid>
< / employee>
< / employees>
谢谢大家,我得到了答案如何做到这一点,张贴在这里为他人的知识,如果需要改变任何可以建议我
def Employee = new XmlParser()。parse(Your xml file path)
def set1 = sql.dataSet(Your field name在Xml)
Employee.employee.each {
def firstname = it。 firstname.text()
def deptname = it.deptname.text()
def empid = it.empid.text()
set1.add(first_name:firstname,dept_name:deptname,emp_id:empid )
}
Possible Duplicate:
Import XML into a Grails Domain Class
say am having the xml file like below, Now i want to insert these firstname, deptname and empid into the database using grails can anyone suggest an idea in this.
<employees>
<employee>
<firstname>Marios</firstname>
<deptname>ITdepartment</deptname>
<empid>123</empid>
</employee>
<employee>
<firstname>Ben</firstname>
<deptname>Management</deptname>
<empid>124</empid>
</employee>
</employees>
Thank you all, I got the answer how to do that am posting here for others for their knowledge if changes required any can suggest me
def Employee = new XmlParser().parse("Your Xml file path")
def set1 = sql.dataSet("Your field name in Xml")
Employee.employee.each {
def firstname = it.firstname.text()
def deptname = it.deptname.text()
def empid = it.empid.text()
set1.add(first_name:firstname,dept_name:deptname,emp_id:empid)
}
这篇关于从XML读取并使用grails将值存储在数据库中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!