mybatis更新操作 update

关于mybatis中update操作遇到了问题解决; 看代码:
测试类:

@Test
    public void updatwUser () throws IOException {
        InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml");
        //建立会话工厂
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
         mapper.updatwUser("帅帅","帅帅",1);
         sqlSession.commit();
        sqlSession.close();

    }

Mapper接口:

 void updatwUser ( String j, String j1,int i);

Mapper.xml配置:

<update id="updatwUser">
        update user
        <set>
                  #             后面加,重点
            <if test="param1!=null">name=#{param1},</if>
            <if test="param2!=null">password=#{param2},</if>
        </set>
        where id=#{param3}
    </update>

重点:一定要在name=#{param1},后面加上那个,password=#{param2},建议最后一个参数后也加,不加也行,mybatis会自动去掉最后一个, ->>>>>>一定加 ","
不加的话会报错:
org.apache.ibatis.exceptions.PersistenceException:

Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'password=‘帅帅’

    where id=1' at line 4

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: update user SET name=? password=? where id=?

希望帮助大家!!!