MeasurementMapper.java 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. package com.energy.online.data.service.mapper;
  2. import com.energy.online.data.service.common.mappers.MyMapper;
  3. import com.energy.online.data.service.dto.MeasurementDto;
  4. import com.energy.online.data.service.po.MeasurementPO;
  5. import org.apache.ibatis.annotations.Param;
  6. import org.springframework.stereotype.Repository;
  7. @Repository
  8. public interface MeasurementMapper extends MyMapper<MeasurementPO> {
  9. /**
  10. * 通过表明查询表是否存在
  11. * @param tableName
  12. * @return
  13. */
  14. int selectTableCountByTableName(@Param("tableName") String tableName);
  15. /**
  16. * 动态创建表
  17. * @param tableName
  18. * @return
  19. */
  20. int createTable(@Param("tableName") String tableName);
  21. /**
  22. * 插入数据
  23. * @param measurementDto
  24. * @return
  25. */
  26. int insertTableData(@Param("item")MeasurementDto measurementDto,@Param("tableName") String tableName);
  27. /**
  28. * temp倒序获取time
  29. * @return
  30. */
  31. Long selectMeasurementTempByid(@Param("confId")Integer confId);
  32. /**
  33. * 删除表数据
  34. * @return
  35. */
  36. int truncateMeasurementTempTable();
  37. }