内阻测试

81041

2019-10-09 0aded54df375e5123f34452764ea7176b4e90e70

内阻测试

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

@@ -162,6 +162,35 @@
        return list;

    }

    

    //检测电池组内阻测试数据库是否存在

    public boolean checkRes(Object obj){

        BattInf binf=(BattInf) obj;

        String dbname="db_batt_testdata";

        String tablename="tb_battresdata_"+ binf.getBattGroupId();

        String sql=" select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA=? and TABLE_NAME=? ";

        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{dbname,tablename}, new CallBack() {

			
            @Override

            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                try {

                    while(rs.next()){

                        list.add(rs.getString("TABLE_NAME"));

                    }

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

        });

        boolean bl=false;

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

            bl=true;

        }

        return bl;

    }

	
     //得到电阻/内阻测试信息

    public List serchByMonNum(Object obj) {

        Battresdata btd = (Battresdata) obj;

@@ -294,12 +323,14 @@
         */

        //List<Battresdata> list = bstd.searchAll(bst);

        BattInf binf=new BattInf();

        binf.setBattGroupId(100000);

        binf.setBattGroupId(1000003);

        binf.setMonNum(1);

        List<Battresdata> list = bstd.serchByMonHistory(binf);

        /*List<Battresdata> list = bstd.serchByMonHistory(binf);

        for (Battresdata b : list) {

            System.out.println(b);

        }

        }*/

        boolean bl = bstd.checkRes(binf);

        System.out.println(bl);

    }



    public List searchAll() {


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

@@ -119,15 +119,22 @@
        } 

   //根据电池组id和单体id查询内阻历史信息

    public ServiceModel serchByMonHistory(Object obj){

        List<Battresdata> list=((BattresdataDAOImpl) dao).serchByMonHistory(obj);

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

            model.setCode(1);

            model.setData(list);

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

        }else{

            model.setCode(0);

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

        }		
        boolean bl=((BattresdataDAOImpl) dao).checkRes(obj);

        if(bl){

            List<Battresdata> list=((BattresdataDAOImpl) dao).serchByMonHistory(obj);

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

                model.setCode(1);

                model.setData(list);

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

            }else{

                model.setCode(0);

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

            }

        }else{

            model.setCode(0);

            model.setMsg("内阻测试不存在!");

        }

				
        return model;

    }

    public static void main(String[] args) {