SQLiteDatabase db = openOrCreateDatabase("TestDB",
MODE_PRIVATE, null);
db.execSQL("CREATE TABLE IF NOT EXISTS Client (clientID INT," +
" clientName VARCHAR, " +
"routeName VARCHAR, " +
"visitingFrequency INT, " +
"creditLimit INT, " +
"outletType VARCHAR, " +
"shopGrade VARCHAR, " +
"creditPeriodDays INT(2), " +
"streetNumber VARCHAR, " +
"streetName VARCHAR, " +
"city VARCHAR, " +
"district VARCHAR, " +
"csrId INT, " +
"comments VARCHAR, " +
"active VARCHAR(1))");
db.execSQL("INSERT INTO Client VALUES (110001, " +
"'LASANTHA STORES', " +
"'R1', " +
"4, " +
"0, " +
"'GROCERY', " +
"'BRONZE', " +
"4, " +
"'2', " +
"'HIGHL LEVEL ROAD', " +
"'MAHARAGAMA', " +
"'COLOMBO', " +
"1091, " +
"'Test Client', " +
"'Y')");
db.close();
tried above one and it's worked. now i need to insert data in XML to
my database. i know how to read XML file and get values in xml
elements. but have no idea about how to insert them into database.
On 9/14/11, skink <[email protected]> wrote:
>
>
> On Sep 14, 12:15 pm, Bishan <[email protected]> wrote:
>> Vector<EgCommon> vClient = new Vector<EgCommon>();
>>
>> for (int temp = 0; temp < getNodes().getLength(); temp++)
>> {
>>
>> Node nNode = getNodes().item(temp);
>> if (nNode.getNodeType() == Node.ELEMENT_NODE) {
>>
>> Element element = (Element) nNode;
>>
>> Client cl = new Client(
>>
>> Util.getTagValue("clientID", element),
>>
>> Util.getTagValue("clientName", element),
>>
>> Util.getTagValue("routeName", element),
>>
>> Util.getTagValue("visitingFrequency", element),
>>
>> Util.getTagValue("creditLimit", element),
>>
>> Util.getTagValue("outletType", element),
>>
>> Util.getTagValue("shopGrade", element),
>>
>> Util.getTagValue("creditPeriodDays", element),
>>
>> Util.getTagValue("streetNumber", element),
>>
>> Util.getTagValue("streetName", element),
>> Util.getTagValue("city",
>> element),
>>
>> Util.getTagValue("district", element),
>> Util.getTagValue("csrId",
>> element),
>>
>> Util.getTagValue("comments", element),
>> Util.getTagValue("active",
>> element));
>>
>> vClient.add(cl);
>>
>> }
>> }
>> return vClient;
>> }
>>
>
> man, i dont mean xml stuff as its already working, i mean your sqlite
> stuff, how do you try to insert data into your db?
>
> pskink
>
> --
> You received this message because you are subscribed to the Google
> Groups "Android Developers" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/android-developers?hl=en
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
