Illustration

请先查看图片。

如何获取值“ Test 1”，然后将sqlite数据库中的列（收藏夹）更新为“是”？

我正在寻找案情的答案，但与我的问题不符，或者我是一个不理解的人。：D

@Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.act_channel_list);

    channelList = this.findViewById(R.id.channelList);
    mDB = openDB();

    if (mDB != null) {
        mCsr = mDB.query(CHANNELTABLE,new String[]{KEY_NO + " AS _id",KEY_NAME,KEY_CATEGORY,KEY_LOGO,KEY_SERVER1,KEY_SERVER2,KEY_SERVER3,KEY_SERVER4,KEY_SERVER5,KEY_LIKE
                },null,null);

        mSCA = new SimpleCursorAdapter(this,R.layout.custom_listview,mCsr,new String[]{KEY_NAME,KEY_LIKE},new int[]{R.id.channel_name,R.id.category,R.id.logo,R.id.like},0);

        mSCA.setViewBinder(new SimpleCursorAdapter.ViewBinder(){
            public boolean setViewValue(final View view,Cursor cursor,int columnIndex){
                if(view.getId() == R.id.logo){
                    channelName = cursor.getString(3);
                    int resID = getResources().getIdentifier(channelName,"drawable",getPackageName());
                    //Toast.makeText(Channel_List_act.this,cursor.getString(9),Toast.LENGTH_LONG).show();
                    ((ImageView)view.findViewById(R.id.logo)).setImageDrawable(getResources().getDrawable(resID,getapplicationContext().getTheme()));
                    return true;
                }
                if(view.getId() == R.id.like){
                    liked = cursor.getString(9);
                    final int resID = getResources().getIdentifier(liked,getPackageName());
                    ((ImageView)view.findViewById(R.id.like)).setImageDrawable(getResources().getDrawable(resID,getapplicationContext().getTheme()));

                    ((ImageView)view.findViewById(R.id.like)).setOnClicklistener(new View.OnClicklistener() {
                        @Override
                        public void onClick(View v) {

                            I AM STUCK IN HERE,OR MAYBE NOT HERE?

                        }
                    });

                    return true;
                }
                return false;
            }

        });

        channelList.setadapter(mSCA);
    } else {
        Toast.makeText(this,"Unable to open Database.",Toast.LENGTH_LONG).show();
    }
}