利用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}]