UserPositionDBUtil.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;
/**
 * 用户位置信息数据处理帮助类
 * @author joe
 *
 */
public class UserPositionDBUtil extends BaseDBHelper<DataUserPositionBean>{
	/**
	 * 用户位置信息数据处理帮助类
	 * @param context
	 */
	public UserPositionDBUtil(Context context) {
		super(context);
		try {
			TableUtils.createTableIfNotExists(getConnectionSource(),
					getBeanClass());
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	@Override
	protected Class<DataUserPositionBean> getBeanClass() {
		return DataUserPositionBean.class;
	}
	/**
	 * 用户位置信息
	 * @param userPositionBeanList
	 */
	public  void addUserPositionListData(List<DataUserPositionBean> userPositionBeanList){
		for (DataUserPositionBean cityBean : userPositionBeanList) {
			try {
				getDao().create(cityBean);
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	/**
	 *保存用户信息
	 * @param userPositionBean
	 */
	public void addUserPosition(DataUserPositionBean userPositionBean){
		try {
			getDao().create(userPositionBean);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	/**
	 * 查询所有用户位置信息
	 * @return
	 */
	public List<DataUserPositionBean> queryAllUserPosition(){
		List<DataUserPositionBean> userPositionBeanList  = new ArrayList<DataUserPositionBean>();
		try {
			userPositionBeanList = getDao().queryForAll(); 
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return userPositionBeanList;
	}
	
	/**
	 * 查询所有用户位置信息
	 * @return
	 */
	public List<DataUserPositionBean> queryUserPositionBySize(){
		List<DataUserPositionBean> userPositionBeanList  = new ArrayList<DataUserPositionBean>();
		DataUserPositionBean cityBean = new DataUserPositionBean();
		try {
			userPositionBeanList = getDao().queryForMatching(cityBean); 
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return userPositionBeanList;
	}
	
	/**
	 * 删除某一个用户位置信息
	 * @param userPositionBean
	 */
	public  void deleteUserPosition(DataUserPositionBean userPositionBean){
		 try {
			getDao().delete(userPositionBean);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public  void deleteUserPositionList(List<DataUserPositionBean> userPositionBeanList){
		for (DataUserPositionBean dataUserPositionBean : userPositionBeanList) {
			 try {
					getDao().delete(dataUserPositionBean);
				 } catch (SQLException e) {
					e.printStackTrace();
				}
		}
		
	}
	/**
	 * 更新某一个用户位置信息
	 * @param userPositionBean
	 */
	public void updateUserPosition(DataUserPositionBean userPositionBean){
	  userPositionBean = new DataUserPositionBean();
		try {
			getDao().update(userPositionBean);
		} 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();
		}
	}
}