修改

whyclxw

2020-08-25 ac70d4f71e98144cb2e222827542ed3a3c741ea4

修改

 zijing/src/com/fgkj/dao/impl/history/Batt_realdataImpl.java

@@ -76,11 +76,42 @@
    //按照时间倒序查出具体电池组的所有信息
    public List serchByCondition(Object obj) {
        Batt_realdata breal=(Batt_realdata) obj;
        String sql="select * from db_batt_history.tb_batt_realdata_"+breal.getBattGroupId()+""
        String sql="select num,battGroupId,recrod_time,group_vol,online_vol,group_curr,group_tmp,batt_test_cap,mon_num,mon_vol,mon_tmp,mon_res,mon_ser,mon_conn_res,mon_cap,mon_JH_curr "
                + " from db_batt_history.tb_batt_realdata_"+breal.getBattGroupId()+""
                + " where  recrod_time>=? and recrod_time<=?  "
                //+ " order by recrod_time asc ";
                + " order by num DESC ";
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{breal.getRecrod_time(),breal.getRecrod_time1()}, new Batt_realdataImpl());
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{breal.getRecrod_time(),breal.getRecrod_time1()}, new CallBack() {
			
            public List getResults(ResultSet rs) {
                ArrayList list=new ArrayList();
                try {
                    while(rs.next()){
                        Batt_realdata breal=new Batt_realdata();
                        breal.setNum(rs.getInt("num"));
                        breal.setBattGroupId(rs.getInt("battGroupId"));
                        breal.setRecrod_time(rs.getTimestamp("recrod_time"));
                        breal.setGroup_vol(rs.getFloat("group_vol"));
                        breal.setOnline_vol(rs.getFloat("online_vol"));
                        breal.setGroup_curr(rs.getFloat("group_curr"));
                        breal.setGroup_tmp(rs.getFloat("group_tmp"));
                        breal.setBatt_test_cap(rs.getFloat("batt_test_cap"));
                        breal.setMon_num(rs.getInt("mon_num"));
                        breal.setMon_vol(rs.getFloat("mon_vol"));
                        breal.setMon_tmp(rs.getFloat("mon_tmp"));
                        breal.setMon_res(rs.getFloat("mon_res"));
                        breal.setMon_ser(rs.getFloat("mon_ser"));
                        breal.setMon_conn_res(rs.getFloat("mon_conn_res"));
                        breal.setMon_cap(rs.getFloat("mon_cap"));
                        breal.setMon_JH_curr(rs.getFloat("mon_JH_curr"));
                        list.add(breal);
                    }
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                return list;
            }
        });
        return list;
    }

@@ -90,10 +121,10 @@
    }
    public static void main(String[] args) throws ParseException {
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        Date date1 = sdf.parse("2019-03-24 21:11:52");
        Date date2 = sdf.parse("2020-03-23 21:11:52");
        Date date1 = sdf.parse("2020-07-24 21:11:52");
        Date date2 = sdf.parse("2020-08-23 21:11:52");
        Batt_realdata b=new Batt_realdata();
        b.setBattGroupId(1005072);
        b.setBattGroupId(1005069);
        b.setRecrod_time(date1);
        b.setRecrod_time1(date2);
        Batt_realdataImpl bimpl=new Batt_realdataImpl();