2022.1.6

15832144755

2022-01-06 7b4c8991dca9cf2a809a95e239d144697d3afb56

 src/main/java/com/hxzkoa/services/SysSettingService.java

@@ -385,7 +385,7 @@
      sql = "SELECT dataname,datapass,gui_ji,bei_fen_di_zhi,data_time,title,udpPort,udpAdress,openudp,"
            + "know_tag_zu,wifi_mdel,tagZb,diskaoqing,viewAnckid,viewName,tunlDw,guiji_sava,viewPower,"
            + "viewTagid,viewAnckzb,offView,anckicon,gas_show,quiet,real_trak_time,"
            + "real_trak_color,gas_open,gas_port,gas_hz,rssid,bs_udp,origin_jingdu,origin_weidu,origin_jiaodu,fence_show,yulan_map,baidu_j,baidu_w FROM tb_system";
            + "real_trak_color,gas_open,gas_port,gas_hz,rssid,bs_udp,origin_jingdu,origin_weidu,origin_jiaodu,fence_show,yulan_map,baidu_j,baidu_w,cs_udp,baoliu10 FROM tb_system";
      query = this.em.createNativeQuery(sql);
      List resultList = query.getResultList();
      List<tb_system> tb_systemList = new ArrayList<tb_system>();
@@ -431,6 +431,8 @@
            setting.setYulan_map(obj[35] == null ?"" :obj[35].toString());
            setting.setBaidu_j(obj[36] == null ?"" :obj[36].toString());
            setting.setBaidu_w(obj[37] == null ?"" :obj[37].toString());
            setting.setCs_udp(obj[38] == null ?"" :obj[38].toString());
            setting.setBaoliu10(obj[39] == null ?"" :obj[39].toString());
            tb_systemList.add(setting);
         }
      }
@@ -609,5 +611,14 @@
      return tb_suanfaList;
   }
   
	
   @Transactional
   public int guiling() {
      String sql = null;
      Query query = null;
      sql = "UPDATE tb_system SET baoliu10=null WHERE id = 1";
      cs.tb_caozuo("tb_suanfa", 3);
      query = this.em.createNativeQuery(sql);
      int executeUpdate = query.executeUpdate();
      return executeUpdate;
   }
}