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 1. Back up the old MySQL5.7 dat...
I recently installed Ubuntu 20.04 and found that ...
Implemented according to the online tutorial. zab...
Table of contents Problem Description Solution Pr...
Table of contents 1. Introduction 2. Main text 2....
Docker only maps ports to IPv6 but not to IPv4 St...
1.service command The service command actually go...
Preface In the springboot configuration file, the...
Preface I wrote an article about rem adaptation b...
1. Add a comment block at the beginning of the sty...
Table of contents Overview How to share data betw...
Copy code The code is as follows: <!--doctype ...
This article shares the specific code of vue+echa...
Preface When developing static pages, such as Vue...
1. I downloaded QT5.13 version before, but after ...