根据设备id查询设备的所有历史记录表

whyclxw

2020-11-06 7728f6a8ae85f47c56d25cbaa2dfe258c3e82ab4

根据设备id查询设备的所有历史记录表

 DyEnvir_system/src/com/fgkj/actions/partinsystem/Partinsystem_infAction.java

@@ -1,6 +1,7 @@
package com.fgkj.actions.partinsystem;

import com.fgkj.actions.ActionUtil;
import com.fgkj.partinsystem.dto.Partinsystem_inf;
import com.fgkj.partinsystem.service.Partinsystem_infService;
import com.fgkj.services.ServiceModel;

@@ -16,7 +17,13 @@
        return SUCCESS;
    }
    
	
    //根据设备id查询设备的所有历史记录表
    public String serchByInfo() {
        Partinsystem_inf pinf=getGson(ActionUtil.time_yyyyMMddHHmmss).fromJson(json, Partinsystem_inf.class);
        ServiceModel model=service.serchByInfo(pinf);
        result=tojson(model);
        return SUCCESS;
    }
    
    
    

 DyEnvir_system/src/com/fgkj/partinsystem/impl/Partinsystem_infImpl.java

@@ -73,11 +73,53 @@
        // TODO Auto-generated method stub
        return null;
    }

    //根据设备id查询设备的所有历史记录表
    @Override
    public List serchByInfo(Object obj) {
        // TODO Auto-generated method stub
        return null;
        final Partinsystem_inf pinf=(Partinsystem_inf) obj;
        String sql=" select table_name,table_rows from information_schema.tables "
                + " where table_schema='db_partinsystem_history'  and table_name like ?  "
                + " order by table_name asc ";
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{"%"+pinf.getDev_id()+"%"}, new CallBack() {
			
            @Override
            public List getResults(ResultSet rs) {
                List<String> list = new ArrayList<String>(){{
                    this.add("0");this.add("0");
                }};
                //List list=new ArrayList();
                try {
                    while(rs.next()){
                        if(rs.getRow()==1){
                            list.set(0,changeDateFrom(rs.getString("table_name"),pinf.getDev_id()));
                            list.set(1,changeDateFrom(rs.getString("table_name"),pinf.getDev_id()));
                        }
                        //if(Integer.parseInt(rs.getString("table_rows"))!=0){
                            list.set(1,changeDateFrom(rs.getString("table_name"),pinf.getDev_id()));
                        //}
                    }
                    /*rs.first();
                    list.add(Devdata_historyImpl.changeDateFrom(rs.getString("table_name")));
                    rs.last();
                    list.add(Devdata_historyImpl.changeDateFrom(rs.getString("table_name")));*/
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                return list;
            }
        });
        List l=new ArrayList();
        for (int i = 0; i < list.size(); i++) {
            l.add(list.get(i));
        }
        return l;
    }

     //历史数据表名取时间转"_"到"-"
    private static String changeDateFrom(String dateString,int flag){
        String mark="_"+String.valueOf(flag)+"_";
        dateString=dateString.substring(dateString.indexOf(mark)+mark.length());
        dateString=dateString.replace("_", "-");
        return dateString;
    }
}

 DyEnvir_system/src/com/fgkj/partinsystem/service/Partinsystem_infService.java

@@ -29,4 +29,17 @@
        }
        return model;
    }
    //根据设备id查询设备的所有历史记录表
    public ServiceModel serchByInfo(Object obj) {
        List list=dao.serchByInfo(obj);
        if(list!=null&&list.size()>0){
            model.setData(list);
            model.setCode(1);
            model.setMsg("查询成功!");
        }else{
            model.setCode(0);
            model.setMsg("查询失败!");
        }
        return model;
    }
}