修改

81041

2019-01-15 253879d0d562db0290a67160d30d3f15e8e7bf09

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

@@ -28,7 +28,8 @@
   //给gprs发送指令

   public boolean update(Object obj) {

      Bts_gprs_state gprs=(Bts_gprs_state) obj;

      String sql=" update db_ram_db.tb_bts_gprs_state set AT_cmd="+FBS9100_ComBase.CSQ+gprs.getAT_cmd()+" where dev_id=? ";

      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);

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

      return bl;

   }

@@ -45,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) {

@@ -63,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);

@@ -135,5 +137,14 @@
      // TODO Auto-generated method stub

      return null;

   }



   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(910000001);

    gprs.setAT_cmd("CSQ");

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

    System.out.println(bl);*/

    List list=bimpl.serchByCondition(gprs);

    System.out.println(list);

}

}