MySQL batch processing for multiple SQL statements

1pstmt=conn.preparestatement (SQL);2              for(inti=0;i<500;i++)3             {4                 //Preparing SQL statements5Pstmt.setstring (1, "TT");6Pstmt.setstring (2, "1234567890");7Pstmt.addbatch ();//Put the SQL statement in the cache8             }            9Pstmt.executebatch ();//to execute the SQL statement in the cache

The bulk execution and loop execution statements here are different, where bulk execution is to put SQL statements in the cache and then execute them in the background

Each statement is executed directly and submitted when the loop executes

MySQL batch processing for multiple SQL statements