Android实现搜索功能并本地保存搜索历史记录

package com.cwvs.microlife;

import android.content.Context;
import android.database.sqlite.sqliteDatabase;
import android.database.sqlite.sqliteOpenHelper;

public class RecordsqliteOpenHelper extends sqliteOpenHelper {

  private static String name = "temp.db";
  private static Integer version = 1;

  public RecordsqliteOpenHelper(Context context) {
    super(context,name,null,version);
  }

  @Override
  public void onCreate(sqliteDatabase db) {
    db.execsql("create table records(id INTEGER PRIMary key autoincrement,name varchar(200))");
  }

  @Override
  public void onUpgrade(sqliteDatabase db,int oldVersion,int newVersion) {

  }


}

package com.cwvs.microlife;

import java.util.Date;

import android.app.Activity;
import android.content.Context;
import android.database.cursor;
import android.database.sqlite.sqliteDatabase;
import android.graphics.drawable.Drawable;
import android.os.bundle;
import android.text.Editable;
import android.text.TextWatcher;
import android.view.KeyEvent;
import android.view.View;
import android.view.Window;
import android.view.inputmethod.InputMethodManager;
import android.widget.AdapterView;
import android.widget.baseAdapter;
import android.widget.cursorAdapter;
import android.widget.EditText;
import android.widget.SimplecursorAdapter;
import android.widget.TextView;
import android.widget.Toast;

public class MainActivity extends Activity {

  private EditText et_search;
  private TextView tv_tip;
  private MyListView listView;
  private TextView tv_clear;
  private RecordsqliteOpenHelper Helper = new RecordsqliteOpenHelper(this);;
  private sqliteDatabase db;
  private BaseAdapter adapter;

  @Override
  protected void onCreate(Bundle savedInstanceStatE) {
    super.onCreate(savedInstanceStatE);
    requestWindowFeature(Window.FEATURE_NO_titlE);
    setContentView(R.layout.activity_main);
    // 初始化控件
    initView();

    // 清空搜索历史
    tv_clear.setOnClickListener(new View.onClickListener() {
      @Override
      public void onClick(View v) {
        deleteData();
        queryData("");
      }
    });

    // 搜索框的键盘搜索键点击回调
    et_search.setOnKeyListener(new View.onKeyListener() {// 输入完后按键盘上的搜索键

      public Boolean onKey(View v,int keyCode,KeyEvent event) {
        if (keyCode == KeyEvent.KEYCODE_ENTER && event.getAction() == KeyEvent.ACTION_DOWN) {// 修改回车键功能
          // 先隐藏键盘
          ((InputMethodManager) getSystemservice(Context.INPUT_METHOD_serviCE)).hideSofTinputFromWindow(
              getCurrentFocus().getWindowToken(),InputMethodManager.HIDE_NOT_ALWAYS);
          // 按完搜索键后将当前查询的关键字保存起来,如果该关键字已经存在就不执行保存
          Boolean hasData = hasData(et_search.getText().toString().trim());
          if (!hasData) {
            insertData(et_search.getText().toString().trim());
            queryData("");
          }
          // TODO 根据输入的内容模糊查询商品，并跳转到另一个界面，由你自己去实现
          Toast.makeText(MainActivity.this,"clicked!",Toast.LENGTH_SHORT).show();

        }
        return false;
      }
    });

    // 搜索框的文本变化实时监听
    et_search.addTextChangedListener(new TextWatcher() {
      @Override
      public void beforeTextChanged(CharSequence s,int start,int count,int after) {

      }

      @Override
      public void ontextChanged(CharSequence s,int before,int count) {

      }

      @Override
      public void afterTextChanged(Editable s) {
        if (s.toString().trim().length() == 0) {
          tv_tip.setText("搜索历史");
        } else {
          tv_tip.setText("搜索结果");
        }
        String tempName = et_search.getText().toString();
        // 根据tempName去模糊查询数据库中有没有数据
        queryData(tempName);

      }
    });

    listView.setOnItemClickListener(new AdapterView.onItemClickListener() {
      @Override
      public void onItemClick(AdapterView<?> parent,View view,int position,long id) {
        TextView textView = (TextView) view.findViewById(android.R.id.text1);
        String name = textView.getText().toString();
        et_search.setText(Name);
        Toast.makeText(MainActivity.this,Toast.LENGTH_SHORT).show();
        // TODO 获取到item上面的文字，根据该关键字跳转到另一个页面查询，由你自己去实现
      }
    });

    // 插入数据，便于测试，否则第一次进入没有数据怎么测试呀？
    Date date = new Date();
    long time = date.getTime();
    insertData("Leo" + timE);

    // 第一次进入查询所有的历史记录
    queryData("");
  }

  /**
   * 插入数据
   */
  private void insertData(String tempName) {
    db = Helper.getWritableDatabase();
    db.execsql("insert into records(Name) values('" + tempName + "')");
    db.close();
  }

