一、 查询近24小时数据
- 调用方法
public void findData(String tableName) {
tableName = "\"" + "\"";
List<Map<String, String>> list = testMapper.checkData(tableName);
}
- 需要执行的sql
<!
<select id="checkData" resultType="java.util.Map" statementType="STATEMENT">
select *
from ${tableName}
where "time" :: TIMESTAMP >= ( to_char( now( ) :: TIMESTAMP, 'yyyy-MM-dd HH24:00:00' ) :: TIMESTAMP - INTERVAL '24 hour' )
AND "time" :: TIMESTAMP < ( to_char( now( ) :: TIMESTAMP, 'yyyy-MM-dd HH24:00:00' ) :: TIMESTAMP )
</select>
二、根据动态表白删除24小时之前的数据
- 调用函数
public void deleteByName(String name) {
test.deledeByName("\"" + name + "\"");
}
- sql
<!
<delete id="deledeByName" statementType="STATEMENT">
delete from ${name}
where "time" :: TIMESTAMP < ( to_char( now( ) :: TIMESTAMP, 'yyyy-MM-dd HH24:00:00' ) :: TIMESTAMP - INTERVAL '24 hour')
</delete>