一,示例代码
1,AddressController.javaMap<String,Object> upMap = new HashMap<String,Object>(); upMap.put("address",address); upMap.put("receiver",receiver); upMap.put("isDefault",isDefault); upMap.put("userId",userId); upMap.put("tel",tel); upMap.put("country",country); upMap.put("enReceiver",enReceiver); upMap.put("email",email); upMap.put("zipcode",zipcode); boolean res = addressService.setOneAddress(upMap,addressId,userId);2,AddressServiceImpl.java
@Override public boolean setOneAddress(Map<String,Object> upMap, Long addressId,Long userId){ int upNum = addressMapper.updateOneAddress(upMap,addressId,userId); if (upNum > 0) { int isDefault = Integer.parseInt(upMap.get("isDefault").toString()); if (isDefault == 1){ //设置当前id为缺省地址 setOneUserAddressIsDefault(addressId,userId); } return true; } else { return false; } }3,AddressMapper.java
int updateOneAddress(@Param("upMap")Map<String,Object> upMap,@Param("addressId") Long addressId, @Param("userId")Long userId);4,AddessMapper.xml
<update id="updateOneAddress"> UPDATE address SET <foreach collection="upMap" item="val" index="key" separator=","> ${key} = #{val} </foreach> WHERE addressId = #{addressId} and userId = #{userId} </update>
说明:刘宏缔的架构森林是一个专注架构的博客,地址:https://www.cnblogs.com/architectforest
对应的源码可以访问这里获取: https://github.com/liuhongdi/
或: https://gitee.com/liuhongdi
说明:作者:刘宏缔 邮箱: 371125307@qq.com
二,测试效果
1,界面 2,保存时的mybatis日志2022-02-26 11:05:45.760 [http-nio-10800-exec-9] [AbstractHandlerMapping.java:522] DEBUG org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped to com.yj.storeback.controller.AddressController#addressEdited(Long, String, String, String, String, String, String, String, int) Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@19feb239] was not registered for synchronization because synchronization is not active JDBC Connection [HikariProxyConnection@873696543 wrapping com.mysql.cj.jdbc.ConnectionImpl@2641b9f0] will not be managed by Spring ==> Preparing: UPDATE address SET zipcode = ? , country = ? , isDefault = ? , address = ? , receiver = ? , tel = ? , userId = ? , email = ? , enReceiver = ? WHERE addressId = ? and userId = ? ==> Parameters: 053200(String), 中国(String), 1(Integer), 河北省衡水市冀州区恒大城(String), 老刘(String), 13811668888(String), 1(Long), ma@qq.com(String), laoma(String), 3(Long), 1(Long) <== Updates: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@19feb239]