定时重启

lxw

2020-08-01 df447ad101c27677da9e3dbab3040db8a1d0a86d

定时重启

 zijing/WebRoot/WEB-INF/ibm-web-ext-pme.xml

New file
@@ -0,0 +1,8 @@
<?xml version="1.0" encoding="UTF-8"?>
<web-ext-pme
        xmlns="http://websphere.ibm.com/xml/ns/javaee"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://websphere.ibm.com/xml/ns/javaee http://websphere.ibm.com/xml/ns/javaee/ibm-web-ext-pme_1_0.xsd"
        version="1.0">

</web-ext-pme>

 zijing/src/com/fgkj/actions/Dev_restart_planAction.java

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

import com.fgkj.dto.Dev_restart_plan;
import com.fgkj.dto.ServiceModel;
import com.fgkj.services.Dev_restart_planService;

public class Dev_restart_planAction extends ActionUtil{
    private Dev_restart_planService service=new Dev_restart_planService();
    private String json;
    private String result;
	
    //根据设备id查询重启设定
    public String serchByCondition() {
        Dev_restart_plan dp=getGson(ActionUtil.time_yyyyMMddHHmmss).fromJson(json, Dev_restart_plan.class);
        ServiceModel model=service.serchByCondition(dp);
        result=tojson(model);
        return SUCCESS;
    }
    //使用replace添加修改信息
    public String update() {
        Dev_restart_plan dp=getGson(ActionUtil.time_yyyyMMddHHmmss).fromJson(json, Dev_restart_plan.class);
        ServiceModel model=service.update(dp);
        result=tojson(model);
        return SUCCESS;
    }
	
	
    public String getResult() {
        return result;
    }
    public void setJson(String json) {
        this.json = json;
    }
	
	

}

 zijing/src/com/fgkj/dao/BaseDAO.java

@@ -194,6 +194,8 @@
    
    public static final int BTSSTAECHANGE_INF=95;
    
    public static final int DEV_RESTART_PLAN=96;
	
    
    public boolean add(Object obj); // 添加


 zijing/src/com/fgkj/dao/BaseDAOFactory.java

@@ -41,6 +41,7 @@
import com.fgkj.dao.impl.CustompageImpl;
import com.fgkj.dao.impl.Database_backupImpl;
import com.fgkj.dao.impl.Dev_paramImpl;
import com.fgkj.dao.impl.Dev_restart_planImpl;
import com.fgkj.dao.impl.Devstate_usrImpl;
import com.fgkj.dao.impl.Fbsdev_Statechange_infImpl;
import com.fgkj.dao.impl.MapImpl;
@@ -203,6 +204,7 @@
            case 93:return new Fbs9100_sysparamImpl();
            case 94:return new Batt_realdataImpl();
            case 95:return new Btsstaechange_infImpl();
            case 96:return new Dev_restart_planImpl();
            default :return null;
        }
    }

 zijing/src/com/fgkj/dao/impl/Dev_restart_planImpl.java

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

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

import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.CallBack;
import com.fgkj.dao.DAOHelper;
import com.fgkj.db.DBUtil;
import com.fgkj.dto.BattInf;
import com.fgkj.dto.Dev_restart_plan;

public class Dev_restart_planImpl 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;
    }
    //使用replace添加修改信息
    public boolean update(Object obj) {
        Dev_restart_plan dp=(Dev_restart_plan) obj;
        String sql="replace into web_site.tb_dev_restart_plan(dev_id,restart_starttime,restart_cycle,restart_en) values(?,?,?,?)";
        boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{dp.getDev_id(),dp.getRestart_starttime(),dp.getRestart_cycle(),dp.getRestart_en()});
        return bl;
    }

    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) {
        Dev_restart_plan dp=(Dev_restart_plan) obj;
        String sql="select distinct web_site.tb_dev_restart_plan.num,dev_id,restart_starttime,restart_cycle,restart_en"
                + " ,tb_battinf.stationName "
                + " from web_site.tb_dev_restart_plan,db_battinf.tb_battinf  "
                + " where dev_id=tb_battinf.FBSDeviceId "
                + " and dev_id=? order by dev_id asc ";
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{dp.getDev_id()}, new CallBack() {
			
            public List getResults(ResultSet rs) {
                List list=new ArrayList();
                try {
                    while(rs.next()){
                        Dev_restart_plan dr=new Dev_restart_plan();
                        dr.setNum(rs.getInt("num"));
                        dr.setDev_id(rs.getInt("dev_id"));
                        dr.setRestart_starttime(rs.getTimestamp("restart_starttime"));
                        dr.setRestart_cycle(rs.getInt("restart_cycle"));
                        dr.setRestart_en(rs.getInt("restart_en"));
                        dr.setStationName(rs.getString("stationName"));
                        list.add(dr);
                    }
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                return list;
            }
        });
        return list;
    }

    public List serchByInfo(Object obj) {
        // TODO Auto-generated method stub
        return null;
    }

}

 zijing/src/com/fgkj/dto/Dev_restart_plan.java

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

import java.io.Serializable;
import java.util.Date;

public class Dev_restart_plan implements Serializable{
    private int num;
    private int dev_id;
    private String stationName;
    private Date restart_starttime ;
    private int restart_cycle ;
    private int restart_en ;
    private String note;
    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 Date getRestart_starttime() {
        return restart_starttime;
    }
    public void setRestart_starttime(Date restart_starttime) {
        this.restart_starttime = restart_starttime;
    }
    public int getRestart_cycle() {
        return restart_cycle;
    }
    public void setRestart_cycle(int restart_cycle) {
        this.restart_cycle = restart_cycle;
    }
    public int getRestart_en() {
        return restart_en;
    }
    public void setRestart_en(int restart_en) {
        this.restart_en = restart_en;
    }
    public String getNote() {
        return note;
    }
    public void setNote(String note) {
        this.note = note;
    }
    public String getStationName() {
        return stationName;
    }
    public void setStationName(String stationName) {
        this.stationName = stationName;
    }
    @Override
    public String toString() {
        return "Dev_restart_plan [num=" + num + ", dev_id=" + dev_id
                + ", stationName=" + stationName + ", restart_starttime="
                + restart_starttime + ", restart_cycle=" + restart_cycle
                + ", restart_en=" + restart_en + ", note=" + note + "]";
    }
	
	
	
}

 zijing/src/com/fgkj/services/Dev_restart_planService.java

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


import java.util.List;

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

public class Dev_restart_planService {
    private ServiceModel model;
    private BaseDAO dao;
    public Dev_restart_planService() {
        super();
        dao=BaseDAOFactory.getBaseDAO(BaseDAO.DEV_RESTART_PLAN);
        model=new ServiceModel();
    }
    //根据设备id查询重启设定
    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;
    }
     //使用replace添加修改信息
    public ServiceModel update(Object obj) {
        boolean bl=dao.update(obj);
        if(bl){
            model.setCode(1);
            model.setMsg("添加或修改成功!");
        }else{
            model.setCode(0);
            model.setMsg("添加或修改失败 !");
        }
        return model;
    }

}