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 As shown in the figure, the correct parameter value should be like this. Smart students should know what is wrong 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:
|
<<: Detailed explanation of two ways of Linux service management: service and systemctl
>>: Vue project implements left swipe delete function (complete code)
Table of contents Preface optimization Extract va...
When an employer asks you whether an index will b...
What is a mata tag The <meta> element provi...
This article mainly introduces how to build a MyS...
This article example shares the specific code of ...
When installing the centos7 version, choose to co...
1. KVM virtual machine migration method and issue...
Table of contents 1. let keyword 1.1 Basic Usage ...
This is the content of React 16. It is not the la...
Anyone who has used the Linux system should know ...
Table of contents Stabilization Introduction Anti...
Problem Description Today, when I was modifying t...
Look at the code first #/bin/sh datename=$(date +...
1. Apache 2.4.41 installation and configuration T...
Three MySQL instance processes are started on one...