  /**
   * 模糊查询数据
   */
  private void queryData(String tempName) {
    cursor cursor = Helper.getReadableDatabase().rawQuery(
        "SELEct id as _id,name from records where name like '%" + tempName + "%' order by id desc ",null);
    // 创建adapter适配器对象
    adapter = new SimplecursorAdapter(this,android.R.layout.simple_list_item_1,cursor,new String[] { "name" },new int[] { android.R.id.text1 },cursorAdapter.FLAG_REGISTER_CONTENT_OBSERVER);
    // 设置适配器
    listView.setAdapter(adapter);
    adapter.notifyDataSetChanged();
  }
  /**
   * 检查数据库中是否已经有该条记录
   */
  private Boolean hasData(String tempName) {
    cursor cursor = Helper.getReadableDatabase().rawQuery(
        "SELEct id as _id,name from records where name =?",new String[]{tempNamE});
    //判断是否有下一个
    return cursor.moveToNext();
  }

  /**
   * 清空数据
   */
  private void deleteData() {
    db = Helper.getWritableDatabase();
    db.execsql("delete from records");
    db.close();
  }

  private void initView() {
    et_search = (EditText) findViewById(R.id.et_search);
    tv_tip = (TextView) findViewById(R.id.tv_tip);
    listView = (com.cwvs.microlife.MyListView) findViewById(R.id.listView);
    tv_clear = (TextView) findViewById(R.id.tv_clear);

    // 调整EditText左边的搜索按钮的大小
    Drawable drawable = getresources().getDrawable(R.drawable.search);
    drawable.setBounds(0,60,60);// 第一0是距左边距离，第二0是距上边距离，60分别是长宽
    et_search.setCompoundDrawables(drawable,null);// 只放左边
  }
}

package com.cwvs.microlife;

import android.content.Context;
import android.util.AttributeSet;
import android.widget.ListView;

public class MyListView extends ListView {
  public MyListView(Context context) {
    super(context);
  }

  public MyListView(Context context,AttributeSet attrs) {
    super(context,attrs);
  }

  public MyListView(Context context,AttributeSet attrs,int defStylE) {
    super(context,attrs,defStylE);
  }

  @Override
  protected void onMeasure(int widthMeasureSpec,int heightMeasureSpeC) {
    int expandSpec = MeasureSpec.makeMeasureSpec(Integer.max_value >> 2,MeasureSpec.AT_MOST);
    super.onMeasure(widthMeasureSpec,expandSpec);
  }

}

<LinearLayout xmlns:android="http://scheR_242_11845@as.android.com/apk/res/android"
  xmlns:tools="http://scheR_242_11845@as.android.com/tools"
  android:layout_width="match_parent"
  android:layout_height="match_parent"
  android:focusableInTouchMode="true"
  android:orientation="vertical"
  tools:context="${relativePackagE}.${activityClass}">

  <LinearLayout
    android:layout_width="fill_parent"
    android:layout_height="50dp"
    android:BACkground="#E54141"
    android:orientation="horizontal"
    android:paddingRight="16dp">

    <ImageView
      android:layout_width="45dp"
      android:layout_height="45dp"
      android:layout_gravity="center_vertical"
      android:padding="10dp"
      android:src="@drawable/BACk" />

    <EditText
      android:id="@+id/et_search"
      android:layout_width="0dp"
      android:layout_height="match_parent"
      android:layout_weight="1"
      android:BACkground="@null"
      android:drawableLeft="@drawable/search"
      android:drawablePadding="8dp"
      android:gravity="start|center_vertical"
      android:hint="输入查询的关键字"
      android:imeOptions="actionSearch"
      android:singleLine="true"
      android:textColor="@android:color/white"
      android:textSize="16sp" />

  </LinearLayout>


  <ScrollView
    android:layout_width="wrap_content"
    android:layout_height="wrap_content">

    <LinearLayout
      android:layout_width="match_parent"
      android:layout_height="wrap_content"
      android:orientation="vertical">

      <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:orientation="vertical"
        android:paddingLeft="20dp"

        >

        <TextView
          android:id="@+id/tv_tip"
          android:layout_width="match_parent"
          android:layout_height="50dp"
          android:gravity="left|center_vertical"
          android:text="搜索历史" />

        <View
          android:layout_width="match_parent"
          android:layout_height="1dp"
          android:BACkground="#EEEEEE"></View>

        <com.cwvs.microlife.MyListView
          android:id="@+id/listView"
          android:layout_width="match_parent"
          android:layout_height="wrap_content"></com.cwvs.microlife.MyListView>


      </LinearLayout>

      <View
        android:layout_width="match_parent"
        android:layout_height="1dp"
        android:BACkground="#EEEEEE"></View>

      <TextView
        android:id="@+id/tv_clear"
        android:layout_width="match_parent"
        android:layout_height="40dp"
        android:BACkground="#F6F6F6"
        android:gravity="center"
        android:text="清除搜索历史" />

      <View
        android:layout_width="match_parent"
        android:layout_height="1dp"
        android:layout_marginBottom="20dp"
        android:BACkground="#EEEEEE"></View>
    </LinearLayout>

  </ScrollView>
</LinearLayout>