com.mysql.jdbc.MysqlDataTruncation

错误信息: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修改成分隔符",",代码运行正常...