sqlite 기본

//init databases
private SQLiteDatabase mDb = null;
	
	public BaseDAO(Context context) {
		super(context);
		mDb = this.getWritableDatabase();
	}	
    

//dml sample
public ArrayList selContactSearch(Bundle item)
	{
		Cursor cursor = null;
		
		cursor = mDb.rawQuery("select * from dual", null);
		
		ArrayList arList= getBundleList(cursor);
		
		return arList;
	} 
	
	public void insContact(Bundle item)
	{		
		mDb.execSQL("insert into t_contact (contact_name, contact_tel) " +
				"values (?,?)",  new Object[]{item.getString("name"),item.getString("tel")});
	}