SourceFile FenceService.java (Lorg/springframework/stereotype/Service; í î \SELECT id,floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color,baoliu1 FROM tb_fence æ ç. /0+ 1 õ java/util/ArrayList, 2% com/hxzkoa/json/tb_fence 34 java/lang/Integer 5% 67 89 :; <; =; >; ?; @; A; B; C; D; E; FG |SELECT id,floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color,baoliu1,baoliu3,baoliu4,baoliu6,baoliu7 FROM tb_fence H; I; J; K; SELECT id,floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color,baoliu1,baoliu3,baoliu4,baoliu6,baoliu7 FROM tb_fence where type!='åçµç«' com/hxzkoa/json/tb_fence2 ;* LM , java/lang/StringBuilderN OPQ RS TU TV ?- °SELECT id,floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color,baoliu1,baoliu3,baoliu4,baoliu6,baoliu7 FROM tb_fence WHERE baoliu7 = '1' ORDER BY addtime DESC LIMIT 0,5 ÆSELECT id,floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color,baoliu1,baoliu3,baoliu4,baoliu6,baoliu7 FROM tb_fence WHERE baoliu7 = '1' and type!='åçµç«' ORDER BY addtime DESC LIMIT 0,5 zSELECT id,floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color,baoliu1 FROM tb_fence Where floor != 'ç¾åº¦å°å¾' )SELECT * FROM tb_shipin LIMIT :start,:end startW X9Y Z[ \] ^_ `a end com/hxzkoa/json/tb_shipin b; c; d; e; f; g; SELECT count(1) FROM tb_shipin hi ³INSERT INTO tb_shipin(fencename,shebeiid,tongdaoid,addtime,posx,posy,posz,floor,name,baoliu1) VALUES(:fencename,:shebeiid,:tongdaoid,now(),:posx,:posy,:posz,:floor,:name,:baoliu1) fencename j9 shebeiid k9 tongdaoid l9 posx m9 posy n9 posz o9 floor p9 name q9 baoliu1 r9 (% ¨UPDATE tb_shipin SET fencename=:fencename,shebeiid=:shebeiid,tongdaoid=:tongdaoid,posx=:posx,posy=:posy,posz=:posz,floor=:floor,name=:name,baoliu1=:baoliu1 WHERE id=:id s% $DELETE FROM tb_shipin WHERE id = :id -SELECT shebeiid FROM tb_shipin WHERE id = :id DELETE FROM tb_shipin /SELECT * FROM tb_shipin WHERE fencename = :name pSELECT id,floor,type,bumen,`name`,zuobiao,shape,`start`,`stop`,addtime,color FROM tb_fence WHERE type LIKE :type type % iSELECT id,floor,type,bumen,`name`,zuobiao,shape,`start`,`stop`,addtime,color FROM tb_fence WHERE id = :id oSELECT id,floor,type,bumen,`name`,zuobiao,shape,`start`,`stop`,addtime,color FROM tb_fence WHERE floor = :floor rUPDATE tb_fence SET bumen=:bumen,name=:name,zuobiao=:zuobiao,start=:start,stop=:stop,baoliu1=:baoliu1 WHERE id=:id ê ë tb_fencet uv bumen w9 x9 y9 stop z9 UPDATE tb_fence SET bumen=:bumen,name=:name,zuobiao=:zuobiao,start=:start,stop=:stop,baoliu1=:baoliu1,baoliu3=:baoliu3,baoliu4=:baoliu4 WHERE id=:id baoliu3 {9 baoliu4 |9 #DELETE FROM tb_fence WHERE id = :id DELETE FROM tb_fence XSELECT quyu,startime,stoptime,xunshu,tagid,needstoptime,cishu,addtime FROM tb_xunjianset com/hxzkoa/json/tb_xunjianset }; ~; ; ; ; ; ; UPDATE tb_xunjianset SET xunshu=:xunshu,tagid=:tagid,cishu=:cishu,needstoptime=:needstoptime,stoptime=:stoptime WHERE quyu=:quyu tb_xunjianset 9 xunshu
9 9 cishu 9 needstoptime 9 stoptime 9 \SELECT id,name,tagid,quyu,bianhao,intime,outtime,alltime,succ,addtime FROM tb_xunjianbaobiao !com/hxzkoa/json/tb_xunjianbaobiao ; ; ; ; ; nSELECT id,name,tagid,quyu,bianhao,intime,outtime,alltime,succ,addtime FROM tb_xunjianbaobiao LIMIT :start,:end rSELECT id,name,tagid,quyu,bianhao,intime,outtime,alltime,succ,addtime FROM tb_xunjianbaobiao WHERE tagid = :tag_id tag_id &SELECT count(1) FROM tb_xunjianbaobiao ,DELETE FROM tb_xunjianbaobiao WHERE id = :id tb_xunjianbaobiao DELETE FROM tb_xunjianbaobiao NSELECT bianhao,intime FROM tb_xunjianbaobiao WHERE tagid=:tagid AND quyu=:quyu rINSERT tb_xunjianbaobiao (name,tagid,quyu,bianhao,intime,addtime) VALUES (:name,:tagid,:quyu,:bianhao,now(),now()) bianhao 9 cSELECT id,floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color FROM tb_fence WHERE id = :id &SELECT name from tb_fence WHERE id=:id ©INSERT INTO tb_jobhistory(type,fencename,department,tagid,high,fenceaddtime,addtime,beizhu) VALUES(:type,:fencename,:department,:tagid,:high,:fenceaddtime,now(),:beizhu) 9
|
