实体类滤空更新（JPQL拼接）_jpql拼接变量-CSDN博客

本文链接：https://blog.csdn.net/github_39525088/article/details/77447786

本文介绍了一种使用Java Persistence API (JPA)实现的对象更新方法。通过反射机制获取对象的所有字段，并构建动态SQL来更新指定实体。文章详细展示了如何处理字段为空的情况，并通过EntityManager执行更新操作。

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

public class JpaTemplate {
  @PersistenceContext
  private EntityManager entityManager;

  @Transactional
  public void update(Object obj) throws IllegalAccessException, NoSuchFieldException {
    Class<?> clazz = obj.getClass();
    String name = clazz.getName().substring(clazz.getName().lastIndexOf(".") + 1);

    StringBuilder sb = new StringBuilder("update " + name + " as t set");
    Field[] fields = clazz.getDeclaredFields();
    boolean fieldFlag = false;

    for (Field field : fields
            ) {
      String fieldName = field.getName();
      field.setAccessible(true);
      if (null != field.get(obj)) {
        sb.append(" t." + fieldName + " = :" + fieldName + ",");
        fieldFlag = true;
      }
    }

    if (fieldFlag) {
      sb.deleteCharAt(sb.length() - 1);
    }else{
      throw new DataException("更新对像全部字段为空");
    }

    sb.append(" where t.id = :id");

    Query query = entityManager.createQuery(sb.toString());
    for (Field field: fields
         ) {
      Object value = field.get(obj);
      if (null != value) {
        query.setParameter(field.getName(),value);
      }
    }
    Class<?> superclass = obj.getClass().getSuperclass();
    Field id = superclass.getDeclaredField("id");
    id.setAccessible(true);
    query.setParameter("id",id.get(obj));

    query.executeUpdate();
  }
}