Description: java implementation into excel to the database. 1 can be configured in the configuration file upload path. 2 support merged cells. 3 using common_dbutils connect to the database. 4 using jxl excel to realize the operation. 5 attached excel template.
To Search:
File list (Check if you may need any files):
TestImportExcel\.classpath
...............\.project
...............\.settings\org.eclipse.core.resources.prefs
...............\bin\com\bo\DbUtil.class
...............\...\...\..\IProjectExcel.class
...............\...\...\..\ProjectBean.class
...............\...\...\..Impl\ProjectExcelImpl.class
...............\...\...\controller\Controller.class
...............\...\...\test\TestMain.class
...............\...\config.properties
...............\src\com\bo\DbUtil.java
...............\...\...\..\IProjectExcel.java
...............\...\...\..\ProjectBean.java
...............\...\...\..Impl\ProjectExcelImpl.java
...............\...\...\controller\Controller.java
...............\...\...\test\TestMain.java
...............\...\config.properties
...............\...\readMe.txt
...............\...\testTemplet.xls
...............\所需jar包\commons-dbutils-1.3.jar
...............\.........\commons-lang-2.6.jar
...............\.........\jxl.jar
...............\.........\mysql-connector-java-5.1.17-bin.jar
...............\bin\com\bo
...............\...\...\boImpl
...............\...\...\controller
...............\...\...\test
...............\src\com\bo
...............\...\...\boImpl
...............\...\...\controller
...............\...\...\test
...............\bin\com
...............\src\com
...............\.settings
...............\bin
...............\src
...............\所需jar包
TestImportExcel
Download