Cause: java.sql.SQLException: Data truncated for column 'LOAN_SUM' at row 1

现象：

> ### Cause: java.sql.SQLException: Data truncated for column 'LOAN_SUM' at row 14 ; SQL []; Data truncated for column 'LOAN_SUM' at row 14;> nested exception is java.sql.SQLException: Data truncated for column> 'LOAN_SUM' at row 14 2017-08-15 08:41:21,668 [http-nio-8080-exec-7]> INFO  [com.jjshome.cj.service.timer.impl.CjBankServiceTimerImpl] -> ResponseVO [id=null, rtnCode=000, rtnInfo=该笔交易托管信息待处理中，尚无状态,> requestNo=20170815084122389349, dealNo=8120220150000010,> agNo=DCZJ00000000202, agDealNo=M3331511-2682, cliname=, loansum=,> loanterm=, termCode=, execrate=, rejectMessage=,> processingStatus=null,> ohTrust=com.jjshome.cj.entity.bank.InnerNode@412edb87,> ohRonsom=com.jjshome.cj.entity.bank.InnerNode@6b4e9d7f,> ohMortgage=com.jjshome.cj.entity.bank.InnerNode@764633e2,> insertDate=null, cjId=1a49e0d0-703c-41f0-8364-d74dbeeed3d8,> termCodeStr=null]> org.springframework.dao.DataIntegrityViolationException: > ### Error updating database.  Cause: java.sql.SQLException: Data truncated for column 'LOAN_SUM' at row 14> ### The error may involve com.jjshome.cj.dao.bank.ICjBankDAO.updateCjRespInfoByIdSelective-Inline> ### The error occurred while setting parameters> ### SQL: UPDATE CJ_RESP_INFO    SET AG_NO=?,             AG_DEAL_NO=?,             DEAL_NO=?,             CLI_NAME=?,             LOAN_SUM=?,            > LOAN_TERM=?,             TERM_CODE=?    WHERE    DEAL_NO = ?> ### Cause: java.sql.SQLException: Data truncated for column 'LOAN_SUM' at row 14 ; SQL []; Data truncated for column 'LOAN_SUM' at row 14;> nested exception is java.sql.SQLException: Data truncated for column> 'LOAN_SUM' at row 14

原因分析：
通过上面的ResponseVO打出来的字段信息，发现是loansum字段是double类型，在更新时传了空字符串导致的，下面具体说明下：
1.表字段设计成double的

2.实体类字段类型为string 的

3.mybatis里面的参数判断没有做空字符串判断

所以在修改时修改字段被修改为空字符串，由于字段类型是double的，所以就报了上面的异常信息。

解决方法:
1.在XML里面加上对空串的判断

2.修改实体类，把所有字段改成跟相对应的数据类型。