| | |
|---|
| | | }); |
|---|
| | | return list; |
|---|
| | | } |
|---|
| | | //获取具体的放电数据 |
|---|
| | | public List<BatttestdataId> exportTinfDataByTestRecordCount(Integer battgroupId, Integer testRecordCount, String tableName) { |
|---|
| | | String sql="select distinct * from "+tableName+" "+ |
|---|
| | | " where test_record_count="+testRecordCount; |
|---|
| | | sql+=" order by record_time asc"; |
|---|
| | | List<BatttestdataId> list = sqlExecuteService.executeQuery_call(sql, new CallBack() { |
|---|
| | | @Override |
|---|
| | | public List getResults(ResultSet rs) throws SQLException { |
|---|
| | | List<BatttestdataId> list=new ArrayList<>(); |
|---|
| | | while (rs.next()){ |
|---|
| | | BatttestdataId data=new BatttestdataId(); |
|---|
| | | data.setNum(rs.getInt("num")); |
|---|
| | | data.setBattgroupId(rs.getInt("battgroup_id")); |
|---|
| | | data.setTestRecordCount(rs.getInt("test_record_count")); |
|---|
| | | data.setTestType(rs.getInt("test_type")); |
|---|
| | | data.setRecordNum(rs.getInt("record_num")); |
|---|
| | | data.setDataNew(rs.getInt("data_new")); |
|---|
| | | data.setDataAvailable(rs.getInt("data_available")); |
|---|
| | | data.setTestTimelong(rs.getInt("test_timelong")); |
|---|
| | | data.setTestCurr(rs.getFloat("test_curr")); |
|---|
| | | data.setTestCap(rs.getFloat("test_cap")); |
|---|
| | | data.setMonNum(rs.getInt("mon_num")); |
|---|
| | | data.setMonVol(rs.getFloat("mon_vol")); |
|---|
| | | data.setMonTmp(rs.getFloat("mon_tmp")); |
|---|
| | | data.setMonRes(rs.getFloat("mon_res")); |
|---|
| | | data.setTestStarttime(rs.getTimestamp("test_starttime")); |
|---|
| | | data.setRecordTime(rs.getTimestamp("record_time")); |
|---|
| | | data.setGroupVol(rs.getFloat("group_vol")); |
|---|
| | | data.setOnlineVol(rs.getFloat("online_vol")); |
|---|
| | | list.add(data); |
|---|
| | | } |
|---|
| | | return list; |
|---|
| | | } |
|---|
| | | }); |
|---|
| | | return list; |
|---|
| | | } |
|---|
| | | } |
|---|
