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();
}
}
}