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.修改实体类，把所有字段改成跟相对应的数据类型。