SQLite

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * 购物车的数据库
 * Created by xue on 2016/9/11.
 */
public class Sqlite extends SQLiteOpenHelper{
    public Sqlite(Context context) {
        super(context, "good.db", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {

        db.execSQL("create table good(_id integer primary key autoincrement,name,spname,spgeshu,spjiage,spimage,spid)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import com.example.administrator.yunifang.bean.Goodbean;
import java.util.ArrayList;

/**
 * Created by LiangShaoTeng on 2016/9/13.
 */
public class Mydb {

    private ArrayList<Goodbean> base=new ArrayList<>();
    private final Sqlite create;
    private SQLiteDatabase writableDatabase;

    public Mydb(Context context) {
        create = new Sqlite(context);
    }
    //添加
    public void add(String name, String spname, int spgeshu, String spjiage, String spimage, String spid) {
        writableDatabase = create.getWritableDatabase();
        ContentValues values = new ContentValues();
        values.put("name", name);
        values.put("spname", spname);
        values.put("spgeshu", spgeshu);
        values.put("spjiage", spjiage);
        values.put("spimage", spimage);
        values.put("spid", spid);
        writableDatabase.insert("good", null, values);
        writableDatabase.close();
    }
    //查询
    public ArrayList<Goodbean> query(String name1) {
        writableDatabase = create.getWritableDatabase();
        //Cursor query = writableDatabase.query("good", null, null, null, null, null, null);
        Cursor query = writableDatabase.query("good", new String[]{"_id","name","spname","spgeshu","spjiage","spimage","spid"}, "name like ?", new String []{"%"+name1+"%"}, null, null, null);
        while (query.moveToNext()) {
            String id = query.getString(query.getColumnIndex("_id"));
            String name = query.getString(query.getColumnIndex("name"));
            String spname = query.getString(query.getColumnIndex("spname"));
            String spgeshu = query.getString(query.getColumnIndex("spgeshu"));
            String spjiage = query.getString(query.getColumnIndex("spjiage"));
            String spimage = query.getString(query.getColumnIndex("spimage"));
            String spid = query.getString(query.getColumnIndex("spid"));
            base.add(new Goodbean(Integer.valueOf(id),name,spname,Integer.valueOf(spgeshu),spjiage,spimage,spid));
        }
        return base;

    }

    //清空数据库
    public void qingk(){
        writableDatabase = create.getWritableDatabase();
        //清空数据库
        writableDatabase.execSQL("DELETE FROM " + "good");
        writableDatabase.close();
    }

    //删除
    public void delect(int id){
        String id1=id+"";
        writableDatabase = create.getWritableDatabase();
        writableDatabase.delete("good", "_id=?", new String[]{id1});

    }
}