java复制代码List<String> list = Arrays.asList(arr);

java复制代码ArrayList<String> arrayList = new ArrayList<String>(Arrays.asList(arr));

java复制代码Set<String> set = new HashSet<String>(Arrays.asList(arr));
return set.contains(targetValue);

java复制代码return Arrays.asList(arr).contains(targetValue);

java复制代码for(String s: arr){
	if(s.equals(targetValue))
		return true;
}
return false;

java复制代码ArrayList<String> list = new ArrayList<String>(Arrays.asList("a", "b", "c", "d"));
for (int i = 0; i < list.size(); i++) {
	list.remove(i);
}
System.out.println(list);

java复制代码ArrayList<String> list = new ArrayList<String>(Arrays.asList("a", "b", "c", "d"));
 
for (String s : list) {
	if (s.equals("a"))
		list.remove(s);
}

java复制代码ArrayList<String> list = new ArrayList<String>(Arrays.asList("a", "b", "c", "d"));
Iterator<String> iter = list.iterator();
while (iter.hasNext()) {
	String s = iter.next();
 
	if (s.equals("a")) {
		iter.remove();
	}
}

java复制代码public static void add(List list, Object o){
	list.add(o);
}
public static void main(String[] args){
	List<String> list = new ArrayList<String>();
	add(list, 10);
	String s = list.get(0);
}

java复制代码public class Test {

    public static void main(String[] args) {

        ArrayList<String> list1 = new ArrayList<String>();
        list1.add("abc");

        ArrayList<Integer> list2 = new ArrayList<Integer>();
        list2.add(123);

        System.out.println(list1.getClass() == list2.getClass());
    }

}

java复制代码String result="";
for(String s: arr){
	result = result + s;
}

java复制代码public Super(){
    System.out.println("Super");
}

java复制代码String x = "abc";
String y = new String("abc");

java复制代码String a = "abcd";
String b = "abcd";
System.out.println(a == b);  // True
System.out.println(a.equals(b)); // True
 
String c = new String("abcd");
String d = new String("abcd");
System.out.println(c == d);  // False
System.out.println(c.equals(d)); // True

sql复制代码DROP TABLE IF EXISTS `knowledge_interfacecatalog`;
CREATE TABLE `knowledge_interfacecatalog` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `UnitGuid` varchar(50) DEFAULT NULL,
  `AddDate` datetime DEFAULT NULL,
  `CataName` varchar(100) DEFAULT NULL,
  `ParentCataGuid` varchar(50) DEFAULT NULL,
  `SortNum` int(11) DEFAULT NULL,
  `DocGuid` varchar(50) DEFAULT NULL,
  KEY `ID` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

sql复制代码DROP TABLE IF EXISTS `knowledge_interfaceinfo`;
CREATE TABLE `knowledge_interfaceinfo` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `UnitGuid` varchar(50) DEFAULT NULL,
  `AddDate` datetime DEFAULT NULL,
  `InterfaceName` varchar(100) DEFAULT NULL,
  `Description` varchar(500) DEFAULT NULL,
  `Remark` varchar(500) DEFAULT NULL,
  `ParamJson` varchar(2000) DEFAULT NULL,
  `ResponseJson` varchar(2000) DEFAULT NULL,
  `InterfaceAddress` varchar(500) DEFAULT NULL,
  `SortNum` int(11) DEFAULT NULL,
  `CataGuid` varchar(50) DEFAULT NULL,
  `DocGuid` varchar(50) DEFAULT NULL,
  KEY `ID` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4;

java复制代码        <dependency>
            <groupId>com.itextpdf</groupId>
            <artifactId>itextpdf</artifactId>
            <version>5.4.3</version>
        </dependency>

        <dependency>
            <groupId>com.itextpdf</groupId>
            <artifactId>itext-asian</artifactId>
            <version>5.2.0</version>
        </dependency>

java复制代码	Document document = new Document(PageSize.A2);
    PdfWriter writer = PdfWriter.getInstance(document, new FileOutputStream(filePath));
  	document.addTitle(doc.getDocName());
    document.addAuthor("xxxxx");
    document.addCreationDate();
    document.addLanguage("中文");
    document.open();

