Android studio使用sqliet。
1.在Android使用sqlite时,如果数据表存在就会直接打开数据表,如果不存在就会执行onCreate(SQLiteDatabase db)方法创建数据表。所以它与继承SQLiteOhpenHelper的类被执行多少次没有关系,它的onCreate(SQLiteDatabase db)方法只会执行一次。
2.在调用继承SQLiteOhpenHelper的类时,onCreate(SQLiteDatabase db)方法不执行,解决方法是将SQLiteDatabase db设置为db = getWritableDatabase()存储为成员变量。
3.只有当数据库的版本号改变时,才会执行onUpgrade()的方法
一,创建数据库
public class SqliteOneUtil extends SQLiteOpenHelper {
private static final String DATABASE = "t_station_transaction_exit.db"; //数据表明
private static final int VERSION = 1; //数据库版本
private SQLiteDatabase db;
public SqliteOneUtil(Context context){
super(context,DATABASE,null,VERSION);
db = getWritableDatabase();
}
@Override
public void onCreate(SQLiteDatabase db) {
this.db = db;
db.execSQL("CREATE TABLE if not exists t_station_transaction_exit (ID TEXT(255) NOT NULL,STATE INTEGER(2) NOT NULL, POINT_ID INTEGER(20) NOT NULL,LANE_NO INTEGER(20) NOT NULL,SHIFT_NO INTEGER(20) NOT NULL,WORK_DATE TEXT NOT NULL,OPERATOR_ID INTEGER(20) NOT NULL,LOGON_TIME TEXT NOT NULL,TRANS_DATE TEXT NOT NULL,MULTI_PROVINCE INTEGER(20) NOT NULL,PAY_FEE INTEGER(20) NOT NULL,FEE INTEGER(20) NOT NULL,DISCOUNT_FEE INTEGER(20) NOT NULL,MEDIA_TYPE INTEGER(20) NOT NULL,OBU_SIGN INTEGER(20) NOT NULL,MEDIA_NO TEXT(255),EN_TOLL_LANE_ID TEXT(255) NOT NULL,EN_TIME TEXT NOT NULL,EN_WEIGHT INTEGER(20),EN_AXLE_COUNT INTEGER(20),EX_TOLL_LANE_ID TEXT(255) NOT NULL,EN_VEHICLE_ID TEXT(255) NOT NULL,EN_VEHICLE_COL INTEGER(20) NOT NULL,EX_VEHICLE_ID TEXT(255) NOT NULL,EX_VEHICLE_COL INTEGER(20) NOT NULL,IDENTIFY_VEHICLE_ID TEXT(255),IDENTITY_VEHICLE_COL INTEGER(20),EN_VEHICLE_TYPE INTEGER(20) NOT NULL,EX_VEHICLE_TYPE INTEGER(20) NOT NULL,EN_VEHICLE_CLASS INTEGER(20) NOT NULL,EX_VEHICLE_CLASS INTEGER(20) NOT NULL,EN_TOLL_STATION_HEX TEXT(255) NOT NULL,EX_TOLL_STATION_HEX TEXT(255) NOT NULL,ETC_CARD_NET_ID TEXT(255),ETC_CARD_ID TEXT(255),TERMINAL_TRANS_NO TEXT(255),TAC TEXT(255),TRANS_TYPE TEXT(255),TERMINAL_NO TEXT(255),ALGORITHM_IDENTIFIER INTEGER(20),SERVICE_TYPE INTEGER(20),PAY_TYPE INTEGER(20) NOT NULL,THIRD_PAY_MESSAGE TEXT(255),IDENTIFICATION INTEGER(20) NOT NULL,DESCRIPTION TEXT(255) NOT NULL,SPECIAL_TYPE TEXT(255) NOT NULL,VEHICLE_SIGN_ID TEXT(255),PASS_ID TEXT(255) NOT NULL,HOUR_BATCH_NO INTEGER(20) NOT NULL,CREATE_TIME TEXT NOT NULL,STATION_TIME TEXT,CENTER_TIME TEXT,TRANSTAG INTEGER(20) NOT NULL,REMARK1 TEXT(255),REMARK2 TEXT(255),REMARK3 TEXT(255),REMARK4 TEXT(255),REMARK5 TEXT(255),PRIMARY KEY (ID))");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
Log.d("===========",oldVersion+"xxxxx"+newVersion);
if (newVersion > oldVersion){
// db.execSQL("alter table t_station_transaction_exit add column RECEIPT_NO INTERGER(38)");
}
}
}
二。创建数据表实体类
public class ExporTradeEntity {
private Context context;
public boolean isInsert = true;
public ExporTradeEntity(Context context){
this.context = context;
}
/**
* 出口交易流水 ID
*/
private String ID;
/**
* 上传状态 1成功 2失败
*/
private Integer STATE;
/**
* 交易所属收费站
*/
private Integer POINT_ID;
/**
* 交易车道号
*/
private Integer LANE_NO;
/**
* 记录发生日期
*/
private String TRANS_DATE;
/**
* 单省多省选择
*/
private Integer MULTI_PROVINCE;
/**
* 应收金额
*/
private Integer PAY_FEE;
/**
* 交易金额
*/
private Integer FEE;
/**
*优惠金额
*/
private Integer DISCOUNT_FEE;
/**
* 通行介质类型
*/
private Integer MEDIA_TYPE;
/**
* OBU 单/双片标识
*/
private Integer OBU_SIGN;
/**
* 介质编码
*/
private String MEDIA_NO;
/**
* 入口车道编号
*/
private String EN_TOLL_LANE_ID;
/**
* 入口交易发生的时间
*/
private String EN_TIME;
/**
* 入口车货总重
*/
private Integer EN_WEIGHT;
/**
* 入口轴数
*/
private Integer EN_AXLE_COUNT;
/**
* 出口车道编号
*/
private String EX_TOLL_LANE_ID;
/**
* 入口实际收费车辆车牌号码
*/
private String EN_VEHICLE_ID;
/**
* 入口实际收费车辆车牌颜色
*/
private Integer EN_VEHICLE_COL;
/**
* 出口实际收费车辆车牌号码
*/
private String EX_VEHICLE_ID;
/**
* 出口实际收费车辆车牌颜色
*/
private Integer EX_VEHICLE_COL;
/**
* 出口识别的车牌号码
*/
private String IDENTIFY_VEHICLE_ID;
/**
* 出口识别的车牌颜色
*/
private Integer IDENTITY_VEHICLE_COL;
/**
* 入口车型
*/
private Integer EN_VEHICLE_TYPE;
/**
* 出口车型
*/
private Integer EX_VEHICLE_TYPE;
/**
* 入口车种
*/
private Integer EN_VEHICLE_CLASS;
/**
* 出口车种
*/
private Integer EX_VEHICLE_CLASS;
/**
* 入口收费站hex字符串
*/
private String EN_TOLL_STATION_HEX;
/**
* 出口收费站hex字符串
*/
private String EX_TOLL_STATION_HEX;
/**
* ETC 卡网络编号
*/
private String ETC_CARD_NET_ID;
/**
* ETC 卡编号
*/
private String ETC_CARD_ID;
/**
* PSAM卡脱机交易序列号
*/
private String TERMINAL_TRANS_NO;
/**
* TAC码
*/
private String TAC;
/**
* 交易类型标识
*/
private String TRANS_TYPE;
/**
* 终端机编号
*/
private String TERMINAL_NO;
/**
* 算法标识
*/
private Integer ALGORITHM_IDENTIFIER;
/**
* 交易的服务类型
*/
private Integer SERVICE_TYPE;
/**
* 支付类型
*/
private Integer PAY_TYPE;
/**
* 第三方支付关联凭证
*/
private String THIRD_PAY_MESSAGE;
/**
* 开票标识
*/
private Integer IDENTIFICATION;
/**
* 对交易的文字解释
*/
private String DESCRIPTION;
/**
* 特情类型
*/
private String SPECIAL_TYPE;
/**
* 车牌识别流水号
*/
private String VEHICLE_SIGN_ID;
/**
* 通行 ID
*/
private String PASS_ID;
/**
* 班次
*/
private String SHIFT_NO;
/**
* 工作日期
*/
private String WORK_DATE;
/**
* 操作员工号
*/
private Integer OPERATOR_ID;
/**
* 系统登录时间
*/
private String LOGON_TIME;
/**
* 交易小时批次号
*/
private Integer HOUR_BATCH_NO;
/**
* 记录入库时间
*/
private String CREATE_TIME;
/**
* 记录入站时间
*/
private String STATION_TIME;
/**
* 记录入中心时间
*/
private String CENTER_TIME;
/**
* 标识
*/
private Integer TRANSTAG;
/**
* 备用字段
*/
private String REMARK1;
/**
* 备用字段
*/
private String REMARK2;
/**
* 备用字段
*/
private String REMARK3;
/**
* 备用字段
*/
private String REMARK4;
/**
* 备用字段
*/
private String REMARK5;
public String getID() {
if (TextUtils.isEmpty(ID)){
ToastUtil.showToast(context,"出口交易流水ID不能为空");
isInsert = false;
}
return ID;
}
public void setID(String ID) {
this.ID = ID;
}
public Integer getSTATE() {
if (STATE == null) {
STATE = 2;
}
return STATE;
}
public void setSTATE(Integer STATE) {
this.STATE = STATE;
}
public Integer getPOINT_ID() {
if (POINT_ID == null){
ToastUtil.showToast(context,"交易所属收费站不能为空");
isInsert = false;
}
return POINT_ID;
}
public void setPOINT_ID(Integer POINT_ID) {
this.POINT_ID = POINT_ID;
}
public Integer getLANE_NO() {
if (LANE_NO == null){
ToastUtil.showToast(context,"交易车道号不能为空");
isInsert = false;
}
return LANE_NO;
}
public void setLANE_NO(Integer LANE_NO) {
this.LANE_NO = LANE_NO;
}
public String getTRANS_DATE() {
if (STATE == null){
ToastUtil.showToast(context,"记录发生日期不能为空");
isInsert = false;
}
return TRANS_DATE;
}
public void setTRANS_DATE(String TRANS_DATE) {
this.TRANS_DATE = TRANS_DATE;
}
public Integer getMULTI_PROVINCE() {
if (MULTI_PROVINCE == null) {
MULTI_PROVINCE = 0;
}
return MULTI_PROVINCE;
}
public void setMULTI_PROVINCE(Integer MULTI_PROVINCE) {
this.MULTI_PROVINCE = MULTI_PROVINCE;
}
public Integer getPAY_FEE() {
if (PAY_FEE == null){
ToastUtil.showToast(context,"应收金额不能为空");
isInsert = false;
}
return PAY_FEE;
}
public void setPAY_FEE(Integer PAY_FEE) {
this.PAY_FEE = PAY_FEE;
}
public Integer getFEE() {
if (FEE == null){
ToastUtil.showToast(context,"交易金额不能为空");
isInsert = false;
}
return FEE;
}
public void setFEE(Integer FEE) {
this.FEE = FEE;
}
public Integer getDISCOUNT_FEE() {
if (DISCOUNT_FEE == null){
ToastUtil.showToast(context,"优惠金额不能为空");
isInsert = false;
}
return DISCOUNT_FEE;
}
public void setDISCOUNT_FEE(Integer DISCOUNT_FEE) {
this.DISCOUNT_FEE = DISCOUNT_FEE;
}
public Integer getMEDIA_TYPE() {
if (MEDIA_TYPE == null){
ToastUtil.showToast(context,"通行介质类型不能为空");
isInsert = false;
}
return MEDIA_TYPE;
}
public void setMEDIA_TYPE(Integer MEDIA_TYPE) {
this.MEDIA_TYPE = MEDIA_TYPE;
}
public Integer getOBU_SIGN() {
if (OBU_SIGN == null){
ToastUtil.showToast(context,"OBU 单/双片标识不能为空");
isInsert = false;
}
return OBU_SIGN;
}
public void setOBU_SIGN(Integer OBU_SIGN) {
this.OBU_SIGN = OBU_SIGN;
}
public String getMEDIA_NO() {
if (TextUtils.isEmpty(MEDIA_NO)){
ToastUtil.showToast(context,"介质编码不能为空");
isInsert = false;
}
return MEDIA_NO;
}
public void setMEDIA_NO(String MEDIA_NO) {
this.MEDIA_NO = MEDIA_NO;
}
public String getEN_TOLL_LANE_ID() {
if (TextUtils.isEmpty(EN_TOLL_LANE_ID)){
ToastUtil.showToast(context,"入口车道编号不能为空");
isInsert = false;
}
return EN_TOLL_LANE_ID;
}
public void setEN_TOLL_LANE_ID(String EN_TOLL_LANE_ID) {
this.EN_TOLL_LANE_ID = EN_TOLL_LANE_ID;
}
public String getEN_TIME() {
if (TextUtils.isEmpty(EN_TIME)){
ToastUtil.showToast(context,"入口交易发生的时间不能为空");
isInsert = false;
}
return EN_TIME;
}
public void setEN_TIME(String EN_TIME) {
this.EN_TIME = EN_TIME;
}
public Integer getEN_WEIGHT() {
return EN_WEIGHT;
}
public void setEN_WEIGHT(Integer EN_WEIGHT) {
this.EN_WEIGHT = EN_WEIGHT;
}
public Integer getEN_AXLE_COUNT() {
return EN_AXLE_COUNT;
}
public void setEN_AXLE_COUNT(Integer EN_AXLE_COUNT) {
this.EN_AXLE_COUNT = EN_AXLE_COUNT;
}
public String getEX_TOLL_LANE_ID() {
if (TextUtils.isEmpty(EX_TOLL_LANE_ID)){
ToastUtil.showToast(context,"出口车道编号不能为空");
isInsert = false;
}
return EX_TOLL_LANE_ID;
}
public void setEX_TOLL_LANE_ID(String EX_TOLL_LANE_ID) {
this.EX_TOLL_LANE_ID = EX_TOLL_LANE_ID;
}
public String getEN_VEHICLE_ID() {
if (TextUtils.isEmpty(EN_VEHICLE_ID)){
ToastUtil.showToast(context,"入口实际收费车辆车牌号码不能为空");
isInsert = false;
}
return EN_VEHICLE_ID;
}
public void setEN_VEHICLE_ID(String EN_VEHICLE_ID) {
this.EN_VEHICLE_ID = EN_VEHICLE_ID;
}
public Integer getEN_VEHICLE_COL() {
if (EN_VEHICLE_COL == null){
ToastUtil.showToast(context,"入口实际收费车辆车牌颜色号码不能为空");
isInsert = false;
}
return EN_VEHICLE_COL;
}
public void setEN_VEHICLE_COL(Integer EN_VEHICLE_COL) {
this.EN_VEHICLE_COL = EN_VEHICLE_COL;
}
public String getEX_VEHICLE_ID() {
if (TextUtils.isEmpty(EX_VEHICLE_ID)){
ToastUtil.showToast(context,"出口实际收费车辆车牌号码号码不能为空");
isInsert = false;
}
return EX_VEHICLE_ID;
}
public void setEX_VEHICLE_ID(String EX_VEHICLE_ID) {
this.EX_VEHICLE_ID = EX_VEHICLE_ID;
}
public Integer getEX_VEHICLE_COL() {
if (EX_VEHICLE_COL == null){
ToastUtil.showToast(context,"出口实际收费车辆车牌颜色不能为空");
isInsert = false;
}
return EX_VEHICLE_COL;
}
public void setEX_VEHICLE_COL(Integer EX_VEHICLE_COL) {
this.EX_VEHICLE_COL = EX_VEHICLE_COL;
}
public String getIDENTIFY_VEHICLE_ID() {
return IDENTIFY_VEHICLE_ID;
}
public void setIDENTIFY_VEHICLE_ID(String IDENTIFY_VEHICLE_ID) {
this.IDENTIFY_VEHICLE_ID = IDENTIFY_VEHICLE_ID;
}
public Integer getIDENTITY_VEHICLE_COL() {
return IDENTITY_VEHICLE_COL;
}
public void setIDENTITY_VEHICLE_COL(Integer IDENTITY_VEHICLE_COL) {
this.IDENTITY_VEHICLE_COL = IDENTITY_VEHICLE_COL;
}
public Integer getEN_VEHICLE_TYPE() {
if (EN_VEHICLE_TYPE == null){
ToastUtil.showToast(context,"入口车型不能为空");
isInsert = false;
}
return EN_VEHICLE_TYPE;
}
public void setEN_VEHICLE_TYPE(Integer EN_VEHICLE_TYPE) {
this.EN_VEHICLE_TYPE = EN_VEHICLE_TYPE;
}
public Integer getEX_VEHICLE_TYPE() {
if (EX_VEHICLE_TYPE == null){
ToastUtil.showToast(context,"出口车型不能为空");
isInsert = false;
}
return EX_VEHICLE_TYPE;
}
public void setEX_VEHICLE_TYPE(Integer EX_VEHICLE_TYPE) {
this.EX_VEHICLE_TYPE = EX_VEHICLE_TYPE;
}
public Integer getEN_VEHICLE_CLASS() {
if (EN_VEHICLE_CLASS == null){
ToastUtil.showToast(context,"入口车种不能为空");
isInsert = false;
}
return EN_VEHICLE_CLASS;
}
public void setEN_VEHICLE_CLASS(Integer EN_VEHICLE_CLASS) {
this.EN_VEHICLE_CLASS = EN_VEHICLE_CLASS;
}
public Integer getEX_VEHICLE_CLASS() {
if (EX_VEHICLE_CLASS == null){
ToastUtil.showToast(context,"出口车种不能为空");
isInsert = false;
}
return EX_VEHICLE_CLASS;
}
public void setEX_VEHICLE_CLASS(Integer EX_VEHICLE_CLASS) {
this.EX_VEHICLE_CLASS = EX_VEHICLE_CLASS;
}
public String getEN_TOLL_STATION_HEX() {
if (TextUtils.isEmpty(EN_TOLL_STATION_HEX)){
ToastUtil.showToast(context,"出口收费站hex字符串不能为空");
isInsert = false;
}
return EN_TOLL_STATION_HEX;
}
public void setEN_TOLL_STATION_HEX(String EN_TOLL_STATION_HEX) {
this.EN_TOLL_STATION_HEX = EN_TOLL_STATION_HEX;
}
public String getEX_TOLL_STATION_HEX() {
if (TextUtils.isEmpty(EX_TOLL_STATION_HEX)){
ToastUtil.showToast(context,"出口收费站hex字符串不能为空");
isInsert = false;
}
return EX_TOLL_STATION_HEX;
}
public void setEX_TOLL_STATION_HEX(String EX_TOLL_STATION_HEX) {
this.EX_TOLL_STATION_HEX = EX_TOLL_STATION_HEX;
}
public String getETC_CARD_NET_ID() {
return ETC_CARD_NET_ID;
}
public void setETC_CARD_NET_ID(String ETC_CARD_NET_ID) {
this.ETC_CARD_NET_ID = ETC_CARD_NET_ID;
}
public String getETC_CARD_ID() {
return ETC_CARD_ID;
}
public void setETC_CARD_ID(String ETC_CARD_ID) {
this.ETC_CARD_ID = ETC_CARD_ID;
}
public String getTERMINAL_TRANS_NO() {
return TERMINAL_TRANS_NO;
}
public void setTERMINAL_TRANS_NO(String TERMINAL_TRANS_NO) {
this.TERMINAL_TRANS_NO = TERMINAL_TRANS_NO;
}
public String getTAC() {
return TAC;
}
public void setTAC(String TAC) {
this.TAC = TAC;
}
public String getTRANS_TYPE() {
return TRANS_TYPE;
}
public void setTRANS_TYPE(String TRANS_TYPE) {
this.TRANS_TYPE = TRANS_TYPE;
}
public String getTERMINAL_NO() {
return TERMINAL_NO;
}
public void setTERMINAL_NO(String TERMINAL_NO) {
this.TERMINAL_NO = TERMINAL_NO;
}
public Integer getALGORITHM_IDENTIFIER() {
return ALGORITHM_IDENTIFIER;
}
public void setALGORITHM_IDENTIFIER(Integer ALGORITHM_IDENTIFIER) {
this.ALGORITHM_IDENTIFIER = ALGORITHM_IDENTIFIER;
}
public Integer getSERVICE_TYPE() {
return SERVICE_TYPE;
}
public void setSERVICE_TYPE(Integer SERVICE_TYPE) {
this.SERVICE_TYPE = SERVICE_TYPE;
}
public Integer getPAY_TYPE() {
if (PAY_TYPE == null){
ToastUtil.showToast(context,"支付类型不能为空");
isInsert = false;
}
return PAY_TYPE;
}
public void setPAY_TYPE(Integer PAY_TYPE) {
this.PAY_TYPE = PAY_TYPE;
}
public String getTHIRD_PAY_MESSAGE() {
return THIRD_PAY_MESSAGE;
}
public void setTHIRD_PAY_MESSAGE(String THIRD_PAY_MESSAGE) {
this.THIRD_PAY_MESSAGE = THIRD_PAY_MESSAGE;
}
public Integer getIDENTIFICATION() {
if (IDENTIFICATION == null){
IDENTIFICATION = 2;
}
return IDENTIFICATION;
}
public void setIDENTIFICATION(Integer IDENTIFICATION) {
this.IDENTIFICATION = IDENTIFICATION;
}
public String getDESCRIPTION() {
if (TextUtils.isEmpty(DESCRIPTION)){
ToastUtil.showToast(context,"对交易的文字解释不能为空");
isInsert = false;
}
return DESCRIPTION;
}
public void setDESCRIPTION(String DESCRIPTION) {
this.DESCRIPTION = DESCRIPTION;
}
public String getSPECIAL_TYPE() {
if (TextUtils.isEmpty(SPECIAL_TYPE)){
ToastUtil.showToast(context,"特情类型不能为空");
isInsert = false;
}
return SPECIAL_TYPE;
}
public void setSPECIAL_TYPE(String SPECIAL_TYPE) {
this.SPECIAL_TYPE = SPECIAL_TYPE;
}
public String getVEHICLE_SIGN_ID() {
return VEHICLE_SIGN_ID;
}
public void setVEHICLE_SIGN_ID(String VEHICLE_SIGN_ID) {
this.VEHICLE_SIGN_ID = VEHICLE_SIGN_ID;
}
public String getPASS_ID() {
if (TextUtils.isEmpty(PASS_ID)){
ToastUtil.showToast(context,"通行ID不能为空");
isInsert = false;
}
return PASS_ID;
}
public void setPASS_ID(String PASS_ID) {
this.PASS_ID = PASS_ID;
}
public String getSHIFT_NO() {
if (TextUtils.isEmpty(SHIFT_NO)){
ToastUtil.showToast(context,"班次不能为空");
isInsert = false;
}
return SHIFT_NO;
}
public void setSHIFT_NO(String SHIFT_NO) {
this.SHIFT_NO = SHIFT_NO;
}
public String getWORK_DATE() {
if (TextUtils.isEmpty(WORK_DATE)){
ToastUtil.showToast(context,"工作日期不能为空");
isInsert = false;
}
return WORK_DATE;
}
public void setWORK_DATE(String WORK_DATE) {
this.WORK_DATE = WORK_DATE;
}
public Integer getOPERATOR_ID() {
if (OPERATOR_ID == null){
ToastUtil.showToast(context,"操作员工号不能为空");
isInsert = false;
}
return OPERATOR_ID;
}
public void setOPERATOR_ID(Integer OPERATOR_ID) {
this.OPERATOR_ID = OPERATOR_ID;
}
public String getLOGON_TIME() {
if (TextUtils.isEmpty(LOGON_TIME)){
ToastUtil.showToast(context,"系统登录时间不能为空");
isInsert = false;
}
return LOGON_TIME;
}
public void setLOGON_TIME(String LOGON_TIME) {
this.LOGON_TIME = LOGON_TIME;
}
public Integer getHOUR_BATCH_NO() {
if (HOUR_BATCH_NO == null){
ToastUtil.showToast(context,"交易小时批次号不能为空");
isInsert = false;
}
return HOUR_BATCH_NO;
}
public void setHOUR_BATCH_NO(Integer HOUR_BATCH_NO) {
this.HOUR_BATCH_NO = HOUR_BATCH_NO;
}
public String getCREATE_TIME() {
if (TextUtils.isEmpty(CREATE_TIME)){
ToastUtil.showToast(context,"记录入库时间不能为空");
isInsert = false;
}
return CREATE_TIME;
}
public void setCREATE_TIME(String CREATE_TIME) {
this.CREATE_TIME = CREATE_TIME;
}
public String getSTATION_TIME() {
if (TextUtils.isEmpty(STATION_TIME)){
ToastUtil.showToast(context,"记录入站时间不能为空");
isInsert = false;
}
return STATION_TIME;
}
public void setSTATION_TIME(String STATION_TIME) {
this.STATION_TIME = STATION_TIME;
}
public String getCENTER_TIME() {
if (TextUtils.isEmpty(CENTER_TIME)){
ToastUtil.showToast(context,"记录入中心时间不能为空");
isInsert = false;
}
return CENTER_TIME;
}
public void setCENTER_TIME(String CENTER_TIME) {
this.CENTER_TIME = CENTER_TIME;
}
public Integer getTRANSTAG() {
if (TRANSTAG == null){
TRANSTAG = 0;
}
return TRANSTAG;
}
public void setTRANSTAG(Integer TRANSTAG) {
this.TRANSTAG = TRANSTAG;
}
public String getREMARK1() {
if (TextUtils.isEmpty(REMARK1)){
REMARK1 = "*";
}
return REMARK1;
}
public void setREMARK1(String REMARK1) {
this.REMARK1 = REMARK1;
}
public String getREMARK2() {
if (TextUtils.isEmpty(REMARK2)){
REMARK2 = "*";
}
return REMARK2;
}
public void setREMARK2(String REMARK2) {
this.REMARK2 = REMARK2;
}
public String getREMARK3() {
if (TextUtils.isEmpty(REMARK3)){
REMARK3 = "*";
}
return REMARK3;
}
public void setREMARK3(String REMARK3) {
this.REMARK3 = REMARK3;
}
public String getREMARK4() {
if (TextUtils.isEmpty(REMARK4)){
REMARK4 = "*";
}
return REMARK4;
}
public void setREMARK4(String REMARK4) {
this.REMARK4 = REMARK4;
}
public String getREMARK5() {
if (TextUtils.isEmpty(REMARK5)){
REMARK5 = "*";
}
return REMARK5;
}
public void setREMARK5(String REMARK5) {
this.REMARK5 = REMARK5;
}
}
三,创建数据库操作工具类,对数据库进行联动查询。
public class ExporTradeDao {
private SqliteOneUtil helper;
private Context context;
public ExporTradeDao(Context context) {
this.context = context;
helper = new SqliteOneUtil(context);
}
/**
* 插入语句
*
* @param entity
*/
public boolean insertAll(ExporTradeEntity entity) {
if (entity.isInsert == false) {
return false;
}
SQLiteDatabase db = helper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("ID", entity.getID());//出口交易流水 ID
values.put("POINT_ID", entity.getPOINT_ID());//交易所属收费站
values.put("STATE", entity.getSTATE());//上传状态
values.put("LANE_NO", entity.getLANE_NO());//交易车道号
values.put("TRANS_DATE", entity.getTRANS_DATE());//记录发生日期
values.put("MULTI_PROVINCE", entity.getMULTI_PROVINCE());//单省多省
values.put("PAY_FEE", entity.getPAY_FEE());//应收金额
values.put("FEE", entity.getFEE());//交易金额
values.put("DISCOUNT_FEE", entity.getDISCOUNT_FEE());//优惠金额
values.put("MEDIA_TYPE", entity.getMEDIA_TYPE());//通行介质类型
values.put("OBU_SIGN", entity.getOBU_SIGN());//OBU 单/双片标识
values.put("MEDIA_NO", entity.getMEDIA_NO());//介质编码
values.put("EN_TOLL_LANE_ID", entity.getEN_TOLL_LANE_ID());//入口车道编号
values.put("EN_TIME", entity.getEN_TIME());//入口交易发生的时间
values.put("EN_WEIGHT", entity.getEN_WEIGHT());//入口车货总重
values.put("EN_AXLE_COUNT", entity.getEN_AXLE_COUNT());//入口轴数
values.put("EX_TOLL_LANE_ID", entity.getEX_TOLL_LANE_ID());//出口车道编号
values.put("EN_VEHICLE_ID", entity.getEN_VEHICLE_ID());//入口实际收费车辆车牌号码
values.put("EN_VEHICLE_COL", entity.getEN_VEHICLE_COL());//入口实际收费车辆车牌颜色
values.put("EX_VEHICLE_ID", entity.getEX_VEHICLE_ID());//出口实际收费车辆车牌号码
values.put("EX_VEHICLE_COL", entity.getEX_VEHICLE_COL());//出口实际收费车辆车牌颜色
values.put("IDENTIFY_VEHICLE_ID", entity.getIDENTIFY_VEHICLE_ID());//出口识别的车牌号码
values.put("IDENTITY_VEHICLE_COL", entity.getIDENTITY_VEHICLE_COL());//出口识别的车牌颜色
values.put("EN_VEHICLE_TYPE", entity.getEN_VEHICLE_TYPE());//入口车型
values.put("EX_VEHICLE_TYPE", entity.getEX_VEHICLE_TYPE());//出口车型
values.put("EN_VEHICLE_CLASS", entity.getEN_VEHICLE_CLASS());//入口车种
values.put("EX_VEHICLE_CLASS", entity.getEX_VEHICLE_CLASS());//出口车种
values.put("EN_TOLL_STATION_HEX", entity.getEN_TOLL_STATION_HEX());//入口收费站hex字符串
values.put("EX_TOLL_STATION_HEX", entity.getEX_TOLL_STATION_HEX());//出口收费站hex字符串
values.put("ETC_CARD_NET_ID", entity.getETC_CARD_NET_ID());//ETC 卡网络编号
values.put("ETC_CARD_ID", entity.getETC_CARD_ID());//ETC 卡编号
values.put("TERMINAL_TRANS_NO", entity.getTERMINAL_TRANS_NO());//PSAM卡脱机交易序列号
values.put("TAC", entity.getTAC());//TAC码
values.put("TRANS_TYPE", entity.getTRANS_TYPE());//交易类型标识
values.put("TERMINAL_NO", entity.getTERMINAL_NO());//终端机编号
values.put("ALGORITHM_IDENTIFIER", entity.getALGORITHM_IDENTIFIER());//算法标识
values.put("SERVICE_TYPE", entity.getSERVICE_TYPE());//交易的服务类型
values.put("PAY_TYPE", entity.getPAY_TYPE());//支付类型
values.put("THIRD_PAY_MESSAGE", entity.getTHIRD_PAY_MESSAGE());//第三方支付关联凭证
values.put("IDENTIFICATION", entity.getIDENTIFICATION());//开票标识
values.put("DESCRIPTION", entity.getDESCRIPTION());//对交易的文字解释
values.put("SPECIAL_TYPE", entity.getSPECIAL_TYPE());//特情类型
values.put("VEHICLE_SIGN_ID", entity.getVEHICLE_SIGN_ID());//车牌识别流水号
values.put("PASS_ID", entity.getPASS_ID());//通行 ID
values.put("SHIFT_NO", entity.getSHIFT_NO());//班次
values.put("WORK_DATE", entity.getWORK_DATE());//工作日期
values.put("OPERATOR_ID", entity.getOPERATOR_ID());//操作员工号
values.put("LOGON_TIME", entity.getLOGON_TIME());//系统登录时间
values.put("HOUR_BATCH_NO", entity.getHOUR_BATCH_NO());//交易小时批次号
values.put("CREATE_TIME", entity.getCREATE_TIME());//记录入库时间
values.put("STATION_TIME", entity.getSTATION_TIME());//记录入站时间
values.put("CENTER_TIME", entity.getCENTER_TIME());//记录入中心时间
values.put("TRANSTAG", entity.getTRANSTAG());//标识
values.put("REMARK1", entity.getREMARK1());//备用字段
values.put("REMARK2", entity.getREMARK2());//备用字段
values.put("REMARK3", entity.getREMARK3());//备用字段
values.put("REMARK4", entity.getREMARK4());//备用字段
values.put("REMARK5", entity.getREMARK5());//备用字段
long c = db.insert("t_station_transaction_exit", null, values);
DubugLog.logd("tag=======", "插入数据成功" + c);
if (c == -1) {
DubugLog.logd("tag=======", "插入数据失败");
return false;
} else {
DubugLog.logd("tag=======", "插入数据成功" + c);
return true;
}
}
/**
* 多条件查询
*
* @param carId 车牌号 EX_VEHICLE_ID
* @param banj 班次 SHIFT_NO
* @param time 时间 CREATE_TIME
* @return
*/
public List<ExporTradeEntity> selectIf(@NotNull String carId, @NotNull String banj, @NotNull String time) {
if (TextUtils.isEmpty(carId)) {
carId = null;
}
if (TextUtils.isEmpty(banj)) {
banj = null;
}
if (TextUtils.isEmpty(time)) {
time = null;
}
SQLiteDatabase db = helper.getWritableDatabase();
List<ExporTradeEntity> list = new ArrayList<>();
String selection = null;
String[] strs = null;
if (carId == null && banj == null && time == null) {
selection = null;
strs = null;
} else if (carId != null && banj == null && time == null) {
selection = "EX_VEHICLE_ID=?";
strs = new String[]{carId};
} else if (carId == null && banj != null && time == null) {
selection = "SHIFT_NO=?";
strs = new String[]{banj};
} else if (carId != null && banj != null && time == null) {
selection = "EX_VEHICLE_ID=? and SHIFT_NO=?";
strs = new String[]{carId, banj};
} else if (carId == null && banj == null && time != null) {
selection = " CREATE_TIME like? ";
strs = new String[]{"%" + time + "%"};
} else if (carId == null && banj != null && time != null) {
selection = "SHIFT_NO=? and CREATE_TIME like?";
strs = new String[]{banj, "%" + time + "%"};
} else if (carId != null && banj == null && time != null) {
selection = "EX_VEHICLE_ID=? and CREATE_TIME like?";
strs = new String[]{carId, "%" + time + "%"};
} else if (carId != null && banj != null && time != null) {
selection = "EX_VEHICLE_ID=? and SHIFT_NO=? and CREATE_TIME like?";
strs = new String[]{carId, banj, "%" + time + "%"};
}
Cursor cursor = db.query("t_station_transaction_exit", null, selection, strs, null, null, null, null);//limit 限制查询返回的行数 “1”是偏移量“3”是数量
cursor.moveToFirst();
while (!cursor.isAfterLast()) {
ExporTradeEntity exporTradeEntity = new ExporTradeEntity(context);
exporTradeEntity.setID(cursor.getString(cursor.getColumnIndex("ID")));
exporTradeEntity.setSTATE(cursor.getInt(cursor.getColumnIndex("STATE")));
exporTradeEntity.setPOINT_ID(cursor.getInt(cursor.getColumnIndex("POINT_ID")));
exporTradeEntity.setLANE_NO(cursor.getInt(cursor.getColumnIndex("LANE_NO")));
exporTradeEntity.setTRANS_DATE(cursor.getString(cursor.getColumnIndex("TRANS_DATE")));
exporTradeEntity.setMULTI_PROVINCE(cursor.getInt(cursor.getColumnIndex("MULTI_PROVINCE")));
exporTradeEntity.setPAY_FEE(cursor.getInt(cursor.getColumnIndex("PAY_FEE")));
exporTradeEntity.setFEE(cursor.getInt(cursor.getColumnIndex("FEE")));
exporTradeEntity.setDISCOUNT_FEE(cursor.getInt(cursor.getColumnIndex("DISCOUNT_FEE")));
exporTradeEntity.setMEDIA_TYPE(cursor.getInt(cursor.getColumnIndex("MEDIA_TYPE")));
exporTradeEntity.setOBU_SIGN(cursor.getInt(cursor.getColumnIndex("OBU_SIGN")));
exporTradeEntity.setMEDIA_NO(cursor.getString(cursor.getColumnIndex("MEDIA_NO")));
exporTradeEntity.setEN_TOLL_LANE_ID(cursor.getString(cursor.getColumnIndex("EN_TOLL_LANE_ID")));
exporTradeEntity.setEN_TIME(cursor.getString(cursor.getColumnIndex("EN_TIME")));
exporTradeEntity.setEN_WEIGHT(cursor.getInt(cursor.getColumnIndex("EN_WEIGHT")));
exporTradeEntity.setEN_AXLE_COUNT(cursor.getInt(cursor.getColumnIndex("EN_AXLE_COUNT")));
exporTradeEntity.setEX_TOLL_LANE_ID(cursor.getString(cursor.getColumnIndex("EX_TOLL_LANE_ID")));
exporTradeEntity.setEN_VEHICLE_ID(cursor.getString(cursor.getColumnIndex("EN_VEHICLE_ID")));
exporTradeEntity.setEN_VEHICLE_COL(cursor.getInt(cursor.getColumnIndex("EN_VEHICLE_COL")));
exporTradeEntity.setEX_VEHICLE_ID(cursor.getString(cursor.getColumnIndex("EX_VEHICLE_ID")));
exporTradeEntity.setEX_VEHICLE_COL(cursor.getInt(cursor.getColumnIndex("EX_VEHICLE_COL")));
exporTradeEntity.setIDENTIFY_VEHICLE_ID(cursor.getString(cursor.getColumnIndex("IDENTIFY_VEHICLE_ID")));
exporTradeEntity.setIDENTITY_VEHICLE_COL(cursor.getInt(cursor.getColumnIndex("IDENTITY_VEHICLE_COL")));
exporTradeEntity.setEN_VEHICLE_TYPE(cursor.getInt(cursor.getColumnIndex("EN_VEHICLE_TYPE")));
exporTradeEntity.setEX_VEHICLE_TYPE(cursor.getInt(cursor.getColumnIndex("EX_VEHICLE_TYPE")));
exporTradeEntity.setEN_VEHICLE_CLASS(cursor.getInt(cursor.getColumnIndex("EN_VEHICLE_CLASS")));
exporTradeEntity.setEX_VEHICLE_CLASS(cursor.getInt(cursor.getColumnIndex("EX_VEHICLE_CLASS")));
exporTradeEntity.setEN_TOLL_STATION_HEX(cursor.getString(cursor.getColumnIndex("EN_TOLL_STATION_HEX")));
exporTradeEntity.setEX_TOLL_STATION_HEX(cursor.getString(cursor.getColumnIndex("EX_TOLL_STATION_HEX")));
exporTradeEntity.setETC_CARD_NET_ID(cursor.getString(cursor.getColumnIndex("ETC_CARD_NET_ID")));
exporTradeEntity.setETC_CARD_ID(cursor.getString(cursor.getColumnIndex("ETC_CARD_ID")));
exporTradeEntity.setTERMINAL_TRANS_NO(cursor.getString(cursor.getColumnIndex("TERMINAL_TRANS_NO")));
exporTradeEntity.setTAC(cursor.getString(cursor.getColumnIndex("TAC")));
exporTradeEntity.setTRANS_TYPE(cursor.getString(cursor.getColumnIndex("TRANS_TYPE")));
exporTradeEntity.setTERMINAL_NO(cursor.getString(cursor.getColumnIndex("TERMINAL_NO")));
exporTradeEntity.setALGORITHM_IDENTIFIER(cursor.getInt(cursor.getColumnIndex("ALGORITHM_IDENTIFIER")));
exporTradeEntity.setSERVICE_TYPE(cursor.getInt(cursor.getColumnIndex("SERVICE_TYPE")));
exporTradeEntity.setPAY_TYPE(cursor.getInt(cursor.getColumnIndex("PAY_TYPE")));
exporTradeEntity.setTHIRD_PAY_MESSAGE(cursor.getString(cursor.getColumnIndex("THIRD_PAY_MESSAGE")));
exporTradeEntity.setIDENTIFICATION(cursor.getInt(cursor.getColumnIndex("IDENTIFICATION")));
exporTradeEntity.setDESCRIPTION(cursor.getString(cursor.getColumnIndex("DESCRIPTION")));
exporTradeEntity.setSPECIAL_TYPE(cursor.getString(cursor.getColumnIndex("SPECIAL_TYPE")));
exporTradeEntity.setVEHICLE_SIGN_ID(cursor.getString(cursor.getColumnIndex("VEHICLE_SIGN_ID")));
exporTradeEntity.setPASS_ID(cursor.getString(cursor.getColumnIndex("PASS_ID")));
exporTradeEntity.setSHIFT_NO(cursor.getString(cursor.getColumnIndex("SHIFT_NO")));
exporTradeEntity.setWORK_DATE(cursor.getString(cursor.getColumnIndex("WORK_DATE")));
exporTradeEntity.setOPERATOR_ID(cursor.getInt(cursor.getColumnIndex("OPERATOR_ID")));
exporTradeEntity.setLOGON_TIME(cursor.getString(cursor.getColumnIndex("LOGON_TIME")));
exporTradeEntity.setHOUR_BATCH_NO(cursor.getInt(cursor.getColumnIndex("HOUR_BATCH_NO")));
exporTradeEntity.setCREATE_TIME(cursor.getString(cursor.getColumnIndex("CREATE_TIME")));
exporTradeEntity.setSTATION_TIME(cursor.getString(cursor.getColumnIndex("STATION_TIME")));
exporTradeEntity.setCENTER_TIME(cursor.getString(cursor.getColumnIndex("CENTER_TIME")));
exporTradeEntity.setTRANSTAG(cursor.getInt(cursor.getColumnIndex("TRANSTAG")));
exporTradeEntity.setREMARK1(cursor.getString(cursor.getColumnIndex("REMARK1")));
exporTradeEntity.setREMARK2(cursor.getString(cursor.getColumnIndex("REMARK2")));
exporTradeEntity.setREMARK3(cursor.getString(cursor.getColumnIndex("REMARK3")));
exporTradeEntity.setREMARK4(cursor.getString(cursor.getColumnIndex("REMARK4")));
exporTradeEntity.setREMARK5(cursor.getString(cursor.getColumnIndex("REMARK5")));
list.add(exporTradeEntity);
cursor.moveToNext();
}
db.close();
cursor.close();
return list;
}
/**
* 根据上传状态查询
*
* @param state 1 成功,2失败
* @return
*/
public List<ExporTradeEntity> selectState(Integer state) {
SQLiteDatabase db = helper.getWritableDatabase();
List<ExporTradeEntity> list = new ArrayList<>();
String selection = "carid=?";
String[] strs = new String[state];
Cursor cursor = db.query("t_station_transaction_exit", null, selection, strs, null, null, null, null);//limit 限制查询返回的行数 “1”是偏移量“3”是数量
cursor.moveToFirst();
while (!cursor.isAfterLast()) {
ExporTradeEntity exporTradeEntity = new ExporTradeEntity(context);
exporTradeEntity.setID(cursor.getString(cursor.getColumnIndex("ID")));
exporTradeEntity.setSTATE(cursor.getInt(cursor.getColumnIndex("STATE")));
exporTradeEntity.setPOINT_ID(cursor.getInt(cursor.getColumnIndex("POINT_ID")));
exporTradeEntity.setLANE_NO(cursor.getInt(cursor.getColumnIndex("LANE_NO")));
exporTradeEntity.setTRANS_DATE(cursor.getString(cursor.getColumnIndex("TRANS_DATE")));
exporTradeEntity.setMULTI_PROVINCE(cursor.getInt(cursor.getColumnIndex("MULTI_PROVINCE")));
exporTradeEntity.setPAY_FEE(cursor.getInt(cursor.getColumnIndex("PAY_FEE")));
exporTradeEntity.setFEE(cursor.getInt(cursor.getColumnIndex("FEE")));
exporTradeEntity.setDISCOUNT_FEE(cursor.getInt(cursor.getColumnIndex("DISCOUNT_FEE")));
exporTradeEntity.setMEDIA_TYPE(cursor.getInt(cursor.getColumnIndex("MEDIA_TYPE")));
exporTradeEntity.setOBU_SIGN(cursor.getInt(cursor.getColumnIndex("OBU_SIGN")));
exporTradeEntity.setMEDIA_NO(cursor.getString(cursor.getColumnIndex("MEDIA_NO")));
exporTradeEntity.setEN_TOLL_LANE_ID(cursor.getString(cursor.getColumnIndex("EN_TOLL_LANE_ID")));
exporTradeEntity.setEN_TIME(cursor.getString(cursor.getColumnIndex("EN_TIME")));
exporTradeEntity.setEN_WEIGHT(cursor.getInt(cursor.getColumnIndex("EN_WEIGHT")));
exporTradeEntity.setEN_AXLE_COUNT(cursor.getInt(cursor.getColumnIndex("EN_AXLE_COUNT")));
exporTradeEntity.setEX_TOLL_LANE_ID(cursor.getString(cursor.getColumnIndex("EX_TOLL_LANE_ID")));
exporTradeEntity.setEN_VEHICLE_ID(cursor.getString(cursor.getColumnIndex("EN_VEHICLE_ID")));
exporTradeEntity.setEN_VEHICLE_COL(cursor.getInt(cursor.getColumnIndex("EN_VEHICLE_COL")));
exporTradeEntity.setEX_VEHICLE_ID(cursor.getString(cursor.getColumnIndex("EX_VEHICLE_ID")));
exporTradeEntity.setEX_VEHICLE_COL(cursor.getInt(cursor.getColumnIndex("EX_VEHICLE_COL")));
exporTradeEntity.setIDENTIFY_VEHICLE_ID(cursor.getString(cursor.getColumnIndex("IDENTIFY_VEHICLE_ID")));
exporTradeEntity.setIDENTITY_VEHICLE_COL(cursor.getInt(cursor.getColumnIndex("IDENTITY_VEHICLE_COL")));
exporTradeEntity.setEN_VEHICLE_TYPE(cursor.getInt(cursor.getColumnIndex("EN_VEHICLE_TYPE")));
exporTradeEntity.setEX_VEHICLE_TYPE(cursor.getInt(cursor.getColumnIndex("EX_VEHICLE_TYPE")));
exporTradeEntity.setEN_VEHICLE_CLASS(cursor.getInt(cursor.getColumnIndex("EN_VEHICLE_CLASS")));
exporTradeEntity.setEX_VEHICLE_CLASS(cursor.getInt(cursor.getColumnIndex("EX_VEHICLE_CLASS")));
exporTradeEntity.setEN_TOLL_STATION_HEX(cursor.getString(cursor.getColumnIndex("EN_TOLL_STATION_HEX")));
exporTradeEntity.setEX_TOLL_STATION_HEX(cursor.getString(cursor.getColumnIndex("EX_TOLL_STATION_HEX")));
exporTradeEntity.setETC_CARD_NET_ID(cursor.getString(cursor.getColumnIndex("ETC_CARD_NET_ID")));
exporTradeEntity.setETC_CARD_ID(cursor.getString(cursor.getColumnIndex("ETC_CARD_ID")));
exporTradeEntity.setTERMINAL_TRANS_NO(cursor.getString(cursor.getColumnIndex("TERMINAL_TRANS_NO")));
exporTradeEntity.setTAC(cursor.getString(cursor.getColumnIndex("TAC")));
exporTradeEntity.setTRANS_TYPE(cursor.getString(cursor.getColumnIndex("TRANS_TYPE")));
exporTradeEntity.setTERMINAL_NO(cursor.getString(cursor.getColumnIndex("TERMINAL_NO")));
exporTradeEntity.setALGORITHM_IDENTIFIER(cursor.getInt(cursor.getColumnIndex("ALGORITHM_IDENTIFIER")));
exporTradeEntity.setSERVICE_TYPE(cursor.getInt(cursor.getColumnIndex("SERVICE_TYPE")));
exporTradeEntity.setPAY_TYPE(cursor.getInt(cursor.getColumnIndex("PAY_TYPE")));
exporTradeEntity.setTHIRD_PAY_MESSAGE(cursor.getString(cursor.getColumnIndex("THIRD_PAY_MESSAGE")));
exporTradeEntity.setIDENTIFICATION(cursor.getInt(cursor.getColumnIndex("IDENTIFICATION")));
exporTradeEntity.setDESCRIPTION(cursor.getString(cursor.getColumnIndex("DESCRIPTION")));
exporTradeEntity.setSPECIAL_TYPE(cursor.getString(cursor.getColumnIndex("SPECIAL_TYPE")));
exporTradeEntity.setVEHICLE_SIGN_ID(cursor.getString(cursor.getColumnIndex("VEHICLE_SIGN_ID")));
exporTradeEntity.setPASS_ID(cursor.getString(cursor.getColumnIndex("PASS_ID")));
exporTradeEntity.setSHIFT_NO(cursor.getString(cursor.getColumnIndex("SHIFT_NO")));
exporTradeEntity.setWORK_DATE(cursor.getString(cursor.getColumnIndex("WORK_DATE")));
exporTradeEntity.setOPERATOR_ID(cursor.getInt(cursor.getColumnIndex("OPERATOR_ID")));
exporTradeEntity.setLOGON_TIME(cursor.getString(cursor.getColumnIndex("LOGON_TIME")));
exporTradeEntity.setHOUR_BATCH_NO(cursor.getInt(cursor.getColumnIndex("HOUR_BATCH_NO")));
exporTradeEntity.setCREATE_TIME(cursor.getString(cursor.getColumnIndex("CREATE_TIME")));
exporTradeEntity.setSTATION_TIME(cursor.getString(cursor.getColumnIndex("STATION_TIME")));
exporTradeEntity.setCENTER_TIME(cursor.getString(cursor.getColumnIndex("CENTER_TIME")));
exporTradeEntity.setTRANSTAG(cursor.getInt(cursor.getColumnIndex("TRANSTAG")));
exporTradeEntity.setREMARK1(cursor.getString(cursor.getColumnIndex("REMARK1")));
exporTradeEntity.setREMARK2(cursor.getString(cursor.getColumnIndex("REMARK2")));
exporTradeEntity.setREMARK3(cursor.getString(cursor.getColumnIndex("REMARK3")));
exporTradeEntity.setREMARK4(cursor.getString(cursor.getColumnIndex("REMARK4")));
exporTradeEntity.setREMARK5(cursor.getString(cursor.getColumnIndex("REMARK5")));
list.add(exporTradeEntity);
cursor.moveToNext();
}
db.close();
cursor.close();
return list;
}
/**
* 根据id改变上传状态
*
* @param ID 出口交易流水 ID
* @return
*/
public boolean updateState(String ID) {
SQLiteDatabase db = helper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("state", 1);
int result = db.update("t_station_transaction_exit", values, "ID=?", new String[]{ID});
if (result > 0) {
return true;
} else {
return false;
}
}
/**
* 删除本地七天前上传成功的数据
*
* @return
*/
public boolean deleteTime() throws ParseException {
String time = DateShiftUtil.dateshit("yyyyMMdd", new SimpleDateFormat("yyyyMMdd").format(new Date().getTime()), -7);
Integer state = 1;//1 成功 2 失败
SQLiteDatabase db = helper.getWritableDatabase();
int result = db.delete("t_station_transaction_exit", "STATE=? and CREATE_TIME<?", new String[]{state + "", time});
DubugLog.logd("tag====", "数据库删除成功" + result);
if (result > 0) {
return true;
} else {
return false;
}
}
}