mybatis 通用更新抽离写法

最新推荐文章于 2024-06-02 16:42:48 发布

潇凝子潇

最新推荐文章于 2024-06-02 16:42:48 发布

阅读量698

点赞数

CC 4.0 BY-SA版权

分类专栏： mybatis spring java

本文链接：https://blog.youkuaiyun.com/xu990128638/article/details/81664724

java 同时被 3 个专栏收录

77 篇文章

订阅专栏

mybatis

8 篇文章

订阅专栏

spring

8 篇文章

订阅专栏

本文介绍了一个账户日期更新机制的设计与实现。通过监听消息并解析JSON数据来获取更新所需的参数，根据文档类型确定目标数据表，并调用服务进行更新操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前提是要更新的表中的字段名称必须命名统一

import com.alibaba.fastjson.JSONObject;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;


@Component
public class AccountDateListener {
   private static final Logger logger = LoggerFactory.getLogger(AccountDateListener.class);
   
   @Autowired
   private AccountDateService accountDateService;
   
    @Override
    public void consumeMessage(String body) throws Exception {
      JSONObject data = JSONObject.parseObject(body);
      Integer accountDate = data.getInteger("accountDate");
      Integer docType = data.getInteger("docType");
      Integer docId = data.getInteger("docId");
      accountDateService.updateAccountDate(docType, docId, accountDate);
    }
    
}

public interface AccountDateService {
   void updateAccountDate(int docType, int docId, int accountDate);
}


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import java.util.HashMap;
import java.util.Map;

@Component
public class AccountDateServiceImpl implements AccountDateService {

   @Autowired
   private AccountDateMapper accountDateMapper;
   
   
   public void updateAccountDate(int docType, int docId, int accountDate){
       String tableName = getTable(docType);
      if(!"".equals(tableName)){
         updateAccountDate(tableName, docId, accountDate);
      }
    }
   
   public String getTable(int docType){
       String tableName = "";
       if(docType == DocType.Rec.getCode()||
            docType == AiDocType.InsureRec.getCode()){
         tableName = "t_fi_rec";
      }else if(docType == DocType.Pay.getCode()||
            docType == DocType.InsurePay.getCode()){
         tableName = "t_fi_pay";
      }
       return tableName;
    }
   
   @Override
   public int updateAccountDate(String tableName, int docId, int accountDate) {
      Map<String, Object> filter = new HashMap<String, Object>();
      filter.put("tableName", tableName);
      filter.put("id", docId);
      filter.put("accountDate", accountDate);
      filter.put("uT", Helper.getCurrentTime());
      int count = accountDateMapper.updateAccountDate(filter);
      if(count == 0){
         throw new BusinessException("数据更新失败"+docId+"数据表："+tableName);
      }
      return count;
   }

}

3.接口

public interface AccountDateMapper {
   int updateAccountDate(Map<String, Object> filter);
}

4. mapper 的写法：

<update id="updateAccountDate" parameterType="Map">
       update ${tableName} set account_date = #{accountDate}, u_t = #{uT}
       where is_deleted = 0 and id = #{id}
</update>