\u6700\u8fd1\u597d\u5947\u505a\u4e86\u4e00\u4e2a\u6d4b\u8bd5\uff0c\u4f7f\u7528spring + mybatis \u5bf9mysql\u63d2\u5165\u767e\u6761\u6570\u636e\u3002
\n\u7b2c\u4e00\u79cd\uff0c\u901a\u8fc7\u8c03\u7528service\u4e00\u6761\u4e00\u6761\u63d2\u5165\uff0c\u51fa\u9519\u6ca1\u6709\u56de\u6eda\u3002
\n\u7ed3\u679c\u8017\u65f6\u975e\u5e38\u957f\uff0c\u8fd9\u4e5f\u662f\u5f88\u6b63\u5e38\u7684\u3002
\n\u7b2c\u4e8c\u79cd\uff0c\u5728100w\u6761sql\u8dd1\u5728\u540c\u4e00\u4e2a\u4e8b\u7269\u4e2d\uff0c\u597d\u5904\u5c31\u662f\u8fd9\u4e00\u767e\u4e07\u6761\u6570\u636e\u662f\u539f\u5b50\u6027\u7684\u3002\u7edf\u4e00\u6210\u529f\u6216\u8005\u5931\u8d25\u3002
\n\u6570\u636e\u751f\u6210\u4ee3\u7801<\/p>\n
\r\n List<Log> logs = new ArrayList<Log>(100_0000);\r\n\t\tfor (int i = 0; i < 100_0000; i++) {\r\n\t\t\tLog log = new Log();\r\n\t\t\tlog.setAddress(Math.random()+"");\r\n\t\t\tlog.setJingdu(Math.random()*100);\r\n\t\t\tlog.setWeidu(Math.random()*100);\r\n\t\t\tlog.setTokenId(UUID.randomUUID().toString().split("-")[0]);\r\n\t\t\tlog.setSignDate(new Date());\r\n\t\t\tlogs.add(log);\r\n\t\t}\r\n<\/pre>\n\u6279\u91cf\u63d2\u5165\u4ee3\u7801<\/p>\n
\r\n public void insert(Iterable<Log> logs) {\r\n\t\tfor (Log l : logs) {\r\n\t\t\tbaseDao.insert(l);\r\n\t\t}\r\n\t\t\r\n\t}\r\n<\/pre>\n\u7ed3\u679c\uff1a\u767e\u4e07\u6b21\uff0c\u5341\u6b21\u6d4b\u8bd5[679, 703, 620, 564, 698, 700, 678, 686, 711, 619]\u5355\u4f4d\u79d2
\n\u7b2c\u4e09\u79cd \u62fc\u63a5sql. insert into … values (…),(…),(….)
\n\u8fd9\u79cd\u65b9\u5f0f\u76f4\u63a5\u5361\u6b7b\u3002
\n\u7b2c\u56db\u79cd batch update<\/p>\n
\r\n@Override\r\n\tpublic void addBatch(final List<Log> item) {\r\n\t\tString sql = "insert into log (id, token_id, sign_date,jingdu, weidu, address)values (null,?,?,?,?, ?)";\r\n\t\tJdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);\r\n\t\tjdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() { \r\n \/\/ \u4e3aprepared statement\u8bbe\u7f6e\u53c2\u6570\u3002\u8fd9\u4e2a\u65b9\u6cd5\u5c06\u5728\u6574\u4e2a\u8fc7\u7a0b\u4e2d\u88ab\u8c03\u7528\u7684\u6b21\u6570 \r\n public void setValues(PreparedStatement pst, int i) \r\n throws SQLException { \r\n \tLog log = item.get(i);\r\n pst.setString(1, log.getTokenId()); \r\n pst.setDate(2,new java.sql.Date(log.getSignDate().getTime()) );\r\n pst.setDouble(3, log.getJingdu());\r\n pst.setDouble(4, log.getWeidu());\r\n pst.setString(5, log.getAddress()); \r\n } \r\n \r\n \/\/ \u8fd4\u56de\u66f4\u65b0\u7684\u7ed3\u679c\u96c6\u6761\u6570 \r\n public int getBatchSize() { \r\n return item.size(); \r\n } \t\r\n }); \r\n\t}\r\n<\/pre>\n\u7ed3\u679c[211, 216, 243, 234, 235, 238, 237, 224, 222, 226]\u79d2
\n\u76ee\u524d\u6765\u770b\u8fd8\u662fbatchUpdate\u7684\u6548\u7387\u6700\u9ad8\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6700\u8fd1\u597d\u5947\u505a\u4e86\u4e00\u4e2a\u6d4b\u8bd5\uff0c\u4f7f\u7528spring + mybatis \u5bf9mysql\u63d2\u5165\u767e\u6761\u6570\u636e\u3002 \u7b2c\u4e00\u79cd\uff0c\u901a\u8fc7\u8c03\u7528ser… Continue reading