<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    tools:context=".AddDanciActivity">
 
    <EditText
        android:id="@+id/addword_edit"
        android:layout_width="match_parent"
        android:layout_height="60dp"
        android:layout_marginTop="20dp"
        android:hint="單詞:"
        android:textColor="@android:color/black"
        android:textColorHint="#DCDCDC"
        android:textSize="30dp" />
 
    <EditText
        android:id="@+id/fanyiword_edit"
        android:layout_width="match_parent"
        android:layout_height="60dp"
        android:hint="解釋:"
        android:textColor="@android:color/black"
        android:textColorHint="#DCDCDC"
        android:textSize="30dp" />
 
    <RelativeLayout
        android:layout_width="match_parent"
        android:layout_height="match_parent"
        android:layout_alignParentBottom = "true"
        android:layout_margin="5dp">
    <ListView
        android:id="@+id/add_list"
        android:layout_width="match_parent"
        android:layout_height="match_parent"
        android:textColor="@android:color/black"
        android:textColorHint="#DCDCDC"
        android:textSize="30dp"
        android:layout_above="@id/lineLayout"
        />
 
        <LinearLayout
            android:layout_height="50dp"
            android:layout_width="match_parent"
            android:id="@+id/lineLayout"
            android:layout_alignParentBottom="true"
            android:orientation="horizontal"
            android:gravity="center_horizontal"
            >
        <Button
            android:layout_width="100dp"
            android:layout_height="50dp"
            android:id="@+id/add_btn"
            android:text="添加" />
        <Button
            android:layout_width="100dp"
            android:layout_height="50dp"
            android:layout_centerHorizontal="true"
            android:id="@+id/shanchu_btn"
            android:layout_gravity="center_vertical"
            android:text="刪除" />
        <Button
            android:layout_width="100dp"
            android:layout_height="50dp"
            android:id="@+id/quxiao_btn"
            android:layout_gravity="right"
            android:text="取消" />
        </LinearLayout>
 
    </RelativeLayout>
 
</LinearLayout>

import androidx.appcompat.app.AppCompatActivity;
import android.content.ContentValues;
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.ListView;
import android.widget.SimpleAdapter;
import android.widget.Toast;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;
 
public class AddDanciActivity extends AppCompatActivity {
 
    private EditText wordedit;
    private EditText yisiedit;
    private Button add_btn;
    private Button quxiao_btn;
    private Button shanchu_btn;
    private ListView listview;
    private DBOpenHelper dbOpenHelper;//聲明
 
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_add_danci);
        dbOpenHelper = new DBOpenHelper(AddDanciActivity.this, "db_dict", null, 1);//實(shí)例化，創(chuàng)建數(shù)據(jù)庫(kù)
        wordedit = (EditText) findViewById(R.id.addword_edit);
        yisiedit = (EditText) findViewById(R.id.fanyiword_edit);
        listview = (ListView) findViewById(R.id.add_list);
        add_btn = (Button) findViewById(R.id.add_btn);
        quxiao_btn = (Button) findViewById(R.id.quxiao_btn);
        shanchu_btn = (Button) findViewById(R.id.shanchu_btn);
        quxiao_btn.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Toast.makeText(AddDanciActivity.this, "返回單詞本主界面", Toast.LENGTH_SHORT).show();
                finish();
            }
        });
 
        shanchu_btn.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                String word = wordedit.getText().toString();
                String ys = yisiedit.getText().toString();
                if (word.equals("")) {
                    Toast.makeText(AddDanciActivity.this, "填寫(xiě)的單詞為空", Toast.LENGTH_SHORT).show();
                } else {
                    deleteData(dbOpenHelper.getReadableDatabase(), word);
                    Toast.makeText(AddDanciActivity.this, "刪除成功", Toast.LENGTH_SHORT).show();
                }
            }
        });
 
        add_btn.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                String word = wordedit.getText().toString();
                String ys = yisiedit.getText().toString();
                if (word.equals("") || ys.equals("")) {
                    Toast.makeText(AddDanciActivity.this, "填寫(xiě)的單詞或解釋為空", Toast.LENGTH_SHORT).show();
                } else {
                    insertData(dbOpenHelper.getReadableDatabase(), word, ys);//插入生詞
                    Toast.makeText(AddDanciActivity.this, "添加生詞成功", Toast.LENGTH_SHORT).show();
                    renew();
                }
            }
        });
    }
 
    //插入數(shù)據(jù)的方法
    private void insertData(SQLiteDatabase sqLiteDatabase, String word, String ys) {
        ContentValues values = new ContentValues();
        values.put("word", word);//保存單詞
        values.put("detail", ys);
        sqLiteDatabase.insert("tb_dict", null, values);//執(zhí)行插入操作
        renew();
    }
 
    private void deleteData(SQLiteDatabase sqLiteDatabase, String word) {
        ContentValues values = new ContentValues();
        String[] args = {String.valueOf(word)};
        sqLiteDatabase.delete("tb_dict", "word=?", args);//執(zhí)行刪除操作
        renew();
    }
 
 
    @Override
    protected void onDestroy() {
        super.onDestroy();
        if (dbOpenHelper != null) {
            dbOpenHelper.close();//關(guān)閉
        }
    }
 
    public void renew() {
        Cursor cursor = dbOpenHelper.getReadableDatabase().query("tb_dict", null, null, null, null, null, null);
        ArrayList<Map<String, String>> resultList = new ArrayList<Map<String, String>>();
        while (cursor.moveToNext()) {
            Map<String, String> map = new HashMap<String, String>();
            map.put("word", cursor.getString(1));
            map.put("interpret", cursor.getString(2));
            resultList.add(map);
        }
 
        if (resultList == null || resultList.size() == 0) {
            Toast.makeText(AddDanciActivity.this, "很遺憾，沒(méi)有相關(guān)記錄！", Toast.LENGTH_SHORT).show();
        } else {
            SimpleAdapter simpleAdapter = new SimpleAdapter(AddDanciActivity.this, resultList, R.layout.item, new String[]{"word", "interpret"
            }, new int[]{R.id.textView, R.id.textView2});
            listview.setAdapter(simpleAdapter);
        }
    }
 
    @Override
    protected void onStart() {
        super.onStart();
        renew();
    }
}

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
import androidx.annotation.Nullable;
 
public class DBOpenHelper extends SQLiteOpenHelper {
 
    final String CREATE_TABLE_SQL = "create table tb_dict (_id integer primary key autoincrement,word,detail)";//定義創(chuàng)建表的
 
    public DBOpenHelper(@Nullable Context context, @Nullable String name, @Nullable SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, null, version);
    }
 
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_TABLE_SQL);//創(chuàng)建單詞的數(shù)據(jù)表
    }
 
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        Log.i("詞典", "--版本更新" + oldVersion + "-->" + newVersion);
    }
}