Listview选定的项目高亮显示来自数据库？

Question

我是android的初学者，创建宗教书籍，我有两个活动，都有列表视图，数据来自sqlite数据库，当我点击任何特定的项目，从第一个活动切换到第二个活动，在第二个活动中显示所有细节，也有列表视图，我的问题是如何突出显示第二个列表项目行，只有特定的项目才突出显示！在图片中显示的例子实际上我想要什么

在这里，如果有人点击第13节，所有第1-25节都显示，但只突出第13节在下一个活动中，如何做到这一点，这里是我的代码

    import android.content.Context;
    import android.content.Intent;
    import android.database.Cursor;
    import android.database.sqlite.SQLiteDatabase;
    import android.support.v7.app.AppCompatActivity;
    import android.os.Bundle;
    import android.support.v7.widget.SearchView;
    import android.support.v7.widget.Toolbar;
    import android.view.Menu;
    import android.view.MenuInflater;
    import android.view.MenuItem;
    import android.view.View;
    import android.widget.AdapterView;
    import android.widget.ArrayAdapter;
    import android.widget.ListView;
    import android.widget.TextView;
    import android.widget.Toast;


    import java.util.ArrayList;

    public class Chapters extends AppCompatActivity {
        private ListView listView;
        private ArrayList<String> stringArrayList;
        private ArrayAdapter<String> adapter;
        private DatabaseHelper mDBHelper;
        private SQLiteDatabase mDb;
        private   int booknumber;
        private  String bookname;
        TextView setbookname;

        @Override
        protected void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.activity_chapters);
            Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
            setbookname=(TextView)findViewById(R.id.bookname);
            Intent mIntent = getIntent();
             booknumber= mIntent.getIntExtra("booknumber", 0);
             bookname=mIntent.getStringExtra("bookname");


             setbookname.setText(bookname);

            toolbar.setTitle("");
            setSupportActionBar(toolbar);
            if (getSupportActionBar() != null) {
                getSupportActionBar().setDisplayHomeAsUpEnabled(true);
                getSupportActionBar().setDisplayShowHomeEnabled(true);
            }

            Toast.makeText(this, ""+booknumber, Toast.LENGTH_SHORT).show();

            setData();

            listView =findViewById(R.id.list);

            adapter = new ChapterAdopter(Chapters.this, R.layout.item_listview, stringArrayList);

            listView.setAdapter(adapter);

            listView.setOnItemClickListener(new AdapterView.OnItemClickListener() {
                @Override
                public void onItemClick(AdapterView<?> parent, View view, int position, long id) {

                    int chapternumber=position+1;

                    Toast.makeText(Chapters.this, ""+chapternumber, Toast.LENGTH_SHORT).show();

                    Intent intent=new Intent(Chapters.this,Verse.class);

                  intent.putExtra("Booknumber",booknumber);

                  intent.putExtra("Chapternumber",chapternumber);


               startActivity(intent);
                }
            });

        }



        @Override
        public boolean onOptionsItemSelected(MenuItem item) {
            // handle arrow click here
            if (item.getItemId() == android.R.id.home) {
                onBackPressed();

            }

            return super.onOptionsItemSelected(item);
        }

        @Override
        public boolean onCreateOptionsMenu(Menu menu) {
            // Inflate the menu; this adds items to the action bar if it is present.
            MenuInflater inflater=getMenuInflater();

            inflater.inflate(R.menu.chapter,menu);
            MenuItem menuItem=menu.findItem(R.id.chapter_search);

            SearchView searchView=(SearchView)menuItem.getActionView();



            searchView.setOnQueryTextListener(new SearchView.OnQueryTextListener() {
                @Override
                public boolean onQueryTextSubmit(String s) {
                    return false;
                }

                @Override
                public boolean onQueryTextChange(String s) {
                    return false;
                }
            });
            return  super.onCreateOptionsMenu(menu);
        }

        private void setData() {



            stringArrayList = new ArrayList<>();

            mDBHelper = new DatabaseHelper(this);
            mDb = mDBHelper.getReadableDatabase();

            Cursor cursor = mDb.rawQuery("select DISTINCT c from t_asv where b="+booknumber, new String[]{});


            if(cursor!=null && cursor.getCount() > 0)
            {
                if (cursor.moveToFirst())
                {
                    do {
                        stringArrayList.add(cursor.getString(0));
                    } while (cursor.moveToNext());
                }
            }
        }


    }



package bible.swordof.God;

import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.support.v7.widget.SearchView;
import android.support.v7.widget.Toolbar;
import android.view.Menu;
import android.view.MenuInflater;
import android.view.MenuItem;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.Toast;

import java.util.ArrayList;

public class Verse extends AppCompatActivity {
    private ListView listView;
    private ArrayList<String> stringArrayList;
    private ArrayAdapter<String> adapter;
    private DatabaseHelper mDBHelper;
    private SQLiteDatabase mDb;
    private int booknumber;
    private  int chapternumber;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_verse);
        Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
        Intent mIntent = getIntent();
         booknumber = mIntent.getIntExtra("Booknumber", 0);
        chapternumber= mIntent.getIntExtra("Chapternumber", 0);
        toolbar.setTitle("");
        setSupportActionBar(toolbar);
        if (getSupportActionBar() != null) {
            getSupportActionBar().setDisplayHomeAsUpEnabled(true);
            getSupportActionBar().setDisplayShowHomeEnabled(true);
        }

        setData();

        listView = findViewById(R.id.list);

        adapter = new VerseAdopter(Verse.this, R.layout.item_listview, stringArrayList);


        Toast.makeText(this, ""+booknumber, Toast.LENGTH_SHORT).show();

        listView.setAdapter(adapter);


    }


    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        // handle arrow click here
        if (item.getItemId() == android.R.id.home) {
          onBackPressed();
        }

        return super.onOptionsItemSelected(item);
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        MenuInflater inflater = getMenuInflater();

        inflater.inflate(R.menu.chapter, menu);
        MenuItem menuItem = menu.findItem(R.id.chapter_search);

        SearchView searchView = (SearchView) menuItem.getActionView();


        searchView.setOnQueryTextListener(new SearchView.OnQueryTextListener() {
            @Override
            public boolean onQueryTextSubmit(String s) {
                return false;
            }

            @Override
            public boolean onQueryTextChange(String s) {
                return false;
            }
        });
        return super.onCreateOptionsMenu(menu);
    }

    private void setData() {


        stringArrayList = new ArrayList<>();

        mDBHelper = new DatabaseHelper(this);
        mDb = mDBHelper.getReadableDatabase();

        Cursor cursor = mDb.rawQuery("select  v FROM t_asv where b="+booknumber+" AND c="+chapternumber+";", new String[]{});


        if (cursor != null && cursor.getCount() > 0) {
            if (cursor.moveToFirst()) {
                do {
                    stringArrayList.add(cursor.getString(0));
                } while (cursor.moveToNext());
            }
        }
    }


}

Answer 1

看起来您将所选的诗句作为一个章节传递，然后在查询cursor cursor=mdb.rawquery（“select v FROM t_asv where b=”+booknumber+“和c=”+chapternumber+“；”，new string[]{}）中选择传递的书/章节中的所有诗句。

您可能需要将单击的值作为verse以及book和chapple，并使用在WHERE子句中包含verse的查询，可能是cursor=MDB.rawQuery（“select v FROM t_asv WHERE b=”+booknumber+“和c=”+chapternumber+“和v=”+versenumber+“；”，new string[]{}）；