public class DataHandler { private SQLiteDatabase sqLiteDatabase; MyHelper myHelper; Context context; public DataHandler(Context context) { myHelper = new MyHelper(context, "College.sqlite", null,1); } public class MyHelper extends SQLiteOpenHelper { public MyHelper(Context context, String name, CursorFactory factory, int version) { super(context, name, factory, version); // TODO Auto-generated constructor stub } @Override public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub db.execSQL("create table Student(sno text,sname text ,city text)"); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // TODO Auto-generated method stub } } public void openDataBase() { sqLiteDatabase = myHelper.getWritableDatabase(); } public void insertStudent(Vector<Student> vecStudent) { openDataBase(); Student student; ContentValues contentValues = null; for(int i = 0;vecStudent.size()>0;i++) { student = vecStudent.get(0); contentValues = new ContentValues(); contentValues.put("sno", student.sno); contentValues.put("name", student.name); contentValues.put("city", student.city); sqLiteDatabase.insert("Student", "", contentValues); } } public void closeDataBase() { sqLiteDatabase.close(); } }
Tuesday, 2 October 2012
Sax Parser Data Handler
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment