com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
来源:互联网 发布:数码宝贝网络侦探智力 编辑:程序博客网 时间:2024/05/16 06:51
提示的原因是“ xxx ”double型不是正确的,错误的原因在于把数据库
update user set username='xxx',password='yyy' where id='zzz'
错写成
update user set username='xxx' and password='yyy' where id='zzz'
将分隔符,错写为and
如果是用ssm框架的话,正确的写法应该是:
<update id="updateUser" parameterType="user">
update sys_user
<set >
<if test="user_name!=null">
user_name=#{user_name} ,
</if>
<if test="user_password!=null">
user_password=#{user_password},
</if>
</set>
where user_id=#{user_id}
</update>
阅读全文
0 0
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'L
- nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE的调错
- MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorr
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value:
- com.mysql.jdbc.MysqlDataTruncation: Data truncation异常
- com.mysql.jdbc.MysqlDataTruncation: Data truncation异常
- mysql 插入中文报错: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value...
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'rdate'
- Data truncation: Truncated incorrect DOUBLE value:Mysql Update时
- Data truncation: Truncated incorrect DOUBLE value
- Data truncation: Truncated incorrect DOUBLE value: 'Y'
- ajax,json学习笔记(一)ajax,http简介
- 如何解决 Socket 连接超时
- JSP
- hdu 1272 小希的迷宫
- 【Angular2】试卷整体设计
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- DateBase-子查询
- 后台收到微信重复请求问题
- 多种方法实现字符串的逆置
- 私有云落地解决方案之网络篇-关键技术-vlan间通信
- opencv 图像对比度及亮度调整
- u盘安装centos7
- Java中==和equals的区别,equals和hashCode的区别
- Drop Pdb