时间戳加减、转换
long command = 1585711324530;
String endDate=Httpservice.timstamp2DateTime(command);
String endTable = "d_cbi_history_"+endDate;
if (dTccHistoryMapper.getTableExist(endTable)==null){
endDate=Httpservice.timstamp2DateTime(command - 24*60*60*1000);
endTable = "d_cbi_history_"+endDate;
}
时间戳long型转为时间格式string型
public static String timstamp2DateTime(Long timestamp) {
return (new SimpleDateFormat("yyyyMMdd")).format(timestamp);
}
查数据库的接口方法,找时间对应数据表,并返回表名
package com.cbi.rpmc.mapper;
import com.cbi.rpmc.entity.history.HttpCbiContents;
import com.example.souce.entity.HttpTccHistory;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import java.math.BigInteger;
import java.util.List;
import java.util.Map;
@Repository
public interface DCbiHistoryMapper {
String getTableExist(@Param("tableName")String tableName);
}
接口方法getTableExist对应xml文件配置映射
<!-- 判断某张表是否存在-->
<select id="getTableExist" resultType="java.lang.String">
show tables like '${tableName}'
</select>