

package com.example.daliy;
import android.content.DialogInterface;
import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import com.google.android.material.floatingactionbutton.FloatingActionButton;
import androidx.appcompat.app.AlertDialog;
import androidx.appcompat.app.AppCompatActivity;
import androidx.appcompat.widget.Toolbar;
import android.text.TextUtils;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.Menu;
import android.view.MenuItem;
import android.widget.AdapterView;
import android.widget.DatePicker;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.Spinner;
import android.widget.Toast;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;
public class MainActivity extends AppCompatActivity {
private static final String TAG="MainActivity";
private List<CostBean> costBeanList;
private DatabaseHelper helper;
private String selectText="oo";
CostAdapter mAdapter;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Toolbar toolbar = findViewById(R.id.toolbar);
setSupportActionBar(toolbar);
costBeanList=new ArrayList<>();
helper=new DatabaseHelper(this);
final ListView costList=findViewById(R.id.lv_main);
initCostData();
mAdapter = new CostAdapter(this, costBeanList);
costList.setAdapter(mAdapter);
costList.setOnItemClickListener(new AdapterView.OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
CostBean costBean=costBeanList.get(position);
//CostBean bean= (CostBean) mAdapter.getItem(costBean.id);
Intent intent=new Intent(MainActivity.this,Delete_UpdateActivity.class);
intent.putExtra("id",costBean.id);
startActivityForResult(intent,1);
}
});
FloatingActionButton fab = findViewById(R.id.fab);
fab.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
AlertDialog.Builder builder=new AlertDialog.Builder(MainActivity.this);
LayoutInflater inflater=LayoutInflater.from(MainActivity.this);
View viewDialog =inflater.inflate(R.layout.new_cost,null);
final EditText cost_title=viewDialog.findViewById(R.id.et_cost_title);
final EditText cost_money=viewDialog.findViewById(R.id.et_cost_money);
final DatePicker cost_date=viewDialog.findViewById(R.id.dp_cost_date);
final Spinner cost_type=viewDialog.findViewById(R.id.sp_type);
cost_type.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
@Override
public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
selectText=cost_type.getSelectedItem().toString();
Log.d(TAG, "onItemSelected: +选择运行了");
}
@Override
public void onNothingSelected(AdapterView<?> parent) {
}
});
builder.setTitle("新账目");
builder.setView(viewDialog);
builder.setPositiveButton("OK", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
if(TextUtils.isEmpty(cost_title.getText())){
Toast.makeText(MainActivity.this,"备注为空",Toast.LENGTH_SHORT).show();
return;
}else if(TextUtils.isEmpty(cost_money.getText())){
Toast.makeText(MainActivity.this,"金额为空",Toast.LENGTH_SHORT).show();
return;
}
CostBean costBean=new CostBean();
costBean.costType=selectText;
Log.d(TAG, "onClick: "+selectText);
costBean.costTitle=cost_title.getText().toString();
costBean.costMoney=cost_money.getText().toString();
costBean.costDate=cost_date.getYear()+"-"+(cost_date.getMonth()+1)+"-"+cost_date.getDayOfMonth();
helper.insertCost(costBean);
costBeanList.add(costBean);
mAdapter.notifyDataSetChanged();
}
});
builder.setNegativeButton("Cancel",null);
builder.create().show();
}
});
}
protected void onActivityResult(int requestCode, int resultCode, Intent data) {
super.onActivityResult(requestCode, resultCode, data);
//此处可以根据两个Code进行判断,本页面和结果页面跳过来的值
if (requestCode == 1 && resultCode == 2) {
//String result = data.getStringExtra("result");
costBeanList.clear();
initCostData();
mAdapter.notifyDataSetChanged();
}
}
private void initCostData() {
// helper.deleteAllCost();
// for(int i=0;i<6;i++) {
//
// CostBean cb=new CostBean();
// cb.costDate="12-12";
// cb.costMoney="50";
// cb.costTitle=i+"heih";
// helper.insertCost(cb);
// }
Cursor cursor = helper.getAllCost();
if(cursor!=null){
while (cursor.moveToNext()){
CostBean costBean=new CostBean();
costBean.id=cursor.getInt(cursor.getColumnIndex("id"));
costBean.costType=cursor.getString(cursor.getColumnIndex("cost_type"));
costBean.costTitle=cursor.getString(cursor.getColumnIndex("cost_title"));
costBean.costDate=cursor.getString(cursor.getColumnIndex("cost_date"));
costBean.costMoney=cursor.getString(cursor.getColumnIndex("cost_money"));
costBeanList.add(costBean);
}
cursor.close();
}
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.menu_main, menu);
return true;
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
int id = item.getItemId();
//noinspection SimplifiableIfStatement
if (id == R.id.action_chart) {
Intent intent = new Intent(MainActivity.this,ChartActivity.class);
intent.putExtra("cost_list", (Serializable) costBeanList);
startActivity(intent);
return true;
}
else if(id==R.id.delete_allData){
helper.deleteAllCost();
costBeanList.clear();
mAdapter.notifyDataSetChanged();
return true;
}
else if(id==R.id.query){
Intent intent = new Intent(MainActivity.this,QueryActivity.class);
startActivity(intent);
}
return super.onOptionsItemSelected(item);
}
}
MainActivity


