Improper inline parameter map format. Should be: #{propName,attr1=val1,attr2;
update wm_stock_${model.tableName} where WMST_ID = #{model.wmstId,jdbcType=INTEGER} WMST_WR_ID = #{model.wmstWrId,jdbcType=INTEGER}, WMST_WH_LOC_ID = #{model.wmstWhLocId,jdbcType=INTEGER}, WMST_SKU_ID = #{model.wmstSkuId,jdbcType=INTEGER}, WMST_SKU_NAME = #{model.wmstSkuName,jdbcType=VARCHAR}, WMST_SKU_GRADE = #{model.wmstSkuGrade,jdbcType=VARCHAR}, WMST_CODE = #{model.wmstCode,jdbcType=VARCHAR}, WMST_SKU_BATCH = #{model.wmstSkuBatch,jdbcType=VARCHAR}, WMST_SKU_UNIT = #{model.wmstSkuUnit,jdbcType=VARCHAR}, WMS_SKU_CATEGORY = #{model.wmsSkuCategory,jdbcType=INTEGER}, WMST_CUSTOMER_CODE = #{model.wmstCustomerCode,jdbcType=INTEGER}, WMST_CUSTOMER_NAME = #{model.wmstCustomerName,jdbcType=INTEGER}, WMST_ENABLED_NUMBER = #{model.wmstEnabledNumber,jdbcType=DOUBLE}, WMST_NOW_NUMBER = #{model.wmstNowNumber,jdbcType=DOUBLE}, WMST_MOVEIN_NUMBER = #{model.wmstMoveinNumber,jdbcType=DOUBLE}, WMST_MOVEOUT_NUMBER = #{model.wmstMoveoutNumber,jdbcType=DOUBLE}, WMST_FROZEN_NUMBER = #{model.wmstFrozenNumber,jdbcType=DOUBLE}, WMST_WH_LOC_TYPE = #{model.wmstWhLocType,jdbcType=INTEGER}, WMST_RECEIVE_DATE = #{model.wmstReceiveDate,jdbcType=TIMESTAMP}, WMST_FINANCE_ORDER_CODE = #{model.wmstFinanceOrderCode,jdbcType=VARCHAR}, WMST_ORDER_NO = #{model.wmstOrderNo,jdbcType=VARCHAR}, WMST_STATUS = #{model.wmstStatus,jdbcType=INTEGER}, WMST_EXEPICK_VERSION = #{model.wmstExepickVersion +1,jdbcType=INTEGER}, WMST_PRODUCT_DATE = #{model.wmstProductDate,jdbcType=TIMESTAMP}, WMST_DISABLE_DATE = #{model.wmstDisableDate,jdbcType=TIMESTAMP}, WMST_VALIDITY_DATE = #{model.wmstValidityDate,jdbcType=VARCHAR}, WMST_STORE_START_DATE = #{model.wmstStoreStartDate,jdbcType=TIMESTAMP}, WMST_STORE_LAST_DATE = #{model.wmstStoreLastDate,jdbcType=TIMESTAMP},
一条update 语句引发的血案?有两个方面的原因:
跟你从网上搜到的结果一样:说的是#{model.wmstStoreLastDate,jdbcType=TIMESTAMP},等号之间有空格;
数据库数据存在问题(我的属于这种);