Java解析Excel：批量导入产品数据的实用方法

public void bacthSaveProduct(ProductBean productBean) throws IOException {
List<Category> categoryList = (List<Category>)ServiceFacade.getCategoryService()
.findCategoryList(Dictionary.COMMAND_PRODUCT_TYPE);
List<Brand> brandList = ServiceFacade.getBrandService().findBrandList();
InputStream in = new FileInputStream(productBean.getBatchFile());
Workbook wb;
try {
wb = Workbook.getWorkbook(in);
Sheet s = wb.getSheet(0);// 第1个sheet
Cell c = null;
int row = s.getRows();// 总行数
int col = s.getColumns();// 总列数
for (int i = 1; i < row; i++) {
if (i > 1) {
productBean = new ProductBean();
productBean.getProperties().setCount("0");
}
Product product = new Product();
List<String> productNameList = productDAO.findBySql(
"select product_name from t_product where product_name in('"
+ s.getCell(0, i).getContents() + "')", null);
if (!s.getCell(0, i).getContents().equals(
s.getCell(0, i - 1).getContents())) {
product.setProductName(s.getCell(0, i).getContents());
product.setPrice(Double.parseDouble(s.getCell(1, i)
.getContents()));
product.setHigPrice(Double.parseDouble(s.getCell(2, i)
.getContents()));
product.setProperty(s.getCell(3, i).getContents());
product.setSize(s.getCell(4, i).getContents());

product.setAnnex(s.getCell(5, i).getContents());
product.setDescription(s.getCell(6, i).getContents());
product.setColor(s.getCell(7, i).getContents());
// 上传缩略图片
if (StringUtil.isNotEmpty(s.getCell(8, i).getContents())) {
File smallFile = new File(s.getCell(8, i).getContents());
productBean.setUploadSmallImage(smallFile);
productBean.setUploadSmallImageFileName(smallFile
.getName());
String fileType = smallFile.getName().substring(
(smallFile.getName().indexOf(".")));
productBean.setUploadSmallImageContentType(fileType);
}
/** 上传相册 **/
// 形象图
if (StringUtil.isNotEmpty(s.getCell(9, i).getContents())) {
File faceFile = new File(s.getCell(9, i).getContents());
productBean.setUploadFaceImage(faceFile);
productBean.setUploadFaceImageFileName(faceFile
.getName());
String ffiletype = faceFile.getName().substring(
faceFile.getName().indexOf("."));
productBean.setUploadFaceImageContentType(ffiletype);
}
// 正面图
if (StringUtil.isNotEmpty(s.getCell(10, i).getContents())) {
File backFile = new File(s.getCell(10, i).getContents());
productBean.setUploadBackImage(backFile);
productBean.setUploadBackImageFileName(backFile
.getName());