AutoCompleteTextView数据库读取

最新推荐文章于 2017-04-10 18:24:11 发布

androidlds

最新推荐文章于 2017-04-10 18:24:11 发布

阅读量3.4k

点赞数

分类专栏： Android开发文章标签：数据库 dropdown service class c

本文链接：https://blog.csdn.net/androidlds/article/details/6955182

版权

Android开发专栏收录该内容

16 篇文章

订阅专栏

本文介绍了如何将数据库数据与Android的AutoCompleteTextView关联，通过自定义CursorAdapter实现当输入时动态查询数据库并显示建议。重点讲解了自定义适配器的编写和使用方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

AutoCompleteTextView从数组里面读取数据很简单，只需使用默认适配器即可，下面我们简单介绍如何将数据库与AutoCompleteTextView关联起来。

1、自定义适配器

public class MyCursorAdapter extends CursorAdapter {
private LayoutInflater layoutInflater;

public MyCursorAdapter(Context context, Cursor c,boolean autoRequery) {
  super(context, c, autoRequery);
  layoutInflater = (LayoutInflater) context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);

}
private void setView(View view, Cursor cursor)
{
  TextView tvWordItem = (TextView) view;
  tvWordItem.setText(cursor.getString(cursor.getColumnIndex("_id")));
}
@Override
public void bindView(View view, Context context, Cursor cursor) {
  // TODO Auto-generated method stub
  setView(view, cursor);
}

@Override
public View newView(Context context, Cursor cursor, ViewGroup parent) {
  // TODO Auto-generated method stub
  final LayoutInflater inflater = LayoutInflater.from(context);
        final TextView view = (TextView) inflater.inflate(
                android.R.layout.simple_dropdown_item_1line, parent, false);
        setView(view, cursor);
        return view;
}

@Override
public CharSequence convertToString(Cursor cursor) {
  // TODO Auto-generated method stub
  return cursor == null?"":cursor.getString(cursor.getColumnIndex("_id"));

}

}

2、调用方式

AutoCompleteTextView actv_lighttype = (AutoCompleteTextView) findViewById(R.id.actv_lighttype);

actv_lighttype.addTextChangedListener(new TextWatcher() {

   @Override
   public void onTextChanged(CharSequence s, int start, int before, int count) {
    // TODO Auto-generated method stub

   }

   @Override
   public void beforeTextChanged(CharSequence s, int start, int count,
     int after) {
    // TODO Auto-generated method stub

   }

   @Override
   public void afterTextChanged(Editable s) {
    // TODO Auto-generated method stub
    String sqlStr="select 某列 as _id from 表名 where 某列 like '"+s.toString()+"%'";
    Cursor cursor=dbhelper.getAllRecordsBySql(sqlStr);
    MyCursorAdapter bltcadapter = new MyCursorAdapter(XXXX.this,cursor,true);
    actv_lighttype.setAdapter(bltcadapter);
   }
  });