java如何更改来自Sqlite数据库的特定数据在Listview中的行颜色

Question

我有自定义列表视图，数据来自sqlite数据库。现在，我想根据id更改特定listview项的背景色。首先，我检查数据库中是否存在id，然后根据id更改特定项行的背景色

我的问题是，它检查成功，但当我尝试更改背景色时，它会更改整个listview背景色。这是我的数据的图片和代码。那你就明白我的意思了，我到底想对你说什么

我的数据库：

整个listview颜色变化：

我的代码：

package bible.swordof.God;

import 安卓.app.Activity;
import 安卓.content.ContentValues;
import 安卓.content.Context;
import 安卓.content.DialogInterface;
import 安卓.content.Intent;
import 安卓.content.SharedPreferences;
import 安卓.database.Cursor;
import 安卓.database.SQLException;
import 安卓.database.sqlite.SQLiteDatabase;
import 安卓.graphics.Color;
import 安卓.opengl.Visibility;
import 安卓.os.Vibrator;
import 安卓.preference.PreferenceManager;
import 安卓.speech.tts.TextToSpeech;
import 安卓.support.v7.app.AlertDialog;
import 安卓.support.v7.app.AppCompatActivity;
import 安卓.util.Log;
import 安卓.view.LayoutInflater;
import 安卓.view.View;
import 安卓.view.ViewGroup;
import 安卓.view.Window;
import 安卓.widget.ArrayAdapter;
import 安卓.widget.Button;
import 安卓.widget.CompoundButton;
import 安卓.widget.ImageView;
import 安卓.widget.LinearLayout;
import 安卓.widget.TextView;
import 安卓.widget.Toast;
import 安卓.widget.ToggleButton;

import com.amulyakhare.textdrawable.TextDrawable;
import com.amulyakhare.textdrawable.util.ColorGenerator;


import java.util.ArrayList;
import java.util.List;
import java.util.Locale;

import es.dmoral.toasty.Toasty;
import petrov.kristiyan.colorpicker.ColorPicker;

import static 安卓.content.Context.MODE_PRIVATE;
import static 安卓.database.sqlite.SQLiteDatabase.CONFLICT_NONE;
import static 安卓.icu.lang.UCharacter.GraphemeClusterBreak.V;
import static 安卓.support.constraint.Constraints.TAG;
import static 安卓.support.v4.content.ContextCompat.createDeviceProtectedStorageContext;
import static 安卓.support.v4.content.ContextCompat.startActivity;

public class FullverseAdopter extends ArrayAdapter<String> {
    private ALLVERSE activity;

    private List<String> versenumber;
    private List<String>verseid;
    private List<String> verselist;
    private List<String> refernce;
    TextToSpeech textToSpeech;
    private DatabaseHelper mDBHelper;
    private SQLiteDatabase mDb;
    private boolean highlight=false;
    LinearLayout linearLayout;


public  String ex="switch";

    //check for availabe language
    int result;


    public FullverseAdopter(ALLVERSE context, int resource, List<String> versenumber, List<String> verselist, List<String> refernce, List<String>verseid) {
        super(context, resource, versenumber);
        this.activity = context;
        this.versenumber = versenumber;
        this.verselist = verselist;
        this.refernce = refernce;
        this.verseid=verseid;



    }


    @Override
    public int getCount() {
        return versenumber.size();
    }

    @Override
    public String getItem(int position) {
        return versenumber.get(position);
    }

    @Override
    public long getItemId(int position) {
        return position;
    }

    @Override
    public View getView(final int position, View convertView, final ViewGroup parent) {
        final ViewHolder holder;

        LayoutInflater inflater = (LayoutInflater) activity.getSystemService(Activity.LAYOUT_INFLATER_SERVICE);
        // If holder not exist then locate all view from UI file.
        if (convertView == null) {
            // inflate UI from XML file
             convertView = inflater.inflate(R.layout.versedisplayrow, parent, false);
            // get all UI view
            holder = new ViewHolder(convertView);
            // set tag for holder
           holder.versenumber = (TextView) convertView.findViewById(R.id.versenumber);
            holder.verselist = (TextView) convertView.findViewById(R.id.verse);
            holder.addfavoruite=(ToggleButton)convertView.findViewById(R.id.adbookmark);

//check if id is exits in db
            if(CheckIsDataAlreadyInDBorNot("t_asv","id","1001001"))
            {

                holder.linearLayout.setBackgroundColor(Color.parseColor("#008577"));
            }



            convertView.setTag(holder);
        } else {
            // if holder created, get tag from view
            holder = (ViewHolder) convertView.getTag();
        }
        holder.versenumber.setText(versenumber.get(position));

        holder.verselist.setText(verselist.get(position));





holder.linearLayout.setOnLongClickListener(new View.OnLongClickListener() {




    @Override
    public boolean onLongClick(View v) {

        //Toasty.success(activity, "PICK COLOR", Toast.LENGTH_SHORT, true).show();
        Vibrator vibe = (Vibrator)activity.getSystemService(Context.VIBRATOR_SERVICE);
        vibe.vibrate(100);


        Toast.makeText(activity, ""+verseid.get(position), Toast.LENGTH_SHORT).show();







      /*  ColorPicker colorPicker = new ColorPicker(activity);
        ArrayList<String>colors=new ArrayList<>();
        colors.add("#e0e0eb");
        colors.add("#ccffff");
        colors.add("#ffe6ff");
        colors.add("#ffffcc");
        colors.add("#ccffcc");
        colors.add("#e6f2ff");
        colorPicker.setColors(colors).setColumns(4).setTitle("HIGHLIGHT VERSE").setRoundColorButton(true).setOnChooseColorListener(new ColorPicker.OnChooseColorListener() {
            @Override
            public void onChooseColor(int position, int color) {





              //  holder.linearLayout.setBackgroundColor(color);





            }

            @Override
            public void onCancel() {

            }
        }).show();*/






        return false;
    }
});
        /*holder.verselist.setOnLongClickListener(new View.OnLongClickListener() {
            @Override
            public boolean onLongClick(View v) {
                holder.verselist.setBackgroundColor(Color.parseColor("#e0e0eb"));
                return false;
            }
        });*/

//verselist highlight

/*holder.verselist.setOnClickListener(new View.OnClickListener() {
    @Override
    public void onClick(View v) {






    }
});*/



        //share verse
        holder.share.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Toasty.info(activity, "Sharing a verse.", Toast.LENGTH_SHORT, true).show();
                Intent sendIntent = new Intent();
                sendIntent.setAction(Intent.ACTION_SEND);
                sendIntent.putExtra(Intent.EXTRA_TEXT, refernce.get(position) + ":" + versenumber.get(position) + '\n'   + verselist.get(position));
                sendIntent.setType("text/plain");
                activity.startActivity(sendIntent);

            }
        });

