修改更新和插入方法

wuww

2025-04-16 cf0f1f174cd26eb0bba66d5684ccd3b591337e46

修改更新和插入方法

 src/main/java/com/se/nsl/controller/RegionController.java

@@ -71,8 +71,8 @@
     * @return 新增成功的记录数
     */
    @ApiOperation(value = "insert")
    @PostMapping("/insert")
    public R<Object> insert(Region region) {
    @PostMapping(value = "/insert", produces = "application/json; charset=UTF-8")
    public R<Object> insert(@RequestBody Region region) {
        try {
            return success(regionService.insert(region));
        } catch (Exception ex) {

 src/main/java/com/se/nsl/controller/SimuController.java

@@ -71,8 +71,8 @@
     * @return 新增成功的记录数
     */
    @ApiOperation(value = "insert")
    @PostMapping("/insert")
    public R<Object> insert(Simu simu) {
    @PostMapping(value = "/insert", produces = "application/json; charset=UTF-8")
    public R<Object> insert(@RequestBody Simu simu) {
        try {
            return success(simuService.insert(simu));
        } catch (Exception ex) {

 src/main/java/com/se/nsl/service/RegionService.java

@@ -72,7 +72,6 @@
     * @return 新增成功的记录数
     */
    public int insert(Region region) {
        region.setGeomText();
        return regionMapper.inserts(Arrays.asList(region));
    }

@@ -83,7 +82,6 @@
     * @return 修改成功的记录数
     */
    public int updateById(Region region) {
        region.setGeomText();
        return regionMapper.updates(Arrays.asList(region));
    }
}

 src/main/java/com/se/nsl/service/SimuService.java

@@ -82,7 +82,6 @@
     * @return 新增成功的记录数
     */
    public int insert(Simu simu) {
        simu.setGeomText();
        return simuMapper.inserts(Collections.singletonList(simu));
    }

@@ -93,7 +92,6 @@
     * @return 修改成功的记录数
     */
    public int updateById(Simu simu) {
        simu.setGeomText();
        return simuMapper.updates(Arrays.asList(simu));
    }
}

 src/main/resources/mapper/RegionMapper.xml

@@ -4,7 +4,18 @@
    <insert id="inserts" parameterType="com.se.nsl.domain.po.Region">
        insert into nsl.region(name, type, geom) values
        <foreach collection="list" item="item" index="index" separator=",">
            (#{item.name}, #{item.type}, ${item.geom})
        (
            #{item.name},
            #{item.type},
            <choose>
                <when test="item.geom != null and item.geom != ''">
                    ST_GeomFromText('${item.geom}')
                </when>
                <otherwise>
                    null
                </otherwise>
            </choose>
        )
        </foreach>
    </insert>

@@ -13,7 +24,14 @@
            update nsl.region
            set name = #{item.name},
                type = #{item.type},
                geom = ${item.geom}
                <choose>
                    <when test="item.geom != null and item.geom != ''">
                        geom = ST_GeomFromText('${item.geom}')
                    </when>
                    <otherwise>
                        geom = null
                    </otherwise>
                </choose>
            where id = #{item.id}
        </foreach>
    </update>

 src/main/resources/mapper/SimuMapper.xml

@@ -17,7 +17,14 @@
            now(),
            #{item.createUser},
            #{item.bak},
            ${item.geom}
            <choose>
                <when test="item.geom != null and item.geom != ''">
                    ST_GeomFromText('${item.geom}')
                </when>
                <otherwise>
                    null
                </otherwise>
            </choose>
        )
        </foreach>
    </insert>
@@ -35,7 +42,14 @@
                update_time=now(),
                update_user=#{item.updateUser},
                bak=#{item.bak},
                geom=${item.geom}
                <choose>
                    <when test="item.geom != null and item.geom != ''">
                        geom = ST_GeomFromText('${item.geom}')
                    </when>
                    <otherwise>
                        geom = null
                    </otherwise>
                </choose>
            where id = #{item.id}
        </foreach>
    </update>