利用POI解析excel并存入数据库demo

[{"title":"（ 67 个子文件 23.72MB ） 利用POI解析excel并存入数据库demo","children":[{"title":"Excel2DB","children":[{"title":".git","children":[{"title":"objects","children":[{"title":"pack","children":[{"title":"pack-b58ede7cee3d468e6093343cc14b515a08941fdc.idx <span style='color:#111;'> 1.13KB </span>","children":null,"spread":false},{"title":"pack-b58ede7cee3d468e6093343cc14b515a08941fdc.pack <span style='color:#111;'> 373B </span>","children":null,"spread":false}],"spread":true},{"title":"2d","children":[{"title":"131c1510ca9f1ee87fa32984a72668dfe95d8d <span style='color:#111;'> 59B </span>","children":null,"spread":false}],"spread":true},{"title":"eb","children":[{"title":"4eb9011d21a43c27447cf907f830232c7205a4 <span style='color:#111;'> 56B </span>","children":null,"spread":false}],"spread":true},{"title":"info","children":null,"spread":false},{"title":"9e","children":[{"title":"78df72a67f8e97afb12afc2742c671ab1e9705 <span style='color:#111;'> 261B </span>","children":null,"spread":false}],"spread":true},{"title":"57","children":[{"title":"b05e2daeb01d61e2a5bcb99cebdbd385ecdd88 <span style='color:#111;'> 50B </span>","children":null,"spread":false}],"spread":true},{"title":"b0","children":[{"title":"e8ddf324e55225ef4084dcc6ac86b370418a0f <span style='color:#111;'> 702B </span>","children":null,"spread":false}],"spread":true},{"title":"93","children":[{"title":"cd42577de28559fbd9a19d4545ce97cbff1859 <span style='color:#111;'> 54B </span>","children":null,"spread":false}],"spread":true},{"title":"68","children":[{"title":"086e8d78d1f35e808ed313ae11567856083a22 <span style='color:#111;'> 1.32MB </span>","children":null,"spread":false}],"spread":true},{"title":"2e","children":[{"title":"9b3e7d13e64704f960123d3bc4ab8f81e64319 <span style='color:#111;'> 4.42MB </span>","children":null,"spread":false}],"spread":true},{"title":"83","children":[{"title":"8bd9d69424290f7e947b867a3b4381e756dad8 <span style='color:#111;'> 209B </span>","children":null,"spread":false}],"spread":true},{"title":"cf","children":[{"title":"ccbcb871fabe84fdb12d981f6983583f2a92e4 <span style='color:#111;'> 60B </span>","children":null,"spread":false}],"spread":false},{"title":"3c","children":[{"title":"b861e88842241bb61207caae532d4fc27e25af <span style='color:#111;'> 242B </span>","children":null,"spread":false},{"title":"24a0a57bd713992a28253f8e22dbdf5c6fe961 <span style='color:#111;'> 56B </span>","children":null,"spread":false}],"spread":false},{"title":"f5","children":[{"title":"cd0aa13b6a6a7571932714726f32e3a1b211f0 <span style='color:#111;'> 117B </span>","children":null,"spread":false}],"spread":false},{"title":"6a","children":[{"title":"1499788b70a4d876a8a46b12154bd8178b54e0 <span style='color:#111;'> 207B </span>","children":null,"spread":false}],"spread":false},{"title":"b4","children":[{"title":"3f7d8a1fc4b9e37b25df9d9fd922f3bdd93f6c <span style='color:#111;'> 257B </span>","children":null,"spread":false}],"spread":false},{"title":"d1","children":[{"title":"b66271f5e379403207383db4ff6e4b9c4e24dd <span style='color:#111;'> 2.22MB </span>","children":null,"spread":false}],"spread":false},{"title":"52","children":[{"title":"a104748b5c8dd1c7fe7d7911c51431d71d31e4 <span style='color:#111;'> 305B </span>","children":null,"spread":false}],"spread":false},{"title":"2f","children":[{"title":"2e32d51be8f2a3a97e64ef38a1864e97dc4645 <span style='color:#111;'> 928.74KB </span>","children":null,"spread":false}],"spread":false},{"title":"ae","children":[{"title":"3c1726048cd06b9a143e0376ed46dd9b9a8d53 <span style='color:#111;'> 21B </span>","children":null,"spread":false}],"spread":false},{"title":"a9","children":[{"title":"add3ab7f0802e60c94481cac40abb4642f2a1c <span style='color:#111;'> 165B </span>","children":null,"spread":false}],"spread":false},{"title":"35","children":[{"title":"3ce765c2f7e35a7a7813e72d3a190b2bbbbb1d <span style='color:#111;'> 2.35MB </span>","children":null,"spread":false}],"spread":false},{"title":"62","children":[{"title":"477141a205638281aa772a0881a6f9c8d87302 <span style='color:#111;'> 6.09KB </span>","children":null,"spread":false}],"spread":false},{"title":"f1","children":[{"title":"a17ace3b50926fdc3b5cb16a07e526f9d7cf3e <span style='color:#111;'> 977B </span>","children":null,"spread":false}],"spread":false},{"title":"16","children":[{"title":"241a4b092d7cb48cef25bd9b1f43516c0aafa5 <span style='color:#111;'> 358B </span>","children":null,"spread":false}],"spread":false},{"title":"87","children":[{"title":"b6cf524b95ce0269c6dd1891c1e0145c8ff09e <span style='color:#111;'> 45B </span>","children":null,"spread":false}],"spread":false},{"title":"ff","children":[{"title":"da74c595cf1e7a893ae0479f9feda92263a019 <span style='color:#111;'> 167B </span>","children":null,"spread":false}],"spread":false},{"title":"dd","children":[{"title":"25d9ef3019ab2eb1fa11328151a109754e1281 <span style='color:#111;'> 289B </span>","children":null,"spread":false}],"spread":false},{"title":"43","children":[{"title":"9d63f3c7de411302a26d2cec7be7709a7883ac <span style='color:#111;'> 71B </span>","children":null,"spread":false},{"title":"a9413b930b0f474efd2817c195ef2a88d7f7b2 <span style='color:#111;'> 645.86KB </span>","children":null,"spread":false}],"spread":false},{"title":"03","children":[{"title":"7168d6f1fa6a19707d07c923e46fb7ed47a0bb <span style='color:#111;'> 436B </span>","children":null,"spread":false}],"spread":false},{"title":"3b","children":[{"title":"63a1d7a3e498594bb44ba8714b3eb3ad55ea81 <span style='color:#111;'> 50B </span>","children":null,"spread":false}],"spread":false},{"title":"10","children":[{"title":"b7ac80c7c0bddab2c463909fdfef5095c8b78e <span style='color:#111;'> 94B </span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"HEAD <span style='color:#111;'> 23B </span>","children":null,"spread":false},{"title":"branches","children":null,"spread":false},{"title":"config <span style='color:#111;'> 270B </span>","children":null,"spread":false},{"title":"index <span style='color:#111;'> 1.78KB </span>","children":null,"spread":false},{"title":"refs","children":[{"title":"tags","children":null,"spread":false},{"title":"remotes","children":[{"title":"origin","children":[{"title":"master <span style='color:#111;'> 41B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"heads","children":[{"title":"master <span style='color:#111;'> 41B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"COMMIT_EDITMSG <span style='color:#111;'> 16B </span>","children":null,"spread":false},{"title":"hooks","children":null,"spread":false},{"title":"FETCH_HEAD <span style='color:#111;'> 115B </span>","children":null,"spread":false},{"title":"logs","children":[{"title":"HEAD <span style='color:#111;'> 534B </span>","children":null,"spread":false},{"title":"refs","children":[{"title":"remotes","children":[{"title":"origin","children":[{"title":"master <span style='color:#111;'> 147B </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"heads","children":[{"title":"master <span style='color:#111;'> 534B </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"README.md <span style='color:#111;'> 70B </span>","children":null,"spread":false},{"title":"Excel2DB","children":[{"title":".gitignore <span style='color:#111;'> 6B </span>","children":null,"spread":false},{"title":"src","children":[{"title":"com","children":[{"title":"harryper","children":[{"title":"domain","children":[{"title":"PersonInfo.java <span style='color:#111;'> 835B </span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"DBUtil.java <span style='color:#111;'> 1.38KB </span>","children":null,"spread":false}],"spread":true},{"title":"excel","children":[{"title":"ExcelRead.java <span style='color:#111;'> 2.21KB </span>","children":null,"spread":false}],"spread":true},{"title":"service","children":[{"title":"Operate.java <span style='color:#111;'> 560B </span>","children":null,"spread":false}],"spread":true},{"title":"test","children":[{"title":"Test.java <span style='color:#111;'> 390B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"bin","children":[{"title":"com","children":[{"title":"harryper","children":[{"title":"domain","children":[{"title":"PersonInfo.class <span style='color:#111;'> 1.54KB </span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"DBUtil.class <span style='color:#111;'> 2.19KB </span>","children":null,"spread":false}],"spread":true},{"title":"excel","children":[{"title":"ExcelRead.class <span style='color:#111;'> 3.08KB </span>","children":null,"spread":false}],"spread":true},{"title":"service","children":[{"title":"Operate.class <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false}],"spread":true},{"title":"test","children":[{"title":"Test.class <span style='color:#111;'> 801B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"resource","children":[{"title":"excel.sql <span style='color:#111;'> 897B </span>","children":null,"spread":false},{"title":"person_info.xlsx <span style='color:#111;'> 8.69KB </span>","children":null,"spread":false}],"spread":true},{"title":".classpath <span style='color:#111;'> 696B </span>","children":null,"spread":false},{"title":".settings","children":[{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 598B </span>","children":null,"spread":false}],"spread":true},{"title":".project <span style='color:#111;'> 384B </span>","children":null,"spread":false},{"title":"lib","children":[{"title":"poi-ooxml-3.17.jar <span style='color:#111;'> 1.41MB </span>","children":null,"spread":false},{"title":"poi-ooxml-schemas-3.17.jar <span style='color:#111;'> 5.65MB </span>","children":null,"spread":false},{"title":"xmlbeans-2.6.0.jar <span style='color:#111;'> 2.60MB </span>","children":null,"spread":false},{"title":"mysql-connector-java-5.1.44-bin.jar <span style='color:#111;'> 976.21KB </span>","children":null,"spread":false},{"title":"commons-collections4-4.1.jar <span style='color:#111;'> 733.63KB </span>","children":null,"spread":false},{"title":"poi-3.17.jar <span style='color:#111;'> 2.58MB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}]