android實現(xiàn)搜索功能并將搜索結(jié)果保存到SQLite中(實例代碼)

更新時間：2020年04月23日 10:37:08 作者：小李也有春天

這篇文章主要介紹了android實現(xiàn)搜索功能并將搜索結(jié)果保存到SQLite中,本文通過實例代碼給大家介紹的非常詳細，對大家的學習或工作具有一定的參考借鑒價值，需要的朋友可以參考下

運行結(jié)果：

涉及要點：

ListView+EditText+ScrollView實現(xiàn)搜索效果顯示
監(jiān)聽軟鍵盤回車執(zhí)行搜索
使用TextWatcher( )實時篩選
將搜索內(nèi)容存儲到SQLite中（可清空歷史記錄）
監(jiān)聽EditText的焦點，獲得焦點彈出軟鍵盤同時顯示搜索歷史，失去焦點隱藏軟件盤和ListView。

實現(xiàn)過程比較簡單，都是常用的，這里就不講解了。代碼可直接復(fù)制使用。

實現(xiàn)過程：

MainActivity.java

public class MainActivity extends Activity {

 private EditText et_search;
 private TextView tv_tip;
 private MyListView listView;
 private TextView tv_clear;
 ScrollView scrollView;
 private RecordSQLiteOpenHelper helper = new RecordSQLiteOpenHelper(this);
 private SQLiteDatabase db;
 private BaseAdapter adapter;

 @Override
 protected void onCreate(Bundle savedInstanceState) {
 super.onCreate(savedInstanceState);
 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);
   // 按完搜索鍵后將當前查詢的關(guān)鍵字保存起來,如果該關(guān)鍵字已經(jīng)存在就不執(zhí)行保存
   boolean hasData = hasData(et_search.getText().toString().trim());
   if (!hasData) {
   insertData(et_search.getText().toString().trim());
   queryData("");
   }
   Toast.makeText(MainActivity.this, "點擊軟鍵盤搜索!", Toast.LENGTH_SHORT).show();
  }
  return false;
  }
 });

 et_search.setOnFocusChangeListener(new View.OnFocusChangeListener() {
  @Override
  public void onFocusChange(View view, boolean b) {
  if (b) { //獲得
   scrollView.setVisibility(View.VISIBLE);
  } else {//市區(qū)焦點
   scrollView.setVisibility(View.GONE);
  }
  }
 });

 // 搜索框的文本變化實時監(jiān)聽
 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("搜索結(jié)果");
  }
  String tempName = et_search.getText().toString();
  // 根據(jù)tempName去模糊查詢數(shù)據(jù)庫中有沒有數(shù)據(jù)
  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();
  ((InputMethodManager) getSystemService(Context.INPUT_METHOD_SERVICE)).hideSoftInputFromWindow(
   getCurrentFocus().getWindowToken(), InputMethodManager.HIDE_NOT_ALWAYS); //隱藏軟鍵盤
  et_search.clearFocus();
  et_search.setText("");
  }
 });

 // 插入測試數(shù)據(jù)
 Date date = new Date();
 long time = date.getTime();
 insertData("LY" + time);
 queryData(""); // 第一次進入查詢所有的歷史記錄
 }

 /**
 * 插入數(shù)據(jù)
 */
 private void insertData(String tempName) {
 db = helper.getWritableDatabase();
 db.execSQL("insert into records(name) values('" + tempName + "')");
 db.close();
 }

 /**
 * 模糊查詢數(shù)據(jù)
 */
 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);
 // 創(chuàng)建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);
 // 設(shè)置適配器
 listView.setAdapter(adapter);
 adapter.notifyDataSetChanged();
 }

 /**
 * 檢查數(shù)據(jù)庫中是否已經(jīng)有該條記錄
 */
 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();
 }

 /**
 * 清空數(shù)據(jù)
 */
 private void deleteData() {
 db = helper.getWritableDatabase();
 db.execSQL("delete from records");
 db.close();
 }

 private void initView() {
 et_search = (EditText) findViewById(R.id.et_search);
 scrollView = findViewById(R.id.showSearch);
 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);

 // 調(diào)整EditText左邊的搜索按鈕的大小
 Drawable drawable = getResources().getDrawable(R.drawable.search);
 drawable.setBounds(0, 0, 60, 60);// 第一0是距左邊距離，第二0是距上邊距離，60分別是長寬
 et_search.setCompoundDrawables(drawable, null, null, null);// 只放左邊
 }
}

RecordSQLiteOpenHelper.java

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) {

 }
}

MyListView.java

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);
	}
}

activity_main.xml

<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:focusable="true"
 android:focusableInTouchMode="true"
 android:orientation="vertical"
 tools:context=".MainActivity">

 <LinearLayout
 android:layout_width="fill_parent"
 android:layout_height="50dp"
 android:background="#be9999"
 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="fill_parent"
  android:layout_weight="264"
  android:background="@null"
  android:drawableLeft="@drawable/search"
  android:drawablePadding="8dp"
  android:gravity="start|center_vertical"
  android:hint="輸入查詢的關(guān)鍵字"
  android:imeOptions="actionSearch"
  android:singleLine="true"
  android:textColor="@android:color/white"
  android:textSize="16sp" />

 </LinearLayout>

 <ScrollView
 android:id="@+id/showSearch"
 android:layout_width="wrap_content"
 android:layout_height="300dp"
 android:visibility="gone">

 <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" />

  <liyue.edu.cn.ncst.app.MyListView
   android:id="@+id/listView"
   android:layout_width="match_parent"
   android:layout_height="wrap_content" />
  </LinearLayout>

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

  <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" />
 </LinearLayout>

 </ScrollView>

</LinearLayout>

完整代碼下載 demo

到此這篇關(guān)于android實現(xiàn)搜索功能并將搜索結(jié)果保存到SQLite中(實例代碼)的文章就介紹到這了,更多相關(guān)android 搜索功能搜索結(jié)果保存sqlite內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！

您可能感興趣的文章: