NutzCN Logo
问答 insertOrUpdate Pojo报错Duplicate entry '556018020014' for key 'CardNumber'
发布于 1821天前 作者 wx_2jk6i7mpius707s625cs 1271 次浏览 复制 上一个帖子 下一个帖子
标签:
@IocBean
@Table("VIP_d")
public class VipDetailBean {
	@Id
	private int id;
	@Name
	@Column
	private String CardNumber;
	@Column
	private String Cardlevel;
	@Column
	private String CardStatus;
	@Column
	private String  IsInvalid;
	@Column
	private String OpenTime;
	@Column
	private String EndTime;
	@Column
	private String  Balance;
	@Column
	private String DrinkCupTicket;
	@Column
	private Date CreateTime;
	@Column
	private Date UpdateTime;
	
	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getCardNumber() {
		return CardNumber;
	}

	public void setCardNumber(String cardNumber) {
		CardNumber = cardNumber;
	}

	public String getCardlevel() {
		return Cardlevel;
	}

	public void setCardlevel(String cardlevel) {
		Cardlevel = cardlevel;
	}

	public String getCardStatus() {
		return CardStatus;
	}

	public void setCardStatus(String cardStatus) {
		CardStatus = cardStatus;
	}

	public String getIsInvalid() {
		return IsInvalid;
	}

	public void setIsInvalid(String isInvalid) {
		IsInvalid = isInvalid;
	}

	public String getOpenTime() {
		return OpenTime;
	}

	public void setOpenTime(String openTime) {
		OpenTime = openTime;
	}

	public String getEndTime() {
		return EndTime;
	}

	public void setEndTime(String endTime) {
		EndTime = endTime;
	}

	public String getBalance() {
		return Balance;
	}

	public void setBalance(String balance) {
		Balance = balance;
	}



	public String getDrinkCupTicket() {
		return DrinkCupTicket;
	}

	public void setDrinkCupTicket(String drinkCupTicket) {
		DrinkCupTicket = drinkCupTicket;
	}

	public Date getCreateTime() {
		return CreateTime;
	}

	public void setCreateTime(Date createTime) {
		CreateTime = createTime;
	}

	public Date getUpdateTime() {
		return UpdateTime;
	}

	public void setUpdateTime(Date updateTime) {
		UpdateTime = updateTime;
	}



	@Override
	public String toString() {
		return "VipDetailBean [id=" + id + ", CardNumber="
				+ CardNumber + ", Cardlevel=" + Cardlevel + ", CardStatus=" + CardStatus + ", IsInvalid=" + IsInvalid
				+ ", OpenTime=" + OpenTime + ", EndTime=" + EndTime + ", Balance=" + Balance + ", DrinkCupTicket="
				+ DrinkCupTicket + ", CreateTime=" + CreateTime + ", UpdateTime=" + UpdateTime + "]";
	}

}
Sex女
2019-04-03 17:17:01,766 net.wendal.nutzbook.dao.UserDao.SelectUser(UserDao.java:69) INFO  - ........
2019-04-03 17:17:01,775 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM VIP_h  WHERE id=?
    | 1 |
    |---|
    | 0 |
  For example:> "SELECT * FROM VIP_h  WHERE id=0"
2019-04-03 17:17:01,799 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - INSERT INTO VIP_h(Phone,VipId,VipNumber,msterID,name,QQ,passwd,Sex,CreateOrgId_Id,CreateOrg_Name,FBirthday,VipCreateDate,ct,ut) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?) 
    |           1 |       2 |    3 |    4 |   5 |    6 |      7 | 8 |    9 |      10 |                  11 |   12 |                  13 |                  14 |
    |-------------|---------|------|------|-----|------|--------|---|------|---------|---------------------|------|---------------------|---------------------|
    | 15861588572 | 2672242 | NULL | NULL | 吴湘君 | NULL | 123456 | 女 | NULL | 无锡华润苏宁店 | 1985-02-01T00:00:00 | NULL | 2019-04-03 17:17:01 | 2019-04-03 17:17:01 |
  For example:> "INSERT INTO VIP_h(Phone,VipId,VipNumber,msterID,name,QQ,passwd,Sex,CreateOrgId_Id,CreateOrg_Name,FBirthday,VipCreateDate,ct,ut) VALUES('15861588572','2672242',NULL,NULL,'吴湘君',NULL,'123456','女',NULL,'无锡华润苏宁店','1985-02-01T00:00:00',NULL,'2019-04-03 17:17:01','2019-04-03 17:17:01') "
