EOS从Excel表中数据导入到数据库的运算逻辑

@Bizlet(params = { @BizletParam(index = 0, paramAlias = "filePath") })
public static void importCust(String filePath) {
try {
Workbook book = Workbook.getWorkbook(new File(filePath));
Sheet sheet = book.getSheet(0);
int rowNum = sheet.getRows();
for (int i = 1; i < rowNum; i++) {
String custname = sheet.getCell(1, i).getContents();
if (!(custname == null || custname.equals(""))) {
custname = custname.trim();
commonj.sdo.DataObject misCust = commonj.sdo.helper.DataFactory.INSTANCE.create("com.primeton.dd.dd.dds","testComponent");
misCust.setString("custname", custname);
int count = DatabaseUtil.expandEntityByTemplate("default", misCust, misCust);
if(count == 0){
DatabaseExt.getPrimaryKey(misCust);
misCust.setDate("createDate", new Date());
misCust.setString("createUserid", "dd");
DatabaseUtil.insertEntity("default", cust);
}
}
}
}catch (Exception e) {
e.printStackTrace();
}
}