AdminAreaBeanDBUtil.java

package com.jiuqi.njt.register.city;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

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

import com.j256.ormlite.support.ConnectionSource;
import com.j256.ormlite.table.TableUtils;
import com.jiuqi.njt.register.KAdminAreaBean;
/**
 * 客户端行政区划对象数据处理帮助类
 * @author joe
 *
 */
public class AdminAreaBeanDBUtil extends BaseDBHelper<KAdminAreaBean>{
	/**
	 * 客户端行政区划对象信息数据处理帮助类
	 * @param context
	 */
	public AdminAreaBeanDBUtil(Context context) {
		super(context);
		try {
			TableUtils.createTableIfNotExists(getConnectionSource(),
					getBeanClass());
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	@Override
	protected Class<KAdminAreaBean> getBeanClass() {
		return KAdminAreaBean.class;
	}
	/**
	 * 客户端行政区划对象信息
	 * @param kAdminAreaBeanList
	 */
	public  void addKAdminAreaBeanListData(List<KAdminAreaBean> kAdminAreaBeanList){
		for (KAdminAreaBean cityBean : kAdminAreaBeanList) {
			try {
				getDao().create(cityBean);
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	/**
	 *保存客户端行政区划对象信息
	 * @param userPositionBean
	 */
	public void addKAdminAreaBean(KAdminAreaBean kAdminAreaBean){
		try {
			getDao().create(kAdminAreaBean);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	/**
	 * 查询所有客户端行政区划对象信息
	 * @return
	 */
	public List<KAdminAreaBean> queryAllKAdminAreaBean(){
		List<KAdminAreaBean> kAdminAreaBeanList  = new ArrayList<KAdminAreaBean>();
		try {
			kAdminAreaBeanList = getDao().queryForAll();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return kAdminAreaBeanList;
	}
	
	/**
	 * 删除某一个客户端行政区划对象信息
	 * @param kAdminAreaBean
	 */
	public  void deleteKAdminAreaBean(KAdminAreaBean kAdminAreaBean){
		 try {
			getDao().delete(kAdminAreaBean);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public  void deleteUserPositionList(List<KAdminAreaBean> kAdminAreaBeanList){
		for (KAdminAreaBean dataUserPositionBean : kAdminAreaBeanList) {
			 try {
					getDao().delete(dataUserPositionBean);
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		
	}
	/**
	 * 更新某一个客户端行政区划对象信息
	 * @param kAdminAreaBean
	 */
	public void updateUserPosition(KAdminAreaBean kAdminAreaBean){
	  kAdminAreaBean = new KAdminAreaBean();
		try {
			getDao().update(kAdminAreaBean);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	@Override
	public void onUpgrade(SQLiteDatabase arg0, ConnectionSource arg1,
			int oldVersion, int newVersion) {
		super.onUpgrade(arg0, arg1, oldVersion, newVersion);
		try {
				for (Class itemClass : DatabaseConfigUtil.getMainDbEntityClasses()) {
					TableUtils.dropTable(arg1, itemClass,true);
				}
				for (Class itemClass : DatabaseConfigUtil.getMainDbEntityClasses()) {
					TableUtils.createTable(arg1, itemClass);
				}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}