111["{\"Result\":{\"ResponseStatus\":null,\"Result\":{\"Id\":2480772,\"FFormId\":\"CMK_VIP_CardInfo\",\"msterID\":2480772,\"DocumentStatus\":\"C\",\"ForbidStatus\":\"A\",\"MultiLanguageText\":[{\"PkId\":1466885,\"LocaleId\":2052,\"Name\":\"106017120006\",\"Description\":\" \"}],\"Name\":[{\"Key\":2052,\"Value\":\"106017120006\"}],\"Number\":\"106017120006\",\"Description\":[{\"Key\":2052,\"Value\":\" \"}],\"CreateOrgId_Id\":100723,\"CreateOrgId\":{\"Id\":100723,\"MultiLanguageText\":[{\"PkId\":100043,\"LocaleId\":2052,\"Name\":\"无锡苏宁店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡苏宁店\"}],\"Number\":\"1020103\"},\"UseOrgId_Id\":100723,\"UseOrgId\":{\"Id\":100723,\"MultiLanguageText\":[{\"PkId\":100043,\"LocaleId\":2052,\"Name\":\"无锡苏宁店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡苏宁店\"}],\"Number\":\"1020103\"},\"CreatorId_Id\":100010,\"CreatorId\":{\"Id\":100010,\"Name\":\"邓觉\",\"UserAccount\":\"邓觉\"},\"ModifierId_Id\":100010,\"ModifierId\":{\"Id\":100010,\"Name\":\"邓觉\",\"UserAccount\":\"邓觉\"},\"CreateDate\":\"2017-12-29T21:38:56.737\",\"FModifyDate\":\"2017-12-29T21:38:56.797\",\"FCheckerId_Id\":100010,\"FCheckerId\":{\"Id\":100010,\"Name\":\"邓觉\",\"UserAccount\":\"邓觉\"},\"FCheckDate\":\"2017-12-29T21:38:56.737\",\"FCardLevelID_Id\":2480746,\"FCardLevelID\":{\"Id\":2480746,\"FFormId\":\"CMK_VIP_CardLevel\",\"msterID\":2480746,\"MultiLanguageText\":[{\"PkId\":100020,\"LocaleId\":2052,\"Name\":\"江苏字里行间悦享卡\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间悦享卡\"}],\"Number\":\"HYKJB2017016\",\"FDiscountRate\":95.0000000000,\"FPointsRate\":1.0000000000,\"FPriority\":950},\"FValidControl\":true,\"FConsumByPWD\":false,\"FDateStart\":\"2018-01-21T00:00:00\",\"FDateEnd\":\"2019-07-20T00:00:00\",\"FConsumePassword\":\"21218CCA77804D2BA1922C33E0151105\",\"FCardKey\":\" \",\"FCardStatus\":\"A\",\"FFreezeStatus\":\"A\",\"FVIPMemberID_Id\":2672242,\"FVIPMemberID\":{\"Id\":2672242,\"FFormId\":\"CMK_VIP_MembershipInfo\",\"msterID\":2672242,\"MultiLanguageText\":[{\"PkId\":2672166,\"LocaleId\":2052,\"Name\":\"吴湘君\",\"Description\":\"POS前台发卡\"}],\"Name\":[{\"Key\":2052,\"Value\":\"吴湘君\"}],\"Number\":\"POSVIP2672242\",\"Description\":[{\"Key\":2052,\"Value\":\"POS前台发卡\"}],\"FMobile\":\"15861588572\"},\"FSumPoints\":0.0,\"FCardMedia_Id\":\"005056c00008968111e3b1bde477f9ca\",\"FCardMedia\":{\"Id\":\"005056c00008968111e3b1bde477f9ca\",\"FNumber\":\"KJZSYS001\",\"MultiLanguageText\":[{\"PkId\":\"5934ec0e4c6b38\",\"LocaleId\":2052,\"FDataValue\":\"条码卡\"}],\"FDataValue\":[{\"Key\":2052,\"Value\":\"条码卡\"}]},\"FCurrencyID_Id\":1,\"FCurrencyID\":{\"Id\":1,\"msterID\":1,\"MultiLanguageText\":[{\"PkId\":2,\"LocaleId\":2052,\"Name\":\"人民币\"}],\"Name\":[{\"Key\":2052,\"Value\":\"人民币\"}],\"Number\":\"PRE001\",\"Sysmbol\":\"¥\",\"PriceDigits\":6,\"AmountDigits\":2,\"IsShowCSymbol\":true,\"FormatOrder\":\"1\",\"RoundType\":\"1\"},\"FCardIssuingFee\":0.0,\"FFaceValue\":60.0000000000,\"FValidPeriod\":365,\"FSumConsumAmt\":0.0,\"FSumAmtIn\":0.0,\"FSumReturns\":0.0,\"FBizOrgId_Id\":100723,\"FBizOrgId\":{\"Id\":100723,\"MultiLanguageText\":[{\"PkId\":100043,\"LocaleId\":2052,\"Name\":\"无锡苏宁店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡苏宁店\"}],\"Number\":\"1020103\"},\"FSaleAmount\":199.0000000000,\"FCardTypeID_Id\":2480748,\"FCardTypeID\":{\"Id\":2480748,\"FFormId\":\"CMK_VIP_CardType\",\"msterID\":2480748,\"MultiLanguageText\":[{\"PkId\":100020,\"LocaleId\":2052,\"Name\":\"江苏字里行间悦享卡\",\"Description\":\"无锡各门店购物和餐饮9.5折,借书每次60元内\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间悦享卡\"}],\"Number\":\"KLX201712290001\",\"Description\":[{\"Key\":2052,\"Value\":\"无锡各门店购物和餐饮9.5折,借书每次60元内\"}],\"FCardMedia_Id\":\"005056c00008968111e3b1bde477f9ca\",\"FCardMedia\":{\"Id\":\"005056c00008968111e3b1bde477f9ca\",\"Number\":\"KJZSYS001\",\"MultiLanguageText\":[{\"PkId\":\"5934ec0e4c6b38\",\"LocaleId\":2052,\"Name\":\"条码卡\"}],\"Name\":[{\"Key\":2052,\"Value\":\"条码卡\"}]},\"FCardNoLength\":12,\"FSkipNumbers\":\" \",\"FDefaultLevel_Id\":2480746,\"FDefaultLevel\":{\"Id\":2480746,\"msterID\":2480746,\"Number\":\"HYKJB2017016\",\"MultiLanguageText\":[{\"PkId\":100020,\"LocaleId\":2052,\"Name\":\"江苏字里行间悦享卡\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间悦享卡\"}]},\"FCardIssuingFee\":0.0,\"FFaceValue\":60.0000000000,\"FSaleAmount\":399.0000000000,\"FValidControl\":true,\"FValidPeriod\":365,\"FEncryptionValid\":false,\"FConsumByPWD\":false,\"FRangeCtrlType\":\"B\",\"FIsVIPBenefits\":false,\"FNotAnonymous\":true,\"FCONSUMBYICODE\":false,\"FIsFixedCard\":false,\"CardTypeAccts\":[{\"Id\":100037,\"Seq\":1,\"FAccountID_Id\":1,\"FAccountID\":{\"Id\":1,\"msterID\":1,\"Number\":\"1\",\"MultiLanguageText\":[{\"PkId\":1,\"LocaleId\":2052,\"Name\":\"积分账户\"}],\"Name\":[{\"Key\":2052,\"Value\":\"积分账户\"}]},\"FInitValue\":0.0},{\"Id\":100038,\"Seq\":2,\"FAccountID_Id\":424041,\"FAccountID\":{\"Id\":424041,\"msterID\":424041,\"Number\":\"ACCT201706280001\",\"MultiLanguageText\":[{\"PkId\":100002,\"LocaleId\":2052,\"Name\":\"借阅账户\"}],\"Name\":[{\"Key\":2052,\"Value\":\"借阅账户\"}]},\"FInitValue\":60.0000000000}],\"VipCardTypeChannels\":[{\"Id\":100976,\"Seq\":1,\"FChannelId_Id\":100714,\"FChannelId\":{\"Id\":100714,\"Number\":\"10202\",\"MultiLanguageText\":[{\"PkId\":100040,\"LocaleId\":2052,\"Name\":\"南京字里行间文化发展有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"南京字里行间文化发展有限公司\"}]}},{\"Id\":100977,\"Seq\":2,\"FChannelId_Id\":100723,\"FChannelId\":{\"Id\":100723,\"Number\":\"1020103\",\"MultiLanguageText\":[{\"PkId\":100043,\"LocaleId\":2052,\"Name\":\"无锡苏宁店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡苏宁店\"}]}},{\"Id\":100978,\"Seq\":3,\"FChannelId_Id\":100724,\"FChannelId\":{\"Id\":100724,\"Number\":\"1020104\",\"MultiLanguageText\":[{\"PkId\":100044,\"LocaleId\":2052,\"Name\":\"无锡宜家店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡宜家店\"}]}},{\"Id\":100979,\"Seq\":4,\"FChannelId_Id\":100716,\"FChannelId\":{\"Id\":100716,\"Number\":\"1020101\",\"MultiLanguageText\":[{\"PkId\":100041,\"LocaleId\":2052,\"Name\":\"苏州字里行间书店有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"苏州字里行间书店有限公司\"}]}},{\"Id\":100980,\"Seq\":5,\"FChannelId_Id\":100725,\"FChannelId\":{\"Id\":100725,\"Number\":\"102010101\",\"MultiLanguageText\":[{\"PkId\":100045,\"LocaleId\":2052,\"Name\":\"苏州华润店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"苏州华润店\"}]}},{\"Id\":100981,\"Seq\":6,\"FChannelId_Id\":100717,\"FChannelId\":{\"Id\":100717,\"Number\":\"1020102\",\"MultiLanguageText\":[{\"PkId\":100042,\"LocaleId\":2052,\"Name\":\"上海字里行间图书有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"上海字里行间图书有限公司\"}]}},{\"Id\":100982,\"Seq\":7,\"FChannelId_Id\":100726,\"FChannelId\":{\"Id\":100726,\"Number\":\"102010201\",\"MultiLanguageText\":[{\"PkId\":100046,\"LocaleId\":2052,\"Name\":\"上海高岛屋店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"上海高岛屋店\"}]}},{\"Id\":100983,\"Seq\":8,\"FChannelId_Id\":1645325,\"FChannelId\":{\"Id\":1645325,\"Number\":\"1020105\",\"MultiLanguageText\":[{\"PkId\":100059,\"LocaleId\":2052,\"Name\":\"江苏字里行间文化传播有限公司无锡东港店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间文化传播有限公司无锡东港店\"}]}},{\"Id\":100984,\"Seq\":9,\"FChannelId_Id\":1645326,\"FChannelId\":{\"Id\":1645326,\"Number\":\"102010501\",\"MultiLanguageText\":[{\"PkId\":100060,\"LocaleId\":2052,\"Name\":\"无锡东港店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡东港店\"}]}},{\"Id\":100985,\"Seq\":10,\"FChannelId_Id\":1843543,\"FChannelId\":{\"Id\":1843543,\"Number\":\"1020106\",\"MultiLanguageText\":[{\"PkId\":100061,\"LocaleId\":2052,\"Name\":\"江苏字里行间文化传播有限公司无锡茂业店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间文化传播有限公司��锡茂业店\"}]}},{\"Id\":100986,\"Seq\":11,\"FChannelId_Id\":1843544,\"FChannelId\":{\"Id\":1843544,\"Number\":\"102010601\",\"MultiLanguageText\":[{\"PkId\":100062,\"LocaleId\":2052,\"Name\":\"无锡茂业店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡茂业店\"}]}},{\"Id\":100987,\"Seq\":12,\"FChannelId_Id\":1843545,\"FChannelId\":{\"Id\":1843545,\"Number\":\"1020107\",\"MultiLanguageText\":[{\"PkId\":100063,\"LocaleId\":2052,\"Name\":\"江苏字里行间文化传播有限公司苏州景城店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间文化传播有限公司苏州景城店\"}]}},{\"Id\":100988,\"Seq\":13,\"FChannelId_Id\":1843546,\"FChannelId\":{\"Id\":1843546,\"Number\":\"102010701\",\"MultiLanguageText\":[{\"PkId\":100064,\"LocaleId\":2052,\"Name\":\"苏州景城店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"苏州景城店\"}]}},{\"Id\":100989,\"Seq\":14,\"FChannelId_Id\":2233123,\"FChannelId\":{\"Id\":2233123,\"Number\":\"1020108\",\"MultiLanguageText\":[{\"PkId\":100067,\"LocaleId\":2052,\"Name\":\"江苏字里行间文化传播有限公司无锡海岸城店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间文化传播有限公司无锡海岸城店\"}]}},{\"Id\":100990,\"Seq\":15,\"FChannelId_Id\":2233124,\"FChannelId\":{\"Id\":2233124,\"Number\":\"102010801\",\"MultiLanguageText\":[{\"PkId\":100068,\"LocaleId\":2052,\"Name\":\"无锡海岸城店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡海岸城店\"}]}},{\"Id\":100991,\"Seq\":16,\"FChannelId_Id\":2503062,\"FChannelId\":{\"Id\":2503062,\"Number\":\"1020109\",\"MultiLanguageText\":[{\"PkId\":100071,\"LocaleId\":2052,\"Name\":\"靖江字里行间书店有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"靖江字里行间书店有限公司\"}]}},{\"Id\":100992,\"Seq\":17,\"FChannelId_Id\":2503063,\"FChannelId\":{\"Id\":2503063,\"Number\":\"102010901\",\"MultiLanguageText\":[{\"PkId\":100072,\"LocaleId\":2052,\"Name\":\"靖江字里行间书店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"靖江字里行间书店\"}]}},{\"Id\":100993,\"Seq\":18,\"FChannelId_Id\":4150092,\"FChannelId\":{\"Id\":4150092,\"Number\":\"102010902\",\"MultiLanguageText\":[{\"PkId\":100100,\"LocaleId\":2052,\"Name\":\"靖江新体店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"靖江新体店\"}]}},{\"Id\":100994,\"Seq\":19,\"FChannelId_Id\":2828419,\"FChannelId\":{\"Id\":2828419,\"Number\":\"10201\",\"MultiLanguageText\":[{\"PkId\":100073,\"LocaleId\":2052,\"Name\":\"江苏字里行间文化传播有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间文化传播有限公司\"}]}},{\"Id\":100995,\"Seq\":20,\"FChannelId_Id\":2916344,\"FChannelId\":{\"Id\":2916344,\"Number\":\"10203\",\"MultiLanguageText\":[{\"PkId\":100074,\"LocaleId\":2052,\"Name\":\"江苏字里行间商贸有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间商贸有限公司\"}]}},{\"Id\":100996,\"Seq\":21,\"FChannelId_Id\":3488583,\"FChannelId\":{\"Id\":3488583,\"Number\":\"1020110\",\"MultiLanguageText\":[{\"PkId\":100077,\"LocaleId\":2052,\"Name\":\"无锡天莹诚信文化传播有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡天莹诚信文化传播有限公司\"}]}},{\"Id\":100997,\"Seq\":22,\"FChannelId_Id\":3488586,\"FChannelId\":{\"Id\":3488586,\"Number\":\"102011001\",\"MultiLanguageText\":[{\"PkId\":100079,\"LocaleId\":2052,\"Name\":\"无锡五爱路店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡五爱路店\"}]}},{\"Id\":100998,\"Seq\":23,\"FChannelId_Id\":3488584,\"FChannelId\":{\"Id\":3488584,\"Number\":\"1020111\",\"MultiLanguageText\":[{\"PkId\":100078,\"LocaleId\":2052,\"Name\":\"江苏字里行间文化传播有限公司昆山万科店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间文化传播有限公司昆山万科店\"}]}},{\"Id\":100999,\"Seq\":24,\"FChannelId_Id\":3488587,\"FChannelId\":{\"Id\":3488587,\"Number\":\"102011101\",\"MultiLanguageText\":[{\"PkId\":100080,\"LocaleId\":2052,\"Name\":\"昆山万科店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"昆山万科店\"}]}}]},\"FCONSUMBYICODE\":false,\"FIsFixedCard\":false,\"FBranchID_Id\":179113,\"FBranchID\":{\"Id\":179113,\"FFormId\":\"CMK_LS_Branch\",\"msterID\":179113,\"MultiLanguageText\":[{\"PkId\":100027,\"LocaleId\":2052,\"Name\":\"无锡华润苏宁店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡华润苏宁店\"}],\"Number\":\"1020103\"},\"FControlBranchId_Id\":179113,\"FControlBranchId\":{\"Id\":179113,\"FFormId\":\"CMK_LS_Branch\",\"msterID\":179113,\"MultiLanguageText\":[{\"PkId\":100027,\"LocaleId\":2052,\"Name\":\"无锡华润苏宁店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡华润苏宁店\"}],\"Number\":\"1020103\"},\"FIntroduceCardID_Id\":0,\"FIntroduceCardID\":null,\"F_CMK_KH_Id\":0,\"F_CMK_KH\":null,\"F_CMK_WL_Id\":0,\"F_CMK_WL\":null,\"F_CMK_YSJE\":0.0,\"F_CMK_Text\":\" \",\"CardAccts\":[{\"Id\":182964,\"Seq\":1,\"FAccountID_Id\":1,\"FAccountID\":{\"Id\":1,\"FFormId\":\"CMK_VIP_CardAccount\",\"msterID\":1,\"MultiLanguageText\":[{\"PkId\":1,\"LocaleId\":2052,\"Name\":\"积分账户\"}],\"Name\":[{\"Key\":2052,\"Value\":\"积分账户\"}],\"Number\":\"1\",\"FAcctType\":\"A\",\"FCanConsume\":false,\"FCanPoints\":false,\"FValidControl\":false,\"FValidPeriod\":0,\"FCanRecharge\":false,\"FCanReturn\":false,\"FReturnFeeRate\":0.0},\"FValue\":0.0,\"FAcctValidCtrl\":false,\"FAcctDateStart\":null,\"FAcctDateEnd\":null,\"FCanPromotion\":false},{\"Id\":182965,\"Seq\":2,\"FAccountID_Id\":424041,\"FAccountID\":{\"Id\":424041,\"FFormId\":\"CMK_VIP_CardAccount\",\"msterID\":424041,\"MultiLanguageText\":[{\"PkId\":100002,\"LocaleId\":2052,\"Name\":\"借阅账户\"}],\"Name\":[{\"Key\":2052,\"Value\":\"借阅账户\"}],\"Number\":\"ACCT201706280001\",\"FAcctType\":\"B\",\"FCanConsume\":false,\"FCanPoints\":false,\"FValidControl\":false,\"FValidPeriod\":0,\"FCanRecharge\":true,\"FCanReturn\":false,\"FReturnFeeRate\":0.0},\"FValue\":60.0000000000,\"FAcctValidCtrl\":false,\"FAcctDateStart\":null,\"FAcctDateEnd\":null,\"FCanPromotion\":false}],\"ServiceAcctEntry\":[{\"Id\":0,\"Seq\":1,\"FMaterialId_Id\":0,\"FMaterialId\":null,\"FIsControlDate\":true,\"FAccountAmount\":0.0,\"FSrvAcctValidPeriod\":0,\"FMsterID\":null,\"FAccountDateBegin\":null,\"FAccountDateEnd\":null,\"FCountCtl\":0.0,\"FUnitID_Id\":0,\"FUnitID\":null,\"FBaseUnitID_Id\":0,\"FBaseUnitID\":null,\"FBaseQty\":0.0,\"FRetailPrice\":0.0,\"FPrice\":0.0,\"FPaidAmount\":0.0,\"FIsEnable\":false,\"FAddConsumeQty\":0.0,\"FAddConsumeAmount\":0.0,\"FRechargeRuleID_Id\":0,\"FRechargeRuleID\":null}],\"FBillHead_Link\":[]}}}","{\"Result\":{\"ResponseStatus\":null,\"Result\":{\"Id\":2816561,\"FFormId\":\"CMK_VIP_CardInfo\",\"msterID\":2816561,\"DocumentStatus\":\"C\",\"ForbidStatus\":\"A\",\"MultiLanguageText\":[{\"PkId\":1486211,\"LocaleId\":2052,\"Name\":\"556018020014\",\"Description\":\" \"}],\"Name\":[{\"Key\":2052,\"Value\":\"556018020014\"}],\"Number\":\"556018020014\",\"Description\":[{\"Key\":2052,\"Value\":\" \"}],\"CreateOrgId_Id\":100723,\"CreateOrgId\":{\"Id\":100723,\"MultiLanguageText\":[{\"PkId\":100043,\"LocaleId\":2052,\"Name\":\"无锡苏宁店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡苏宁店\"}],\"Number\":\"1020103\"},\"UseOrgId_Id\":100723,\"UseOrgId\":{\"Id\":100723,\"MultiLanguageText\":[{\"PkId\":100043,\"LocaleId\":2052,\"Name\":\"无锡苏宁店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡苏宁店\"}],\"Number\":\"1020103\"},\"CreatorId_Id\":179914,\"CreatorId\":{\"Id\":179914,\"Name\":\"虞岚\",\"UserAccount\":\"虞岚\"},\"ModifierId_Id\":179914,\"ModifierId\":{\"Id\":179914,\"Name\":\"虞岚\",\"UserAccount\":\"虞岚\"},\"CreateDate\":\"2018-02-14T17:34:41.76\",\"FModifyDate\":\"2018-02-14T17:34:41.81\",\"FCheckerId_Id\":179914,\"FCheckerId\":{\"Id\":179914,\"Name\":\"虞岚\",\"UserAccount\":\"虞岚\"},\"FCheckDate\":\"2018-02-14T17:34:41.76\",\"FCardLevelID_Id\":1003,\"FCardLevelID\":{\"Id\":1003,\"FFormId\":\"CMK_VIP_CardLevel\",\"msterID\":1003,\"MultiLanguageText\":[{\"PkId\":1003,\"LocaleId\":2052,\"Name\":\"普卡\"}],\"Name\":[{\"Key\":2052,\"Value\":\"普卡\"}],\"Number\":\"03\",\"FDiscountRate\":100.0000000000,\"FPointsRate\":1.0000000000,\"FPriority\":990},\"FValidControl\":false,\"FConsumByPWD\":false,\"FDateStart\":null,\"FDateEnd\":null,\"FConsumePassword\":\"21218CCA77804D2BA1922C33E0151105\",\"FCardKey\":\" \",\"FCardStatus\":\"A\",\"FFreezeStatus\":\"A\",\"FVIPMemberID_Id\":2672242,\"FVIPMemberID\":{\"Id\":2672242,\"FFormId\":\"CMK_VIP_MembershipInfo\",\"msterID\":2672242,\"MultiLanguageText\":[{\"PkId\":2672166,\"LocaleId\":2052,\"Name\":\"吴湘君\",\"Description\":\"POS前台发卡\"}],\"Name\":[{\"Key\":2052,\"Value\":\"吴湘君\"}],\"Number\":\"POSVIP2672242\",\"Description\":[{\"Key\":2052,\"Value\":\"POS前台发卡\"}],\"FMobile\":\"15861588572\"},\"FSumPoints\":0.0,\"FCardMedia_Id\":\"005056c00008968111e3b1bde477f9ca\",\"FCardMedia\":{\"Id\":\"005056c00008968111e3b1bde477f9ca\",\"FNumber\":\"KJZSYS001\",\"MultiLanguageText\":[{\"PkId\":\"5934ec0e4c6b38\",\"LocaleId\":2052,\"FDataValue\":\"条码卡\"}],\"FDataValue\":[{\"Key\":2052,\"Value\":\"条码卡\"}]},\"FCurrencyID_Id\":1,\"FCurrencyID\":{\"Id\":1,\"msterID\":1,\"MultiLanguageText\":[{\"PkId\":2,\"LocaleId\":2052,\"Name\":\"人民币\"}],\"Name\":[{\"Key\":2052,\"Value\":\"人民币\"}],\"Number\":\"PRE001\",\"Sysmbol\":\"¥\",\"PriceDigits\":6,\"AmountDigits\":2,\"IsShowCSymbol\":true,\"FormatOrder\":\"1\",\"RoundType\":\"1\"},\"FCardIssuingFee\":0.0,\"FFaceValue\":0.0,\"FValidPeriod\":0,\"FSumConsumAmt\":0.0,\"FSumAmtIn\":220.0000000000,\"FSumReturns\":0.0,\"FBizOrgId_Id\":100723,\"FBizOrgId\":{\"Id\":100723,\"MultiLanguageText\":[{\"PkId\":100043,\"LocaleId\":2052,\"Name\":\"无锡苏宁店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡苏宁店\"}],\"Number\":\"1020103\"},\"FSaleAmount\":0.0,\"FCardTypeID_Id\":2216833,\"FCardTypeID\":{\"Id\":2216833,\"FFormId\":\"CMK_VIP_CardType\",\"msterID\":2216833,\"MultiLanguageText\":[{\"PkId\":100010,\"LocaleId\":2052,\"Name\":\"储值卡(江苏上海)\",\"Description\":\"具有储值功能,无积分、不享受会员价、无会员折扣、无兑奖功能;\"}],\"Name\":[{\"Key\":2052,\"Value\":\"储值卡(江苏上海)\"}],\"Number\":\"KLX201712050001\",\"Description\":[{\"Key\":2052,\"Value\":\"具有储值功能,无积分、不享受会员价、无会员折扣、无兑奖功能;\"}],\"FCardMedia_Id\":\"005056c00008968111e3b1bde477f9ca\",\"FCardMedia\":{\"Id\":\"005056c00008968111e3b1bde477f9ca\",\"Number\":\"KJZSYS001\",\"MultiLanguageText\":[{\"PkId\":\"5934ec0e4c6b38\",\"LocaleId\":2052,\"Name\":\"条码卡\"}],\"Name\":[{\"Key\":2052,\"Value\":\"条码卡\"}]},\"FCardNoLength\":12,\"FSkipNumbers\":\" \",\"FDefaultLevel_Id\":1003,\"FDefaultLevel\":{\"Id\":1003,\"msterID\":1003,\"Number\":\"03\",\"MultiLanguageText\":[{\"PkId\":1003,\"LocaleId\":2052,\"Name\":\"普卡\"}],\"Name\":[{\"Key\":2052,\"Value\":\"普卡\"}]},\"FCardIssuingFee\":0.0,\"FFaceValue\":0.0,\"FSaleAmount\":0.0,\"FValidControl\":false,\"FValidPeriod\":0,\"FEncryptionValid\":false,\"FConsumByPWD\":false,\"FRangeCtrlType\":\"B\",\"FIsVIPBenefits\":false,\"FNotAnonymous\":true,\"FCONSUMBYICODE\":false,\"FIsFixedCard\":false,\"CardTypeAccts\":[{\"Id\":100018,\"Seq\":1,\"FAccountID_Id\":2,\"FAccountID\":{\"Id\":2,\"msterID\":2,\"Number\":\"2\",\"MultiLanguageText\":[{\"PkId\":2,\"LocaleId\":2052,\"Name\":\"储值账户\"}],\"Name\":[{\"Key\":2052,\"Value\":\"储值账户\"}]},\"FInitValue\":0.0}],\"VipCardTypeChannels\":[{\"Id\":101005,\"Seq\":1,\"FChannelId_Id\":100714,\"FChannelId\":{\"Id\":100714,\"Number\":\"10202\",\"MultiLanguageText\":[{\"PkId\":100040,\"LocaleId\":2052,\"Name\":\"南京字里行间文化发展有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"南京字里行间文化发展有限公司\"}]}},{\"Id\":101006,\"Seq\":2,\"FChannelId_Id\":100723,\"FChannelId\":{\"Id\":100723,\"Number\":\"1020103\",\"MultiLanguageText\":[{\"PkId\":100043,\"LocaleId\":2052,\"Name\":\"无锡苏宁店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡苏宁店\"}]}},{\"Id\":101007,\"Seq\":3,\"FChannelId_Id\":100724,\"FChannelId\":{\"Id\":100724,\"Number\":\"1020104\",\"MultiLanguageText\":[{\"PkId\":100044,\"LocaleId\":2052,\"Name\":\"无锡宜家店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡宜家店\"}]}},{\"Id\":101008,\"Seq\":4,\"FChannelId_Id\":100716,\"FChannelId\":{\"Id\":100716,\"Number\":\"1020101\",\"MultiLanguageText\":[{\"PkId\":100041,\"LocaleId\":2052,\"Name\":\"苏州字里行间书店有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"苏州字里行间书店有限公司\"}]}},{\"Id\":101009,\"Seq\":5,\"FChannelId_Id\":100725,\"FChannelId\":{\"Id\":100725,\"Number\":\"102010101\",\"MultiLanguageText\":[{\"PkId\":100045,\"LocaleId\":2052,\"Name\":\"苏州华润店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"苏州华润店\"}]}},{\"Id\":101010,\"Seq\":6,\"FChannelId_Id\":100717,\"FChannelId\":{\"Id\":100717,\"Number\":\"1020102\",\"MultiLanguageText\":[{\"PkId\":100042,\"LocaleId\":2052,\"Name\":\"上海字里行间图书有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"上海字里行间图书有限公司\"}]}},{\"Id\":101011,\"Seq\":7,\"FChannelId_Id\":100726,\"FChannelId\":{\"Id\":100726,\"Number\":\"102010201\",\"MultiLanguageText\":[{\"PkId\":100046,\"LocaleId\":2052,\"Name\":\"上海高岛屋店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"上海高岛屋店\"}]}},{\"Id\":101012,\"Seq\":8,\"FChannelId_Id\":1645325,\"FChannelId\":{\"Id\":1645325,\"Number\":\"1020105\",\"MultiLanguageText\":[{\"PkId\":100059,\"LocaleId\":2052,\"Name\":\"江苏字里行间文化传播有限公司无锡东港店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间文化传播有限公司无锡东港店\"}]}},{\"Id\":101013,\"Seq\":9,\"FChannelId_Id\":1645326,\"FChannelId\":{\"Id\":1645326,\"Number\":\"102010501\",\"MultiLanguageText\":[{\"PkId\":100060,\"LocaleId\":2052,\"Name\":\"无锡东港店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡东港店\"}]}},{\"Id\":101014,\"Seq\":10,\"FChannelId_Id\":1843543,\"FChannelId\":{\"Id\":1843543,\"Number\":\"1020106\",\"MultiLanguageText\":[{\"PkId\":100061,\"LocaleId\":2052,\"Name\":\"江苏字里行间文化传播有限公司无锡茂业店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间文化传播有限公司无锡茂业店\"}]}},{\"Id\":101015,\"Seq\":11,\"FChannelId_Id\":1843544,\"FChannelId\":{\"Id\":1843544,\"Number\":\"102010601\",\"MultiLanguageText\":[{\"PkId\":100062,\"LocaleId\":2052,\"Name\":\"无锡茂业店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡茂业店\"}]}},{\"Id\":101016,\"Seq\":12,\"FChannelId_Id\":1843545,\"FChannelId\":{\"Id\":1843545,\"Number\":\"1020107\",\"MultiLanguageText\":[{\"PkId\":100063,\"LocaleId\":2052,\"Name\":\"江苏字里行间文化传播有限公司苏州景城店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间文化传播有限公司苏州景城店\"}]}},{\"Id\":101017,\"Seq\":13,\"FChannelId_Id\":1843546,\"FChannelId\":{\"Id\":1843546,\"Number\":\"102010701\",\"MultiLanguageText\":[{\"PkId\":100064,\"LocaleId\":2052,\"Name\":\"苏州景城店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"苏州景城店\"}]}},{\"Id\":101018,\"Seq\":14,\"FChannelId_Id\":2233123,\"FChannelId\":{\"Id\":2233123,\"Number\":\"1020108\",\"MultiLanguageText\":[{\"PkId\":100067,\"LocaleId\":2052,\"Name\":\"江苏字里行间文化传播有限公司无锡海岸城店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间文化传播有限公司无锡海岸城店\"}]}},{\"Id\":101019,\"Seq\":15,\"FChannelId_Id\":2233124,\"FChannelId\":{\"Id\":2233124,\"Number\":\"102010801\",\"MultiLanguageText\":[{\"PkId\":100068,\"LocaleId\":2052,\"Name\":\"无锡海岸城店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡海岸城店\"}]}},{\"Id\":101020,\"Seq\":16,\"FChannelId_Id\":2503062,\"FChannelId\":{\"Id\":2503062,\"Number\":\"1020109\",\"MultiLanguageText\":[{\"PkId\":100071,\"LocaleId\":2052,\"Name\":\"靖江字里行间书店有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"靖江字里行间书店有限公司\"}]}},{\"Id\":101021,\"Seq\":17,\"FChannelId_Id\":2503063,\"FChannelId\":{\"Id\":2503063,\"Number\":\"102010901\",\"MultiLanguageText\":[{\"PkId\":100072,\"LocaleId\":2052,\"Name\":\"靖江字里行间书店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"靖江字里行间书店\"}]}},{\"Id\":101022,\"Seq\":18,\"FChannelId_Id\":4150092,\"FChannelId\":{\"Id\":4150092,\"Number\":\"102010902\",\"MultiLanguageText\":[{\"PkId\":100100,\"LocaleId\":2052,\"Name\":\"靖江新体店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"靖江新体店\"}]}},{\"Id\":101023,\"Seq\":19,\"FChannelId_Id\":2828419,\"FChannelId\":{\"Id\":2828419,\"Number\":\"10201\",\"MultiLanguageText\":[{\"PkId\":100073,\"LocaleId\":2052,\"Name\":\"江苏字里行间文化传播有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间文化传播有限公司\"}]}},{\"Id\":101024,\"Seq\":20,\"FChannelId_Id\":2916344,\"FChannelId\":{\"Id\":2916344,\"Number\":\"10203\",\"MultiLanguageText\":[{\"PkId\":100074,\"LocaleId\":2052,\"Name\":\"江苏字里行间商贸有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间商贸有限公司\"}]}},{\"Id\":101025,\"Seq\":21,\"FChannelId_Id\":3488583,\"FChannelId\":{\"Id\":3488583,\"Number\":\"1020110\",\"MultiLanguageText\":[{\"PkId\":100077,\"LocaleId\":2052,\"Name\":\"无锡天莹诚信文化传播有限公司\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡天莹诚信文化传播有限公司\"}]}},{\"Id\":101026,\"Seq\":22,\"FChannelId_Id\":3488586,\"FChannelId\":{\"Id\":3488586,\"Number\":\"102011001\",\"MultiLanguageText\":[{\"PkId\":100079,\"LocaleId\":2052,\"Name\":\"无锡五爱路店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡五爱路店\"}]}},{\"Id\":101027,\"Seq\":23,\"FChannelId_Id\":3488584,\"FChannelId\":{\"Id\":3488584,\"Number\":\"1020111\",\"MultiLanguageText\":[{\"PkId\":100078,\"LocaleId\":2052,\"Name\":\"江苏字里行间文化传播有限公司昆山万科店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"江苏字里行间文化传播有限公司昆山万科店\"}]}},{\"Id\":101028,\"Seq\":24,\"FChannelId_Id\":3488587,\"FChannelId\":{\"Id\":3488587,\"Number\":\"102011101\",\"MultiLanguageText\":[{\"PkId\":100080,\"LocaleId\":2052,\"Name\":\"昆山万科店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"昆山万科店\"}]}}]},\"FCONSUMBYICODE\":false,\"FIsFixedCard\":false,\"FBranchID_Id\":179113,\"FBranchID\":{\"Id\":179113,\"FFormId\":\"CMK_LS_Branch\",\"msterID\":179113,\"MultiLanguageText\":[{\"PkId\":100027,\"LocaleId\":2052,\"Name\":\"无锡华润苏宁店\"}],\"Name\":[{\"Key\":2052,\"Value\":\"无锡华润苏宁店\"}],\"Number\":\"1020103\"},\"FControlBranchId_Id\":0,\"FControlBranchId\":null,\"FIntroduceCardID_Id\":0,\"FIntroduceCardID\":null,\"F_CMK_KH_Id\":0,\"F_CMK_KH\":null,\"F_CMK_WL_Id\":0,\"F_CMK_WL\":null,\"F_CMK_YSJE\":0.0,\"F_CMK_Text\":\" \",\"CardAccts\":[{\"Id\":214702,\"Seq\":1,\"FAccountID_Id\":2,\"FAccountID\":{\"Id\":2,\"FFormId\":\"CMK_VIP_CardAccount\",\"msterID\":2,\"MultiLanguageText\":[{\"PkId\":2,\"LocaleId\":2052,\"Name\":\"储值账户\"}],\"Name\":[{\"Key\":2052,\"Value\":\"储值账户\"}],\"Number\":\"2\",\"FAcctType\":\"B\",\"FCanConsume\":true,\"FCanPoints\":false,\"FValidControl\":false,\"FValidPeriod\":0,\"FCanRecharge\":true,\"FCanReturn\":true,\"FReturnFeeRate\":0.0},\"FValue\":52.0000000000,\"FAcctValidCtrl\":false,\"FAcctDateStart\":null,\"FAcctDateEnd\":null,\"FCanPromotion\":true}],\"ServiceAcctEntry\":[{\"Id\":0,\"Seq\":1,\"FMaterialId_Id\":0,\"FMaterialId\":null,\"FIsControlDate\":true,\"FAccountAmount\":0.0,\"FSrvAcctValidPeriod\":0,\"FMsterID\":null,\"FAccountDateBegin\":null,\"FAccountDateEnd\":null,\"FCountCtl\":0.0,\"FUnitID_Id\":0,\"FUnitID\":null,\"FBaseUnitID_Id\":0,\"FBaseUnitID\":null,\"FBaseQty\":0.0,\"FRetailPrice\":0.0,\"FPrice\":0.0,\"FPaidAmount\":0.0,\"FIsEnable\":false,\"FAddConsumeQty\":0.0,\"FAddConsumeAmount\":0.0,\"FRechargeRuleID_Id\":0,\"FRechargeRuleID\":null}],\"FBillHead_Link\":[]}}}"]
22019-04-03 17:17:02,108 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM VIP_d  WHERE id=?
    | 1 |
    |---|
    | 0 |
  For example:> "SELECT * FROM VIP_d  WHERE id=0"