//add in favourite
      holder.addfavoruite.setOnCheckedChangeListener(new CompoundButton.OnCheckedChangeListener() {

            @Override
            public void onCheckedChanged(CompoundButton buttonView, boolean isChecked) {

                if(isChecked){
                    mDBHelper = new DatabaseHelper(activity);
                    mDb = mDBHelper.getWritableDatabase();
                    ContentValues contentValues=new ContentValues();
                  contentValues.put("id",verseid.get(position));
                  contentValues.put("bookname",refernce.get(position));
                   contentValues.put("versenumber",versenumber.get(position));
                   contentValues.put("verse",verselist.get(position));
                   long check=mDb.insert("favourite",null,contentValues);
                   Log.d("MY_TAG","DB IS NOW "+check);
                   Toasty.success(activity, "Added in favouite", Toast.LENGTH_SHORT, true).show();


                }else {


                    mDBHelper = new DatabaseHelper(activity);
                    mDb = mDBHelper.getWritableDatabase();
                    long delete= mDb.delete("favourite","id=?",new String[]{verseid.get(position)});
                   Toasty.error(activity, "Remove in favouite", Toast.LENGTH_SHORT, true).show();
                }


            }
        });

       /* textToSpeech = new TextToSpeech(activity, new TextToSpeech.OnInitListener() {
            @Override
            public void onInit(int status) {

                if (status == TextToSpeech.SUCCESS) {
                    result = textToSpeech.setLanguage(Locale.ENGLISH);
                } else {

                    Toast.makeText(activity, "YOUR DEVICE NOT SUPPORTED", Toast.LENGTH_SHORT).show();
                }
            }
        });
*/



        //My toggle button








       /* holder.speakverse.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {

                Toast.makeText(activity, "I AM CLICKED", Toast.LENGTH_SHORT).show();

                if (result == TextToSpeech.LANG_NOT_SUPPORTED || result == TextToSpeech.LANG_MISSING_DATA) {

                    Toast.makeText(activity, "Language not supported or Missing", Toast.LENGTH_SHORT).show();

                } else {


                    textToSpeech.speak(verselist.get(position), TextToSpeech.QUEUE_FLUSH, null);

                }
            }
        });*/




        return convertView;
    }

    static class ViewHolder {
        private TextView versenumber;
        private TextView verselist;

        private ImageView share;
        private  ToggleButton addfavoruite;
        private ImageView speakverse;
        private LinearLayout linearLayout;

        public ViewHolder(View v) {
            versenumber = (TextView) v.findViewById(R.id.versenumber);
            verselist = (TextView) v.findViewById(R.id.verse);
           share = (ImageView) v.findViewById(R.id.share);
            /*speakverse = (ImageView) v.findViewById(R.id.speakverse);*/
        addfavoruite=(ToggleButton)v.findViewById(R.id.adbookmark);
        linearLayout=(LinearLayout)v.findViewById(R.id.layout);



        }


    }
    public boolean CheckIsDataAlreadyInDBorNot(String TableName,  String dbfield, String fieldValue) {

        mDBHelper = new DatabaseHelper(activity);
        mDb = mDBHelper.getReadableDatabase();
        String Query = "Select * from " + TableName + " where " + dbfield + " = " + fieldValue;
        Cursor cursor = mDb.rawQuery(Query, null);
        if(cursor.getCount() <= 0){
            cursor.close();

            Toast.makeText(activity, "false", Toast.LENGTH_SHORT).show();
            return false;
        }else {


            Toast.makeText(activity, "TRUE", Toast.LENGTH_SHORT).show();

        }
        cursor.close();


        return true;
    }
    public  void opecolorpicker(){

    }

}

Answer 1

假设将ID存储在private List<String>verseid;中，则可以使用它检查当前ListView项的ID
当前项目位置在final int position参数中传递给您
所以要检查并应用颜色：
移除

if(CheckIsDataAlreadyInDBorNot("t_asv","id","1001001"))
{
     holder.linearLayout.setBackgroundColor(Color.parseColor("#008577"));
}

从if (convertView == null) {
然后，在以下情况下，将此代码添加到外部：

if("1001001".equals(verseid.get(position))) {
    //change the color
} else {
    //set the color to default
}

请注意，由于ListView的工作方式（回收项目），您必须在else内设置默认颜色