package com.example.daliy;
public class Constants {
public static final String TABLE_NAME="daily";
public static final int DATABASE_VERSION=1;
public static final String COST_TITLE = "cost_title";
public static final String COST_DATE = "cost_date";
public static final String COST_MONEY = "cost_money";
public static final String COST_TYPE = "cost_type";
}
Constants


package com.example.daliy;
import android.content.Context;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.TextView;
import java.util.List;
public class CostAdapter extends BaseAdapter {
String TAG="CostAdapter";
private List<CostBean> mlist;
private LayoutInflater minflater;
private Context mcontext;
public CostAdapter(Context context, List<CostBean> list) {
mlist = list;
mcontext = context;
minflater = LayoutInflater.from(context);
}
@Override
public int getCount() {
return mlist.size();
}
@Override
public Object getItem(int position) {
Log.d(TAG, "getItem: "+mlist.get(position));
return mlist.get(position);
}
@Override
public long getItemId(int position) {
return position;
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
ViewHolder viewHolder;
if (convertView == null) {
viewHolder = new ViewHolder();
convertView = minflater.inflate(R.layout.list_item, null);
viewHolder.mTvcostTitle = convertView.findViewById(R.id.tv_costTitle);
viewHolder.mTvcostMoney = convertView.findViewById(R.id.tv_costMoney);
viewHolder.mTvcostDate = convertView.findViewById(R.id.tv_costDate);
viewHolder.mTvcostType = convertView.findViewById(R.id.tv_costType);
convertView.setTag(viewHolder);
} else {
viewHolder = (ViewHolder) convertView.getTag();
}
CostBean bean = mlist.get(position);
viewHolder.mTvcostTitle.setText(bean.costTitle);
viewHolder.mTvcostMoney.setText(bean.costMoney);
viewHolder.mTvcostDate.setText(bean.costDate);
viewHolder.mTvcostType.setText(bean.costType);
return convertView;
}
private static class ViewHolder {
public TextView mTvcostTitle;
public TextView mTvcostDate;
public TextView mTvcostMoney;
public TextView mTvcostType;
}
}
CostAdapter


package com.example.daliy;
import java.io.Serializable;
public class CostBean implements Serializable {
public int id;
public String costTitle;
public String costDate;
public String costType;
public String costMoney;
}
CostBean