2019-04-03 17:17:02,137 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - INSERT INTO VIP_d(CardNumber,Cardlevel,CardStatus,IsInvalid,OpenTime,EndTime,Balance,DrinkCupTicket,CreateTime,UpdateTime) VALUES(?,?,?,?,?,?,?,?,?,?) 
    |            1 |  2 | 3 | 4 |    5 |    6 |    7 |    8 |    9 |   10 |
    |--------------|----|---|---|------|------|------|------|------|------|
    | 556018020014 | 普卡 | A | A | NULL | NULL | NULL | NULL | NULL | NULL |
    | 556018020014 | 普卡 | A | A | NULL | NULL | NULL | NULL | NULL | NULL |
  For example:> "INSERT INTO VIP_d(CardNumber,Cardlevel,CardStatus,IsInvalid,OpenTime,EndTime,Balance,DrinkCupTicket,CreateTime,UpdateTime) VALUES('556018020014','普卡','A','A',NULL,NULL,NULL,NULL,NULL,NULL) "
2019-04-03 17:17:02,152 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException
java.sql.BatchUpdateException: Duplicate entry '556018020014' for key 'CardNumber'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.cj.core.util.Util.handleNewInstance(Util.java:185)
	at com.mysql.cj.core.util.Util.getInstance(Util.java:168)
	at com.mysql.cj.core.util.Util.getInstance(Util.java:175)
	at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:636)
	at com.mysql.cj.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1734)
	at com.mysql.cj.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1217)
	at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:1009)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:566)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:322)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:159)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:126)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:93)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:82)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:55)
	at org.nutz.dao.impl.NutDao.fastInsert(NutDao.java:193)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:140)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:155)
	at org.nutz.dao.impl.NutDao.insertOrUpdate(NutDao.java:1088)
	at org.nutz.dao.impl.NutDao.insertOrUpdate(NutDao.java:1067)
	at net.wendal.nutzbook.dao.UserDao.SelectUser(UserDao.java:107)
	at net.wendal.nutzbook.WxHandler.DefaultWxHandler.text(DefaultWxHandler.java:51)
	at org.nutz.weixin.util.Wxs.handle(Wxs.java:268)
	at org.nutz.weixin.impl.AbstractWxHandler.handle(AbstractWxHandler.java:93)
	at org.nutz.weixin.util.Wxs.handle(Wxs.java:699)
	at net.wendal.nutzbook.weinModel.WeixinModule.msgin(WeixinModule.java:26)
	at net.wendal.nutzbook.weinModel.WeixinModule$FM$msgin$b806526ae658790edc3fc063949c9d61.invoke(WeixinModule.java)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:31)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:30)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2441)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2430)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '556018020014' for key 'CardNumber'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:533)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
	at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
	at com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1826)
	at com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2034)
	at com.mysql.cj.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1712)
	... 60 more
