| | |
|---|
| | | });
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | //电池配组用到(筛选出有效的最近的一次节能放电技术)
|
|---|
| | | public List Batt_selecteffectiveBatt(Object obj,float param){
|
|---|
| | | BattInf binf=(BattInf) obj;
|
|---|
| | | String sql="SELECT distinct battGroupId,test_starttime,record_time,test_cap,max_monvol,min_monvol,test_record_count,test_curr FROM db_batt_testdata.tb_batttestdata_inf "
|
|---|
| | | + " WHERE BattGroupId =? " |
|---|
| | | + " AND data_available=1 AND data_new = 1 AND " |
|---|
| | | + " test_type = 3 AND test_starttype = 3 AND " //判断是节能放电
|
|---|
| | | + " abs(test_cap) >?*? " //判断测试数据容量是否有效
|
|---|
| | | + " ORDER BY test_record_count DESC LIMIT 1 ";
|
|---|
| | | |
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getBattGroupId(),binf.getMonCapStd(),param}, new CallBack() {
|
|---|
| | | |
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
| | | try {
|
|---|
| | | while(rs.next()){
|
|---|
| | | Batttestdata_inf tinf=new Batttestdata_inf();
|
|---|
| | | tinf.setBattGroupId(rs.getInt("battGroupId"));
|
|---|
| | | if(rs.getString("test_starttime")!=null)
|
|---|
| | | tinf.setTest_starttime(rs.getTimestamp("test_starttime"));
|
|---|
| | | if(rs.getString("record_time")!=null)
|
|---|
| | | tinf.setRecord_time(rs.getTimestamp("record_time"));
|
|---|
| | | tinf.setTest_cap(rs.getFloat("test_cap"));
|
|---|
| | | tinf.setMax_monvol(rs.getFloat("max_monvol"));
|
|---|
| | | tinf.setMin_monvol(rs.getFloat("min_monvol"));
|
|---|
| | | tinf.setTest_record_count(rs.getInt("test_record_count"));
|
|---|
| | | tinf.setTest_curr(rs.getFloat("test_curr"));
|
|---|
| | | list.add(tinf);
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
| | | // TODO Auto-generated catch block
|
|---|
| | | e.printStackTrace();
|
|---|
| | | }
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | });
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | public static void main(String[] args) throws ParseException {
|
|---|
| | | Batttestdata_infDAOImpl bimpl=new Batttestdata_infDAOImpl();
|
|---|
| | | Batttestdata_inf tdata=new Batttestdata_inf();
|
|---|
