~whyclxw/Device_Manage.git

parent: a36d9af6 | 补丁 | 提交 | ignore whitespace

81041

2019-12-28 9fc51315211b59cf043ceb169ab84cc315f7ec7d

根据设备id查信息的

3个文件已修改

	Device_Manage/src/com/fgkj/actions/BattInfAction.java	85 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Device_Manage/src/com/fgkj/dao/impl/BattInfImpl.java	28 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Device_Manage/src/com/fgkj/services/BattInfService.java	129 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 Device_Manage/src/com/fgkj/actions/BattInfAction.java

@@ -1,39 +1,46 @@
package com.fgkj.actions;



import com.fgkj.dto.BattInf;

import com.fgkj.dto.Page;

import com.fgkj.dto.ServiceModel;

import com.fgkj.services.BattInfService;



public class BattInfAction extends ActionUtil{

    private BattInfService service=new BattInfService();

    private String result;

    private String json;

	
	
    //根据电池组id查询电池组信息

    public String searchAll() {

        ServiceModel model=service.searchAll();

        result=tojson(model);

        return SUCCESS;

    }

    // 查询所有电池组的信息（包含充放电和告警情况）（分页）

    public String serchByCondition() {

        BattInf binf=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, BattInf.class);

        ServiceModel model=service.serchByCondition(binf);

        result=tojson(model);

        return SUCCESS;

    }

    //查询所有的设备

    public String serchDevice() {

        ServiceModel model=service.serchDevice();

        result=tojson(model);

        return SUCCESS;

    }

    public String getResult() {

        return result;

    }

    public void setJson(String json) {

        this.json = json;

    }

}

package com.fgkj.actions;

import com.fgkj.dto.BattInf;
import com.fgkj.dto.Page;
import com.fgkj.dto.ServiceModel;
import com.fgkj.services.BattInfService;

public class BattInfAction extends ActionUtil{
    private BattInfService service=new BattInfService();
    private String result;
    private String json;
	
	
    //根据电池组id查询电池组信息
    public String searchAll() {
        ServiceModel model=service.searchAll();
        result=tojson(model);
        return SUCCESS;
    }
    // 查询所有电池组的信息（包含充放电和告警情况）（分页）
    public String serchByCondition() {
        BattInf binf=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, BattInf.class);
        ServiceModel model=service.serchByCondition(binf);
        result=tojson(model);
        return SUCCESS;
    }
    //查询所有的设备
    public String serchDevice() {
        ServiceModel model=service.serchDevice();
        result=tojson(model);
        return SUCCESS;
    }
    //根据设备id查询机房名称
    public String serchByInfo() {
        BattInf binf=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, BattInf.class);
        ServiceModel model=service.serchByInfo(binf);
        result=tojson(model);
        return SUCCESS;
    }
    public String getResult() {
        return result;
    }
    public void setJson(String json) {
        this.json = json;
    }
}

 Device_Manage/src/com/fgkj/dao/impl/BattInfImpl.java

