SQLLite保存单词到本地数据库中

写一个存储单词的demo。存储再SQLLite数据库中。
步骤：
1、布局：包括两个编辑框分别是单词和汉语意思，点击保存按钮，另一个
是输入关键字进行查询的编辑框，点击查询按钮跳到另外一个activity界面。

2、还用SQLLiteHelper类来实现数据库的版本更新操作，使用SQLLite提供的插入和删除方法

MainActivity.java

package lzl.edu.com.savewords;import android.app.Activity;import android.content.ContentValues;import android.content.Intent;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.os.Bundle;import android.view.View;import android.widget.Button;import android.widget.EditText;import android.widget.Toast;import java.util.ArrayList;import java.util.HashMap;import java.util.Map;public class MainActivity extends Activity implements View.OnClickListener {    EditText mEWord,mEMean,mESearch;    Button mBSave,mBSearch;    MySQLHelper dbSqlHelper;    @Override    protected void onCreate(Bundle savedInstanceState) {        super.onCreate(savedInstanceState);        setContentView(R.layout.activity_main);        //创建数据库对象        dbSqlHelper = new MySQLHelper(this,"mysql.db",1);        mEWord = (EditText) findViewById(R.id.myword_edit);        mEMean = (EditText) findViewById(R.id.mymean_edit);        mESearch = (EditText) findViewById(R.id.mysearch_edit);        mBSave = (Button) findViewById(R.id.save_btn);        mBSearch = (Button) findViewById(R.id.select_btn);        mBSearch.setOnClickListener(this);        mBSave.setOnClickListener(this);    }    @Override    public void onClick(View v) {        switch (v.getId()) {            case R.id.save_btn://插入语句                String word = mEWord.getText().toString();                String mean = mEMean.getText().toString();                long id = saveData(dbSqlHelper.getReadableDatabase(),word,mean);                if(id==-1){                    Toast.makeText(this,"保存失败！",Toast.LENGTH_LONG).show();                }else{                    Toast.makeText(this,"保存成功！",Toast.LENGTH_LONG).show();                }                break;            case R.id.select_btn:                String key = mESearch.getText().toString();                //调用查询语句，返回Cursor类的对象                Cursor cursor = getQuery(dbSqlHelper.getReadableDatabase(),key);                //将Cursor类的数据封装成ArrayList集合。并放到另一个Activity中显示                Intent intent = new Intent(MainActivity.this,DialogActivity.class);                intent.putExtra("data",CursorList(cursor));                startActivity(intent);                break;        }    }    //保存数据到数据库中    public long saveData(SQLiteDatabase db,String word,String mean){        ContentValues values = new ContentValues();        values.put("word",word);        values.put("explain",mean);        long rowid = db.insert("mywords",null,values);        return rowid;    }    //关键字查询数据库中的数据    public Cursor getQuery(SQLiteDatabase db,String key){        Cursor cursor = db.rawQuery("select * from mywords where word like ? or explain like ?",                new String[]{"%" + key + "%", "%" + key + "%"});        return cursor;    }    //将获取的cursor存到List集合中    public ArrayList<Map<String,String>> CursorList(Cursor cursor){        ArrayList<Map<String,String>> list = new ArrayList<Map<String,String>>();        //遍历游标，将数据存储到list集合中        while (cursor.moveToNext()){            Map<String,String> list_item = new HashMap<String,String>();            list_item.put("word",cursor.getString(1));            list_item.put("explain",cursor.getString(2));            list.add(list_item);        }        return list;    }    @Override    protected void onDestroy() {        super.onDestroy();        if(dbSqlHelper!=null)            dbSqlHelper.close();    }}

activity_main.xml

<RelativeLayout 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:paddingLeft="@dimen/activity_horizontal_margin"    android:paddingRight="@dimen/activity_horizontal_margin"    android:paddingTop="@dimen/activity_vertical_margin"    android:paddingBottom="@dimen/activity_vertical_margin" tools:context=".MainActivity"><LinearLayout    android:layout_width="fill_parent"    android:layout_height="fill_parent"    android:orientation="vertical">    <EditText        android:id="@+id/myword_edit"        android:layout_width="fill_parent"        android:layout_height="wrap_content"        android:hint="请输入单词"/>    <EditText        android:id="@+id/mymean_edit"        android:layout_width="fill_parent"        android:layout_height="wrap_content"        android:hint="请输入解释"/>    <Button        android:id="@+id/save_btn"        android:text="保存"        android:layout_width="fill_parent"        android:layout_height="wrap_content" />    <EditText        android:id="@+id/mysearch_edit"        android:layout_width="fill_parent"        android:layout_height="wrap_content"        android:hint="请输入关键词"/>    <Button        android:id="@+id/select_btn"        android:layout_width="fill_parent"        android:layout_height="wrap_content"        android:text="搜索"/></LinearLayout></RelativeLayout>

MySQLHelper.java

package lzl.edu.com.savewords;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;import android.util.Log;/** * Created by admin on 2015/9/26. */public class MySQLHelper extends SQLiteOpenHelper {    final String CRATE_TABLE = "create table mywords (_id integer primary key autoincrement" +            " ,word , explain)";    public MySQLHelper(Context context,String info,int version){        super(context,info,null,version);    }    @Override    public void onCreate(SQLiteDatabase db) {        //第一次创建时使用        db.execSQL(CRATE_TABLE);    }    @Override    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {        //有新版本更新时使用        Log.i("onUpgrade ", "db-----oldversion:" + oldVersion + ",new :" + newVersion);    }}

DialogActivity.java

package lzl.edu.com.savewords;import android.app.Activity;import android.content.Intent;import android.os.Bundle;import android.widget.ListView;import android.widget.SimpleAdapter;import java.util.ArrayList;import java.util.Map;public class DialogActivity extends Activity {    private ListView mListView;    @Override    protected void onCreate(Bundle savedInstanceState) {        super.onCreate(savedInstanceState);        setContentView(R.layout.activity_dialog);        mListView = (ListView)findViewById(R.id.mylistview);       Intent intent = getIntent();        //获取intent中的数据        Bundle data =  intent.getExtras();        //将bundle中的数据强转成List集合        ArrayList<Map<String,String>> arrayList =                (ArrayList<Map<String,String>>)data.getSerializable("data");        SimpleAdapter simpleAdapter = new SimpleAdapter(this,arrayList,R.layout.line                ,new String[]{"word","explain"},new int[]{R.id.word,R.id.explain});        mListView.setAdapter(simpleAdapter);    }}