添加均衡供电查询接口

whycxzp

2021-04-13 ee8e6c8434ede1c1499c341042b64214ece832ac

添加均衡供电查询接口

 gx_tieta/src/com/fgkj/actions/ram/Fbs9100s_fod_stateAction.java

@@ -5,6 +5,9 @@
import com.fgkj.dto.ram.Fbs9100s_fod_state;
import com.fgkj.services.ram.Fbs9100s_fod_stateService;

/**
 * 养护除硫的状态,电压状态等
 */
public class Fbs9100s_fod_stateAction extends ActionUtil {
    private Fbs9100s_fod_stateService service = new Fbs9100s_fod_stateService();
    private String json; 

 gx_tieta/src/com/fgkj/actions/ram/JhStateAction.java

New file
@@ -0,0 +1,33 @@
package com.fgkj.actions.ram;

import com.fgkj.actions.ActionUtil;
import com.fgkj.dto.ram.JhState;
import com.fgkj.dto.ServiceModel;
import com.fgkj.services.ram.JhStateService;

public class JhStateAction extends ActionUtil {
    private JhStateService service=new JhStateService();
    private String json;
    private String result;
	
    //根据设备id查询设备均衡供电模块的信息
    public String serchByCondition() {
        JhState jh=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, JhState.class);
        ServiceModel model=service.serchByCondition(jh);
        result=tojson(model);
        return SUCCESS;
    }
	
	
	
	
    public String getResult() {
        return result;
    }
    public void setJson(String json) {
        this.json = json;
    }
	
	

}

 gx_tieta/src/com/fgkj/dao/impl/ram/JhStateImpl.java

New file
@@ -0,0 +1,93 @@
package com.fgkj.dao.impl.ram;

import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.CallBack;
import com.fgkj.dao.DAOHelper;
import com.fgkj.db.DBUtil;
import com.fgkj.dto.ram.JhState;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class JhStateImpl implements BaseDAO, CallBack {

    public List getResults(ResultSet rs) {
        // TODO Auto-generated method stub
        return null;
    }

    public boolean add(Object obj) {
        // TODO Auto-generated method stub
        return false;
    }

    public boolean update(Object obj) {
        // TODO Auto-generated method stub
        return false;
    }

    public boolean del(Object obj) {
        // TODO Auto-generated method stub
        return false;
    }

    public List searchAll() {
        // TODO Auto-generated method stub
        return null;
    }
    //根据设备id查询设备均衡供电模块的信息
    public List serchByCondition(Object obj) {
        JhState jh=(JhState) obj;
        String sql=" select * from db_ram_db.tb_61850_jhstate where dev_id=? ";
        List list= DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{jh.getDev_id()}, new CallBack() {
			
            public List getResults(ResultSet rs) {
                List list=new ArrayList();
                try {
                    while(rs.next()){
                        JhState j=new JhState();
                        j.setNum(rs.getInt("num"));
                        j.setDev_id(rs.getInt("dev_id"));
                        j.setDev_version(rs.getString("dev_version"));
                        j.setInput_vol_total(rs.getDouble("input_vol_total"));
                        j.setOutput_vol_total(rs.getDouble("output_vol_total"));
                        j.setInput_curr_total(rs.getDouble("input_curr_total"));
                        j.setOutput_curr_total(rs.getDouble("output_curr_total"));
                        j.setOutput_vol_one(rs.getDouble("output_vol_one"));
                        j.setOutput_vol_two(rs.getDouble("output_vol_two"));
                        j.setOutput_vol_three(rs.getDouble("output_vol_three"));
                        j.setOutput_vol_four(rs.getDouble("output_vol_four"));
                        j.setOutput_vol_five(rs.getDouble("output_vol_five"));
                        j.setOutput_vol_six(rs.getDouble("output_vol_six"));
                        j.setOutput_vol_seven(rs.getDouble("output_vol_seven"));
                        j.setOutput_vol_eight(rs.getDouble("output_vol_eight"));
                        j.setOutput_vol_nine(rs.getDouble("output_vol_nine"));
                        j.setOutput_vol_ten(rs.getDouble("output_vol_ten"));
                        j.setDev_temp(rs.getDouble("dev_temp"));
                        list.add(j);
                    }
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                return list;
            }
        });
        // TODO Auto-generated method stub
        return list;
    }

    public List serchByInfo(Object obj) {
        // TODO Auto-generated method stub
        return null;
    }
    public static void main(String[] args) {
        JhStateImpl jimpl=new JhStateImpl();
        JhState jh=new JhState();
        jh.setDev_id(618500001);
        List list=jimpl.serchByCondition(jh);
        System.out.println(list.size());
    }
}

 gx_tieta/src/com/fgkj/dto/ram/JhState.java

New file
@@ -0,0 +1,155 @@
package com.fgkj.dto.ram;

import java.io.Serializable;