2019-04-03 17:17:02,172 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN  - Error@/weixin/msgin :
org.nutz.dao.DaoException: !Nutz SQL Error: 'INSERT INTO VIP_d(CardNumber,Cardlevel,CardStatus,IsInvalid,OpenTime,EndTime,Balance,DrinkCupTicket,CreateTime,UpdateTime) VALUES('556018020014','普卡','A','A',NULL,NULL,NULL,NULL,NULL,NULL) '
PreparedStatement: 
'INSERT INTO VIP_d(CardNumber,Cardlevel,CardStatus,IsInvalid,OpenTime,EndTime,Balance,DrinkCupTicket,CreateTime,UpdateTime) VALUES(?,?,?,?,?,?,?,?,?,?) '
CaseMessage=Duplicate entry '556018020014' for key 'CardNumber'
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:159)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:126)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:93)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:82)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:55)
	at org.nutz.dao.impl.NutDao.fastInsert(NutDao.java:193)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:140)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:155)
	at org.nutz.dao.impl.NutDao.insertOrUpdate(NutDao.java:1088)
	at org.nutz.dao.impl.NutDao.insertOrUpdate(NutDao.java:1067)
	at net.wendal.nutzbook.dao.UserDao.SelectUser(UserDao.java:107)
	at net.wendal.nutzbook.WxHandler.DefaultWxHandler.text(DefaultWxHandler.java:51)
	at org.nutz.weixin.util.Wxs.handle(Wxs.java:268)
	at org.nutz.weixin.impl.AbstractWxHandler.handle(AbstractWxHandler.java:93)
	at org.nutz.weixin.util.Wxs.handle(Wxs.java:699)
	at net.wendal.nutzbook.weinModel.WeixinModule.msgin(WeixinModule.java:26)
	at net.wendal.nutzbook.weinModel.WeixinModule$FM$msgin$b806526ae658790edc3fc063949c9d61.invoke(WeixinModule.java)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:31)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:30)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2441)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2430)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.BatchUpdateException: Duplicate entry '556018020014' for key 'CardNumber'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.cj.core.util.Util.handleNewInstance(Util.java:185)
	at com.mysql.cj.core.util.Util.getInstance(Util.java:168)
	at com.mysql.cj.core.util.Util.getInstance(Util.java:175)
	at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:636)
	at com.mysql.cj.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1734)
	at com.mysql.cj.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1217)
	at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:1009)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:566)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:322)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90)
	... 55 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '556018020014' for key 'CardNumber'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:533)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
	at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
	at com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1826)
	at com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2034)
	at com.mysql.cj.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1712)
	... 60 more

5 回复

insertupdate(list)期望也可以实现校验重复项,期望想知道insertupdate的逻辑规则

是insertOrUpdate方法, 不是insertupdate

具体逻辑,看源码比我说得更清楚

是的以上报错是insertOrUpdate的报错。回复简写了

以上报错是不是说我的插入两个完全一样的,那么这块怎么去规避好呢?还是怎么处理啊

for循环调用, insertOrUpdate不支持集合

添加回复
请先登陆
回到顶部