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

How to use MySQL binlog to restore accidentally deleted databases

Table of contents 1 View the current database con...

Solution to the automatic termination of docker run container

Today I encountered a problem when I used Dockerf...

The difference between MySQL count(1), count(*), and count(field)

Table of contents 1. First look at COUNT 2. The d...

The difference between html empty link href="#" and href="javascript:void(0)"

# contains a location information. The default anc...

How to implement Mysql switching data storage directory

How to implement Mysql switching data storage dir...

A brief discussion on the design of Tomcat multi-layer container

Table of contents Container Hierarchy The process...

MySQL users and permissions and examples of how to crack the root password

MySQL Users and Privileges In MySQL, there is a d...

Solve the problem that Navicat cannot connect to MySQL on the Linux server

At the beginning, I felt sad. The screenshots are...

MySQL case when group by example

A mysql-like php switch case statement. select xx...

SQL GROUP BY detailed explanation and simple example

The GROUP BY statement is used in conjunction wit...

A detailed summary of HTML tag nesting rules suitable for beginners

I have been relearning HTML recently, which can be...

How to elegantly back up MySQL account information

Preface: I recently encountered the problem of in...

Teach you how to build the vue3.0 project architecture step by step

Table of contents Preface: 1. Create a project wi...