Android消费记录系统.doc

public class _20120727ExamationActivity extends Activity /* Called when the activity is first created. */private Button sum;private EditText editText;private ListView listView;private ArrayList list;private MyAdapter adapter;Overridepublic void onCreate(Bundle savedInstanceState) super.onCreate(savedInstanceState);setContentView(R.layout.main);sum = (Button) findViewById(R.id.addInfromation);editText = (EditText) findViewById(R.id.mainEditText);listView = (ListView) findViewById(R.id.listView);list = new ArrayList();sum.setOnClickListener(new OnClickListener() Overridepublic void onClick(View v) / TODO Auto-generated method stubBuilder builder = new AlertDialog.Builder(_20120727ExamationActivity.this);builder.setTitle(统计结果);String date = editText.getText().toString();MyDBHelper helper = new MyDBHelper(_20120727ExamationActivity.this, Globle.DB_NAME, null,Globle.DB_VERSION);SQLiteDatabase db = helper.getWritableDatabase();String sql = select * from + Globle.TABLE_COST_LIST+ where date like + + date + % + ;Cursor cursor = Util.selectData(db, sql);double sumMoney = 0;while (cursor.moveToNext() try sumMoney += Double.parseDouble(cursor.getString(2); catch (Exception e) builder.setMessage(消费金额必须为数字);builder.create().show();cursor.close();db.close();builder.setMessage(date + 的消费总额为： + sumMoney);builder.create().show(););adapter = new MyAdapter();listView.setAdapter(adapter);listView.setOnItemClickListener(new OnItemClickListener() Overridepublic void onItemClick(AdapterView arg0, View arg1, int arg2,long arg3) / TODO Auto-generated method stubIntent intent = new Intent();intent.setClass(_20120727ExamationActivity.this,Information.class);intent.putExtra(_id, list.get(arg2).get_id();intent.putExtra(date, list.get(arg2).getDate();intent.putExtra(money, list.get(arg2).getMoney();intent.putExtra(remarks, list.get(arg2).getRemarks();startActivity(intent););Overrideprotected void onStart() / TODO Auto-generated method stubinData();super.onStart();public void inData() list.clear();MyDBHelper helper = new MyDBHelper(_20120727ExamationActivity.this,Globle.DB_NAME, null, Globle.DB_VERSION);SQLiteDatabase db = helper.getWritableDatabase();String sql = select * from + Globle.TABLE_COST_LIST;Cursor cursor = Util.selectData(db, sql);while (cursor.moveToNext() CostList cl = new CostList();cl.set_id(Integer.parseInt(cursor.getString(0);cl.setDate(cursor.getString(1);cl.setMoney(cursor.getString(2);cl.setRemarks(cursor.getString(3);list.add(cl);cursor.close();db.close();adapter.notifyDataSetChanged();Overridepublic boolean onCreateOptionsMenu(Menu menu) / TODO Auto-generated method stubMenuItem add = menu.add(添加);add.setOnMenuItemClickListener(new OnMenuItemClickListener() Overridepublic boolean onMenuItemClick(MenuItem item) / TODO Auto-generated method stubIntent intent = new Intent();intent.setClass(_20120727ExamationActivity.this,AddMessage.class);startActivity(intent);return false;);MenuItem search = menu.add(搜索);search.setOnMenuItemClickListener(new OnMenuItemClickListener() Overridepublic boolean onMenuItemClick(MenuItem item) / TODO Auto-generated method stubIntent intent = new Intent(_20120727ExamationActivity.this,Search.class);startActivity(intent);return false;);return super.onCreateOptionsMenu(menu);class MyAdapter extends BaseAdapter Overridepublic int getCount() / TODO Auto-generated method stubreturn list.size();Overridepublic Object getItem(int position) / TODO Auto-generated method stubreturn null;Overridepublic long getItemId(int position) / TODO Auto-generated method stubreturn 0;Overridepublic View getView(int position, View convertView, ViewGroup parent) / TODO Auto-generated method stubLayoutInflater l = LayoutInflater.from(_20120727ExamationActivity.this);View view = l.inflate(R.layout.listview, null);TextView date = (TextView) view.findViewById(R.id.listViewDate);TextView money = (TextView) view.findViewById(R.id.listViewMoney);date.setText(list.get(position).getDate();money.setText(list.get(position).getMoney();return view;public class AddMessage extends Activity private Button dateButton, ok, cancle;private TextView dateTextView;private EditText moneyEditText, remarksEditText;private Calendar c;private Intent intent;Overrideprotected void onCreate(Bundle savedInstanceState) / TODO Auto-generated method stubsuper.onCreate(savedInstanceState);setContentView(R.layout.add_message);dateButton = (Button) findViewById(R.id.addMessageForDateButton);ok = (Button) findViewById(R.id.addMessageOk);cancle = (Button) findViewById(R.id.addMessageCancle);dateTextView = (TextView) findViewById(R.id.addMessageForDateTextView);moneyEditText = (EditText) findViewById(R.id.addMessageForMoneyEditText);remarksEditText = (EditText) findViewById(R.id.addMessageForRemarksEditText);c = Calendar.getInstance();intent = getIntent();if (intent.getIntExtra(_id, -1) != -1) dateTextView.setText(intent.getStringExtra(date);moneyEditText.setText(intent.getStringExtra(money);remarksEditText.setText(intent.getStringExtra(remarks);dateButton.setOnClickListener(new OnClickListener() Overridepublic void onClick(View v) / TODO Auto-generated method stubDatePickerDialog dpd = new DatePickerDialog(AddMessage.this,new OnDateSetListener() Overridepublic void onDateSet(DatePicker view, int year,int monthOfYear, int dayOfMonth) / TODO Auto-generated method stubString text = year + - + monthOfYear + -+ dayOfMonth;dateTextView.setText(text);, c.get(Calendar.YEAR), c.get(Calendar.MONTH), c.get(Calendar.DAY_OF_MONTH);dpd.show(););ok.setOnClickListener(new OnClickListener() Overridepublic void onClick(View v) / TODO Auto-generated method stubContentValues values = new ContentValues();values.put(date, dateTextView.getText().toString();values.put(money, moneyEditText.getText().toString();values.put(remarks, remarksEditText.getText().toString();MyDBHelper helper = new MyDBHelper(AddMessage.this,Globle.DB_NAME, null, Globle.DB_VERSION);SQLiteDatabase db = helper.getWritableDatabase();if (intent.getIntExtra(_id, -1) != -1) if (Util.updateData(db, Globle.TABLE_COST_LIST, values,_id = + intent.getIntExtra(_id, -1) != 0) Toast.makeText(AddMessage.this,Globle.MESSAGE_UPDATE_SUCCESS,Toast.LENGTH_SHORT).show();intent.setClass(AddMessage.this,_20120727ExamationActivity.class);startActivity(intent); else Toast.makeText(AddMessage.this,Globle.MESSAGE_UPDATE_FAILED,Toast.LENGTH_SHORT).show(); else if (Util.insertData(db, Globle.TABLE_COST_LIST, values) != 0) Toast.makeText(AddMessage.this, Globle.MESSAGE_SUCCESS,Toast.LENGTH_SHORT).show();finish(); else Toast.makeText(AddMessage.this, Globle.MESSAGE_FAILED,Toast.LENGTH_LONG).show();db.close(););cancle.setOnClickListener(new OnClickListener() Overridepublic void onClick(View v) / TODO Auto-generated method stubfinish(););public class Information extends Activity private TextView date, money, remarks;private Intent intent;Overrideprotected void onCreate(Bundle savedInstanceState) / TODO Auto-generated method stubsuper.onCreate(savedInstanceState);setContentView(R.layout.infromation);date = (TextView) findViewById(R.id.infromationDate);money = (TextView) findViewById(R.id.infromationMoney);remarks = (TextView) findViewById(R.id.infromationRemarks);intent = getIntent();date.setText(Globle.INFORMATION_DATE + intent.getStringExtra(date);money.setText(Globle.INFROMATION_MONEY+ intent.getStringExtra(money);remarks.setText(Globle.INFORMATION_REMARKS+ intent.getStringExtra(remarks);Overridepublic boolean onCreateOptionsMenu(Menu menu) / TODO Auto-generated method stubMenuItem update = menu.add(修改);update.setOnMenuItemClickListener(new OnMenuItemClickListener() Overridepublic boolean onMenuItemClick(MenuItem item) / TODO Auto-generated method stubintent.setClass(Information.this, AddMessage.class);startActivity(intent);return false;);MenuItem delete = menu.add(删除);delete.setOnMenuItemClickListener(new OnMenuItemClickListener() Overridepublic boolean onMenuItemClick(MenuItem item) / TODO Auto-generated method stubMyDBHelper helper = new MyDBHelper(Information.this,Globle.DB_NAME, null, Globle.DB_VERSION);SQLiteDatabase db = helper.getWritableDatabase();if (Util.deleteData(db, Globle.TABLE_COST_LIST, _id = + intent.getIntExtra(_id, -1) != 0) Toast.makeText(Information.this,Globle.MESSAGE_DELETE_SUCCESS, Toast.LENGTH_SHORT).show();finish(); else Toast.makeText(Information.this,Globle.MESSAGE_DELETE_FAILED, Toast.LENGTH_SHORT).show();db.close();return false;);return super.onCreateOptionsMenu(menu);public class Search extends Activity private EditText date, money, remarks;private Button ok;private TextView textView;private ArrayList list;Overrideprotected void onCreate(Bundle savedInstanceState) / TODO Auto-generated method stubsuper.onCreate(savedInstanceState);setContentView(R.layout.search);date = (EditText) findViewById(R.id.searchForDate);money = (EditText) findViewById(R.id.searchForMoneyEditText);remarks = (EditText) findViewById(R.id.searchForRemarksEditText);ok = (Button) findViewById(R.id.searchOk);textView = (TextView) findViewById(R.id.serarchtextView);list = new ArrayList();ok.setOnClickListener(new OnClickListener() Overridepublic void onClick(View v) / TODO Auto-generated method stubString sql;if (!(date.getText().toString().equals() sql = select * from + Globle.TABLE_COST_LIST+ where date like + + date.getText().toString() + % + ;inData(sql);StringBuffer buffer = new StringBuffer();for (int i = 0; i list.size(); i+) System.out.println(list.get(i).get_id()=+ list.get(i).get_id();buffer.append(list.get(i).getDate() + tt+ list.get(i).getMoney() + tt+ list.get(i).getRemarks() + n);textView.setText(buffer);if (!(money.getText().toString().equals() sql = select * from + Globle.TABLE_COST_LIST+ where money like