1

13693261870

2023-03-24 80202ba459f8c11bf62e35832d829bfcfcf0ee48

1

 ExportMap/Web.config

@@ -13,7 +13,8 @@
    <add key="sgDB" value="E:\soft\SGConfig\catalog.db"/>
    <!-- PG连接 -->
    <!--<add key="pgConn" value="Server=127.0.0.1;Port=5433;Database=langfang;User Id=postgres;Password=postgres;"/>-->
    <add key="pgConn" value="Server=192.168.20.205;Port=5433;Database=langfang;User Id=postgres;Password=Postgres!_14_Lf;"/>
    <!--<add key="pgConn" value="Server=192.168.20.205;Port=5433;Database=langfang;User Id=postgres;Password=Postgres!_14_Lf;"/>-->
    <add key="pgConn" value="Server=103.85.165.99;Port=5433;Database=langfang;User Id=postgres;Password=Postgres!_14_Lf;"/>
    <add key="webpages:Version" value="3.0.0.0"/>
    <add key="webpages:Enabled" value="false"/>
    <add key="ClientValidationEnabled" value="true"/>

 JavaCode/SysTemplate/Mapper.xml

@@ -17,12 +17,12 @@
                {testWhere}
            </if>
        </where>
        order by id
        order by id desc
        limit #{limit} offset #{offset}
    </select>

    <select id="selectAll" resultType="{entityNS}.{entityName}">
        select * from {tabName} order by id;
        select * from {tabName} order by id desc;
    </select>

    <select id="selectById" resultType="{entityNS}.{entityName}">
@@ -65,9 +65,7 @@
    <update id="updates">
        <foreach collection="list" item="item" index="index" separator=";">
            update {tabName}
            <set>
                {updateVals}
            </set>
            set {updateVals}
            where id = #{item.id}
        </foreach>
    </update>