public class JhState implements Serializable{
    private int num;
    private int dev_id;
    private String dev_version;
    private double input_vol_total;
    private double output_vol_total;
    private double input_curr_total;
    private double output_curr_total;
    private double output_vol_one;
    private double output_vol_two;
    private double output_vol_three;
    private double output_vol_four;
    private double output_vol_five;
    private double output_vol_six;
    private double output_vol_seven;
    private double output_vol_eight;
    private double output_vol_nine;
    private double output_vol_ten;
    private double dev_temp;
    public int getNum() {
        return num;
    }
    public void setNum(int num) {
        this.num = num;
    }
    public int getDev_id() {
        return dev_id;
    }
    public void setDev_id(int dev_id) {
        this.dev_id = dev_id;
    }
    public String getDev_version() {
        return dev_version;
    }
    public void setDev_version(String dev_version) {
        this.dev_version = dev_version;
    }
    public double getInput_vol_total() {
        return input_vol_total;
    }
    public void setInput_vol_total(double input_vol_total) {
        this.input_vol_total = input_vol_total;
    }
    public double getOutput_vol_total() {
        return output_vol_total;
    }
    public void setOutput_vol_total(double output_vol_total) {
        this.output_vol_total = output_vol_total;
    }
    public double getInput_curr_total() {
        return input_curr_total;
    }
    public void setInput_curr_total(double input_curr_total) {
        this.input_curr_total = input_curr_total;
    }
    public double getOutput_curr_total() {
        return output_curr_total;
    }
    public void setOutput_curr_total(double output_curr_total) {
        this.output_curr_total = output_curr_total;
    }
    public double getOutput_vol_one() {
        return output_vol_one;
    }
    public void setOutput_vol_one(double output_vol_one) {
        this.output_vol_one = output_vol_one;
    }
    public double getOutput_vol_two() {
        return output_vol_two;
    }
    public void setOutput_vol_two(double output_vol_two) {
        this.output_vol_two = output_vol_two;
    }
    public double getOutput_vol_three() {
        return output_vol_three;
    }
    public void setOutput_vol_three(double output_vol_three) {
        this.output_vol_three = output_vol_three;
    }
    public double getOutput_vol_four() {
        return output_vol_four;
    }
    public void setOutput_vol_four(double output_vol_four) {
        this.output_vol_four = output_vol_four;
    }
    public double getOutput_vol_five() {
        return output_vol_five;
    }
    public void setOutput_vol_five(double output_vol_five) {
        this.output_vol_five = output_vol_five;
    }
	
    public double getOutput_vol_six() {
        return output_vol_six;
    }
    public void setOutput_vol_six(double output_vol_six) {
        this.output_vol_six = output_vol_six;
    }
    public double getOutput_vol_seven() {
        return output_vol_seven;
    }
    public void setOutput_vol_seven(double output_vol_seven) {
        this.output_vol_seven = output_vol_seven;
    }
    public double getOutput_vol_eight() {
        return output_vol_eight;
    }
    public void setOutput_vol_eight(double output_vol_eight) {
        this.output_vol_eight = output_vol_eight;
    }
    public double getOutput_vol_nine() {
        return output_vol_nine;
    }
    public void setOutput_vol_nine(double output_vol_nine) {
        this.output_vol_nine = output_vol_nine;
    }
    public double getOutput_vol_ten() {
        return output_vol_ten;
    }
    public void setOutput_vol_ten(double output_vol_ten) {
        this.output_vol_ten = output_vol_ten;
    }
    public double getDev_temp() {
        return dev_temp;
    }
    public void setDev_temp(double dev_temp) {
        this.dev_temp = dev_temp;
    }
    @Override
    public String toString() {
        return "JhState [num=" + num + ", dev_id=" + dev_id + ", dev_version="
                + dev_version + ", input_vol_total=" + input_vol_total
                + ", output_vol_total=" + output_vol_total
                + ", input_curr_total=" + input_curr_total
                + ", output_curr_total=" + output_curr_total
                + ", output_vol_one=" + output_vol_one + ", output_vol_two="
                + output_vol_two + ", output_vol_three=" + output_vol_three
                + ", output_vol_four=" + output_vol_four + ", output_vol_five="
                + output_vol_five + ", output_vol_six=" + output_vol_six
                + ", output_vol_seven=" + output_vol_seven
                + ", output_vol_eight=" + output_vol_eight
                + ", output_vol_nine=" + output_vol_nine + ", output_vol_ten="
                + output_vol_ten + ", dev_temp=" + dev_temp + "]";
    }
	
	

    


}

 gx_tieta/src/com/fgkj/services/ram/JhStateService.java

New file
@@ -0,0 +1,44 @@
package com.fgkj.services.ram;

import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.BaseDAOFactory;
import com.fgkj.dao.impl.ram.JhStateImpl;
import com.fgkj.dto.ServiceModel;

import java.util.List;

/**
 * @author 81041
 *
 */
public class JhStateService {
    private ServiceModel model;
    private BaseDAO dao;
	
    public JhStateService() {
        super();
        model=new ServiceModel();
        dao= new JhStateImpl();
    }
	
	
    //根据设备id查询设备均衡供电模块的信息
    public ServiceModel serchByCondition(Object obj) {
        try {
            List list = dao.serchByCondition(obj);

            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功");
        }catch (Exception e){
            e.printStackTrace();
            model.setCode(0);
            model.setMsg("查询失败");
        }
        return model;
    }
	
	
	

}