{"id":5722,"date":"2024-08-01T22:46:59","date_gmt":"2024-08-01T14:46:59","guid":{"rendered":"https:\/\/xinchewhd.com.cn\/?p=5722"},"modified":"2024-08-01T22:46:59","modified_gmt":"2024-08-01T14:46:59","slug":"13-%e7%a7%92%e6%8f%92%e5%85%a5-30-%e4%b8%87%e6%9d%a1%e6%95%b0%e6%8d%ae%ef%bc%8c%e8%bf%99%e6%89%8d%e6%98%af%e6%89%b9%e9%87%8f%e6%8f%92%e5%85%a5%e6%ad%a3%e7%a1%ae%e7%9a%84%e5%a7%bf%e5%8a%bf%ef%bc%81","status":"publish","type":"post","link":"https:\/\/xinchewhd.com.cn\/index.php\/spring-boot\/13-%e7%a7%92%e6%8f%92%e5%85%a5-30-%e4%b8%87%e6%9d%a1%e6%95%b0%e6%8d%ae%ef%bc%8c%e8%bf%99%e6%89%8d%e6%98%af%e6%89%b9%e9%87%8f%e6%8f%92%e5%85%a5%e6%ad%a3%e7%a1%ae%e7%9a%84%e5%a7%bf%e5%8a%bf%ef%bc%81\/","title":{"rendered":"13 \u79d2\u63d2\u5165 30 \u4e07\u6761\u6570\u636e\uff0c\u8fd9\u624d\u662f\u6279\u91cf\u63d2\u5165\u6b63\u786e\u7684\u59ff\u52bf\uff01"},"content":{"rendered":"
\n
\n

<\/span><\/span>\u672c\u6587\u4e3b\u8981\u8bb2\u8ff0\u901a\u8fc7MyBatis\u3001JDBC\u7b49\u505a\u5927\u6570\u636e\u91cf\u6570\u636e\u63d2\u5165\u7684\u6848\u4f8b\u548c\u7ed3\u679c\u3002<\/span><\/p>\n

30\u4e07\u6761\u6570\u636e\u63d2\u5165\u63d2\u5165\u6570\u636e\u5e93\u9a8c\u8bc1<\/span><\/h2>\n
    \n
  • \n
    \n

    \u5b9e\u4f53\u7c7b\u3001mapper\u548c\u914d\u7f6e\u6587\u4ef6\u5b9a\u4e49<\/p>\n<\/section>\n<\/li>\n

  • \n
    <\/section>\n<\/li>\n
      \n
    • \n
      User\u5b9e\u4f53<\/section>\n<\/li>\n
    • \n
      mapper\u63a5\u53e3<\/section>\n<\/li>\n
    • \n
      mapper.xml\u6587\u4ef6<\/section>\n<\/li>\n
    • \n
      jdbc.properties<\/section>\n<\/li>\n
    • \n
      sqlMapConfig.xml<\/section>\n<\/li>\n<\/ul>\n
    • \n
      \n

      \u4e0d\u5206\u6279\u6b21\u76f4\u63a5\u68ad\u54c8<\/p>\n<\/section>\n<\/li>\n

    • \n
      \n

      \u5faa\u73af\u9010\u6761\u63d2\u5165<\/p>\n<\/section>\n<\/li>\n

    • \n
      \n

      MyBatis\u5b9e\u73b0\u63d2\u516530\u4e07\u6761\u6570\u636e<\/p>\n<\/section>\n<\/li>\n

    • \n
      \n

      JDBC\u5b9e\u73b0\u63d2\u516530\u4e07\u6761\u6570\u636e<\/p>\n<\/section>\n<\/li>\n

    • \n
      \n

      \u603b\u7ed3<\/p>\n<\/section>\n<\/li>\n<\/ul>\n

      \u9a8c\u8bc1\u7684\u6570\u636e\u5e93\u8868\u7ed3\u6784\u5982\u4e0b\uff1a<\/p>\n

      CREATETABLE`t_user`(`id`int(11)NOTNULLAUTO_INCREMENTCOMMENT'\u7528\u6237id'<\/span>,`username`varchar(64)DEFAULTNULLCOMMENT'\u7528\u6237\u540d\u79f0'<\/span>,`age`int(4)DEFAULTNULLCOMMENT'\u5e74\u9f84'<\/span>,PRIMARYKEY(`id`))ENGINE=InnoDBDEFAULTCHARSET=utf8COMMENT='\u7528\u6237\u4fe1\u606f\u8868'<\/span>;<\/code><\/pre>\n
      \u8bdd\u4e0d\u591a\u8bf4\uff0c\u5f00\u6574\uff01<\/p>\n
      \u5b9e\u4f53\u7c7b\u3001mapper\u548c\u914d\u7f6e\u6587\u4ef6\u5b9a\u4e49<\/span><\/h3>\n
      User\u5b9e\u4f53<\/p>\n
      \/***<p>\u7528\u6237\u5b9e\u4f53<\/p>**@Authorzjq*\/@DatapublicclassUser{privateintid;privateStringusername;privateintage;}<\/code><\/pre>\n
      mapper\u63a5\u53e3<\/p>\n
      publicinterfaceUserMapper{\/***\u6279\u91cf\u63d2\u5165\u7528\u6237*@paramuserList*\/voidbatchInsertUser(@Param(\"list\"<\/span>)List<User>userList);}<\/code><\/pre>\n
      mapper.xml\u6587\u4ef6<\/p>\n
      <!--\u6279\u91cf\u63d2\u5165\u7528\u6237\u4fe1\u606f--><insertid=\"batchInsertUser\"<\/span>parameterType=\"java.util.List\"<\/span>>insertintot_user(username,age)values<foreachcollection=\"list\"<\/span>item=\"item\"<\/span>index=\"index\"<\/span>separator=\",\"<\/span>>(#{item.username},<\/span>#{item.age}<\/span>)<\/foreach><\/insert><\/code><\/pre>\n
      jdbc.properties<\/p>\n
      jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql:\/\/localhost:3306\/test<\/span>jdbc.username=rootjdbc.password=root<\/code><\/pre>\n
      sqlMapConfig.xml<\/p>\n
      <?xmlversion=\"1.0\"<\/span>encoding=\"UTF-8\"<\/span>?><!DOCTYPEconfigurationPUBLIC\"-\/\/mybatis.org\/\/DTDConfig3.0\/\/EN\"<\/span>\"http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd\"<\/span>><configuration><!--\u901a\u8fc7properties\u6807\u7b7e\u52a0\u8f7d\u5916\u90e8properties\u6587\u4ef6--><propertiesresource=\"jdbc.properties\"<\/span>><\/properties><!--\u81ea\u5b9a\u4e49\u522b\u540d--><typeAliases><typeAliastype<\/span>=\"com.zjq.domain.User\"<\/span>alias<\/span>=\"user\"<\/span>><\/typeAlias><\/typeAliases><!--\u6570\u636e\u6e90\u73af\u5883--><environmentsdefault=\"developement\"<\/span>><environmentid=\"developement\"<\/span>><transactionManagertype<\/span>=\"JDBC\"<\/span>><\/transactionManager><dataSourcetype<\/span>=\"POOLED\"<\/span>><propertyname=\"driver\"<\/span>value=\"${jdbc.driver}<\/span>\"<\/span>\/><propertyname=\"url\"<\/span>value=\"${jdbc.url}<\/span>\"<\/span>\/><propertyname=\"username\"<\/span>value=\"${jdbc.username}<\/span>\"<\/span>\/><propertyname=\"password\"<\/span>value=\"${jdbc.password}<\/span>\"<\/span>\/><\/dataSource><\/environment><\/environments><!--\u52a0\u8f7d\u6620\u5c04\u6587\u4ef6--><mappers><mapperresource=\"com\/zjq\/mapper\/UserMapper.xml\"<\/span>><\/mapper><\/mappers><\/configuration><\/code><\/pre>\n
      \u4e0d\u5206\u6279\u6b21\u76f4\u63a5\u68ad\u54c8<\/span><\/h3>\n
      MyBatis\u76f4\u63a5\u4e00\u6b21\u6027\u6279\u91cf\u63d2\u516530\u4e07\u6761\uff0c\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n
      @TestpublicvoidtestBatchInsertUser()throwsIOException{InputStreamresourceAsStream=Resources.getResourceAsStream(\"sqlMapConfig.xml\"<\/span>);SqlSessionFactorysqlSessionFactory=newSqlSessionFactoryBuilder().build(resourceAsStream);SqlSessionsession=sqlSessionFactory.openSession();System.out.println(\"=====\u5f00\u59cb\u63d2\u5165\u6570\u636e=====\"<\/span>);longstartTime=System.currentTimeMillis();try{List<User>userList=newArrayList<>();for<\/span>(inti=1;i<=300000;i++){Useruser=newUser();user.setId(i);user.setUsername(\"\u5171\u996e\u4e00\u676f\u65e0\"<\/span>+i);user.setAge((int)(Math.random()*100));userList.add(user);}session.insert(\"batchInsertUser\"<\/span>,userList);\/\/\u6700\u540e\u63d2\u5165\u5269\u4f59\u7684\u6570\u636esession.commit();longspendTime=System.currentTimeMillis()-startTime;System.out.println(\"\u6210\u529f\u63d2\u5165 30\u4e07\u6761\u6570\u636e,\u8017\u65f6\uff1a\"<\/span>+spendTime+\"\u6beb\u79d2\"<\/span>);}finally{session.close();}}<\/code><\/pre>\n
      \u53ef\u4ee5\u770b\u5230\u63a7\u5236\u53f0\u8f93\u51fa\uff1a<\/p>\n
      \n
      Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (27759038 >yun 4194304). You can change this value on the server by setting the max_allowed_packet\u2019 variable.<\/p>\n<\/blockquote>\n