@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
