android studio sqlite一个基本操作

来源：互联网发布：北航软件工程硕士学费编辑：程序博客网时间：2024/04/24 05:57

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);    }}

0 0