Dao

来源：互联网发布：做效果图的软件编辑：程序博客网时间：2024/06/05 23:40
package com.example.yuekao;/** * Created by dell on 2017/8/22. */import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.content.ContentValues;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;public class Dao {    private SQLiteDatabase db;    public Dao(Context context) {        MyOpenHelper helper = new MyOpenHelper(context);        db = helper.getWritableDatabase();    }    public boolean add(String name, String pwd) {        ContentValues values = new ContentValues();        values.put("name", name);        values.put("pwd", pwd);        long i = db.insert("suibian4", null, values);        if (i != -1) {            return true;        }        return false;    }    public boolean update(String name, String pwd, int id) {        ContentValues values = new ContentValues();        values.put("name", name);        values.put("pwd", pwd);        int i = db.update("suibian4", values, "id=?", new String[]{String.valueOf(id)});        if (i > 0) {            return true;        }        return false;    }    public boolean delete(int id) {        int i = db.delete("suibian4", "id=?", new String[]{String.valueOf(id)});        if (i > 0) {            return true;        }        return false;    }    public Cursor find() {        Cursor cursor = db.query("suibian4", null, null, null, null, null, null);        return cursor;    }}
阅读全文
0 0