java复制代码    File fontFile = new File("font/msyh.ttf");
    BaseFont bf = BaseFont.createFont(fontFile.getAbsolutePath(), BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
    Font fontChinese5 = new Font(bf,14);

java复制代码 	//目录的字体
   Font cataFont = new Font(bf, 24, Font.NORMAL, BaseColor.BLACK);
   // 接口的字体
   Font interFont = new Font(bf, 20, Font.NORMAL, BaseColor.BLACK);     
   for(int i=1;i<=10;i++){
		Chapter chapter = new Chapter(new Paragraph("目录", cataFont),i);
        for(int j=1;j<=5;j++){
            Section section = chapter.addSection(new Paragraph("接口", interFont));
        }
        document.add(chapter);
    }
	document.close();

java复制代码  PdfPTable table = new PdfPTable(3);//生成一个3列的表格
  //表格垂直居中
  table.setHorizontalAlignment(Element.ALIGN_CENTER);
  table.setTotalWidth(800f);
  float[] widths = new float[] { 150f,325f,325f };
  table.setWidths(widths);
  PdfPCell cell;
  cell = new PdfPCell(new Paragraph("接口地址",fontChinese5));
  table.addCell(cell);
   cell = new PdfPCell(new Paragraph(interfaceInfoDO.getInterfaceAddress(),fontChinese5));
  cell.setColspan(2);
  table.addCell(cell);

javascript复制代码<script type="text/javascript">
    var interval = setInterval('loadPdf()', 1000);

    function loadPdf() {
        if (PDFViewerApplication.pdfDocument == null) {
            console.info('Loading...');
        } else {
            clearInterval(interval);
            console.info('Load Success...');
            var sidebarToggle =   $("#sidebarToggle");
            var viewOutline =   $("#viewOutline");
            if(!sidebarToggle.hasClass("toggled")){
              sidebarToggle.click();
            }
            if(!viewOutline.hasClass("toggled")){
              viewOutline.click();
            }
        }
    }
</script>

xml复制代码<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>4.1.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.2</version>
</dependency>

java复制代码XWPFDocument document = new XWPFDocument(new FileInputStream(path));

java复制代码XWPFDocument document = new XWPFDocument(XWPFDocument.openPackage("C:\Users\admin\Desktop\0.docx"));

arduino复制代码 new XWPFDocument(new FileInputStream(path)) 打开操作word不会修改原模板输出操作时。
 new XWPFDocument(XWPFDocument.openPackage("C:\Users\admin\Desktop\0.docx")) 原来的word模板会被修改

java复制代码    public class Test004 {
        public static void main(String[] args) throws IOException, OpenXML4JException, XmlException {

            XWPFDocument document = new XWPFDocument(new FileInputStream("C:\Users\admin\Desktop\0.docx"));

            XWPFParagraph paragraph = document.createParagraph();
            //获取所有段落
            List<XWPFParagraph> paragraphs = document.getParagraphs();
            for (int i = 0; i < paragraphs.size(); i++) {
                XWPFParagraph paragraph1 = paragraphs.get(i);
                if (paragraph1.getText().equals("开头")){
                    //将一个新运行追加到这一段
                    XWPFRun r1=paragraph.createRun();
                    r1.addCarriageReturn();
    //                获取当前光标位置
                    XmlCursor cursor = paragraph1.getCTP().newCursor();
                    cursor.toNextSibling();
    //                光标位置插入新段落
                    XWPFParagraph newParagraph = document.insertNewParagraph(cursor);
                    XWPFRun run = newParagraph.createRun();
                    run.getCTR().addNewRPr().addNewHighlight().setVal(STHighlightColor.LIGHT_GRAY);
                    String s= "                                                                        ";

                    String s1 = "插入当前位置！！！！";
                    StringBuilder stringBuilder = new StringBuilder();
                    for (int j = 0; j < 64-s1.length(); j++) {
                        stringBuilder.append(" ");
                    }
                    run.setText(s1+stringBuilder);


                    document.removeBodyElement(document.getPosOfParagraph(paragraph1));
                }

                System.out.println("死循环"+i);
            }


            document.write(new FileOutputStream("C:\Users\admin\Desktop\001.docx"));
            document.close();

        }
    }

复制代码   效果

sql复制代码-- 使 用explanin 查看 city 表的行数
mysql> EXPLAIN SELECT * FROM city;

+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+

| id | select_type | table | partitions | type | possible_keys | key  | key_len | ref  | rows | filtered | Extra |

+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+

|  1 | SIMPLE      | city  | NULL       | ALL  | NULL          | NULL | NULL    | NULL |  600 |   100.00 | NULL  |

+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+

1 row in set, 1 warning (0.01 sec)

xml复制代码<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <scope>runtime</scope>
</dependency>

properties复制代码spring.datasource.url=jdbc:postgresql://localhost:5432/test
spring.datasource.username=postgres
spring.datasource.password=123456
spring.datasource.driver-class-name=org.postgresql.Driver

spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
spring.jpa.properties.hibernate.hbm2ddl.auto=create

java复制代码@Entity
@Data
@NoArgsConstructor
public class UserInfo {

    @Id
    @GeneratedValue
    private Long id;

    private String name;
    private Integer age;

    public UserInfo(String name, Integer age) {
        this.name = name;
        this.age = age;
    }
}

java复制代码public interface UserInfoRepository extends JpaRepository<UserInfo, Long> {

    UserInfo findByName(String name);

    UserInfo findByNameAndAge(String name, Integer age);

    @Query("from UserInfo u where u.name=:name")
    UserInfo findUser(@Param("name") String name);

}

java复制代码@Slf4j
@SpringBootTest
public class ApplicationTests {

    @Autowired
    private UserInfoRepository userRepository;

    @Test
    public void test() throws Exception {
        // 创建10条记录
        userRepository.save(new UserInfo("AAA", 10));
        userRepository.save(new UserInfo("BBB", 20));
        userRepository.save(new UserInfo("CCC", 30));
        userRepository.save(new UserInfo("DDD", 40));
        userRepository.save(new UserInfo("EEE", 50));
        userRepository.save(new UserInfo("FFF", 60));
        userRepository.save(new UserInfo("GGG", 70));
        userRepository.save(new UserInfo("HHH", 80));
        userRepository.save(new UserInfo("III", 90));
        userRepository.save(new UserInfo("JJJ", 100));

        // 测试findAll, 查询所有记录
        Assertions.assertEquals(10, userRepository.findAll().size());

        // 测试findByName, 查询姓名为FFF的User
        Assertions.assertEquals(60, userRepository.findByName("FFF").getAge().longValue());

        // 测试findUser, 查询姓名为FFF的User
        Assertions.assertEquals(60, userRepository.findUser("FFF").getAge().longValue());

        // 测试findByNameAndAge, 查询姓名为FFF并且年龄为60的User
        Assertions.assertEquals("FFF", userRepository.findByNameAndAge("FFF", 60).getName());

        // 测试删除姓名为AAA的User
        userRepository.delete(userRepository.findByName("AAA"));

        // 测试findAll, 查询所有记录, 验证上面的删除是否成功
        Assertions.assertEquals(9, userRepository.findAll().size());

    }

}

ini复制代码private static HttpsURLConnection initHttps(String url, String method,
        Map<String, String> headers) throws Exception {
    TrustManager[] tm = { new MyX509TrustManager() };
    System.setProperty("https.protocols", "TLSv1");
    SSLContext sslContext = SSLContext.getInstance("TLS");
    sslContext.init(null, tm, new java.security.SecureRandom());
    // 从上述SSLContext对象中得到SSLSocketFactory对象
    SSLSocketFactory ssf = sslContext.getSocketFactory();
    URL _url = new URL(url);
    HttpsURLConnection http = (HttpsURLConnection) _url.openConnection();
    // 设置域名校验
    http.setHostnameVerifier(new HttpUtil().new TrustAnyHostnameVerifier());
    // 连接超时
    http.setConnectTimeout(DEF_CONN_TIMEOUT);
    // 读取超时 --服务器响应比较慢，增大时间
    http.setReadTimeout(DEF_READ_TIMEOUT);
    http.setUseCaches(false);
    http.setRequestMethod(method);
    http.setRequestProperty("Content-Type",
            "application/x-www-form-urlencoded");
    http.setRequestProperty(
            "User-Agent",
            "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.146 Safari/537.36");
    if (null != headers && !headers.isEmpty()) {
        for (Entry<String, String> entry : headers.entrySet()) {
            http.setRequestProperty(entry.getKey(), entry.getValue());
        }
    }
    http.setSSLSocketFactory(ssf);
    http.setDoOutput(true);
    http.setDoInput(true);
    http.connect();
    return http;
}
public static String get(String url, Map<String, String> params,
        Map<String, String> headers) throws Exception {
    HttpURLConnection http = null;
    if (isHttps(url)) {
        http = initHttps(initParams(url, params), _GET, headers);
    } else {
        http = initHttp(initParams(url, params), _GET, headers);
    }
    InputStream in = http.getInputStream();
    BufferedReader read = new BufferedReader(new InputStreamReader(in,
            DEFAULT_CHARSET));
    String valueString = null;
    StringBuffer bufferRes = new StringBuffer();
    while ((valueString = read.readLine()) != null) {
        bufferRes.append(valueString);
    }
    in.close();
    if (http != null) {
        http.disconnect();// 关闭连接
    }
    return bufferRes.toString();
}
public static String post(String url, String params)
        throws Exception {
    HttpURLConnection http = null;
    if (isHttps(url)) {
        http = initHttps(url, _POST, null);
    } else {
        http = initHttp(url, _POST, null);
    }
    OutputStream out = http.getOutputStream();
    out.write(params.getBytes(DEFAULT_CHARSET));
    out.flush();
    out.close();

    InputStream in = http.getInputStream();
    BufferedReader read = new BufferedReader(new InputStreamReader(in,
            DEFAULT_CHARSET));
    String valueString = null;
    StringBuffer bufferRes = new StringBuffer();
    while ((valueString = read.readLine()) != null) {
        bufferRes.append(valueString);
    }
    in.close();
    if (http != null) {
        http.disconnect();// 关闭连接
    }
    return bufferRes.toString();
}

scss复制代码List<User> users = http.sync("/users") // 请求数据的链接🔗
        .get()                         // GET请求
        .getBody()                     // 获取响应报文体
        .toList(User.class);           // 得到目标数据

xml复制代码<dependency>
     <groupId>com.ejlchina</groupId>
     <artifactId>okhttps</artifactId>
     <version>3.1.5</version>
</dependency>

ini复制代码HTTP http = HTTP.builder().build();

ini复制代码List<User> users = http.sync("/users") 
        .get()                         
        .getBody()                     
        .toList(User.class);

scss复制代码http.async("/users")               
        .setOnResponse((HttpResult res) -> {
            // 得到目标数据
            User user = res.getBody().toBean(User.class);
        })
        .get();

scss复制代码http.webSocket("/chat") 
        .setOnOpen((WebSocket ws, HttpResult res) -> {
            ws.send("hello world");
        })
        .setOnMessage((WebSocket ws，Message msg) -> {
            // 从服务器接收消息（自动反序列化）
            Chat chat = msg.toBean(Chat.class);
            // 相同的消息发送给服务器（自动序列化 Chat 对象）
            ws.send(chat); 
        })
        .listen();

arduino复制代码struct sentinelState {

    //当前纪元，故障转移使用
    uint64_t current_epoch; 

    // Sentinel监视的主服务器信息 
    // key -> 主服务器名称 
    // value -> 指向sentinelRedisInstance指针
    dict *masters; 
    // ...
} sentinel;

bash复制代码daemonize yes
port 26379
protected-mode no
dir "/usr/local/soft/redis-6.2.4/sentinel-tmp"
sentinel monitor redis-master 192.168.211.104 6379 2
sentinel down-after-milliseconds redis-master 30000
sentinel failover-timeout redis-master 180000
sentinel parallel-syncs redis-master 1

arduino复制代码typedef struct sentinelRedisInstance {

    // 标识值，标识当前实例的类型和状态。如SRI_MASTER、SRI_SLVAE、SRI_SENTINEL
    int flags;

    // 实例名称 主服务器为用户配置实例名称、从服务器和Sentinel为ip:port
    char *name;

    // 服务器运行ID
    char *runid;

    //配置纪元，故障转移使用
    uint64_t config_epoch; 

    // 实例地址
    sentinelAddr *addr;

    // 实例判断为主观下线的时长 sentinel down-after-milliseconds redis-master 30000
    mstime_t down_after_period; 

    // 实例判断为客观下线所需支持的投票数 sentinel monitor redis-master 192.168.211.104 6379 2
    int quorum;

    // 执行故障转移操作时，可以同时对新的主服务器进行同步的从服务器数量 sentinel parallel-syncs redis-master 1
    int parallel-syncs;

    // 刷新故障迁移状态的最大时限 sentinel failover-timeout redis-master 180000
    mstime_t failover_timeout;

    // ...
} sentinelRedisInstance;

erlang复制代码sentinel down-after-milliseconds redis-master 30000

xml复制代码SENTINEL is-master-down-by-addr <ip> <port> <current_epoch> <runid>

xml复制代码SENTINEL is-master-down-by-addr <ip> <port> <current_epoch> <runid>

java复制代码if(!"1".equals(MapUtils.getString(user, "role"))){
    ...
}else{
    ...
}

java复制代码public static final String ADMIN_ROLE = "1";
public static final String _NAME_ = "name";
if(!ADMIN_ROLE.equals(MapUtils.getString(user, _NAME_))){
    ...
}else{
    ...
}

java复制代码public enum CommonCodeEnum{

    // '状态信息(1-未审核，2-已审核，3-审核通过, 4-审核作废)',
    STATUS_INFO_1(1, "未审核"),
    STATUS_INFO_2(2, "已审核"),
    STATUS_INFO_3(3, "审核通过"),
    STATUS_INFO_4(4, "审核作废");

    private int code;
    private String caption;
    ComnCodeEnum(int code, String caption) {
        this.code = code;
        this.caption = caption;
    }
    
    public int code() {
        return code;
    }
    public String caption(){
        return caption;
    }
}

java复制代码if(CommonCodeEnum.STATUS_INFO_1.code().equals(user.getStatus())){
    ...
}else{
    ...
}

sql复制代码-- ----------------------------
-- 创建数据库
-- ----------------------------
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
DROP DATABASE IF EXISTS `testdb`;
CREATE DATABASE `testdb`;
USE `testdb`;

-- ----------------------------
-- 创建 user 表
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `createtime` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- 添加测试数据
-- ----------------------------
INSERT INTO `user` VALUES (1, '赵云', '123456', '2021-09-10 18:11:16');
INSERT INTO `user` VALUES (2, '张飞', '123456', '2021-09-10 18:11:28');
INSERT INTO `user` VALUES (3, '关羽', '123456', '2021-09-10 18:11:34');
INSERT INTO `user` VALUES (4, '刘备', '123456', '2021-09-10 18:11:41');
INSERT INTO `user` VALUES (5, '曹操', '123456', '2021-09-10 18:12:02');

SET FOREIGN_KEY_CHECKS = 1;

java复制代码import com.example.demo.model.User;
import com.example.demo.service.impl.UserServiceImpl;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
class UserControllerTest {

    // 最大循环次数
    private static final int MAXCOUNT = 100000;

    @Autowired
    private UserServiceImpl userService;

    /**
     * 循环单次插入
     */
    @Test
    void save() {
        long stime = System.currentTimeMillis(); // 统计开始时间
        for (int i = 0; i < MAXCOUNT; i++) {
            User user = new User();
            user.setName("test:" + i);
            user.setPassword("123456");
            userService.save(user);
        }
        long etime = System.currentTimeMillis(); // 统计结束时间
        System.out.println("执行时间：" + (etime - stime));
    }
}

xml复制代码<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>mybatis-plus-latest-version</version>
</dependency>

java复制代码import com.example.demo.model.User;
import com.example.demo.service.impl.UserServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.ArrayList;
import java.util.List;

@RestController
@RequestMapping("/u")
public class UserController {

    @Autowired
    private UserServiceImpl userService;

    /**
     * 批量插入（自定义）
     */
    @RequestMapping("/mysavebatch")
    public boolean mySaveBatch(){
        List<User> list = new ArrayList<>();
        // 待添加（用户）数据
        for (int i = 0; i < 1000; i++) {
            User user = new User();
            user.setName("test:"+i);
            user.setPassword("123456");
            list.add(user);
        }
        return userService.saveBatchCustom(list);
    }
}

java复制代码import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.example.demo.mapper.UserMapper;
import com.example.demo.model.User;
import com.example.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;

@Service
public class UserServiceImpl extends ServiceImpl<UserMapper,User>
        implements UserService {

    @Autowired
    private UserMapper userMapper;

    public boolean saveBatchCustom(List<User> list){
        return userMapper.saveBatchCustom(list);
    }
}

java复制代码import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.demo.model.User;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface UserMapper extends BaseMapper<User>{

    boolean saveBatchCustom(List<User> list);
}

java复制代码import com.example.demo.model.User;
import com.example.demo.service.impl.UserServiceImpl;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.ArrayList;
import java.util.List;

@SpringBootTest
class UserControllerTest {

    // 最大循环次数
    private static final int MAXCOUNT = 100000;

    @Autowired
    private UserServiceImpl userService;

    /**
     * MP 批量插入
     */
    @Test
    void saveBatch() {
        long stime = System.currentTimeMillis(); // 统计开始时间
        List<User> list = new ArrayList<>();
        for (int i = 0; i < MAXCOUNT; i++) {
            User user = new User();
            user.setName("test:" + i);
            user.setPassword("123456");
            list.add(user);
        }
        // MP 批量插入
        userService.saveBatch(list);
        long etime = System.currentTimeMillis(); // 统计结束时间
        System.out.println("执行时间：" + (etime - stime));
    }
}

java复制代码import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.example.demo.mapper.UserMapper;
import com.example.demo.model.User;
import com.example.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User>
        implements UserService {

    @Autowired
    private UserMapper userMapper;

    public boolean saveBatchByNative(List<User> list) {
        return userMapper.saveBatchByNative(list);
    }

}

java复制代码import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.demo.model.User;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface UserMapper extends BaseMapper<User> {

    boolean saveBatchByNative(List<User> list);
}

java复制代码<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.demo.mapper.UserMapper">
    <insert id="saveBatchByNative">
        INSERT INTO `USER`(`NAME`,`PASSWORD`) VALUES
        <foreach collection="list" separator="," item="item">
            (#{item.name},#{item.password})
        </foreach>
    </insert>

</mapper>

java复制代码import com.example.demo.model.User;
import com.example.demo.service.impl.UserServiceImpl;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.ArrayList;
import java.util.List;

@SpringBootTest
class UserControllerTest {

    // 最大循环次数
    private static final int MAXCOUNT = 100000;

    @Autowired
    private UserServiceImpl userService;
    
    /**
     * 原生自己拼接 SQL，批量插入
     */
    @Test
    void saveBatchByNative() {
        long stime = System.currentTimeMillis(); // 统计开始时间
        List<User> list = new ArrayList<>();
        for (int i = 0; i < MAXCOUNT; i++) {
            User user = new User();
            user.setName("test:" + i);
            user.setPassword("123456");
            list.add(user);
        }
        // 批量插入
        userService.saveBatchByNative(list);
        long etime = System.currentTimeMillis(); // 统计结束时间
        System.out.println("执行时间：" + (etime - stime));
    }
}

sql复制代码-- 设置最大执行 SQL 为 10M
set global max_allowed_packet=10*1024*1024;

url复制代码https://sales.jetbrains.com/hc/zh-cn/articles/207154369-学生授权申请方式

url复制代码https://www.jetbrains.com/community/education/#students

url复制代码https://www.jetbrains.com/zh-cn/community/opensource/#support