建库
public class sqliteopenhelper extends SQLiteOpenHelper{
public sqliteopenhelper(Context context) {
super(context, "kuku.db", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
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) {
}
}
增删改查
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("jiaqian", h.price);
db.update("kao", values, "id=?", new String []{h.id+""});
}
}