public boolean updateFpkjByCondition(Map params) {
Map<String , Object> map = new HashMap<>();
map.put("params" , params);
return getMybatisDao().execute(FpkjConstant.UPDATEFPKJBYCONDITION, map) == 1;
}
<update id="updateFpkjByCondition" parameterType="java.util.Map">
UPDATE fp_kj
SET
<foreach item="value" index="key" collection="params" separator=",">
<if test="key != 'ID'">
${key} =
</if>
</foreach>
WHERE
<foreach item="value" index="key" collection="params" separator=",">
<if test="key == 'ID'">
ID =
</if>
</foreach>
</update>
private ApplicationContext applicationContext;
@Before
public void setUp() throws Exception{
applicationContext = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
}
@Test
public void testUpdateFpkjByCondition(){
IFpkjService fpkjService = (IFpkjService) applicationContext.getBean("fpkjService");
Map<String, String> map = new HashMap<>();
map.put("ID", "100003");
map.put("FPQQLSH","2");
map.put("KPRQ", "20090101010101");
boolean b = fpkjService.updateFpkjByCondition(map);
System.out.println(b);
}