| | |
| | | Connection conn=DBUtil.getConn();
|
| | | String numberSql=" SELECT FOUND_ROWS() number";
|
| | | String sql="select SQL_CALC_FOUND_ROWS distinct tb_batt_endurance.num,tb_batt_endurance.deviceid,tb_batt_endurance.stationid,real_cap,tb_batt_endurance.moncapstd,real_curr,endurance_theory_timelong,endurance_actual_timelong,endurance_actual_timelong_max"
|
| | | + ",endurance_actual_timelong_min,is_out_stand,batts_moncapstd,batts_teststarttime,real_cap_group1,real_cap_group2,real_cap_group3,real_cap_group4 " +
|
| | | + ",endurance_actual_timelong_min,is_out_stand,batts_moncapstd,batts_teststarttime,real_cap_group1,real_cap_group2,real_cap_group3,real_cap_group4,groupcount " +
|
| | | ",db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.StationName1,db_battinf.tb_battinf.StationName2,db_battinf.tb_battinf.StationName5 " +
|
| | | " from web_site.tb_batt_endurance,db_battinf.tb_battinf " +
|
| | | " where tb_batt_endurance.stationid=db_battinf.tb_battinf.stationid "+
|
| | |
| | | b.setReal_cap_group2(rs.getFloat("real_cap_group2"));
|
| | | b.setReal_cap_group3(rs.getFloat("real_cap_group3"));
|
| | | b.setReal_cap_group4(rs.getFloat("real_cap_group4"));
|
| | | b.setGroupcount(rs.getInt("groupcount"));
|
| | | b.setEndurance_theory_timelong(rs.getFloat("endurance_theory_timelong"));
|
| | | b.setEndurance_actual_timelong(rs.getFloat("endurance_actual_timelong"));
|
| | | b.setEndurance_actual_timelong_max(rs.getFloat("endurance_actual_timelong_max"));
|
| | |
| | | //分组
|
| | | String endSql=" GROUP BY tb_batt_rtstate.BattGroupId ";
|
| | | //排序
|
| | | String orderSql=" order by db_battinf.tb_battinf.stationid asc";
|
| | | String orderSql=" order by db_battinf.tb_battinf.stationid asc ";
|
| | | sql=baseSql+endSql+orderSql;
|
| | | //System.out.println(sql);
|
| | | List<Batt_State> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{"%"+binf.getStationName()+"%","%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName5()+"%",binf.getMonVolStd()}, new CallBack() {
|
| | |
| | | private float real_cap_group2;
|
| | | private float real_cap_group3;
|
| | | private float real_cap_group4;
|
| | | private int groupcount;
|
| | | private String batts_moncapstd;//机房电池组的标称容量
|
| | | private String batts_teststarttime;//机房电池组的和容开始时间
|
| | | private String note;
|
| | |
| | | public void setReal_cap_group4(float real_cap_group4) {
|
| | | this.real_cap_group4 = real_cap_group4;
|
| | | }
|
| | | public int getGroupcount() {
|
| | | return groupcount;
|
| | | }
|
| | | public void setGroupcount(int groupcount) {
|
| | | this.groupcount = groupcount;
|
| | | }
|
| | | @Override
|
| | | public String toString() {
|
| | | return "Batt_endurance [num=" + num + ", deviceId=" + deviceId + ", stationid=" + stationid + ", real_cap="
|
| | |
| | | + ", endurance_actual_timelong_max=" + endurance_actual_timelong_max
|
| | | + ", endurance_actual_timelong_min=" + endurance_actual_timelong_min + ", is_out_stand=" + is_out_stand
|
| | | + ", real_cap_group1=" + real_cap_group1 + ", real_cap_group2=" + real_cap_group2 + ", real_cap_group3="
|
| | | + real_cap_group3 + ", real_cap_group4=" + real_cap_group4 + ", batts_moncapstd=" + batts_moncapstd
|
| | | + ", batts_teststarttime=" + batts_teststarttime + ", note=" + note + ", stationName=" + stationName
|
| | | + ", stationName1=" + stationName1 + ", stationName2=" + stationName2 + ", stationName5=" + stationName5
|
| | | + ", monvolstd=" + monvolstd + ", page=" + page + "]";
|
| | | + real_cap_group3 + ", real_cap_group4=" + real_cap_group4 + ", groupcount=" + groupcount
|
| | | + ", batts_moncapstd=" + batts_moncapstd + ", batts_teststarttime=" + batts_teststarttime + ", note="
|
| | | + note + ", stationName=" + stationName + ", stationName1=" + stationName1 + ", stationName2="
|
| | | + stationName2 + ", stationName5=" + stationName5 + ", monvolstd=" + monvolstd + ", page=" + page + "]";
|
| | | }
|
| | |
|
| | |
|