package com.example.schedule; import android.os.Bundle; import android.app.Activity; import android.view.Menu; import android.os.Bundle; import android.app.Activity; import android.app.AlertDialog; import android.app.ListActivity; import android.content.ContentValues; import android.content.DialogInterface; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.view.Menu; import android.view.View; import android.view.View.OnClickListener; import android.widget.AdapterView; import android.widget.AdapterView.OnItemClickListener; import android.widget.AdapterView.OnItemLongClickListener; import android.widget.Button; import android.widget.EditText; import android.widget.SimpleAdapter; import android.widget.SimpleCursorAdapter; public class MainActivity extends ListActivity { private SimpleCursorAdapter adapter; private EditText etDate,etItem; private Button btnAdd,btnUpdate; private Db db; private SQLiteDatabase dbRead,dbWrite; private OnItemClickListener ListViewItemClickListener = new OnItemClickListener() { @Override public void onItemClick(AdapterView<?> arg0, View arg1, final int position, long arg3) { // TODO Auto-generated method stub btnUpdate.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { // TODO Auto-generated method stub Cursor c = adapter.getCursor(); c.moveToPosition(position); int itemId = c.getInt(c.getColumnIndex("_id")); ContentValues cv = new ContentValues(); cv.put("date", etDate.getText().toString()); cv.put("item", etItem.getText().toString()); dbWrite.update("user", cv,"_id=?", new String[]{itemId+""}); refresListview(); } }); } }; private OnItemLongClickListener ListViewItemLongClickListener = new OnItemLongClickListener() { @Override public boolean onItemLongClick(AdapterView<?> parent, View v, final int position, long id) { // TODO Auto-generated method stub new AlertDialog.Builder(MainActivity.this) .setTitle("提醒").setMessage("您确定要删除该项吗") .setNegativeButton("取消", null) .setPositiveButton("确定", new DialogInterface.OnClickListener() { @Override public void onClick(DialogInterface arg0, int arg1) { // TODO Auto-generated method stub Cursor c = adapter.getCursor(); c.moveToPosition(position); int itemId = c.getInt(c.getColumnIndex("_id")); dbWrite.delete("user", "_id=?", new String[]{itemId+""}); refresListview(); } }).show(); return true; } }; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); db = new Db(this); dbRead =db.getReadableDatabase(); dbWrite =db.getWritableDatabase(); adapter = new SimpleCursorAdapter(this, R.layout.user_list_cell, null,new String[]{"date","item"}, new int[]{R.id.tvDate,R.id.tvItem}); setListAdapter(adapter); refresListview(); getListView().setOnItemLongClickListener(ListViewItemLongClickListener); getListView().setOnItemClickListener(ListViewItemClickListener); etDate = (EditText) findViewById(R.id.etDate); etItem = (EditText) findViewById(R.id.etItem); btnAdd = (Button) findViewById(R.id.btnAdd); btnUpdate = (Button) findViewById(R.id.btnUpdate); btnAdd.setOnClickListener(new OnClickListener( ) { @Override public void onClick(View v) { // TODO Auto-generated method stub ContentValues cv = new ContentValues(); cv.put("date", etDate.getText().toString()); cv.put("item", etItem.getText().toString()); dbWrite.insert("user", null, cv); refresListview(); } }); } private void refresListview(){ Cursor c = dbRead.query("user", null, null, null, null, null, null); adapter.changeCursor(c); } @Override public boolean onCreateOptionsMenu(Menu menu) { // Inflate the menu; this adds items to the action bar if it is present. getMenuInflater().inflate(R.menu.main, menu); return true; } }
慕瓜9220888
xleon
相关分类