@@ -156,8 +156,34 @@
        });
        return list;
    }
    //根据设备id查询机房名称
     public List serchByInfo(Object obj) {
        return null;
         BattInf binf=(BattInf) obj;
         String sql="select distinct db_battinf.tb_battinf.FBSDeviceId,stationName3,stationName "
                + " FROM  db_battinf.tb_battinf "
                + " where FBSDeviceId=? ";
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getFBSDeviceId()}, new CallBack() {
			
            @Override
            public List getResults(ResultSet rs) {
                List list=new ArrayList();
                try {
                    while(rs.next()){
                        BattInf binf=new BattInf();
                        binf.setStationName(rs.getString("stationName"));;
                        binf.setStationName3(rs.getString("stationName3"));
                        binf.setFBSDeviceId(rs.getInt("FBSDeviceId"));
						
                        list.add(binf);
                    }
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                return list;
            }
        });
        return list;
    }
    public static void main(String[] args) {
        BattInfImpl bimpl=new BattInfImpl();

 Device_Manage/src/com/fgkj/services/BattInfService.java

@@ -1,58 +1,71 @@
package com.fgkj.services;



import java.util.List;



import com.fgkj.dao.BaseDAO;

import com.fgkj.dao.BaseDAOFactory;

import com.fgkj.dao.impl.BattInfImpl;

import com.fgkj.dto.ServiceModel;



public class BattInfService {

    private ServiceModel model;

    private BaseDAO dao;

	
    public BattInfService() {

        model=new ServiceModel();

        dao=BaseDAOFactory.getBaseDAO(BaseDAO.BATTINF);

    }

	
     //根据电池组id查询电池组信息

    public ServiceModel searchAll() {

        List list=dao.searchAll();

        if(list!=null&&list.size()>0){

            model.setCode(1);

            model.setData(list);

            model.setMsg("查询成功");

        }else{

            model.setCode(0);

            model.setMsg("查询失败");

        }

        return model;

    }

    // 查询所有电池组的信息（包含充放电和告警情况）（分页）

    public ServiceModel serchByCondition(Object obj) {

        List list=dao.serchByCondition(obj);

        if(list!=null&&list.size()>0){

            model.setCode(1);

            model.setData(list);

            model.setMsg("查询成功");

        }else{

            model.setCode(0);

            model.setMsg("查询失败");

        }

        return model;

    }

    //查询所有的设备

    public ServiceModel serchDevice() {

        List list=((BattInfImpl)dao).serchDevice();

        if(list!=null&&list.size()>0){

            model.setCode(1);

            model.setData(list);

            model.setMsg("查询成功");

        }else{

            model.setCode(0);

            model.setMsg("查询失败");

        }

        return model;

    }

}

package com.fgkj.services;

import java.util.List;

import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.BaseDAOFactory;
import com.fgkj.dao.impl.BattInfImpl;
import com.fgkj.dto.ServiceModel;

public class BattInfService {
    private ServiceModel model;
    private BaseDAO dao;
	
    public BattInfService() {
        model=new ServiceModel();
        dao=BaseDAOFactory.getBaseDAO(BaseDAO.BATTINF);
    }
	
     //根据电池组id查询电池组信息
    public ServiceModel searchAll() {
        List list=dao.searchAll();
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功");
        }else{
            model.setCode(0);
            model.setMsg("查询失败");
        }
        return model;
    }
    // 查询所有电池组的信息（包含充放电和告警情况）（分页）
    public ServiceModel serchByCondition(Object obj) {
        List list=dao.serchByCondition(obj);
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功");
        }else{
            model.setCode(0);
            model.setMsg("查询失败");
        }
        return model;
    }
    //查询所有的设备
    public ServiceModel serchDevice() {
        List list=((BattInfImpl)dao).serchDevice();
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功");
        }else{
            model.setCode(0);
            model.setMsg("查询失败");
        }
        return model;
    }
    //根据设备id查询机房名称
    public ServiceModel serchByInfo(Object obj) {
        List list=((BattInfImpl)dao).serchByInfo(obj);
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功");
        }else{
            model.setCode(0);
            model.setMsg("查询失败");
        }
        return model;
    }
}

			@@ -1,39 +1,46 @@
			package com.fgkj.actions;

			import com.fgkj.dto.BattInf;
			import com.fgkj.dto.Page;
			import com.fgkj.dto.ServiceModel;
			import com.fgkj.services.BattInfService;

			public class BattInfAction extends ActionUtil{
			private BattInfService service=new BattInfService();
			private String result;
			private String json;


			//根据电池组id查询电池组信息
			public String searchAll() {
			ServiceModel model=service.searchAll();
			result=tojson(model);
			return SUCCESS;
			}
			// 查询所有电池组的信息（包含充放电和告警情况）（分页）
			public String serchByCondition() {
			BattInf binf=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, BattInf.class);
			ServiceModel model=service.serchByCondition(binf);
			result=tojson(model);
			return SUCCESS;
			}
			//查询所有的设备
			public String serchDevice() {
			ServiceModel model=service.serchDevice();
			result=tojson(model);
			return SUCCESS;
			}
			public String getResult() {
			return result;
			}
			public void setJson(String json) {
			this.json = json;
			}
			}
			package com.fgkj.actions;

			import com.fgkj.dto.BattInf;
			import com.fgkj.dto.Page;
			import com.fgkj.dto.ServiceModel;
			import com.fgkj.services.BattInfService;

			public class BattInfAction extends ActionUtil{
			private BattInfService service=new BattInfService();
			private String result;
			private String json;


			//根据电池组id查询电池组信息
			public String searchAll() {
			ServiceModel model=service.searchAll();
			result=tojson(model);
			return SUCCESS;
			}
			// 查询所有电池组的信息（包含充放电和告警情况）（分页）
			public String serchByCondition() {
			BattInf binf=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, BattInf.class);
			ServiceModel model=service.serchByCondition(binf);
			result=tojson(model);
			return SUCCESS;
			}
			//查询所有的设备
			public String serchDevice() {
			ServiceModel model=service.serchDevice();
			result=tojson(model);
			return SUCCESS;
			}
			//根据设备id查询机房名称
			public String serchByInfo() {
			BattInf binf=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, BattInf.class);
			ServiceModel model=service.serchByInfo(binf);
			result=tojson(model);
			return SUCCESS;
			}
			public String getResult() {
			return result;
			}
			public void setJson(String json) {
			this.json = json;
			}
			}

			@@ -156,8 +156,34 @@
			});
			return list;
			}
			//根据设备id查询机房名称
			public List serchByInfo(Object obj) {
			return null;
			BattInf binf=(BattInf) obj;
			String sql="select distinct db_battinf.tb_battinf.FBSDeviceId,stationName3,stationName "
			+ " FROM db_battinf.tb_battinf "
			+ " where FBSDeviceId=? ";
			List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getFBSDeviceId()}, new CallBack() {

			@Override
			public List getResults(ResultSet rs) {
			List list=new ArrayList();
			try {
			while(rs.next()){
			BattInf binf=new BattInf();
			binf.setStationName(rs.getString("stationName"));;
			binf.setStationName3(rs.getString("stationName3"));
			binf.setFBSDeviceId(rs.getInt("FBSDeviceId"));

			list.add(binf);
			}
			} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			}
			return list;
			}
			});
			return list;
			}
			public static void main(String[] args) {
			BattInfImpl bimpl=new BattInfImpl();

			@@ -1,58 +1,71 @@
			package com.fgkj.services;

			import java.util.List;

			import com.fgkj.dao.BaseDAO;
			import com.fgkj.dao.BaseDAOFactory;
			import com.fgkj.dao.impl.BattInfImpl;
			import com.fgkj.dto.ServiceModel;

			public class BattInfService {
			private ServiceModel model;
			private BaseDAO dao;

			public BattInfService() {
			model=new ServiceModel();
			dao=BaseDAOFactory.getBaseDAO(BaseDAO.BATTINF);
			}

			//根据电池组id查询电池组信息
			public ServiceModel searchAll() {
			List list=dao.searchAll();
			if(list!=null&&list.size()>0){
			model.setCode(1);
			model.setData(list);
			model.setMsg("查询成功");
			}else{
			model.setCode(0);
			model.setMsg("查询失败");
			}
			return model;
			}
			// 查询所有电池组的信息（包含充放电和告警情况）（分页）
			public ServiceModel serchByCondition(Object obj) {
			List list=dao.serchByCondition(obj);
			if(list!=null&&list.size()>0){
			model.setCode(1);
			model.setData(list);
			model.setMsg("查询成功");
			}else{
			model.setCode(0);
			model.setMsg("查询失败");
			}
			return model;
			}
			//查询所有的设备
			public ServiceModel serchDevice() {
			List list=((BattInfImpl)dao).serchDevice();
			if(list!=null&&list.size()>0){
			model.setCode(1);
			model.setData(list);
			model.setMsg("查询成功");
			}else{
			model.setCode(0);
			model.setMsg("查询失败");
			}
			return model;
			}
			}
			package com.fgkj.services;

			import java.util.List;

			import com.fgkj.dao.BaseDAO;
			import com.fgkj.dao.BaseDAOFactory;
			import com.fgkj.dao.impl.BattInfImpl;
			import com.fgkj.dto.ServiceModel;

			public class BattInfService {
			private ServiceModel model;
			private BaseDAO dao;

			public BattInfService() {
			model=new ServiceModel();
			dao=BaseDAOFactory.getBaseDAO(BaseDAO.BATTINF);
			}

			//根据电池组id查询电池组信息
			public ServiceModel searchAll() {
			List list=dao.searchAll();
			if(list!=null&&list.size()>0){
			model.setCode(1);
			model.setData(list);
			model.setMsg("查询成功");
			}else{
			model.setCode(0);
			model.setMsg("查询失败");
			}
			return model;
			}
			// 查询所有电池组的信息（包含充放电和告警情况）（分页）
			public ServiceModel serchByCondition(Object obj) {
			List list=dao.serchByCondition(obj);
			if(list!=null&&list.size()>0){
			model.setCode(1);
			model.setData(list);
			model.setMsg("查询成功");
			}else{
			model.setCode(0);
			model.setMsg("查询失败");
			}
			return model;
			}
			//查询所有的设备
			public ServiceModel serchDevice() {
			List list=((BattInfImpl)dao).serchDevice();
			if(list!=null&&list.size()>0){
			model.setCode(1);
			model.setData(list);
			model.setMsg("查询成功");
			}else{
			model.setCode(0);
			model.setMsg("查询失败");
			}
			return model;
			}
			//根据设备id查询机房名称
			public ServiceModel serchByInfo(Object obj) {
			List list=((BattInfImpl)dao).serchByInfo(obj);
			if(list!=null&&list.size()>0){
			model.setCode(1);
			model.setData(list);
			model.setMsg("查询成功");
			}else{
			model.setCode(0);
			model.setMsg("查询失败");
			}
			return model;
			}
			}