public class DB extends SQLiteOpenHelper { public DB(Context context) { super(context, "user.db", null, 1); } @Override public void onCreate(SQLiteDatabase sqLiteDatabase) { sqLiteDatabase.execSQL("create table user("+"_id INTEGER PRIMARY KEY AUTOINCREMENT,"+ "name TEXT DEFAULT NULL,"+"sex TEXT DEFAULT NULL)"); } @Override public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) { } }
public class Main2Activity extends ListActivity{ private SimpleCursorAdapter adapter; EditText editText1,editText2; SQLiteDatabase dbwrite,dbread; Button button; DB db; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main2); editText1=(EditText)findViewById(R.id.etname); editText2=(EditText)findViewById(R.id.etsex); button=(Button)findViewById(R.id.add); db=new DB(this); dbwrite=db.getWritableDatabase(); dbread=db.getReadableDatabase(); button.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { ContentValues values=new ContentValues(); values.put("name",editText1.getText().toString()); values.put("sex",editText2.getText().toString()); dbwrite.insert("user",null,values); refresh(); } }); adapter=new SimpleCursorAdapter(this,R.layout.cell,null,new String[]{"name","sex"},new int[]{R.id.name,R.id.sex}); setListAdapter(adapter); refresh(); getListView().setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() { @Override public boolean onItemLongClick(AdapterView<?> adapterView, View view, final int position, long l) { new AlertDialog.Builder(Main2Activity.this).setTitle("delete").setMessage("delete item from db?").setPositiveButton("sure", new DialogInterface.OnClickListener() { @Override public void onClick(DialogInterface dialogInterface, int i) { Cursor cursor=adapter.getCursor(); cursor.moveToPosition(position); int itemid=cursor.getInt(cursor.getColumnIndex("_id")); dbwrite.delete("user","_id=?",new String[]{itemid+""}); refresh(); } }).setNegativeButton("cancel",null).show(); return true; } }); } private void refresh() { Cursor cursor=dbread.query("user",null,null,null,null,null,null); adapter.changeCursor(cursor); } }