//按所有查詢?? ??? ?btnAll.setOnClickListener(new OnClickListener(){?? ??? ??? ?public void onClick(View v){?? ??? ??? ??? ?SQLiteDatabase m_dbSQLiteDatabase=null;?? ??? ??? ??? ??? ??? ??? ??? ?m_dbSQLiteDatabase=SQLiteDatabase.openOrCreateDatabase("/data/data/com.example.demo_01/xiao.db",null);?? ??? ??? ??? ??? ??? ??? ??? ?if(m_dbSQLiteDatabase!=null)?? ??? ??? ??? ?{?? ??? ??? ??? ??? ?String strMsg="查到的數(shù)據(jù):\n? 編號(hào)? 姓名? 電話\n";?? ??? ??? ??? ??? ?Cursor resultCursor=m_dbSQLiteDatabase.query("Address",new String[]{"User_Id","User_Name","User_Tel"},null,null,null,null,null);?? ??? ??? ??? ??? ?if (resultCursor.moveToFirst()){?? ??? ??? ??? ??? ??? ?for(int i=0;i<resultCursor.getCount();i++){?? ??? ??? ??? ??? ??? ??? ?strMsg+=" "+resultCursor.getString(0)+" "+resultCursor.getString(1)+" "+resultCursor.getString(2)+"\n";?? ??? ??? ??? ??? ??? ??? ?resultCursor.moveToNext();?? ??? ??? ??? ??? ??? ?}?? ??? ??? ??? ??? ?}?? ??? ??? ??? ??? ?txtresult.setText(strMsg);?? ??? ??? ??? ??? ?m_dbSQLiteDatabase.close();?? ??? ??? ??? ?}?? ??? ??? ?}?? ??? ?});
1 回答
- 1 回答
- 0 關(guān)注
- 1075 瀏覽
添加回答
舉報(bào)
0/150
提交
取消