Saving xml date in sql lite

User 11705193

Dear sir. I am getting data in xml format. I want to save that in sql lite. Note if is whole xml as not in string which i am getting.

Sascha Lefevre

Member 11739620 wrote:

Note if is whole xml as not in string which i am getting.

Not sure what you want to say here. But as XML is always plain text by definition you could just store it in a text-type column. If your XML is not just plain text then it's not valid XML.

If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

User 11705193

I am getting xml from server. how to store that all xml tag in string.

Sascha Lefevre

XML is a string.

If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

Lost User

Your question is not very clear, but if you are wanting to extract the content of the XML, you should take a look at http://developer.android.com/training/basics/network-ops/xml.html[^], for how to parse it.

Dadecki

Hello, I will try to show you the possibility to save the data with SQLite in Android application: Firstly add import:

import android.database.sqlite.SQLiteDatabase;

Declare your database value in your Activity class:

private SQLiteDatabase _yourDBname;

Also declare name of the table in you database in Activity class:

private String YourTableForXml = "XMLtable";

In your Activity class in onCreate method initialize earlier declared database:

@Override
protected void onCreate(Bundle savedInstanceState)
{

_yourDBname=YourActivityName.this.openOrCreateDatabase("NameofYourDB", Context.MODE_PRIVATE, null);

};

Now you must prepare your table structure (in onCreate method too):

_eSubSQLliteDB.execSQL("DROP TABLE IF EXISTS '" + YourTableForXml + "'");
_eSubSQLliteDB.execSQL("CREATE TABLE IF NOT EXISTS " + YourTableForXml + " (Id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, xmlColumn VARCHAR);");

Now you are ready to insert some xml to your table. Note that xml is just normal String value: String sampleXML = "

<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>

"

ContentValues insertValues = new ContentValues();

insertValues.put("XmlColumn", sampleXML);

_yourDBname.insert(YourTableForXml, null, insertValues);

Hope this will help you.