SAXParser | parse xml data via vector to db

Question

Edit: Not totally solved!
How I can add every entry to db. I want to add Data1, Data2, Data3 and so on to a new column.

In my actual code, down below, parsing data from the XML in res/raw works like a charm. But I cant get it from a URL. Which I'am doing wrong?

I want to parse data from an XML on the net. The XML looks like:

<entrys>
  <entry>
    <data1>a number</data1>
    <data2>a name</data2>
    <data3>a webUrl</data3>
    <data4>a streamUrl</data4>
    <data5>a logoUrl</data5>
  </entry>
  <entry>
    <data1>other number</data1>
    <data2>other name</data2>
    <data3>other webUrl</data3>
    <data4>other streamUrl</data4>
    <data5>other logoUrl</data5>
  </entry>

<-- more entrys like this, up to one number defined in another xml -->
</entrys>

If I parse it on my way (the code below), I only get the last entry data.
The problem is, I want every entry (and its data) in my db. How can I achieve it?

class ParsedExampleDataSet {
    private String data1;
    private String data2;
    private String data3;
    private String data4;
    private String data5;

    public String toString() {
        return "entry ID: " + data1 + "entry Name: "
                + data2 + "entry webUrl: " + data3
                + "entry streamUrl: " + data4
                + "entry Logo: " + data5;
    }

    public String getdata1() { return data1; }
    public void setdata1(String data1) { this.data1 = data1; }
    public String getdata2() { return data2; }
    public void setdata2(String data2) { this.data2 = data2; }
    public String getdata3() { return data3; }
    public void setdata3(String data3) { this.data3 = data3; }
    public String getdata4() { return data4; }
    public String getdata5() { return data5; }
    public void setdata4(String data4) {
        this.data4 = data4;
    }
    public void setdata5(String data5) {
        this.data5 = data5;
    }
}

class ContentHandler extends DefaultHandler {
    private enum Tags {
        entry, data1, data2, data3, data4, data5, entrys
    }

    private boolean in_entryTag = false;
    private boolean in_entrys = false; //opened at document start, closed at document end
    private boolean in_entry = false; //opened at new entry, closed after entry completet
    private boolean in_data1 = false; //the entry id
    private boolean in_data2 = false; //entry Name
    private boolean in_data3 = false; //entry weburl
    private boolean in_data4 = false; //entry streamUrl
    private boolean in_data5 = false; // Url to entry logo

    private ParsedExampleDataSet DataSet;
    private Vector<ParsedExampleDataSet> MyParsedExampleDataSets;


    public ContentHandler() {
        super();
        this.MyParsedExampleDataSets = new Vector<ParsedExampleDataSet>();
    }

    public Vector<ParsedExampleDataSet> getParsedExampleDataSets() {
        return this.MyParsedExampleDataSets;
    }

    public void startDocument() throws SAXException { }
    public void endDocument() throws SAXException { }

    public void startElement(String n, String l, String q, Attributes a) {
         switch(Tags.valueOf(l)) {
             case entry:
                 in_entryTag = true;
                 DataSet = new ParsedExampleDataSet();
                 break;
             case data1:
                 in_data1 = true;
                 break;
             case data2:
                 in_data2 = true;
                 break;
             case data3:
                 in_data3 = true;
                 break;
             case data4:
                 in_data4 = true;
                 break;
             case data5:
                 in_data5 = true;
                 break;
             case entrys:
                 break;
         }
    }

    public void endElement(String n, String l, String q) {
        switch(Tags.valueOf(l)) {
            case entry:
                in_entryTag = false;
                MyParsedExampleDataSets.add(DataSet);
                break;             
            case data1:
             in_data1 = false;
             break;      
            case data2:
             in_data2 = false;
             break;              
            case data3:
             in_data3 = false;
             break;              
            case data4:
             in_data4 = false;
             break;              
            case data5:
             in_data5 = false;
             break;              
            case entrys:
                break;
        }
    }

