App_bts_comm_task修改

81041

2018-12-05 d662962200bbf6bd150b079e6d25c67ff49ad9a2

App_bts_comm_task修改

 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;


 gx_tieta/src/com/fgkj/dto/App_bts_comm_task.java

@@ -16,7 +16,7 @@
    private int battgroup_index3;

    private int battgroup_id4;

    private int battgroup_index4;

    private Date connect_time;

    private Date connet_time;

    private Date dev_comm_runtime;

    private int break_type;//break_type ：0，成功连接；1，找不到对应dev_id；2，通信异常断开

    private String stationName;

@@ -98,11 +98,11 @@
    public void setBattgroup_index4(int battgroup_index4) {

        this.battgroup_index4 = battgroup_index4;

    }

    public Date getConnect_time() {

        return connect_time;

    public Date getConnet_time() {

        return connet_time;

    }

    public void setConnect_time(Date connect_time) {

        this.connect_time = connect_time;

    public void setConnet_time(Date connet_time) {

        this.connet_time = connet_time;

    }

    public Date getDev_comm_runtime() {

        return dev_comm_runtime;

@@ -167,7 +167,7 @@
                + ", battgroup_index2=" + battgroup_index2 + ", battgroup_id3="

                + battgroup_id3 + ", battgroup_index3=" + battgroup_index3

                + ", battgroup_id4=" + battgroup_id4 + ", battgroup_index4="

                + battgroup_index4 + ", connect_time=" + connect_time

                + battgroup_index4 + ", connect_time=" + connet_time

                + ", dev_comm_runtime=" + dev_comm_runtime + ", break_type="

                + break_type + ", stationName=" + stationName

                + ", stationName1=" + stationName1 + ", stationName2="