7.23

15832144755

2021-07-23 741d66c00c593d4f14cd6731d3e4af6ee5c191ac

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

@@ -73,6 +73,11 @@
            shipin.setShebeiid(obj[2] == null ? "" : obj[2].toString());
            shipin.setTongdaoid(obj[3] == null ? "" : obj[3].toString());
            shipin.setAddtime(obj[4] == null ? "" : obj[4].toString());
            shipin.setPosx(obj[5] == null ? "" : obj[5].toString());
            shipin.setPosy(obj[6] == null ? "" : obj[6].toString());
            shipin.setPosz(obj[7] == null ? "" : obj[7].toString());
            shipin.setFloor(obj[8] == null ? "" : obj[8].toString());
            shipin.setName(obj[9] == null ? "" : obj[9].toString());
            tb_shipinList.add(shipin);
         }
      }
@@ -91,11 +96,16 @@
   public int shipinManagement_add(tb_shipin shipin) {
      String sql = null;
      Query query = null;
      sql = "INSERT INTO tb_shipin(fencename,shebeiid,tongdaoid,addtime) VALUES(:fencename,:shebeiid,:tongdaoid,now())";
      sql = "INSERT INTO tb_shipin(fencename,shebeiid,tongdaoid,addtime,posx,posy,posz,floor,name) VALUES(:fencename,:shebeiid,:tongdaoid,now(),:posx,:posy,:posz,:floor,:name)";
      query = this.em.createNativeQuery(sql);
      query.setParameter("fencename", shipin.getFencename());
      query.setParameter("shebeiid", shipin.getShebeiid());
      query.setParameter("tongdaoid", shipin.getTongdaoid());
      query.setParameter("posx", shipin.getPosx());
      query.setParameter("posy", shipin.getPosy());
      query.setParameter("posz", shipin.getPosz());
      query.setParameter("floor", shipin.getFloor());
      query.setParameter("name", shipin.getName());
      int executeUpdate = query.executeUpdate();
      return executeUpdate;
   }
@@ -104,13 +114,17 @@
   public void shipinManagement_modify(tb_shipin shipin) {
      String sql = null;
      Query query = null;
      sql = "UPDATE tb_shipin SET fencename=:fencename,shebeiid=:shebeiid,tongdaoid=:tongdaoid WHERE id=:id";
      sql = "UPDATE tb_shipin SET fencename=:fencename,shebeiid=:shebeiid,tongdaoid=:tongdaoid,posx=:posx,posy=:posy,posz=:posz,floor=:floor,name=:name WHERE id=:id";
      query = this.em.createNativeQuery(sql);
      query.setParameter("id", shipin.getId());
      query.setParameter("fencename", shipin.getFencename());
      query.setParameter("shebeiid", shipin.getShebeiid());
      query.setParameter("tongdaoid", shipin.getTongdaoid());
      System.out.print(sql);
      query.setParameter("posx", shipin.getPosx());
      query.setParameter("posy", shipin.getPosy());
      query.setParameter("posz", shipin.getPosz());
      query.setParameter("floor", shipin.getFloor());
      query.setParameter("name", shipin.getName());
      query.executeUpdate();
   }