SQLite增删改查

public class MySQLite extends SQLiteOpenHelper{
	private Context context;
	public MySQLite(Context context) {
		
		super(context, "shoucang", null, 1);
		// TODO Auto-generated constructor stub
		this.context=context;
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		
		db.execSQL("create table shangpin(_id integer primary key autoincrement,"
				+ "name varchar(10),"
				+ "pri varchar(10),"
				+ "yuanpri varchar(10),"
				+ "img varchar(100),"
				+ "count varchar(10))");
		
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub
		
	}
	public ArrayList<SQbean> chaxun(){
		ArrayList<SQbean> arrayList=new ArrayList<SQbean>();
		SQLiteDatabase db = getReadableDatabase();
		Cursor cursor = db.query("shangpin", null, null, null, null, null, null);
		while (cursor.moveToNext()) {
			
			String id = cursor.getString(cursor.getColumnIndex("_id"));
			String name = cursor.getString(cursor.getColumnIndex("name"));
			String pri = cursor.getString(cursor.getColumnIndex("pri"));
			String yuanpri = cursor.getString(cursor.getColumnIndex("yuanpri"));
			String img = cursor.getString(cursor.getColumnIndex("img"));
			String count = cursor.getString(cursor.getColumnIndex("count"));
			
			SQbean sQbean = new SQbean(id,name,pri,yuanpri,img,count);
			arrayList.add(sQbean);
		}
		
		return arrayList;
		
	}
	public void adddata(SQbean sQbean){
		
		SQLiteDatabase db = getWritableDatabase();
		db.execSQL("insert into shangpin(name,pri,yuanpri,img,count) values(?,?,?,?,?)", new Object[]{sQbean.getName(),sQbean.getPri(),sQbean.getYuanpri(),sQbean.getImgas(),sQbean.getCount()});
		
	}
	public void delete(String id){
		SQLiteDatabase	db = getWritableDatabase();
			db.delete("shangpin", "_id=?", new String[]{id+""});
		}

}