数据库

建库

public class sqliteopenhelper extends SQLiteOpenHelper{

    public sqliteopenhelper(Context context) {
        super(context, "kuku.db", null, 1);
        // TODO Auto-generated constructor stub
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL("create table mypro(id integer primary key autoincrement,foodtitle text,foodcontent text,foodprice text,imageurl text)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub

    }

}

增删改查

    //定义上下文和创建数据库和表的对象sqliteopenhelper
    Context context;
    sqliteopenhelper sl;
    public sqlitedao(Context context) {
        super();
        this.context = context;
        sl=new sqliteopenhelper(context);
    }
    //数据库添加数据
    public void add(Houses h){
        SQLiteDatabase db = sl.getWritableDatabase();
        ContentValues values=new ContentValues();
        values.put("xinxi", h.name);
        values.put("didian", h.location);
        values.put("jiaqian", h.price);
        db.insert("kao", null, values);
    }
    //查询数据库中的信息
    public List<Houses> gethHouses(){
        List<Houses> list=new ArrayList<Houses>();
        SQLiteDatabase db = sl.getReadableDatabase();
        Cursor cursor = db.query("kao", null, null, null, null, null, null);
        while(cursor.moveToNext()){
            Houses h=new Houses();
            h.id=cursor.getInt(cursor.getColumnIndex("id"));
            h.location=cursor.getString(cursor.getColumnIndex("xinxi"));
            h.name=cursor.getString(cursor.getColumnIndex("didian"));
            h.price=cursor.getString(cursor.getColumnIndex("jiaqian"));
            list.add(h);
        }
        return list;
    }
    //删除数据库的信息
    public int del(Houses h){
        SQLiteDatabase db = sl.getWritableDatabase();
        int i = db.delete("kao", "id=?", new String []{h.id+""});
        return i;
    }
    //修改数据库数据的信息
    public void update(Houses h){
        SQLiteDatabase db = sl.getWritableDatabase();
        ContentValues values=new ContentValues();
//      values.put("xinxi", h.name);
//      values.put("didian", h.location);
        values.put("jiaqian", h.price);
        db.update("kao", values, "id=?", new String []{h.id+""});
    }

}