安卓，查询数据时怎么什么也没有查到？

数据库创建成功了，添加数据也成功了。但在查询数据跳转到第二个Activity时是白屏，
什么也没查到，调试的结果是没有进入到while里面去执行，为什么没满足while条件，
怎么改？

DatabaseHelper.java

 package com.exampl.mysql;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;

public class DatabaseHelper extends SQLiteOpenHelper{
    private Context mContext;
    public static final String CREATE_TABLE_SQL="create table dict(_id integer primary key autoincrement,word text,detail text);";

    public DatabaseHelper(Context context,String name,CursorFactory factory,int version)
    {
        super(context,name,factory,version);
        mContext=context;
    }

    public void onCreate(SQLiteDatabase db)
    {
        db.execSQL(CREATE_TABLE_SQL);
        Toast.makeText(mContext,"创建成功!",Toast.LENGTH_LONG).show();
    }

    public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion)
    {

    }


}

MainActivity.java

 package com.exampl.mysql;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;

import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class MainActivity extends Activity implements OnClickListener{
    private Button insert=null;
    private Button search=null;
    private EditText word=null;
    private EditText detail=null;
    private EditText key=null;
    DatabaseHelper dbHelper;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        dbHelper=new DatabaseHelper(this,"myDict.db3",null,1);
        insert=(Button)findViewById(R.id.insert);
        insert.setOnClickListener(this);
        search=(Button)findViewById(R.id.search);
        search.setOnClickListener(this);
        word=(EditText)findViewById(R.id.word);
        detail=(EditText)findViewById(R.id.detail);
        key=(EditText)findViewById(R.id.key);
    }

    @Override
    public void onClick(View v) {
        switch (v.getId()) {
        case R.id.insert:
            String wor=word.getText().toString().trim();
            String det=detail.getText().toString().trim();
            insertData(dbHelper.getReadableDatabase(),wor,det);
            Toast.makeText(this, "添加生词成功!", Toast.LENGTH_LONG).show();
            break;
        case R.id.search:
            String ke=key.getText().toString().trim();
            Cursor cursor=dbHelper.getReadableDatabase().rawQuery("select*from dict where ? or ?", new String[]{"%"+ke+"%","%"+ke+"%"});
            Bundle data=new Bundle();
            data.putSerializable("date", converCursorToList(cursor));
            Intent intent=new Intent(MainActivity.this,Result.class);
            intent.putExtras(data);
            startActivity(intent);
            break;
        default:break;
        }
    }

    protected ArrayList<Map<String,String>> converCursorToList(Cursor cursor)
    {
        ArrayList<Map<String,String>> result=new ArrayList<Map<String,String>>();
        while (cursor.moveToNext())
        {
            Map<String,String> map=new HashMap<String,String>();
            map.put("word", cursor.getString(1));
            map.put("detail", cursor.getString(2));
            result.add(map);
        }
        return result;
    }

    private void insertData(SQLiteDatabase db,String word,String detail)
    {
        db.execSQL("insert into dict(word,detail) values(?,?)",new String[]{word,detail});
    }

    @Override
    public void onDestroy()
    {
        super.onDestroy();
        if (dbHelper!=null)
            dbHelper.close();
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.main, menu);
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        // Handle action bar item clicks here. The action bar will
        // automatically handle clicks on the Home/Up button, so long
        // as you specify a parent activity in AndroidManifest.xml.
        int id = item.getItemId();
        if (id == R.id.action_settings) {
            return true;
        }
        return super.onOptionsItemSelected(item);
    }
}

Result.java

 package com.exampl.mysql;

import android.app.Activity;
import android.os.Bundle;
import android.widget.TextView;

public class Result extends Activity {
    private TextView jieguo=null;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.line);
        jieguo=(TextView)findViewById(R.id.jieguo);
        Bundle bundle=getIntent().getExtras();
        jieguo.setText(bundle.getString("date"));
    }

}

首先，你的sql语句不对，你可以依照楼上这位大神的方法修改你的sql语句，这样的话大概就能解决你所说的while()循环不执行的问题；
再一个，我照你的代码大概的跑了一遍，第二个界面之所以不显示任何信息是因为你的bundle用的不对。我不知道你为什么要传List，还要嵌套Map集合
但是就算是非这样不可，跳转后的界面我觉得因该这样实现
不知道能不能解决你的问题。

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:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context="com.exampl.mysql.MainActivity"
    android:orientation="vertical" >

    <EditText
        android:inputType="text"
        android:id="@+id/word"
        android:layout_width="match_parent"
        android:layout_height="wrap_content" />
    <EditText
        android:inputType="text"
        android:id="@+id/detail"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:lines="3" />
    <Button
        android:id="@+id/insert"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="@string/insert" />
    <EditText
        android:inputType="text"
        android:id="@+id/key"
        android:layout_width="match_parent"
        android:layout_height="wrap_content" />
    <Button
        android:id="@+id/search"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="@string/search" />
    <ListView 
        android:id="@+id/show"
        android:layout_width="match_parent"
        android:layout_height="match_parent">

    </ListView>


</LinearLayout>

line.xml

 <?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical" >

    <TextView
        android:id="@+id/jieguo"
        android:layout_width="match_parent"
        android:layout_height="wrap_content" />


</LinearLayout>

AndroidManifest.xml

 <?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.exampl.mysql"
    android:versionCode="1"
    android:versionName="1.0" >

    <uses-sdk
        android:minSdkVersion="8"
        android:targetSdkVersion="21" />

    <application
        android:allowBackup="true"
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name"
        android:theme="@style/AppTheme" >
        <activity
            android:name=".MainActivity"
            android:label="@string/app_name" >
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>

        <activity
            android:name=".Result"
            android:label="@string/app_name" >
        </activity>

    </application>

</manifest>

那段程序没有执行 说明不满足while循环条件

Cursor cursor=dbHelper.getReadableDatabase().rawQuery("select*from dict where ? or ?", new String[]{"%"+ke+"%","%"+ke+"%"});是不是sql语句出错了，*这里

你的sql语句不对，你写的这条语句是select * from dict where %ke% or %ke%?，这个where后面都不是判断语句。猜测你想做的功能，应该是detail查找word或者detail字段符合用户输入的数据，应该这样写：
Cursor cursor=dbHelper.getReadableDatabase().rawQuery("select * from dict where word = ？ or detail = ？", new String[]{ke, ke});

按楼上的改法运行如下:

我自己修改了下Result.java文件:

 package com.exampl.mysql;

import java.util.ArrayList;
import java.util.Map;

import android.app.ListActivity;
import android.content.Intent;
import android.os.Bundle;
import android.widget.SimpleAdapter;

public class Result extends ListActivity {
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        getListView();
        Intent inte=getIntent();
        ArrayList<Map<String,String>> tResult=(ArrayList<Map<String,String>>)inte.getSerializableExtra("date");
        SimpleAdapter adapter=new SimpleAdapter(this,tResult,android.R.layout.simple_list_item_2,new String[]{"word","detail"},new int[]{android.R.id.text1,android.R.id.text2});        
        setListAdapter(adapter);
    }

}

运行如下:

这个效果是不是好点