android SQLite(单词的添加与查询应用)

本人小白，刚接触android，为方便记忆，将平时练习的代码写下来，跟大家分享，也希望大神批评指正。

这个实例主要用到的SQLite数据库的操作，可以向数据库添加单词，查询，修改以及删除单词，描述如有不当之处，还请帮忙纠正，下面上源码。

------------------------------------------我是邪恶的分割线----------------------------------------------

下面是java文件

1.创建数据库：

　　

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DatabaseHelper extends SQLiteOpenHelper {
    
    //定义创建数据表的语句
    private static final String CREATE_TABLES="create table word_dic(_id INTEGERT PRIMARY KEY AUTOINCREMENT,word,detail)";
    
    //定义构造函数
    public DatabaseHelper(Context context,String name,int version){
        super(context,name,null,version);
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL(CREATE_TABLES);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {
        // TODO Auto-generated method stub

    }

}

2.创建界面UI

　　

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

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.Menu;
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 {
    private EditText word;
    private EditText detail;
    private Button insert;
    private Button query;
    private Button update;
    private Button delete;
    DatabaseHelper dbHelper=null;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        
        //获取控件对象
        word=(EditText)findViewById(R.id.word);
        detail=(EditText)findViewById(R.id.detail);
        insert=(Button)findViewById(R.id.insert);
        query=(Button)findViewById(R.id.query);
        update=(Button)findViewById(R.id.update);
        delete=(Button)findViewById(R.id.delete);
        
        //生成DatabaseHelper对象
        dbHelper=new DatabaseHelper(MainActivity.this,"english_db",1);
        
        //两个EditText用来获取用户的输入
        //String wordStr=word.getText().toString();
        //String detailStr=detail.getText().toString();
        
        //**************************
        //为按钮绑定相应的监听器
        //**************************
        
        //添加单词
        insert.setOnClickListener(new OnClickListener() {
            
            @Override
            public void onClick(View v) {
                // TODO Auto-generated method stub
                SQLiteDatabase db=dbHelper.getWritableDatabase();
                String wordStr=word.getText().toString();
                String detailStr=detail.getText().toString();
                ContentValues values=new ContentValues();
                values.put("word", wordStr);
                values.put("detail", detailStr);
                db.insert("word_dic", null, values);
                Toast.makeText(MainActivity.this, "添加单词成功", Toast.LENGTH_LONG).show();
            }
        });
        
        //查询单词
        query.setOnClickListener(new OnClickListener() {
            
            @Override
            public void onClick(View v) {
                // TODO Auto-generated method stub
                SQLiteDatabase db=dbHelper.getReadableDatabase();
                String wordStr=word.getText().toString();
                
                Cursor cursor=db.query("word_dic", new String[]{"_id","word","detail"}, "word like ?", 
                        new String[]{wordStr},null, null, null);
                ArrayList<HashMap<String, String>> list=new ArrayList<HashMap<String,String>>();
                while(cursor.moveToNext()){
                    HashMap<String, String> map=new HashMap<String, String>();
                    map.put("word", cursor.getString(cursor.getColumnIndex("word")));
                    map.put("detail", cursor.getString(cursor.getColumnIndex("detail")));
                    list.add(map);
                }
                Intent intent=new Intent(MainActivity.this,OtherActivity.class);
                Bundle bundle=new Bundle();
                bundle.putSerializable("data", list);
                intent.putExtras(bundle);
                startActivity(intent);
            }
        });
        
        //修改单词
        update.setOnClickListener(new OnClickListener() {
            
            @Override
            public void onClick(View v) {
                // TODO Auto-generated method stub
                SQLiteDatabase db=dbHelper.getWritableDatabase();
                String wordStr=word.getText().toString();
                String detailStr=detail.getText().toString();
                ContentValues values=new ContentValues();
                values.put("word", wordStr);
                values.put("detail", detailStr);
                db.update("word_dic", values, "word like ?", new String[]{wordStr});
                Toast.makeText(MainActivity.this, "单词已更新", Toast.LENGTH_LONG).show();
            }
        });
        
        //删除单词
        delete.setOnClickListener(new OnClickListener() {
            
            @Override
            public void onClick(View v) {
                // TODO Auto-generated method stub
                SQLiteDatabase db=dbHelper.getWritableDatabase();
                String wordStr=word.getText().toString();
                
                db.delete("word_dic", "word like ?", new String[]{wordStr});
                Toast.makeText(MainActivity.this, "单词已删除", Toast.LENGTH_LONG).show();
            }
        });
    }

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

}

3.创建查询结果的ACTIVITY:

　　

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

import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.widget.ListView;
import android.widget.SimpleAdapter;

public class OtherActivity extends Activity {
    private ListView listView;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        // TODO Auto-generated method stub
        super.onCreate(savedInstanceState);
        setContentView(R.layout.result);
        
        listView=(ListView)findViewById(R.id.listView);
        Intent intent=getIntent();
        Bundle bundle=intent.getExtras();
        
        @SuppressWarnings("unchecked")
        ArrayList<HashMap<String, String>> list=(ArrayList<HashMap<String,String>>)bundle.getSerializable("data");
        SimpleAdapter adapter=new SimpleAdapter(this, list, R.layout.option, new String[]{"word","detail"}, 
                new int[]{R.id.wordShow,R.id.detailShow});
        listView.setAdapter(adapter);
    }

}

*********************************以下是用到的资源文件*********************************************

1.main.xml:

<TableLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent" >
    <TableRow android:paddingLeft="10dp">
        <TextView
            android:layout_width="50dp"
            android:layout_height="wrap_content"
            android:text="单词:"
            android:textSize="16sp"
            />
        <EditText
            android:id="@+id/word"
            android:layout_width="250dp"
            android:layout_height="wrap_content"
            android:selectAllOnFocus="true"
            android:hint="请输入单词"
            />
    </TableRow>
    <TableRow android:paddingLeft="10dp">
        <TextView
            android:layout_width="50dp"
            android:layout_height="wrap_content"
            android:text="释意:"
            android:textSize="16sp"
            />
        <EditText
            android:id="@+id/detail"
            android:layout_width="250dp"
            android:layout_height="wrap_content"
            android:selectAllOnFocus="true"
            android:hint="请输入单词的解释"
            />
    </TableRow>
    <Button
        android:id="@+id/insert"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="添加单词"
        />
    <Button
        android:id="@+id/query"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="查询单词"
        />
    <Button
        android:id="@+id/update"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="修改单词"
        />
    <Button
        android:id="@+id/delete"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="删除单词"
        />
</TableLayout>

2.result.xml:

　　

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:orientation="vertical" >

    <ListView
        android:id="@+id/listView"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content" >
    </ListView>

</LinearLayout>

3.option.xml:

　　

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent" >

    <TextView
        android:id="@+id/wordShow"
        android:layout_width="100dp"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true"
        />

    <TextView
        android:id="@+id/detailShow"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentRight="true"
        android:layout_alignParentTop="true"
        android:layout_toRightOf="@+id/wordShow"
        />

</RelativeLayout>