Android消费记录系统.doc

public class xamationActivity extends Activity { /** Called when the activity is first created. */ private Button sum; private EditText editText; private ListView listView; private ArrayListCostList list; private MyAdapter adapter; @Override public 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 ArrayListCostList(); sum.setOnClickListener(new OnClickListener() { @Override public void onClick(View v) { // TODO Auto-generated method stub Builder builder = new AlertDialog.Builder( xamationActivity.this); builder.setTitle(统计结果); String date = editText.getText().toString(); MyDBHelper helper = new MyDBHelper( xamationActivity.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() { @Override public void onItemClick(AdapterView? arg0, View arg1, int arg2, long arg3) { // TODO Auto-generated method stub Intent intent = new Intent(); intent.setClass(xamationActivity.this, Information.class); intent.putExtra(_id, list.get(arg2).get_id());