Example

Question

I have the following feeds from my vendor, http://scores.cricandcric.com/cricket/getFeed?key=4333433434343&format=xml&tagsformat=long&type=schedule

I wanted to get the data from that xml files as java objects, so that I can insert into my database regularly. The above data is nothing but regular updates from the vendor, so that I can update in my website.

请向我建议,我可以选择哪些办法来开展这项工作。

Should I use any webservices or just Xstream to get my final output.. please suggest me as am a new comer to this concept

供应商建议我,他可以向我提供以下3种格式的器、xml或json的数据,我不相信什么是轻而易的,可以让我工作。

Answer 1

我只想写出一个方案,把XML同起来,并将数据直接输入你的数据库。

Example

The groovy script.” rel=“nofollow” H2 数据库。

// 
// Dependencies
// ============
import groovy.sql.Sql

@Grapes([
    @Grab(group= com.h2database , module= h2 , version= 1.3.163 ),
    @GrabConfig(systemClassLoader=true)
])

//
// Main program
// ============
def sql = Sql.newInstance("jdbc:h2:db/cricket", "user", "pass", "org.h2.Driver") 

def dataUrl = new URL("http://scores.cricandcric.com/cricket/getFeed?key=4333433434343&format=xml&tagsformat=long&type=schedule")

dataUrl.withReader { reader ->
    def feeds = new XmlSlurper().parse(reader)

    feeds.matches.match.each {
        def data = [
            it.id,
            it.name,
            it.type,
            it.tournamentId,
            it.location,
            it.date,
            it.GMTTime,
            it.localTime,
            it.description,
            it.team1,
            it.team2,
            it.teamId1,
            it.teamId2,
            it.tournamentName,
            it.logo
        ].collect {
            it.text()
        }

        sql.execute("INSERT INTO matches (id,name,type,tournamentId,location,date,GMTTime,localTime,description,team1,team2,teamId1,teamId2,tournamentName,logo) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", data)
    }
}

Answer 2

......你可以使用XML Parser(溪流或多氧化二氮),也可以使用JSON教区(DOM的溪流),并在飞机上建树。但是,这些数据似乎包括板球配对记录,为什么不采用碎格式?

这似乎是你的基本 da子:

<id>1263</id>
<name>Australia v India 3rd Test at  Perth - Jan 13-17, 2012</name>
<type>TestMatch</type>
<tournamentId>137</tournamentId>
<location>Perth</location>
<date>2012-01-14</date>
<GMTTime>02:30:00</GMTTime>
<localTime>10:30:00</localTime>
<description>3rd Test day 2</description>
<team1>Australia</team1>
<team2>India</team2>
<teamId1>7</teamId1>
<teamId2>1</teamId2>
<tournamentName>India tour of Australia 2011-12</tournamentName>
<logo>/cricket/137/tournament.png</logo>

当然,你仍然必须打上头巾,处理限定性的问题(例如,如果你有或“有str”,但会大大减少你的网络交通,并很可能使客户更快地陷入困境。当然,这取决于你的客户。

Answer 3

Actually you have RESTful store that can return data in several formats and you only need to read from this source and no further interaction is needed. So, you can use any XML Parser to parse XML data and put the extracted data in whatever data structure that you want or you have.

我没有听说过XTREME的话,但你可以找到更多信息,了解如何在上选择最优等舱位。

Example

友情链接