Mybatis mysql delete in operation can only delete the first data method

Mybatis mysql delete in operation can only delete the first data method

Bugs

As shown in the figure, I started to copy the delete statement and parameters to the database to execute and delete two data, but the background execution only deleted one data. I was confused at the time.

  Analyze the causes

Analyze the causes

As shown in the figure, the correct parameter value should be like this. Smart students should know what is wrong

Solving the problem

  Solving the problem

I won't post the initial code, I will directly post the code to solve the bug

Code in mybatis

<!-- Batch Delete -->
  <delete id="deleteByIds" parameterType="int[]">
     <![CDATA[
    DELETE FROM p_customer
    WHERE customerId in
    ]]>
    <foreach collection="array" item="arr" index="no" open="("
      separator="," close=")">
      #{arr}
    </foreach>
  </delete>

Code in controller

/**
   * Delete and bulk delete */
  @RequestMapping(value = "/del", method = RequestMethod.POST, produces = { MediaType.APPLICATION_JSON_VALUE })
  public ResponseEntity<PCustomerVo> delete(@RequestParam String customerId) throws Exception {
    //Get the IDs for batch deletion and remove the last ","
    customerId = customerId.substring(0, customerId.length()-1);
    String[] strarr=customerId.split(",");
    int[] arr = new int[strarr.length];
    for(int i=0;i<strarr.length;i++){
      arr[i]=Integer.parseInt(str[i]);
    }
    pcustomerService.deletes(arr);
    return new ResponseEntity<>(HttpStatus.OK);
  }

Summarize

The above is what I introduced to you. The mybatis mysql delete in operation can only delete the first data. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:
  • Solve the problem that mybatis only displays one piece of data in one-to-many association query
  • Solve the problem that mybatis plus paging query has a number of entries, total and pages are both zero
  • Oracle combined with Mybatis to achieve the top 10 data in the table
  • Mybatis example code for querying the number of records
  • Mybatis RowBounds implementation code to limit the number of queries
  • Mybatis batch insert returns the number of successful examples

<<:  Detailed explanation of two ways of Linux service management: service and systemctl

>>:  Vue project implements left swipe delete function (complete code)

Recommend

An example of elegantly writing status labels in Vue background

Table of contents Preface optimization Extract va...

Will the index be used in the MySQL query condition?

When an employer asks you whether an index will b...

A collection of common uses of HTML meta tags

What is a mata tag The <meta> element provi...

How to build mysql master-slave server on centos7 (graphic tutorial)

This article mainly introduces how to build a MyS...

js canvas realizes slider verification

This article example shares the specific code of ...

CentOS 7 method to modify the gateway and configure the IP example

When installing the centos7 version, choose to co...

How to implement online hot migration of KVM virtual machines (picture and text)

1. KVM virtual machine migration method and issue...

Based on JavaScript ES new features let and const keywords

Table of contents 1. let keyword 1.1 Basic Usage ...

React error boundary component processing

This is the content of React 16. It is not the la...

How to get the size of a Linux system directory using the du command

Anyone who has used the Linux system should know ...

Web project development JS function anti-shake and throttling sample code

Table of contents Stabilization Introduction Anti...

Tutorial on installing Apache 2.4.41 on Windows 10

1. Apache 2.4.41 installation and configuration T...

Zabbix implements monitoring of multiple mysql processes

Three MySQL instance processes are started on one...