    public void characters(char ch[], int start, int length) {
        if(this.in_data1){
            DataSet.setdata1(new String(ch, start, length));
        }else if(this.in_data2) {
            DataSet.setdata2(new String(ch, start, length));
        }else if(this.in_data3) {
            DataSet.setdata3(new String(ch, start, length));
        }else if(this.in_data4) {
            DataSet.setdata4(new String(ch, start, length));
        }else if(this.in_data5) {
            DataSet.setdata5(new String(ch, start, length));
        }

    }
}

public class XMLparserSample extends Activity {
    private TextView myTextView;
    private static final String TAG = XMLparserSample.class.getSimpleName();

    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);

        setContentView(R.layout.main);

        Vector<ParsedExampleDataSet> test = read(getResources().openRawResource(R.raw.sample));

        String text = "";
        for(int i=0; i < test.size(); i++)
            text += test.get(i).toString();

        myTextView = (TextView) findViewById(R.id.tv);        
        myTextView.setText(text);
        Log.d(TAG, "vector = " + test);
    }

    public Vector<ParsedExampleDataSet> read(InputStream in) {
        SAXParserFactory spf = SAXParserFactory.newInstance();
        SAXParser sp;
        try {
            sp = spf.newSAXParser();
            XMLReader xr = sp.getXMLReader();
            ContentHandler ch = new ContentHandler();
            xr.setContentHandler(ch);
            xr.parse(new InputSource(in));
            return ch.getParsedExampleDataSets();                
        } catch (ParserConfigurationException e) {
        } catch (SAXException e) {
        } catch (IOException e) {}
        return null;
    }    
}

You have not added your dataset to MyParsedExampleDataSets any where. Add all your entries to MyParsed... and return it. That way you will get vector of datasets. — kosa, Jan 17 '12 at 22:13
you need to add DataSet to MyParsedExampleDataSets and return MyParsedExampleDataSets, that way you will get all datasets. — kosa, Jan 17 '12 at 22:33

score 1 · Accepted Answer · answered Jan 18 '12 at 10:28

1

Please look into your code into application

case entrys:
                MyParsedExampleDataSets.add(DataSet);
                break;

here entrys tag will end only one time in full document. So place this code into entry tag like this:

public void endElement(String n, String l, String q) {
        switch(Tags.valueOf(l)) {
            case entry:
                in_entryTag = false;
                MyParsedExampleDataSets.add(DataSet);

                break;             
            case data1:
             in_data1 = false;
             break;      
            case data2:
             in_data2 = false;
             break;              
            case data3:
             in_data3 = false;
             break;              
            case data4:
             in_data4 = false;
             break;              
            case data5:
             in_data5 = false;
             break;              
            case entrys:
                break;
        }
    }

answered Jan 18 '12 at 10:28

jeet

29,001
6
52
53

This work, but not as intendet. I get now more thank one result, but the result is everytime the same. The last entry, How I can fix it? – Leandros Jan 18 '12 at 17:10
Fixed it myself, added `case entry: DataSet = new ParsedExampleDataSet();` to `onStartElement()`. Now I want to export it into a db, how can I add every entry? – Leandros Jan 18 '12 at 17:19
now you have got an arraylist, search regarding saving an array in db. you will get enough links. – jeet Jan 19 '12 at 04:47
Can you get me a hint, why opening a url to parse xml dont work with my code? I tried to open url like this `url.openstream() ` – Leandros Jan 19 '12 at 05:51
Anyway, forgot the permission for Internet ^^ – Leandros Jan 19 '12 at 21:18

score 0 · Answer 2 · answered Jan 18 '12 at 10:10

Try to parse like this, here doc is nothing but your parsed xml document

    NodeList entrysnodeList = doc.getElementsByTagName("entrys");   
        for (int i = 0; i < ccnodeList.getLength(); i++) {
//loop through the results

// Again take the nodelist for entry like above in the same loop
// then read one by one
    }

SAXParser | parse xml data via vector to db

2 Answers2