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 start, 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, name, 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, 0, 60, 60);// 第一0是距左边距离，第二0是距上边距离，60分别是长宽    et_search.setCompoundDrawables(drawable, null, null, 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://schemas.android.com/apk/res/android"  xmlns:tools="http://schemas.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>