java的excel解析入库_java中解析excel 批量插入数据库

Facade 层 实现类 (@Service("samePeriodModelImportFacade"))

1、获取cells 的方法

public Cells getCells(File file){

Cells cells = null;

License license = new License();

InputStream licenseStream = this.getClass().getResourceAsStream("/aspose.lic");

try{

license.setLicense(licenseStream);

FileInputStream fr = new FileInputStream(file);

Workbook wb = new Workbook(fr);

Worksheet worksheet = wb.getWorksheets().get(0);

cells = worksheet.getCells();

}catch(Exception e){

e.printStackTrace();

}

return cells;

}

2、解析excel 的方法

public String analyExcel(File file){

String dis_no=null;

String dis_mp=null;

List  insertParamList =new ArrayList();

Cells cells = this.getCells( file);

for(int i=1;i

for(int j=0; j<35;j++){        //获取列数   例如35列

String cellsValue = cells.getRows().get(i).get(j).getStringValue();  // 获取的每一个单元格的数据  返回的是String 类型

if(j==0){

dis_no =cellsValue;   //  i=1 j=0

}

if( j==23){

dis_mp=cellsValue;   // i =1 j=23

}

}

insertParamList.add(new Object[] {dis_no,dis_mp});

}

samePeriodModelImportDomainService.insertPspCellModel(insertParamList);

return "success";

}

service层实现类@Repository("samePeriodModelImportDomainService")

//批量插入数据库

public void insertPspCellModel(List insertParamList) {

String sql = "insert into psp_model(dis_no,dis_mp) values(?,?)";

this.getJdbcTemplate().batchUpdate(sql, insertCellParamList);

}

aspose.lic

Aspose.Total for Java

Aspose.Words for Java

Enterprise

20991231

20991231

8bfe198c-7f0c-4ef8-8ff0-acc3237bf0d7

sNLLKGMUdF0r8O1kKilWAGdgfs2BvJb/2Xp8p5iuDVfZXmhppo+d0Ran1P9TKdjV4ABwAgKXxJ3jcQTqE/2IRfqwnPf8itN8aFZlV3TJPYeD3yWE7IT55Gz6EijUpC7aKeoohTb4w2fpox58wWoF3SNp6sK6jDfiAUGEHYJ9pjU=