1

13693261870

2023-04-07 18ef42f5a89babf01bdce096d05fbb6471763f68

1

 data/db_cx.sql

@@ -25,6 +25,30 @@
select * from lf.sys_download order by id desc limit 20; --downid
select * from lf.sys_apply order by id desc;

select case a.userid when 2 then guid else null end "guid", a.* from lf.sys_apply a order by id desc

select c.relname "tab", cast(obj_description(c.oid) as varchar) "desc", a.attnum "num",
a.attname "col", t.typname "type", d.description "bak" from pg_attribute a left join pg_description d 
on d.objoid = a.attrelid and d.objsubid = a.attnum left join pg_class c on a.attrelid = c.oid left join pg_type t 
on a.atttypid = t.oid where a.attnum >= 0 and reltype>0 and relnamespace in (5424908) and c.relname='pl_pipelinepoint_f' and position('pg.dropped' in a.attname) = 0
order by c.relname desc, a.attnum asc

select * from bs.s_explorationpointstratum where exppointid in ('HJXK20')



















 src/main/resources/mapper/show/ApplyMapper.xml

@@ -86,17 +86,17 @@
        </selectKey>

        insert into lf.sys_apply
        (userid,depids,tabs,entities,wkt,pwd,status,count,descr,create_user,create_time,depcode,dircodes,gids,filters)
        (userid,depids,tabs,entities,wkt,pwd,status,count,descr,create_user,create_time,depcode,dircodes,gids,filters,guid)
        values
        (#{userid},#{depids},#{tabs},#{entities},#{wkt},#{pwd},#{status},#{count},#{descr},#{createUser},now(),#{depcode},#{dircodes},#{gids},#{filters})
        (#{userid},#{depids},#{tabs},#{entities},#{wkt},#{pwd},#{status},#{count},#{descr},#{createUser},now(),#{depcode},#{dircodes},#{gids},#{filters},#{guid})
    </insert>

    <insert id="inserts">
        insert into lf.sys_apply
        (userid,depids,tabs,entities,wkt,pwd,status,count,descr,create_user,create_time,depcode,dircodes,gids,filters)
        (userid,depids,tabs,entities,wkt,pwd,status,count,descr,create_user,create_time,depcode,dircodes,gids,filters,guid)
        values
        <foreach collection="list" item="item" index="index" separator=",">
            (#{item.userid},#{item.depids},#{item.tabs},#{item.entities},#{item.wkt},#{item.pwd},#{item.status},#{item.count},#{item.descr},#{item.createUser},now(),#{item.depcode},#{item.dircodes},#{item.gids},#{item.filters})
            (#{item.userid},#{item.depids},#{item.tabs},#{item.entities},#{item.wkt},#{item.pwd},#{item.status},#{item.count},#{item.descr},#{item.createUser},now(),#{item.depcode},#{item.dircodes},#{item.gids},#{item.filters},#{item.guid})
        </foreach>
    </insert>

@@ -113,7 +113,7 @@

    <update id="update">
        update lf.sys_apply
        set userid=#{userid},depids=#{depids},tabs=#{tabs},entities=#{entities},wkt=#{wkt},pwd=#{pwd},status=#{status},count=#{count},descr=#{descr},update_user=#{updateUser},update_time=now(),depcode=#{depcode},dircodes=#{dircodes},gids=#{gids},filters=#{filters}
        set userid=#{userid},depids=#{depids},tabs=#{tabs},entities=#{entities},wkt=#{wkt},pwd=#{pwd},status=#{status},count=#{count},descr=#{descr},update_user=#{updateUser},update_time=now(),depcode=#{depcode},dircodes=#{dircodes},gids=#{gids},filters=#{filters},guid=#{guid}
        where id=#{id}
    </update>

@@ -121,7 +121,7 @@
        <foreach collection="list" item="item" index="index" separator=";">
            update lf.sys_apply
            <set>
                userid=#{item.userid},depids=#{item.depids},tabs=#{item.tabs},entities=#{item.entities},wkt=#{item.wkt},pwd=#{item.pwd},status=#{item.status},count=#{item.count},descr=#{item.descr},update_user=#{item.updateUser},update_time=now(),depcode=#{item.depcode},dircodes=#{item.dircodes},gids=#{item.gids},filters=#{item.filters}
                userid=#{item.userid},depids=#{item.depids},tabs=#{item.tabs},entities=#{item.entities},wkt=#{item.wkt},pwd=#{item.pwd},status=#{item.status},count=#{item.count},descr=#{item.descr},update_user=#{item.updateUser},update_time=now(),depcode=#{item.depcode},dircodes=#{item.dircodes},gids=#{item.gids},filters=#{item.filters},guid=#{item.guid}
            </set>
            where id = #{item.id}
        </foreach>

 说明.txt

@@ -1,8 +1,9 @@
-------------------------------------------------------------------------------
Access锛歨ttps://blog.csdn.net/weixin_43407520/article/details/122165848
GDAL锛歨ttps://www.cnblogs.com/unlockth/p/14062076.html

E:\terrait\TianJin\Zip\release-1928-x64-dev\release-1928-x64\bin

https://start.spring.io -> https://start.aliyun.com
-------------------------------------------------------------------------------
mklink /d "C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\geoserver\data\data\tiles" E:\TaiRui\LFData\2d\tiles