QualityTaskMapper.java 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. package edp.davinci.dao;
  2. import edp.davinci.model.DataRules;
  3. import edp.davinci.model.DataSubject;
  4. import edp.davinci.model.QualityTask;
  5. import org.apache.ibatis.annotations.Delete;
  6. import org.apache.ibatis.annotations.Param;
  7. import org.apache.ibatis.annotations.Select;
  8. import org.apache.ibatis.annotations.Update;
  9. import org.springframework.stereotype.Component;
  10. import java.util.List;
  11. @Component
  12. public interface QualityTaskMapper
  13. {
  14. int insert(QualityTask qualityTask);
  15. @Delete({"delete from `quality_task` where id = #{id}"})
  16. int deleteById(@Param("id") Long id);
  17. @Update({
  18. "update `dict_type`",
  19. "set `dict_name` = #{dictName,jdbcType=VARCHAR},",
  20. "`dict_type` = #{dictType,jdbcType=VARCHAR},",
  21. "`status` = #{status,jdbcType=BIGINT},",
  22. "`remark` = #{remark,jdbcType=VARCHAR},",
  23. "`update_by` = #{updateBy,jdbcType=BIGINT},",
  24. "`update_time` = #{updateTime,jdbcType=TIMESTAMP}",
  25. "where dict_id = #{dictId,jdbcType=BIGINT}"
  26. })
  27. int update(QualityTask qualityTask);
  28. @Select({"select * from `quality_task`"})
  29. List<QualityTask> getQualityTaskList();
  30. @Select({"select * from `quality_task` where id = #{id}"})
  31. QualityTask getQualityTask(@Param("id") Long id);
  32. }