mybatis用动态查询时，没有区分**${}和#{}**导致报错

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘school’ = ‘浙大’,gmt_modified = now()WHERE openid = ‘oIF_n5bFcV–GsYi1OFiHCZP’ at line 1
The error may involve com.wx.webPostgraExam.dao.WeXinMapper.updataUserInfoM-Inline
The error occurred while setting parameters
SQL: UPDATE bese.politics_user set ? = ?,gmt_modified = now()WHERE openid = ?

刚了解mybatis对其中东西不是很熟，网上找了一会发现。
${}和#{}
这是导致本次错误的主要原因。

简单来说：
#{}是占位符，传参是会对参数进行处理如 :
change=111, #{change} 就会变成“111”
${}是不对数据做任何处理，用在动态处理比较好。
set ${change} = #{value}