App_bts_comm_task修改

81041

2018-12-05 d662962200bbf6bd150b079e6d25c67ff49ad9a2

 gx_tieta/src/com/fgkj/dao/impl/App_bts_comm_taskImpl.java

@@ -14,6 +14,7 @@
import com.fgkj.dto.App_bts_comm_task;

import com.fgkj.dto.BattInf;

import com.fgkj.dto.Page;

import com.fgkj.dto.User_inf;

import com.mysql.fabric.xmlrpc.base.Array;



public class App_bts_comm_taskImpl implements BaseDAO,CallBack{

@@ -48,7 +49,7 @@
      Page page=binf.getPage();

      Connection conn=DBUtil.getConn();

      String numberSql=" SELECT FOUND_ROWS() number";

      String sql=" select SQL_CALC_FOUND_ROWS distinct dev_id,thread_id,battgroup_cnt,battgroup_id1,battgroup_index1,battgroup_id2,battgroup_index2,battgroup_id3,battgroup_index3,battgroup_id4,battgroup_index4,connect_time,dev_comm_runtime,break_type " +

      String sql=" select SQL_CALC_FOUND_ROWS distinct dev_id,thread_id,battgroup_cnt,battgroup_id1,battgroup_index1,battgroup_id2,battgroup_index2,battgroup_id3,battgroup_index3,battgroup_id4,battgroup_index4,connet_time,dev_comm_runtime,break_type " +

            "  ,stationName,stationName1,stationName2,stationName3,stationName5,StationId " +

            " from db_app_sys.tb_app_bts_comm_task,db_battinf.tb_battinf  " +

            " where db_app_sys.tb_app_bts_comm_task.dev_id=db_battinf.tb_battinf.fBSDeviceId " +

@@ -79,7 +80,7 @@
                  atask.setBattgroup_index3(rs.getInt("battgroup_index3"));

                  atask.setBattgroup_id4(rs.getInt("battgroup_id4"));

                  atask.setBattgroup_index4(rs.getInt("battgroup_index4"));

                  atask.setConnect_time(rs.getTimestamp("connect_time"));

                  atask.setConnet_time(rs.getTimestamp("connet_time"));

                  atask.setDev_comm_runtime(rs.getTimestamp("dev_comm_runtime"));

                  atask.setBreak_type(rs.getInt("break_type"));

                  atask.setStationId(rs.getString("stationId"));

@@ -106,7 +107,23 @@
      }

      return list;

   }



    public static void main(String[] args) {

      App_bts_comm_taskImpl aimpl=new App_bts_comm_taskImpl();

      BattInf binf=new BattInf();

      binf.setNum(1002);

      binf.setStationName1("");

      binf.setStationName2("");

      binf.setStationName3("");

      binf.setStationName5("");

      binf.setStationId("");

      binf.setBattGroupNum(62);

      Page p=new Page();

      p.setPageCurr(1);

      p.setPageSize(10);

      binf.setPage(p);

      List list=aimpl.serchByCondition(binf);

      System.out.println(list.size());

   }

   public List serchByInfo(Object obj) {

      // TODO Auto-generated method stub

      return null;