How to populate database table from a file in ecplise?



I'm working on small Android project in eclipse. I created a database table but instead of populating the columns using EditText control, I want to populate it using data from a file (txt or xml). I have a table shown below populated using EditText.


Database class:



@Override
public void onCreate(SQLiteDatabase sqldb) {
myTableQuery="CREATE TABLE staff (staff_ID INTEGER PRIMARY KEY, staff_Name TEXT, appointment_Day TEXT, " +
"start_Time TEXT, end_Time TEXT, comment TEXT)";

sqldb.execSQL(myTableQuery);
}

public void AddStaff(String id, String name, String day, String start, String end, String comment){

SQLiteDatabase sqldb=this.getWritableDatabase();

ContentValues values = new ContentValues();
values.put("staff_ID", id);
values.put("staff_Name", name);
values.put("appointment_Day", day);
values.put("start_Time", start);
values.put("end_Time", end);
values.put("comment", comment);

sqldb.insert("staff", null, values);
sqldb.close();


}


AddActivity class:



public void AddRowItemTable(View v){


EditText staff_id = (EditText) findViewById(R.id.sId);
EditText staff_name = (EditText) findViewById(R.id.sname);
EditText day = (EditText) findViewById(R.id.day);
EditText start = (EditText) findViewById(R.id.start);
EditText end = (EditText) findViewById(R.id.end);
EditText comment = (EditText) findViewById(R.id.comment);

String id = staff_id.getText().toString();
String name = staff_name.getText().toString();
String d = day.getText().toString();
String s = start.getText().toString();
String e = end.getText().toString();
String c = comment.getText().toString();

MainActivity.myDB.AddStaff(id, name, d, s, e, c);
Intent newintent=new Intent(this, MainActivity.class);
startActivity(newintent);

}


Instead of doing it this way, how can I read data from file to populate it. File looks like this.



<?xml version="1.0" encoding="utf-8"?>
<staff>

<record staff_ID="S1" staff_Name="John" appointment_Day="Monday" start_Time="9" end_Time="12" comment="xxx"/>
<record staff_ID="S2" staff_Name="Bob" appointment_Day="Monday" start_Time="10" end_Time="11" comment="xxx"/>

</staff>


Any help..??


No comments:

Post a Comment