| | |
|---|
| | | });
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | //历史监测<-------跨域----------->
|
|---|
| | | public List serchByCondition_ky(Object obj) {
|
|---|
| | | Batttestdata btd=(Batttestdata)obj;
|
|---|
| | | int number=btd.getRecord_num();//总数
|
|---|
| | | int roteN=0;
|
|---|
| | | int endN=BattTestData.RC_NUM_PARAM;//总笔数
|
|---|
| | | if(number<=endN){
|
|---|
| | | roteN=1;
|
|---|
| | | }else{ |
|---|
| | | if(number%endN==0){
|
|---|
| | | roteN=number/endN;
|
|---|
| | | }else{
|
|---|
| | | roteN=number/endN+1;
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | String sql="select num,BattGroupId,test_record_count,test_type,data_new,data_available,record_num,test_starttime,record_time,test_timelong,online_vol,group_vol,test_curr,test_cap,mon_num,mon_vol,mon_tmp " +
|
|---|
| | | " from db_batt_testdata.tb_batttestdata_"+btd.getBattGroupId()+"" +
|
|---|
| | | " where test_record_count=? and (record_num%"+roteN+"=0 or test_timelong>=? or test_timelong<= ?) " +
|
|---|
| | | " and db_batt_testdata.tb_batttestdata_"+btd.getBattGroupId()+".data_available=1 ";
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(),new Object[]{btd.getTest_record_count(),btd.getNum(),btd.getTest_type()}, new CallBack() {
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
| | | try {
|
|---|
| | | while(rs.next()){
|
|---|
| | | Batttestdata b=new Batttestdata();
|
|---|
| | | b.setNum(rs.getInt("num"));
|
|---|
| | | b.setBattGroupId(rs.getInt("BattGroupId"));
|
|---|
| | | b.setTest_record_count(rs.getInt("test_record_count"));
|
|---|
| | | b.setTest_type(rs.getInt("test_type"));
|
|---|
| | | b.setData_new(rs.getInt("data_new")); |
|---|
| | | b.setData_available(rs.getInt("data_available"));
|
|---|
| | | b.setRecord_num(rs.getInt("record_num"));
|
|---|
| | | b.setTest_starttime(rs.getTimestamp("test_starttime"));
|
|---|
| | | b.setRecord_time(rs.getTimestamp("record_time"));
|
|---|
| | | b.setTest_timelong(rs.getInt("test_timelong"));
|
|---|
| | | b.setOnline_vol(rs.getFloat("online_vol"));
|
|---|
| | | b.setGroup_vol(rs.getFloat("group_vol"));
|
|---|
| | | b.setTest_curr(rs.getFloat("test_curr"));
|
|---|
| | | b.setTest_cap(rs.getFloat("test_cap"));
|
|---|
| | | b.setMon_num(rs.getInt("mon_num"));
|
|---|
| | | b.setMon_vol(rs.getFloat("mon_vol"));
|
|---|
| | | b.setMon_tmp(rs.getFloat("mon_tmp"));
|
|---|
| | | list.add(b);
|
|---|
| | | }
|
|---|
| | | }catch (SQLException e) {
|
|---|
| | | e.printStackTrace();
|
|---|
| | | } |
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | });
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | //查询某一次测试中的最大一次的测试时长和最短时长<历史监测>
|
|---|
| | | public List serchMaxAndMintime(Object obj){
|
|---|
| | | Batttestdata btb=(Batttestdata) obj;
|
|---|
| | |
|---|
| | |
|
|---|
| | | public static void main(String[] args) {
|
|---|
| | | Batttestdata b=new Batttestdata();
|
|---|
| | | b.setBattGroupId(1000010);
|
|---|
| | | b.setBattGroupId(1002085);
|
|---|
| | | b.setTest_record_count(1);
|
|---|
| | | Date d1 = new Date();
|
|---|
| | | List list=new BatttestdataDAOImpl().serchByCondition(b);
|
|---|
| | | //List list=new BatttestdataDAOImpl().serchByCondition(b);
|
|---|
| | | List list=new BatttestdataDAOImpl().serchByCondition_ky(b);
|
|---|
| | | System.out.println(new Date().getTime() - d1.getTime());
|
|---|
| | | System.out.println(list.size()+"*********");
|
|---|
| | | }
|
|---|