package com.example.daliy;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import androidx.annotation.Nullable;
public class DatabaseHelper extends SQLiteOpenHelper {
public DatabaseHelper(@Nullable Context context) {
super(context, Constants.TABLE_NAME, null, Constants.DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table if not exists daily("+
"id integer primary key autoincrement,"+
"cost_title varchar,"+
"cost_date varchar,"+
"cost_type varchar,"+
"cost_money varchar)");
}
public void insertCost(CostBean costBean){
SQLiteDatabase database=getWritableDatabase();
ContentValues cv=new ContentValues();
cv.put(Constants.COST_TITLE,costBean.costTitle);
cv.put(Constants.COST_DATE,costBean.costDate);
cv.put(Constants.COST_MONEY,costBean.costMoney);
cv.put(Constants.COST_TYPE,costBean.costType);
database.insert(Constants.TABLE_NAME,null,cv);
}
public void updateCost(CostBean costBean){
SQLiteDatabase database=getWritableDatabase();
ContentValues cv=new ContentValues();
cv.put(Constants.COST_DATE,costBean.costDate);
cv.put(Constants.COST_TYPE,costBean.costType);
cv.put(Constants.COST_MONEY,costBean.costMoney);
cv.put(Constants.COST_TITLE,costBean.costTitle);
database.update(Constants.TABLE_NAME,cv,"id='"+costBean.id+"'",null);
}
public Cursor getAllCost(){
SQLiteDatabase database=getWritableDatabase();
return database.query(Constants.TABLE_NAME,null,null,null,null,null,"cost_date asc");
}
public Cursor getCost(String key){
SQLiteDatabase database=getWritableDatabase();
return database.query(Constants.TABLE_NAME,null,"cost_title like '%"+key+"%'",null,null,null," cost_date asc");
}
public Cursor getCostById(String key){
SQLiteDatabase database=getWritableDatabase();
return database.query(Constants.TABLE_NAME,null,"id= '"+key+"'",null,null,null,null);
}
public void deleteById(int id){
SQLiteDatabase database=getWritableDatabase();
database.delete(Constants.TABLE_NAME,"id= '"+id+"'",null);
}
public void deleteAllCost(){
SQLiteDatabase database=getWritableDatabase();
database.delete(Constants.TABLE_NAME,null,null);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
DatabaseHelper


package com.example.daliy;
import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import android.text.TextUtils;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.Button;
import android.widget.DatePicker;
import android.widget.EditText;
import android.widget.Spinner;
import android.widget.SpinnerAdapter;
import androidx.annotation.Nullable;
public class Delete_UpdateActivity extends Activity {
private int id;
private CostBean costBean;
DatabaseHelper helper;
EditText ed_title;
EditText ed_money;
DatePicker dp_date;
Button bt_delete;
Button bt_update;
Spinner sp_type;
String TAG="Delete_UpdateActivity";
String selectText;
@Override
protected void onCreate(@Nullable Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_delete_or_update);
helper=new DatabaseHelper(Delete_UpdateActivity.this);
Intent intent=getIntent();
id=intent.getIntExtra("id",id);
costBean=new CostBean();
Cursor cursor=helper.getCostById(String.valueOf(id));
Log.d(TAG, "onCreate: "+id+"sss");
if(cursor!=null){
cursor.moveToNext();
costBean.costType=cursor.getString(cursor.getColumnIndex("cost_type"));
costBean.costTitle=cursor.getString(cursor.getColumnIndex("cost_title"));
costBean.costDate=cursor.getString(cursor.getColumnIndex("cost_date"));
costBean.costMoney=cursor.getString(cursor.getColumnIndex("cost_money"));
}
initData();
initListener();
}
private void initData() {
ed_title = findViewById(R.id.et_cost1_title);
ed_money = findViewById(R.id.et_cost1_money);
dp_date = findViewById(R.id.dp_cost1_date);
sp_type = findViewById(R.id.sp_1type);
bt_delete = findViewById(R.id.bt_delete);
bt_update = findViewById(R.id.bt_update);
ed_title.setText(costBean.costTitle);
ed_money.setText(costBean.costMoney);
SpinnerAdapter apsAdapter = sp_type.getAdapter();
sp_type.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
@Override
public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
selectText=sp_type.getSelectedItem().toString();
Log.d(TAG, "onItemSelected: +选择运行了");
}
@Override
public void onNothingSelected(AdapterView<?> parent) {
}
});
int size = apsAdapter.getCount();
for (int i = 0; i < size; i++) {
if (TextUtils.equals(costBean.costType, apsAdapter.getItem(i).toString())) {
sp_type.setSelection(i,true);
break;
}
}
}
private void initListener() {
bt_delete.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
helper.deleteById(id);
setResult(2);
finish();
}
});
bt_update.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
costBean=new CostBean();
costBean.id=id;
costBean.costDate= dp_date.getYear()+"-"+(dp_date.getMonth()+1)+"-"+dp_date.getDayOfMonth();
costBean.costTitle=ed_title.getText().toString();
costBean.costMoney=ed_money.getText().toString();
costBean.costType=selectText;
helper.updateCost(costBean);
setResult(2);
finish();
}
});
}
}
DeleteUpdateActivity


package com.example.daliy;
import android.app.Activity;
import android.database.Cursor;
import android.os.Bundle;
import android.text.TextUtils;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.Toast;
import androidx.annotation.Nullable;
import java.util.ArrayList;
import java.util.List;
public class QueryActivity extends Activity {
EditText queryKey;
Button doResearch;
DatabaseHelper helper;
ListView listView;
List<CostBean> list;
//private String queryKey;
@Override
protected void onCreate(@Nullable Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_query_layout);
listView=findViewById(R.id.lv_query);
queryKey = findViewById(R.id.et_queryKey);
doResearch = findViewById(R.id.bt_do_research);
helper=new DatabaseHelper(this);
list=new ArrayList<>();
initListener();
}
private void initListener() {
doResearch.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
if(TextUtils.isEmpty(queryKey.getText())){
Toast.makeText(QueryActivity.this,"没有目标",Toast.LENGTH_SHORT).show();
return;
}
Cursor cursor = helper.getCost(queryKey.getText().toString());
if(cursor!=null){
while (cursor.moveToNext()){
CostBean costBean=new CostBean();
costBean.costType=cursor.getString(cursor.getColumnIndex("cost_type"));
costBean.costTitle=cursor.getString(cursor.getColumnIndex("cost_title"));
costBean.costDate=cursor.getString(cursor.getColumnIndex("cost_date"));
costBean.costMoney=cursor.getString(cursor.getColumnIndex("cost_money"));
list.add(costBean);
}
cursor.close();
}
listView.setAdapter(new CostAdapter(QueryActivity.this,list));
}
});
}
}
QueryActivity


package com.example.daliy;
import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.Spinner;
import android.widget.Toast;
import androidx.annotation.Nullable;
public class SpinnerAdapterActivity extends Activity {
private static final String TAG="SpinnerAdapterActivity";
public Spinner spinner;
public String selectText;
public SpinnerAdapterActivity(){
spinner.findViewById(R.id.sp_type);
}
@Override
protected void onCreate(@Nullable Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
spinner.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
@Override
public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
selectText=parent.getItemAtPosition(position).toString();
//Log.d(TAG, "onItemSelected: "+selectText);
}
@Override
public void onNothingSelected(AdapterView<?> parent) {
}
});
}
}
SpinnerActivity