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;
}
}
添加回答
举报
0/150
提交
取消