{"id":2261,"date":"2023-06-27T15:33:03","date_gmt":"2023-06-27T07:33:03","guid":{"rendered":"https:\/\/xinchewhd.com.cn\/?p=2261"},"modified":"2023-06-27T15:33:03","modified_gmt":"2023-06-27T07:33:03","slug":"mysql%e4%bc%98%e5%8c%96%ef%bc%9a%e6%89%b9%e9%87%8f%e6%8f%92%e5%85%a5%e5%a4%a7%e6%95%b0%e6%8d%ae4%e7%a7%8d%e5%ae%9e%e7%94%a8%e3%80%81%e8%ae%b2%e7%a9%b6%e6%96%b9%e6%a1%88%e7%9a%84%e6%b5%8b%e8%af%95","status":"publish","type":"post","link":"https:\/\/xinchewhd.com.cn\/index.php\/mysql\/mysql%e4%bc%98%e5%8c%96%ef%bc%9a%e6%89%b9%e9%87%8f%e6%8f%92%e5%85%a5%e5%a4%a7%e6%95%b0%e6%8d%ae4%e7%a7%8d%e5%ae%9e%e7%94%a8%e3%80%81%e8%ae%b2%e7%a9%b6%e6%96%b9%e6%a1%88%e7%9a%84%e6%b5%8b%e8%af%95\/","title":{"rendered":"MySQL\u4f18\u5316\uff1a\u6279\u91cf\u63d2\u5165\u5927\u6570\u636e4\u79cd\u5b9e\u7528\u3001\u8bb2\u7a76\u65b9\u6848\u7684\u6d4b\u8bd5"},"content":{"rendered":"
\n
<\/mp-common-profile><\/section>\n
\n

\u672c\u6587\u8bb0\u5f55\u4e2a\u4eba\u4f7f\u7528MySQL\u63d2\u5165\u5927\u6570\u636e\u603b\u7ed3\u8f83\u5b9e\u7528\u7684\u65b9\u6848\uff0c\u901a\u8fc7\u5bf9\u5e38\u7528\u63d2\u5165\u5927\u6570\u636e\u76844\u79cd\u65b9\u5f0f\u8fdb\u884c\u6d4b\u8bd5\uff0c\u5373for\u5faa\u73af\u5355\u6761\u3001\u62fc\u63a5SQL\u3001\u6279\u91cf\u63d2\u5165saveBatch()\u3001\u5faa\u73af + \u5f00\u542f\u6279\u5904\u7406\u6a21\u5f0f\uff0c\u5f97\u51fa\u6bd4\u8f83\u5b9e\u7528\u7684\u65b9\u6848\u5fc3\u5f97\u3002<\/p>\n

\n

\u4e2a\u4eba\u8bb0\u5f55\u5b66\u4e60\u7b14\u8bb0\u5185\u5bb9\uff0c\u82e5\u6587\u4e2d\u51fa\u73b0\u8003\u8651\u4e0d\u5468\u3001\u7406\u89e3\u9519\u8bef\u7b49\u60c5\u51b5\uff0c\u8bf7\u591a\u6307\u51fa\uff0c\u5171\u540c\u5b66\u4e60\uff01\uff01\uff01<\/p>\n<\/blockquote>\n

\u4e00\u3001\u524d\u8a00<\/h2>\n

\u6700\u8fd1\u8d81\u7a7a\u95f2\u4e4b\u4f59\uff0c\u5728\u5bf9MySQL\u6570\u636e\u5e93\u8fdb\u884c\u63d2\u5165\u6570\u636e\u6d4b\u8bd5\uff0c\u5bf9\u4e8e\u5982\u4f55\u5feb\u901f\u63d2\u5165\u6570\u636e\u7684\u64cd\u4f5c\u65e0\u4ece\u4e0b\u624b\uff0c\u5728\u4ec51W\u6570\u636e\u91cf\u7684\u60c5\u51b5\u4e0b\uff0c\u7adf\u82b1\u8d39\u63a5\u8fd147s\uff0c\u5b9e\u5728\u4e0d\u5fcd\u76f4\u89c6\uff01\u5728\u4e0d\u65ad\u6478\u7d22\u4e4b\u540e\uff0c\u6574\u7406\u51fa\u4e00\u4e9b\u8f83\u5b9e\u7528\u7684\u65b9\u6848\u3002<\/p>\n

\u4e8c\u3001\u51c6\u5907\u5de5\u4f5c<\/h2>\n

\u6d4b\u8bd5\u73af\u5883\uff1aSpringBoot\u9879\u76ee\u3001MyBatis-Plus\u6846\u67b6\u3001MySQL8.0.24\u3001JDK13<\/p>\n

\u524d\u63d0\uff1aSpringBoot\u9879\u76ee\u96c6\u6210MyBatis-Plus\u4e0a\u8ff0\u6587\u7ae0\u6709\u914d\u7f6e\u8fc7\u7a0b\uff0c\u540c\u65f6\u5b9e\u73b0IService\u63a5\u53e3\u7528\u4e8e\u8fdb\u884c\u6279\u91cf\u63d2\u5165\u6570\u636e\u64cd\u4f5csaveBatch()<\/code>\u65b9\u6cd5<\/p>\n

1\u3001Maven\u9879\u76ee\u4e2dpom.xml\u6587\u4ef6\u5f15\u5165\u7684\u76f8\u5173\u4f9d\u8d56\u5982\u4e0b<\/p>\n

<\/span> <dependencies<\/span>><\/span>
 
  <!-- SpringBoot Web\u6a21\u5757\u4f9d\u8d56 --><\/span>
  <dependency<\/span>><\/span>
   <groupId<\/span>><\/span>org.springframework.boot<\/groupId<\/span>><\/span>
   <artifactId<\/span>><\/span>spring-boot-starter-web<\/artifactId<\/span>><\/span>
  <\/dependency<\/span>><\/span>
 
  <!-- MyBatis-Plus \u4f9d\u8d56 --><\/span>
  <dependency<\/span>><\/span>
   <groupId<\/span>><\/span>com.baomidou<\/groupId<\/span>><\/span>
   <artifactId<\/span>><\/span>mybatis-plus-boot-starter<\/artifactId<\/span>><\/span>
   <version<\/span>><\/span>3.3.1<\/version<\/span>><\/span>
  <\/dependency<\/span>><\/span>
 
  <!-- \u6570\u636e\u5e93\u8fde\u63a5\u9a71\u52a8 --><\/span>
  <dependency<\/span>><\/span>
   <groupId<\/span>><\/span>mysql<\/groupId<\/span>><\/span>
   <artifactId<\/span>><\/span>mysql-connector-java<\/artifactId<\/span>><\/span>
  <\/dependency<\/span>><\/span>
  
  <!-- \u4f7f\u7528\u6ce8\u89e3\uff0c\u7b80\u5316\u4ee3\u7801--><\/span>
  <dependency<\/span>><\/span>
   <groupId<\/span>><\/span>org.projectlombok<\/groupId<\/span>><\/span>
   <artifactId<\/span>><\/span>lombok<\/artifactId<\/span>><\/span>
  <\/dependency<\/span>><\/span>
  
 <\/dependencies<\/span>><\/span>
<\/code><\/pre>\n
2\u3001application.yml\u914d\u7f6e\u5c5e\u6027\u6587\u4ef6\u5185\u5bb9\uff08\u91cd\u70b9\uff1a\u5f00\u542f\u6279\u5904\u7406\u6a21\u5f0f\uff09<\/p>\n
<\/span>server:<\/span>
    # \u7aef\u53e3\u53f7 <\/span>
    port:<\/span> 8080<\/span>
 
#  MySQL\u8fde\u63a5\u914d\u7f6e\u4fe1\u606f\uff08\u4ee5\u4e0b\u4ec5\u7b80\u5355\u914d\u7f6e\uff0c\u66f4\u591a\u8bbe\u7f6e\u53ef\u81ea\u884c\u67e5\u770b\uff09<\/span>
spring:<\/span>
    datasource:<\/span>
        #  \u8fde\u63a5\u5730\u5740\uff08\u89e3\u51b3UTF-8\u4e2d\u6587\u4e71\u7801\u95ee\u9898 + \u65f6\u533a\u6821\u6b63\uff09<\/span>
        #         \uff08rewriteBatchedStatements=true \u5f00\u542f\u6279\u5904\u7406\u6a21\u5f0f\uff09<\/span>
        url:<\/span> jdbc:mysql:\/\/127.0.0.1:3306\/bjpowernode?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia\/Shanghai&rewriteBatchedStatements=true<\/span>
        #  \u7528\u6237\u540d<\/span>
        username:<\/span> root<\/span>
        #  \u5bc6\u7801<\/span>
        password:<\/span> xxx<\/span>
        #  \u8fde\u63a5\u9a71\u52a8\u540d\u79f0<\/span>
        driver-class-name:<\/span> com.mysql.cj.jdbc.Driver<\/span>
<\/code><\/pre>\n
3\u3001Entity\u5b9e\u4f53\u7c7b\uff08\u6d4b\u8bd5\uff09<\/p>\n
<\/span>\/**
 *   Student \u6d4b\u8bd5\u5b9e\u4f53\u7c7b
 *   
 *   @Data<\/span>\u6ce8\u89e3\uff1a\u5f15\u5165Lombok\u4f9d\u8d56\uff0c\u53ef\u7701\u7565Setter\u3001Getter\u65b9\u6cd5
 *   @author<\/span> LBF
 *   @date<\/span> 2022\/3\/18 16:06
 *\/<\/span>
@Data<\/span>
@TableName<\/span>(value = \"student\"<\/span>)
public<\/span> class<\/span> Student<\/span> <\/span>{
    
    \/**  \u4e3b\u952e  type:\u81ea\u589e *\/<\/span>
    @TableId<\/span>(type = IdType.AUTO)
    private<\/span> int<\/span> id;
 
    \/**  \u540d\u5b57 *\/<\/span>
    private<\/span> String name;
 
    \/**  \u5e74\u9f84 *\/<\/span>
    private<\/span> int<\/span> age;
 
    \/**  \u5730\u5740 *\/<\/span>
    private<\/span> String addr;
 
    \/**  \u5730\u5740\u53f7  @TableField<\/span>\uff1a\u4e0e\u8868\u5b57\u6bb5\u6620\u5c04 *\/<\/span>
    @TableField<\/span>(value = \"addr_num\"<\/span>)
    private<\/span> String addrNum;
 
    public<\/span> Student<\/span>(String name, int<\/span> age, String addr, String addrNum)<\/span> <\/span>{
        this<\/span>.name = name;
        this<\/span>.age = age;
        this<\/span>.addr = addr;
        this<\/span>.addrNum = addrNum;
    }
}
<\/code><\/pre>\n
4\u3001\u6570\u636e\u5e93student\u8868\u7ed3\u6784\uff08\u6ce8\u610f\uff1a\u65e0\u7d22\u5f15\uff09<\/p>\n