Merge branch 'dev_lxw' of https://whychdw@gitlab.com/whyclxw1/gx_tieta.git ...

hdw

2018-11-13 a098897b8b37dd9418a8840a5f89cac92757ab4a

Merge branch 'dev_lxw' of https://whychdw@gitlab.com/whyclxw1/gx_tieta.git into dev_lxw

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

@@ -1,9 +1,13 @@
package com.fgkj.actions.ram;



import java.util.List;



import com.fgkj.actions.ActionUtil;

import com.fgkj.dto.ServiceModel;

import com.fgkj.dto.ram.Fbs9100_state;

import com.fgkj.dto.ram.Fbs9100s_dfu_state;

import com.fgkj.services.ram.Fbs9100s_dfu_stateService;

import com.google.gson.reflect.TypeToken;



public class Fbs9100s_dfu_stateAction extends ActionUtil{

    private Fbs9100s_dfu_stateService service = new Fbs9100s_dfu_stateService();

@@ -24,6 +28,13 @@
        result=tojson(model);

        return SUCCESS;

    }

    //升级界面实时刷新

    public String serchByCondition(){

        List<Integer>  list=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json,new TypeToken<List<Integer>>(){}.getType());

        ServiceModel model=service.serchByCondition(list);

        result=tojson(model);

        return SUCCESS;

    }

    

    public String getResult() {

        return result;


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

@@ -1,6 +1,8 @@
package com.fgkj.dao.impl.ram;



import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;



import com.fgkj.dao.BaseDAO;

@@ -39,15 +41,70 @@
        // TODO Auto-generated method stub

        return null;

    }



    //升级界面实时刷新

    public List serchByCondition(Object obj) {

        // TODO Auto-generated method stub

        return null;

        List<Integer> list=(List<Integer>) obj;

        String sql=" select * from db_ram_db.tb_fbs9100s_dfu_state  " +

                " where dev_id in(";

        String devSql="";

        Object[] object=new Object[list.size()];

        //System.out.println(list.size());

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

            for (int i = 0; i <list.size(); i++) {

                if(i==(list.size()-1)){

                    devSql+="?)";

                }else{

                    devSql+="?,";

                }

                object[i]=list.get(i);

            }

        }

        sql+=devSql;

        String endSql="  order by dev_id";

        sql+=endSql;

        //System.out.println(sql);

        List listAll=DAOHelper.executeQuery(sql, DBUtil.getConn(), object, new CallBack() {

			
            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                try {

                    while(rs.next()){

                        Fbs9100s_dfu_state dfu=new Fbs9100s_dfu_state();

                        dfu.setDev_id(rs.getInt("dev_id"));

                        dfu.setSysVersion_new(rs.getInt("sysVersion_new"));

                        dfu.setSoftVersion_new(rs.getInt("softVersion_new"));

                        dfu.setSysVersion_dev(rs.getInt("sysVersion_dev"));

                        dfu.setSoftVersion_dev(rs.getInt("softVersion_dev"));

                        dfu.setDfu_file(rs.getString("dfu_file"));

                        dfu.setDfu_en(rs.getInt("dfu_en"));

                        dfu.setDfu_wr_stat(rs.getInt("dfu_wr_stat"));

                        dfu.setDfu_data_blocknum(rs.getInt("dfu_data_blocknum"));

                        dfu.setDfu_data_blocklen(rs.getInt("dfu_data_blocklen"));

                        list.add(dfu);

                    }

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

        });

        return listAll;

    }



    public List serchByInfo(Object obj) {

        // TODO Auto-generated method stub

        return null;

    }



   public static void main(String[] args) {

    Fbs9100s_dfu_stateImpl fimpl=new Fbs9100s_dfu_stateImpl();

    List list=new ArrayList();

    list.add(910000013);

    list.add(910000577);

    list.add(910000534);

    List<Fbs9100s_dfu_state> listAll=fimpl.serchByCondition(list);

    for (Fbs9100s_dfu_state dfu : listAll) {

        System.out.println(dfu);

    }

}

}


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

@@ -1,5 +1,7 @@
package com.fgkj.services.ram;



import java.util.List;



import com.fgkj.dao.BaseDAO;

import com.fgkj.dao.BaseDAOFactory;

import com.fgkj.dto.ServiceModel;

@@ -38,4 +40,17 @@
        }

        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;

    }

}