android query 模糊查詢

標籤：

package com.example.utils;     import java.util.ArrayList;  import android.content.ContentValues;  import android.content.Context;  import android.database.Cursor;  import android.database.sqlite.SQLiteDatabase;  import android.database.sqlite.SQLiteOpenHelper;  import android.util.Log;  public class DBManage extends SQLiteOpenHelper {         static int init_version = 1;      static String database_name = "android_sqlite_test.db";      static String tab_name = "uer_log";      static String tab_field01 = "_id";      static String tab_field02 = "log_name";      SQLiteDatabase mDatabase;         public DBManage(Context context) {          super(context, database_name, null, init_version);          // TODO Auto-generated constructor stub          mDatabase = getWritableDatabase();      }  @Override      public void onCreate(SQLiteDatabase db) {          // TODO Auto-generated method stub          String sql = "create table " + tab_name + " ( " + tab_field01                  + " integer primary key , " + tab_field02 + " text  not null) ";             db.execSQL(sql);      }         @Override      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {          // TODO Auto-generated method stub         }         /**      * 插入記錄      *      * @param u      * @return      */      public boolean insertData(String... str) {             int request_int = 0;          for (int i = 0; i < str.length; i++) {                 // 執行個體化一個ContentValues 對象 ,作用，收集資料，方便於SQLite執行增，刪，改，查              ContentValues contentValues = new ContentValues();              contentValues.put(tab_field02, str);              mDatabase.insert(tab_name, null, contentValues);              request_int++;          }          return str.length == request_int;      }         // 根據條件模糊查詢資料庫資料      public ArrayList<String> query(int top_int, String... str) {          ArrayList<String> result_list = new ArrayList<String>();          mDatabase = getReadableDatabase();          //模糊查詢的三種方式：  /* * 全部查詢         String current_sql_sel = "SELECT  * FROM " + tab_name;         Cursor c = mDatabase.rawQuery(current_sql_sel, null);*/  //1.使用這種query方法%號前不能加‘ ;          Cursor c_test = mDatabase.query(tab_name, new String[]{tab_field02}, tab_field02+"  LIKE ? ",                  new String[] { "%" + str[0] + "%" }, null, null, null);                     //2.使用這種query方法%號前必須加‘  ;      //  Cursor  c_test=mDatabase.query(tab_name, new String[]{tab_field02},tab_field02+"  like ‘%" + str[0] + "%‘", null, null, null, null);                 //3.使用這種方式必須在%號前加‘  ;          String current_sql_sel = "SELECT  * FROM "+tab_name +" where "+tab_field02+" like ‘%"+str[0]+"%‘";          //Cursor c_test = mDatabase.rawQuery(current_sql_sel, null);  Log.e("tag", "查詢完成...");          while (c_test.moveToNext()) {              String name = c_test.getString(c_test.getColumnIndex(tab_field02));              //name.contains(str[0]);              // 讓集合中的資料不重複;              if (!result_list.contains(name)) {                  result_list.add(name);                   Log.e("tag", name);              }          }          c_test.close();             return result_list;      }     }

Db.rawQuery(sql,selectionArgs);sql ="selcet * from where  欄位 like ‘% "+datestr+" %‘ "; //sql語句

 

android query 模糊查詢