搜索从SQLite数据库的值和检索列表视图 [英] search a value from sqlite database and retrieve in listview

问题描述

如何找到 SQLite数据库的确切数据和检索一个 listactivity ？我想是这样，但我没有得到的值。

 搜索=（EditText上）findViewById（R.id.alertsearch）;

sea​​rch.addTextChangedListener（新TextWatcher（）{

        @覆盖
        公共无效afterTextChanged（编辑S）{
            // TODO自动生成方法存根
            list2.clear（）;
            DB = openOrCreateDatabase（Contactsnew.DB_NAME，MODE_PRIVATE，NULL）;
            光标cTitle = db.rawQuery（SELECT * FROM+ Contactsnew.TABLE02 +WHERE
                    + Contactsnew.userid +=+ GetSet.getUserId（）+和+ + Contactsnew.TITLE
                     怎么样？，新的String [] {search.getText（）+％}）;
            custAdapter.changeCursor（cTitle）;

            而（cTitle.moveToNext（））{
                list2.add（cTitle.getString（2））;
                }
            cTitle.close（）;
        }
 

解决方案

在你sqliteconnecter创建一个方法，并呼吁在各自的类方法。现在霍尔电压传感器以下code在乌拉圭回合源码级的，

 光标cusror;

光标= db.rawQuery（SELECT * FROM+ Contactsnew.TABLE02 +WHERE
                + Contactsnew.userid +=+ Contactsnew.userId +和+ + Contactsnew.TITLE
                 LIKE'+ search.getText（）+％'）;
 

打印查询字符串，并检查您是否得到了正确的值，然后返回光标。

试试这个，说!!

How to find the exact data in sqlite database and retrieve it in a listactivity? I tried like this but I didn't get the value.

search = (EditText) findViewById(R.id.alertsearch);

search.addTextChangedListener(new TextWatcher(){

        @Override
        public void afterTextChanged(Editable s) {
            // TODO Auto-generated method stub
            list2.clear();
            db =  openOrCreateDatabase(Contactsnew.DB_NAME, MODE_PRIVATE, null);
            Cursor cTitle=db.rawQuery(" SELECT * FROM "+ Contactsnew.TABLE02 + " WHERE " 
                    + Contactsnew.userid + " = " + GetSet.getUserId() + " AND " + Contactsnew.TITLE +
                     " LIKE ? " ,new String []{search.getText()+"%"});
            custAdapter.changeCursor(cTitle);

            while(cTitle.moveToNext()){
                list2.add(cTitle.getString(2));
                }
            cTitle.close();
        }

解决方案

In your sqliteconnecter create a method and call that method in your respective class. Now typr the following code in ur sqlite class,

Cursor cusror;

cursor=db.rawQuery("SELECT * FROM "+ Contactsnew.TABLE02 + " WHERE " 
                + Contactsnew.userid + " = " + Contactsnew.userId + " AND " + Contactsnew.TITLE +
                 " LIKE  '"+search.getText()+"%'");

print the query in a string and check whether you are getting the correct values, then return the cursor.

try this and say!!

这篇关于搜索从SQLite数据库的值和检索列表视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！