android sqlite 增删查 demo

packagecom.example.wtw.learnlayout;importandroid.app.AlertDialog;importandroid.app.ListActivity;importandroid.content.ContentValues;importandroid.content.DialogInterface;importandroid.database.Cursor;importandroid.database.sqlite.SQLiteDatabase;importandroid.support.v7.app.AppCompatActivity;importandroid.os.Bundle;importandroid.util.Log;importandroid.view.View;importandroid.widget.AdapterView;importandroid.widget.Button;importandroid.widget.EditText;importandroid.widget.LinearLayout;importandroid.widget.ListView;importandroid.widget.RadioButton;importandroid.widget.RadioGroup;importandroid.widget.SimpleCursorAdapter;importandroid.widget.Toast;importcom.example.wtw.common.Db;publicclassListViewActivityextendsListActivity{privateSimpleCursorAdapteradapter;privateEditTextedName;//privateEditTextedSex;RadioGroupedSex;privateButtonadd;privateDbdb;privateSQLiteDatabasedbRead;privateSQLiteDatabasedbWrite;//添加按钮事件privateView.OnClickListeneraddbtn=newView.OnClickListener(){@OverridepublicvoidonClick(Viewv){ContentValuescv=newContentValues();if(edName.getText().toString().isEmpty()//||edSex.getText().toString().isEmpty()||edSex.getCheckedRadioButtonId()==-1){Toast.makeText(v.getContext(),"不能为空",Toast.LENGTH_SHORT).show();}else{Stringname=edName.getText().toString();//Stringsex=edSex.getText().toString();RadioButtonr=(RadioButton)findViewById(edSex.getCheckedRadioButtonId());Log.i("mylog","radioID="+edSex.getCheckedRadioButtonId());Stringsex=r.getText().toString();cv.put("name",name);cv.put("sex",sex);dbWrite.insert("user",null,cv);Toast.makeText(v.getContext(),"成功",Toast.LENGTH_SHORT).show();Log.i("mylog","新增成功");refreshListView();}}};@OverrideprotectedvoidonCreate(BundlesavedInstanceState){super.onCreate(savedInstanceState);setContentView(R.layout.activity_list_view);edName=(EditText)findViewById(R.id.edName);//edSex=(EditText)findViewById(R.id.edSex);edSex=(RadioGroup)findViewById(R.id.edSex);add=(Button)findViewById(R.id.btn_add);add.setOnClickListener(addbtn);db=newDb(this);dbRead=db.getReadableDatabase();dbWrite=db.getWritableDatabase();adapter=newSimpleCursorAdapter(this,R.layout.user_list,null,newString[]{"name","sex"},newint[]{R.id.tvName,R.id.tvSex});Log.i("mylog","正在加载LISTVIEW数据");setListAdapter(adapter);refreshListView();//listview添加长按事件getListView().setOnItemLongClickListener(newAdapterView.OnItemLongClickListener(){@OverridepublicbooleanonItemLongClick(AdapterView<?>parent,Viewview,finalintposition,longid){//弹出框,title设置弹出框的标题，message设置弹出框的内容,negative设置取消按钮,positive设置确定按钮及事件newAlertDialog.Builder(ListViewActivity.this).setTitle("提醒").setMessage("您确定删除该项吗?").setNegativeButton("取消",null).setPositiveButton("确定",newDialogInterface.OnClickListener(){@OverridepublicvoidonClick(DialogInterfacedialog,intwhich){Cursorc=adapter.getCursor();//c.moveToPosition(position);//从LISTVIEW中移除intitemid=c.getInt(c.getColumnIndex("_id"));Log.i("mylog","删除ID="+itemid);dbWrite.delete("user","_id=?",newString[]{itemid+""});//在数据库中删除数据refreshListView();//刷新}}).show();returntrue;}});}//刷新publicvoidrefreshListView(){Cursorc=dbRead.query("user",null,null,null,null,null,null,null);adapter.changeCursor(c);}}
更多相关文章

随机推荐
