/**
* 导入数据
* @param path
*/
@SuppressWarnings("static-access")
@ResponseBody
@RequestMapping(value = "/interfaceLeadingIn")
public JSONObject interfaceLeadingIn(HttpServletRequest request, String path){
JSONObject json = new JSONObject();
String returnCode = new String();
try {
String loginAccount = (String) request.getSession().getAttribute("userName");//登陆帐号
URL url = new URL(path);
URLConnection conn = url.openConnection();
InputStream is = conn.getInputStream();
XSSFWorkbook hssfWorkbook = new XSSFWorkbook(is);
List<InterfaceConcludeSign> list = new ArrayList<InterfaceConcludeSign>();
for (int numSheet = 0; numSheet < hssfWorkbook.getNumberOfSheets(); numSheet++) {
XSSFSheet hssfSheet = hssfWorkbook.getSheetAt(numSheet);
if (hssfSheet == null) {
continue;
}
for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {
XSSFRow hssfRow = hssfSheet.getRow(rowNum);
if(hssfRow != null){
InterfaceConcludeSign inter = new InterfaceConcludeSign();
XSSFCell interface_name = hssfRow.getCell(0);
XSSFCell parent_interface_name = hssfRow.getCell(1);
XSSFCell son_interface_name = hssfRow.getCell(2);
XSSFCell interface_remark = hssfRow.getCell(3);
XSSFCell catalog_name = hssfRow.getCell(4);
XSSFCell tiny_catalog = hssfRow.getCell(5);
XSSFCell out_parameter = hssfRow.getCell(6);
XSSFCell put_parameter = hssfRow.getCell(7);
XSSFCell buy_price = hssfRow.getCell(8);
XSSFCell pack_price = hssfRow.getCell(9);
XSSFCell company_name = hssfRow.getCell(10);
XSSFCell company_code = hssfRow.getCell(11);
XSSFCell company_abutment = hssfRow.getCell(12);
XSSFCell company_tel = hssfRow.getCell(13);
XSSFCell channel_area = hssfRow.getCell(14);
XSSFCell channel_user = hssfRow.getCell(15);
Date stime = hssfRow.getCell(16).getDateCellValue();
Date etime = hssfRow.getCell(17).getDateCellValue();
XSSFCell product_model = hssfRow.getCell(18);
XSSFCell type = hssfRow.getCell(19);
XSSFCell scope = hssfRow.getCell(20);
XSSFCell test_scope = hssfRow.getCell(21);
XSSFCell upd_rate = hssfRow.getCell(22);
XSSFCell remark = hssfRow.getCell(23);
XSSFCell cell_url = hssfRow.getCell(24);
XSSFCell test_url = hssfRow.getCell(25);
XSSFCell upd_info = hssfRow.getCell(26);
XSSFCell platform_price = hssfRow.getCell(27);
inter.setPact_sttime(stime);
inter.setPact_entime(etime);
inter.setCompany_tel(String.valueOf(company_tel));
inter.setPlatform_price(String.valueOf(platform_price));
inter.setTest_url(String.valueOf(test_url));
inter.setUpd_info(String.valueOf(upd_info));
inter.setCell_url(String.valueOf(cell_url));
inter.setRemark(String.valueOf(remark));
inter.setProduct_model(String.valueOf(product_model));
inter.setChannel_area(String.valueOf(channel_area));
inter.setBuy_price(String.valueOf(buy_price));
inter.setPack_name(String.valueOf(pack_price));
inter.setCompany_name(String.valueOf(company_name));
inter.setCompany_abutment(String.valueOf(company_abutment));
inter.setCompany_name(String.valueOf(company_name));
inter.setCompany_code(String.valueOf(company_code));
inter.setCatalog_name(String.valueOf(catalog_name));
inter.setTiny_catalog(String.valueOf(tiny_catalog));
inter.setOut_parameter(String.valueOf(out_parameter));
inter.setPut_parameter(String.valueOf(put_parameter));
inter.setCompany_name(String.valueOf(company_name));
inter.setChannel_user(String.valueOf(channel_user));
inter.setType(String.valueOf(type));
inter.setScope(String.valueOf(scope));
inter.setTest_scope(String.valueOf(test_scope));
inter.setUpd_rate(String.valueOf(upd_rate));
inter.setInterface_remark(String.valueOf(interface_remark));
inter.setInterface_name(String.valueOf(interface_name));
inter.setSon_interface_name(String.valueOf(son_interface_name));
inter.setParent_interface_name(String.valueOf(parent_interface_name));
inter.setStatus(1);
inter.setAdd_user(loginAccount);
inter.setAdd_time(new Date());
inter.setIs_show(1);
list.add(inter);
}
}
}
if(list != null && list.size() > 0){
int circleInsertInterface = interfaceConcludeSignServiceImpl.circleInsertInterface(list);
if(circleInsertInterface > 0){
returnCode = new String(ReturnCode.LEADINGIN_SUCCESS.toString());
}else{
returnCode = new String(ReturnCode.LEADINGIN_ERROR.toString());
}
}else{
returnCode = new String(ReturnCode.FILE_NULL.toString());
}
} catch (Exception e) {
returnCode = new String(ReturnCode.OPERATE_ERROR.toString());
e.printStackTrace();
}
json = json.fromObject(returnCode);
return json;
}
Java 实现导出:http://blog.csdn.net/u014266877/article/details/53691381