| | |
| | | List list = null; |
| | | String sql=""; |
| | | BattInf binf = bmd.getBinf(); |
| | | String sqlT="select distinct(db_battinf.tb_battinf.BattgroupId),moncapstd,monvolstd,monresstd,monserstd" + |
| | | String sqlT="select distinct(db_battinf.tb_battinf.BattgroupId),moncapstd,monvolstd,monresstd,monserstd,FloatVolLevel,OfflineVolLevel " + |
| | | ",db_batt_testdata.tb_batttestdata_inf.battgroupid,max_monvol,min_monvol,db_batt_testdata.tb_batttestdata_inf.test_record_count,test_type,test_record_count " + |
| | | "from db_battinf.tb_battinf,db_batt_testdata.tb_batttestdata_inf " + |
| | | "where " + |
| | | "db_battinf.tb_battinf.BattgroupId=db_batt_testdata.tb_batttestdata_inf.BattGroupId " + |
| | | "and db_battinf.tb_battinf.battgroupid=? and db_batt_testdata.tb_batttestdata_inf.data_available=1 " + |
| | | "and db_batt_testdata.tb_batttestdata_inf.test_type=? and db_batt_testdata.tb_batttestdata_inf.test_starttype=3 "; |
| | | String sqlE="select distinct(db_battinf.tb_battinf.BattgroupId),moncapstd,monvolstd,monresstd,monserstd" + |
| | | String sqlE="select distinct(db_battinf.tb_battinf.BattgroupId),moncapstd,monvolstd,monresstd,monserstd,FloatVolLevel,OfflineVolLevel " + |
| | | ",db_batt_testdata.tb_battresdata_inf.battgroupid,db_batt_testdata.tb_battresdata_inf.test_record_count,test_type,test_record_count " + |
| | | "from db_battinf.tb_battinf,db_batt_testdata.tb_battresdata_inf " + |
| | | "where " + |
| | |
| | | binf.setMonCapStd(rs.getFloat("monCapStd")); |
| | | binf.setMonResStd(rs.getFloat("monResStd")); |
| | | binf.setMonSerStd(rs.getFloat("monSerStd")); |
| | | binf.setFloatVolLevel(rs.getFloat("FloatVolLevel")); |
| | | binf.setOfflineVolLevel(rs.getFloat("OfflineVolLevel")); |
| | | Battresdata_inf rinf=new Battresdata_inf(); |
| | | rinf.setBattGroupId(rs.getInt("battGroupId")); |
| | | rinf.setTest_record_count(rs.getInt("test_record_count")); |