I would like to parse data from remote xml and add parsed records to my sqlite database
I parse data from xml with this code:
try{
ArrayList<HashMap<String, String>> menuItems = new ArrayList<HashMap<String, String>>();
XMLParser parser = new XMLParser();
String xml = parser.getXmlFromUrl(URL); // getting XML
Document doc = parser.getDomElement(xml); // getting DOM element
NodeList nl = doc.getElementsByTagName(KEY_ITEM);
// looping through all item nodes <item>
for (int i = 0; i < nl.getLength(); i++) {
// creating new HashMap
HashMap<String, String> map = new HashMap<String, String>();
Element e = (Element) nl.item(i);
// adding each child node to HashMap key => value
map.put(KEY_PLAYER, parser.getValue(e, KEY_PLAYER));
map.put(KEY_DATA, parser.getValue(e, KEY_DATA));
// adding HashList to ArrayList
}
}
catch (Exception e) {
Log.d("error", "error");
}
and in DBHelper:
public void add_DATA(String[] data){
try{
mDataBase = this.getWritableDatabase();
ContentValues cv = new ContentValues();
for(int i=0;i<data.length;i++){
cv.put(KEY_PLAYER, data[i]);
cv.put(KEY_DATA, data[i]);
mDataBase.insert(TABLE1_NAME, null, cv);
}
mDataBase.close();
}
catch(Exception ex){
Log.e("Error", ex.toString());}
}
I'm trying something like
add_Data(map);
No comments:
Post a Comment