一、效果展示
点击第一项查看详情
修改其信息
保存修改
再次查看详情
删除该账目
二、问题
对于下拉框组件的值的从数据库获取并赋值并不清楚,还有点击事件的失效情况与布局之间的关联
三、部分原码
activity_info.xml
<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="vertical" android:layout_width="match_parent" android:background="@mipmap/info" android:layout_height="match_parent"> <TextView android:layout_width="wrap_content" android:text="账目信息" android:textSize="50sp" android:layout_gravity="center" android:layout_height="wrap_content"/> <RelativeLayout android:layout_width="wrap_content" android:layout_gravity="center" android:layout_marginTop="40dp" android:layout_height="wrap_content"> <TextView android:id="@+id/update_type" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="账目类型" android:textSize="20sp" /> <TextView android:id="@+id/type_spin" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_marginLeft="20dp" android:layout_toRightOf="@+id/update_type" /> </RelativeLayout> <EditText android:id="@+id/bill_money" android:layout_marginTop="20dp" android:layout_width="250dp" android:hint="请输入账目金额" android:inputType="number" android:layout_gravity="center" android:layout_height="wrap_content"/> <TextView android:id="@+id/bill_date" android:layout_marginTop="20dp" android:layout_width="250dp" android:hint="请输入账目日期" android:inputType="date" android:textSize="18dp" android:layout_gravity="center" android:layout_height="wrap_content"/> <EditText android:id="@+id/bill_remark" android:layout_width="250dp" android:layout_marginTop="20dp" android:layout_gravity="center" android:hint="在此处添加备注" android:layout_height="wrap_content"/> <RelativeLayout android:layout_width="wrap_content" android:layout_marginTop="20dp" android:layout_gravity="center" android:layout_height="wrap_content"> <Button android:id="@+id/update_btn" android:layout_width="wrap_content" android:text="保存修改" android:layout_gravity="left" android:layout_height="wrap_content"/> <Button android:id="@+id/delete_btn" android:layout_width="wrap_content" android:layout_toRightOf="@+id/update_btn" android:layout_marginLeft="20dp" android:text="删除该账目" android:layout_height="wrap_content"/> </RelativeLayout> </LinearLayout>
QueryAllActivity.java
package com.example.familybook; import android.annotation.SuppressLint; import android.app.Activity; import android.content.Intent; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.AdapterView; import android.widget.ArrayAdapter; import android.widget.LinearLayout; import android.widget.ListView; import android.widget.ScrollView; import android.widget.TextView; import android.widget.Toast; import androidx.annotation.Nullable; import com.example.familybook.dao.BillDaoImpl; import com.example.familybook.dao.IBillDao; import com.example.familybook.entity.Bill; import com.example.familybook.utils.ShowBillsAdapter; import com.example.familybook.utils.ViewHolder; import java.util.List; public class QueryAllActivity extends Activity { private String mUsername; private String TAG="QueryAllActivity"; private List <Bill> mShowBills; private List <ViewHolder> mViewHolder; private IBillDao mIBillDao; private SQLiteOpenHelper mBillDatabaseHelper; private ListView mShowBillList; private int mInfoCode=1; @Override protected void onCreate(@Nullable Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_list); this.setTitle("总览账目信息"); //获取登录者的用户名 Intent intent =getIntent(); mUsername =intent.getStringExtra("username"); Log.e(TAG,"使用者:"+mUsername); //初始化控件 initView(); //获取表格布局 mShowBillList=(ListView)findViewById(R.id.list_View); //获取从数据库获得的表单 mShowBills=mIBillDao.listAllBill(mUsername); //新建并配置Show ShowBillsAdapter ShowAdapter=new ShowBillsAdapter(mShowBills,this); mShowBillList.setAdapter(ShowAdapter); //添加事件监听 initListener(); } private void initListener() { mShowBillList.setOnItemClickListener(new AdapterView.OnItemClickListener() { @Override public void onItemClick(AdapterView<?> parent, View view, int position, long id) { Bill bill =mShowBills.get(position); int bill_id=bill.get_id(); Intent intent=new Intent(); intent.putExtra("username",mUsername); intent.putExtra("bill_id",bill_id); intent.setClass(QueryAllActivity.this,InfoActivity.class); startActivityForResult(intent,mInfoCode); } }); } private void initView() { mIBillDao =new BillDaoImpl(QueryAllActivity.this); } /** * 返回的结果在这里回调 * @param requestCode * @param resultCode * @param data */ @Override protected void onActivityResult(int requestCode, int resultCode, Intent data) { super.onActivityResult(requestCode, resultCode, data); String resultContent = null; //当我们判断这个请求码的时候,就知道,这是哪个界面返回的结果 if (requestCode==mInfoCode) { if(resultCode==2){ //注册成功 Toast.makeText(this,"修改成功",Toast.LENGTH_SHORT).show(); }else if(requestCode==3){ //删除成功 Toast.makeText(this,"删除成功",Toast.LENGTH_SHORT).show(); } } } }
InfoActivity.java
package com.example.familybook; import android.app.Activity; import android.app.DatePickerDialog; import android.content.Intent; import android.os.Bundle; import android.text.TextUtils; import android.util.Log; import android.view.View; import android.widget.Adapter; import android.widget.AdapterView; import android.widget.Button; import android.widget.DatePicker; import android.widget.EditText; import android.widget.Spinner; import android.widget.TextView; import android.widget.Toast; import androidx.annotation.Nullable; import com.example.familybook.dao.BillDaoImpl; import com.example.familybook.dao.IBillDao; import com.example.familybook.entity.Bill; import java.util.Calendar; public class InfoActivity extends Activity { private Bill mBill; private String mUsername; private int mBillID; private int mYear; private int mMonth; private int mDay; private TextView mTypeSpin; private EditText mMoney; private TextView mDate; private EditText mRemark; private Button mUpdateBillBtn; private Button mDeleteBillBtn; private IBillDao mIBillDao; private String mTypeText; private String TAG="InfoActivity"; @Override protected void onCreate(@Nullable Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_info); //获取登录者的用户名 Intent intent =getIntent(); mUsername =intent.getStringExtra("username"); mBillID =intent.getIntExtra("bill_id",mBillID); Log.e(TAG,"使用者:"+mUsername); Log.e(TAG,"账单号:"+mBillID); //获取时间 initDate(); //初始化控件 initView(); //从数据库获取信息,并完成信息初始化 mBill=mIBillDao.QueryBill(mBillID); initInfo(); //添加监听事件 initListener(); } private void initInfo() { mTypeSpin.setText(mBill.getType()); mMoney.setText(mBill.getMoney()); mDate.setText(mBill.getDate()); mRemark.setText(mBill.getRemark()); } private void initDate() { //获取当前时间 Calendar ca = Calendar.getInstance(); mYear = ca.get(Calendar.YEAR); mMonth = ca.get(Calendar.MONTH); mDay = ca.get(Calendar.DAY_OF_MONTH); } private void initListener() { mDate.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { //调用时间选择器 DatePickerDialog datePickerDialog = new DatePickerDialog(InfoActivity.this, R.style.MyDatePickerDialogTheme, onDateSetListener, mYear, mMonth, mDay); //获取时间戳 long timeStamp = System.currentTimeMillis(); //设置可以显示的最晚的时间 datePickerDialog.getDatePicker().setMaxDate(timeStamp); //弹框 datePickerDialog.show(); } }); mDeleteBillBtn.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { deleteBill(); } }); mUpdateBillBtn.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { updateBill(); } }); } /** * 进行修改 */ private void updateBill() { Bill bill=null; //获取账目类型 mTypeText=mTypeSpin.getText().toString().trim(); //获取账目金额 String moneyText=mMoney.getText().toString().trim(); //获取日期 String date= mDate.getText().toString().trim(); //获取备注 String remarkText=mRemark.getText().toString().trim(); if(TextUtils.isEmpty(moneyText)){ //账目金额为空 Toast.makeText(this,"账目金额不可以为空",Toast.LENGTH_SHORT).show(); return; }else if(TextUtils.isEmpty((CharSequence) date)){ //账目日期为空 Toast.makeText(this,"账目日期不可以为空",Toast.LENGTH_SHORT).show(); return; }else { Log.e(TAG, "账户:" + mUsername); Log.e(TAG, "类型:" + mTypeText); Log.e(TAG, "金额:" + moneyText); Log.e(TAG, "日期:" + date); Log.e(TAG, "备注:" + remarkText); bill=new Bill(mUsername,mTypeText,moneyText,date,remarkText); boolean rs=mIBillDao.Update(mBillID,bill); Log.e(TAG,"rs:"+rs); if (rs ) { //修改成功,跳回账页 Intent intent = new Intent(); setResult(2, intent); finish(); } } } /** * 进行删除 */ private void deleteBill() { boolean rs=mIBillDao.DeleteBill(mBillID); if(rs){ //删除成功,跳回账页 Intent intent = new Intent(); setResult(3, intent); finish(); } } /** * 日期选择器对话监听 */ private DatePickerDialog.OnDateSetListener onDateSetListener = new DatePickerDialog.OnDateSetListener() { @Override public void onDateSet(DatePicker view, int year, int monthOfYear, int dayOfMonth) { mYear = year; mMonth = monthOfYear; mDay = dayOfMonth; String days; if (mMonth + 1 < 10) { if (mDay < 10) { days = new StringBuffer().append(mYear).append("-").append("0"). append(mMonth + 1).append("-").append("0").append(mDay).append("").toString(); } else { days = new StringBuffer().append(mYear).append("-").append("0"). append(mMonth + 1).append("-").append(mDay).append("").toString(); } } else { if (mDay < 10) { days = new StringBuffer().append(mYear).append("-"). append(mMonth + 1).append("-").append("0").append(mDay).append("").toString(); } else { days = new StringBuffer().append(mYear).append("-"). append(mMonth + 1).append("-").append(mDay).append("").toString(); } } mDate.setText(days); } }; private void initView() { mTypeSpin =(TextView) this.findViewById(R.id.type_spin); mMoney =(EditText)this.findViewById(R.id.bill_money); mDate =(TextView) this.findViewById(R.id.bill_date); mRemark=(EditText)this.findViewById(R.id.bill_remark); mUpdateBillBtn=(Button)this.findViewById(R.id.update_btn); mDeleteBillBtn=(Button)this.findViewById(R.id.delete_btn); mIBillDao =new BillDaoImpl(InfoActivity.this); } }