PrivilegeItemDb.java

package com.mzeat.db;

import java.util.ArrayList;
import java.util.List;

import com.mzeat.model.PrivilegeItem;
import com.mzeat.model.Shopping;
import com.mzeat.model.User;
import com.mzeat.util.CheckTable;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class PrivilegeItemDb {
	private DatabaseHelper databaseHelper;
	private SQLiteDatabase db;
	private Context context;

	public PrivilegeItemDb(Context context) {
		this.context = context;
		databaseHelper = DatabaseHelper.getInstance(context);
		db = databaseHelper.getWritableDatabase();

	}

	public void add(List<PrivilegeItem> column) {
		db.beginTransaction(); // 开始事务
		/** 数据库SQL语句 添加一个表 **/
		String Privilege = "create table Privilege ("
				+ "_id INTEGER PRIMARY KEY AUTOINCREMENT," 
				+ "goods_id TEXT,"
				+ "title TEXT," 
				+ "goods_desc TEXT,"
				+ "goods_brief TEXT,"
				+ "image TEXT," 
				+ "buy_count TEXT,"
				+ "ori_price_format TEXT,"
				+ "cur_price_format TEXT," 
				+ "discount TEXT," 
				+ "address TEXT,"
				+ "sp_detail TEXT," 
				+ "sp_tel TEXT," 
				+ "saving_format TEXT,"
				+ "less_time TEXT,"
				+ "xpoint TEXT,"
				+ "ypoint TEXT,"
				+ "distance TEXT,"
				+ "time_status TEXT,"
				+ "buy_status TEXT,"
				+ "buy_type TEXT,"
				+ "count_image TEXT,"
				+ "start_times TEXT,"
				+ "sp_open_times TEXT,"
				+ "cur_price TEXT"
				+ ");";
		db.execSQL("DROP TABLE IF EXISTS Privilege");
		db.execSQL(Privilege);
		try {
			for (PrivilegeItem columns : column) {
			db.execSQL(
					"INSERT INTO Privilege VALUES(null,?,?,?,?, ?, ?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
					new Object[] { 
							columns.getGoods_id(), 
							columns.getTitle(),
							columns.getGoods_desc(),
							columns.getGoods_brief(),
							columns.getImage(), 
							columns.getBuy_count(),
							columns.getOri_price_format(),
							columns.getCur_price_format(), 
							columns.getDiscount(),
							columns.getAddress(), 
							columns.getSp_detail(),
							columns.getSp_tel(), 
							columns.getSaving_format(),
							columns.getLess_time(), 
							columns.getXpoint(),
							columns.getYpoint(),
							columns.getDistance(),
							columns.getTime_status(),
							columns.getBuy_status(),
							columns.getBuy_type(),
							columns.getCount_image(),
							columns.getStart_times(),
							columns.getSp_open_times(),
							columns.getCur_price()
							});
			}
			db.setTransactionSuccessful(); // 设置事务成功完成
		} finally {
			db.endTransaction(); // 结束事务
		}
	}

	public void deleteAll() {
		db.delete("Privilege", null, null);

	}

	public void delete(String goods_id) {
		String whereClause = "goods_id = ?";
		String[] whereArgs = { goods_id };

		db.delete("Privilege", whereClause, whereArgs);

	}

	public ArrayList<PrivilegeItem> getItem() {
		ArrayList<PrivilegeItem>  items = new ArrayList<PrivilegeItem>();
		// HomeUser home_user = new HomeUser();
		String table = "Privilege";
		String[] columns = { "*" };
		String selection = null;
		String[] selectionArgs = null;
		String groupBy = null;
		String having = null;
		String orderBy = null;
		if (CheckTable.tabbleIsExist(context, table)) {
			Cursor c = db.query(table, columns, selection, selectionArgs,
					groupBy, having, orderBy);

			while (c.moveToNext()) {
				PrivilegeItem item = new PrivilegeItem();
				item.setGoods_id(c.getString(c.getColumnIndex("goods_id")));
				item.setTitle(c.getString(c.getColumnIndex("title")));
				item.setImage(c.getString(c.getColumnIndex("image")));
				item.setBuy_count(c.getString(c.getColumnIndex("buy_count")));
				item.setOri_price_format(c.getString(c.getColumnIndex("ori_price_format")));
				item.setCur_price_format(c.getString(c.getColumnIndex("cur_price_format")));
				item.setDiscount(c.getString(c.getColumnIndex("discount")));
				item.setAddress(c.getString(c.getColumnIndex("address")));
				item.setSp_detail(c.getString(c.getColumnIndex("sp_detail")));
				item.setSp_tel(c.getString(c.getColumnIndex("sp_tel")));
				item.setSaving_format(c.getString(c.getColumnIndex("saving_format")));
				item.setLess_time(c.getString(c.getColumnIndex("less_time")));
				item.setXpoint(c.getString(c.getColumnIndex("xpoint")));
				item.setYpoint(c.getString(c.getColumnIndex("ypoint")));
				item.setDistance(c.getString(c.getColumnIndex("distance")));
				item.setGoods_brief(c.getString(c.getColumnIndex("goods_brief")));
				item.setGoods_desc(c.getString(c.getColumnIndex("goods_desc")));
				item.setTime_status(c.getString(c.getColumnIndex("time_status")));
				item.setBuy_status(c.getString(c.getColumnIndex("buy_status")));
				item.setBuy_type(c.getString(c.getColumnIndex("buy_type")));
				item.setCount_image(c.getString(c.getColumnIndex("count_image")));
				item.setStart_times(c.getString(c.getColumnIndex("start_times")));
				item.setSp_open_times(c.getString(c.getColumnIndex("sp_open_times")));
				item.setCur_price(c.getString(c.getColumnIndex("cur_price")));

				items.add(item);
			}
			c.close();
		}
		return items;
	}

	/**
	 * close database
	 */
	public void closeDB() {
		db.close();
	}

}