Merge branch 'dev_lxw' of https://gitlab.com/whyclxw1/gx_tieta.git into dev...

hdw

2019-01-19 7f953d9aa0e7d4fcbe3c366c7f9f0b3f847f12bd

 gx_tieta/src/com/fgkj/dao/impl/ram/Bts_gprs_stateImpl.java

@@ -29,7 +29,7 @@
   public boolean update(Object obj) {

      Bts_gprs_state gprs=(Bts_gprs_state) obj;

      String sql=" REPLACE  into db_ram_db.tb_bts_gprs_state(AT_cmd,dev_id)  values('"+FBS9100_ComBase.CSQ+gprs.getAT_cmd()+"',?)";

      System.out.println(sql);

      //System.out.println(sql);

      boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{gprs.getDev_id()});

      return bl;

   }

@@ -46,12 +46,12 @@
    //根据设备id读取的设备连接的gprs模块的信号值

   public List serchByCondition(Object obj) {

      Bts_gprs_state gprs=(Bts_gprs_state) obj;

      String sql=" select distinct db_ram_db.tb_bts_gprs_state.num,dev_id,op_cmd,AT_cmd,ack_inf" +

      String sql=" select distinct db_ram_db.tb_bts_gprs_state.num,dev_id,op_cmd,AT_cmd,ack_inf,bts_task_inf" +

            " ,stationName,FBSDeviceName " +

            " from db_ram_db.tb_bts_gprs_state,db_battinf.tb_battinf " +

            " where db_ram_db.tb_bts_gprs_state.dev_id=db_battinf.tb_battinf.FBSDeviceId " +

            " and dev_id=? " +

            " order by record_datetime desc";

            " and dev_id=? " ;

      //System.err.println(sql);

      List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{gprs.getDev_id()}, new CallBack() {

         

         public List getResults(ResultSet rs) {

@@ -64,6 +64,7 @@
                  g.setOp_cmd(rs.getInt("op_cmd"));

                  g.setAT_cmd(rs.getString("aT_cmd"));

                  g.setAck_inf(rs.getString("ack_inf"));

                  g.setBts_task_inf(rs.getString("bts_task_inf"));

                  g.setStationName(rs.getString("stationName"));

                  g.setFBSDeviceName(rs.getString("fBSDeviceName"));

                  list.add(g);

@@ -139,9 +140,11 @@
   public static void main(String[] args) {

    Bts_gprs_stateImpl bimpl=new Bts_gprs_stateImpl();

    Bts_gprs_state gprs=new Bts_gprs_state();

    gprs.setDev_id(910000577);

    gprs.setDev_id(910000001);

    gprs.setAT_cmd("CSQ");

    boolean bl=bimpl.update(gprs);

    System.out.println(bl);

   /* boolean bl=bimpl.update(gprs);

    System.out.println(bl);*/

    List list=bimpl.serchByCondition(gprs);

    System.out.println(list);

}

}