Mybatis中用Map方法

UseMapper

//定义方法 参数为Map<String,Object> map

int updateUserByMap(Map<String,Object> map);

在UserMapper.xml

<update id="updateUserByMap" parameterType="map">
        update users set name=#{newName},password=#{newPassword} where id=#{id}
</update>

这里我们三个参数都可以随便定义，不用在像使用User类那样遵循字段

 所以我就用newName，newPassword来区别。id其实也可以

测试

@Test
    public void test06(){
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        Map<String, Object> map = new HashMap<String, Object>();
        map.put("newName","zhzhzhzh");
        map.put("newPassword","zhzhzhzh");
        map.put("id",1);

        mapper.updateUserByMap(map);
        sqlSession.commit();

        sqlSession.close();
    }