可参考Android 中对 ListView 中 进行增删改查
完成效果如图所示:
GoodActivity
package com.example.sqlitedemo;
import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.text.TextUtils;
import android.view.View;
import android.widget.Adapter;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.Toast;
import androidx.annotation.NonNull;
import androidx.annotation.Nullable;
import com.example.sqlitedemo.adapter.MyAdapter;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Iterator;
import java.util.List;
import java.util.ListIterator;
public class GoodActivity extends Activity {
Button btnAdd,btnfindall;
EditText etGname;
EditText etGprice;
GoodDao goodDao;
MyAdapter myAdapter;
List<GoodBean> goodlist;
@Override
protected void onCreate(@Nullable Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_goods);
goodDao = new GoodDao(this);
btnAdd = findViewById(R.id.btn_add);
etGname = findViewById(R.id.et_name);
etGprice = findViewById(R.id.et_price);
btnfindall = findViewById(R.id.btn_findall);
btnAdd.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
String goodname = etGname.getText().toString();
String price = etGprice.getText().toString();
if (!(TextUtils.isEmpty(goodname)||TextUtils.isEmpty(price))){
int goodprice = Integer.valueOf(price);
boolean flag = goodDao.insertGood(goodname,goodprice);
if(flag){
Toast.makeText(getApplicationContext(),"添加成功",Toast.LENGTH_SHORT).show();
}else {
Toast.makeText(getApplicationContext(),"该商品已存在!",Toast.LENGTH_SHORT).show();
}
}else {
Toast.makeText(getApplicationContext(),"请输入相关信息",Toast.LENGTH_SHORT).show();
}
}
});
btnfindall.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
Intent intent = new Intent();
intent.setClass(GoodActivity.this,ListViewActivity.class);
startActivity(intent);
}
});
}
}
GoodDao
package com.example.sqlitedemo;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.text.TextUtils;
import android.util.Log;
import android.widget.Toast;
import java.util.ArrayList;
import java.util.List;
public class GoodDao {