package com.whyc.service;
|
|
import com.whyc.dto.Response;
|
import com.whyc.mapper.CallBack;
|
import com.whyc.pojo.db_abe_testdata.AbeTestData;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.LinkedList;
|
import java.util.List;
|
|
@Service
|
public class AbeTestDataService {
|
|
@Autowired
|
private JdbcSqlExecuteService jdbcSqlExecuteService;
|
|
|
public List<AbeTestData> getList(int monId, int testRecordCount) {
|
String sql = "select mon_id,test_record_count,record_time,test_starttime,test_type,record_num,test_timelong,group_vol,test_curr,test_cap,mon_vol,mon_tmp,mon_res from db_abe_testdata.tb_abe_testdata_"+monId +" where test_record_count = "+testRecordCount;
|
List<AbeTestData> monDatalist = jdbcSqlExecuteService.executeQuery_call(sql, new CallBack<AbeTestData>() {
|
|
@Override
|
public List<AbeTestData> getResults(ResultSet rs) throws SQLException {
|
LinkedList<AbeTestData> temp = new LinkedList<>();
|
while (rs.next()) {
|
AbeTestData abeTestData = new AbeTestData();
|
abeTestData.setMonId(rs.getInt("mon_id"));
|
abeTestData.setTestRecordCount(rs.getInt("test_record_count"));
|
abeTestData.setRecordTime(rs.getTimestamp("record_time"));
|
abeTestData.setTestStartTime(rs.getTimestamp("test_starttime"));
|
abeTestData.setTestType(rs.getInt("test_type"));
|
abeTestData.setRecordNum(rs.getInt("record_num"));
|
abeTestData.setTestTimeLong(rs.getInt("test_timelong"));
|
abeTestData.setGroupVol(rs.getFloat("group_vol"));
|
abeTestData.setTestCurr(rs.getFloat("test_curr"));
|
abeTestData.setTestCap(rs.getFloat("test_cap"));
|
abeTestData.setMonVol(rs.getFloat("mon_vol"));
|
abeTestData.setMonTmp(rs.getFloat("mon_tmp"));
|
abeTestData.setMonRes(rs.getFloat("mon_res"));
|
temp.add(abeTestData);
|
}
|
return temp;
|
}
|
});
|
return monDatalist;
|
}
|
}
|
