错误信息:com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'admin'
原SQL语句:
<strong><span style="font-size:18px;">String sql = "UPDATE USER SET username=" +
"'"+user.getUsername()+"' AND password='"+user.getPassword()+"'" +
" WHERE id="+user.getId();</span></strong>
改成:
<strong><span style="font-size:18px;">String sql = "UPDATE USER SET username=" +
"'"+user.getUsername()+"', password='"+user.getPassword()+"'" +
" WHERE id="+user.getId();</span></strong>
即把AND修改成分隔符",",代码运行正常...