whyclxw
2025-05-28 e16302f9d475c7cc4dd18c5abf1a23cb5502e362
src/main/java/com/whyc/mapper/CommonMapper.java
@@ -1,5 +1,13 @@
package com.whyc.mapper;
import com.whyc.pojo.BattalarmDataHistory;
import com.whyc.pojo.DevalarmDataHistory;
import com.whyc.pojo.PwrdevAlarmHistory;
import com.whyc.pojo.UserLog;
import org.apache.ibatis.annotations.Param;
import java.util.List;
/**
 * 通用mapper,用于通用数据的查询
 */
@@ -14,4 +22,35 @@
     */
    //Object getMaxValue(String schema,String table,String field,String valuePrefix);
    Object getMaxValue(String schema,String table,String field);
    String existTable(String dbName, String tableName);
    //void truncate(String dbName, String tableName);
    void createTable4AlarmVoiceSet();
    //void createTable4UserLogByYear(@Param("year") String year);
    //void insertBatch4UserLogByYear(@Param("year")String year, List<UserLog> userLogs);
    //void createTable4PowerAlarmHistoryByYear(@Param("year") String year);
    //void insertBatch4PowerAlarmHistoryByYear(String year, List<PwrdevAlarmHistory> temp);
    //void createTable4BattAlarmDataHistoryByYear(@Param("year") String year);
    //void insertBatch4BattAlarmDataHistoryByYear(String year, List<BattalarmDataHistory> temp);
    //void createTable4DevAlarmDataHistoryByYear(@Param("year") String year);
    //void insertBatch4DevAlarmDataHistoryByYear(String year, List<DevalarmDataHistory> temp);
    void createBattState_RT_RamDB_Table();
    void updateTb_App_Sys_AppServerTable();
    List<String> getTableListLike(String dbName, String tableLike);
    Long getSystemDBTimeIn5Minutes();
}