写一个存储单词的demo。存储再SQLLite数据库中。
步骤:
1、布局:包括两个编辑框分别是单词和汉语意思,点击保存按钮,另一个
是输入关键字进行查询的编辑框,点击查询按钮跳到另外一个activity界面。
步骤:
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);
}
}