@RequestMapping(value="/importUserInfo")
public void ImportUserInfo(HttpServletRequest request,HttpServletResponse response){
try{
String pid = request.getParameter("pid");//产品id
ProductList pro = productService.selectByPrimaryKey(Byte.valueOf(pid));
String userExcelPath = request.getParameter("userExcelPath");//excel路径
ServletContext application = request.getSession().getServletContext();
String savePath = application.getRealPath("") ;
String saveUrl = savePath.replaceAll("\\\\", "/") + userExcelPath;//excel绝对路径
InputStream input = null;
XSSFWorkbook wb = null;
int result =0;
try {
input = new FileInputStream(saveUrl);
wb = new XSSFWorkbook(input);
for(int numSheet=0;numSheet<wb.getNumberOfSheets();numSheet++){
XSSFSheet sheet = wb.getSheetAt(numSheet);
int count = sheet.getLastRowNum();
for (int i = 1; i <= count; i++) {
XSSFRow row = sheet.getRow(i);
//学生信息
String school = getCellStringValue(row, 0); // 学校
String trueName = getCellStringValue(row, 1); // 姓名
String sex = getCellStringValue(row, 2); //性别
String usercard = getCellStringValue(row, 3); // 身份证
String type = getCellStringValue(row, 8);//用户类型
String tel = getCellStringValue(row, 9);//联系方式
if(StringUtil.isEmpty(usercard)){
continue;
}
public void ImportUserInfo(HttpServletRequest request,HttpServletResponse response){
try{
String pid = request.getParameter("pid");//产品id
ProductList pro = productService.selectByPrimaryKey(Byte.valueOf(pid));
String userExcelPath = request.getParameter("userExcelPath");//excel路径
ServletContext application = request.getSession().getServletContext();
String savePath = application.getRealPath("") ;
String saveUrl = savePath.replaceAll("\\\\", "/") + userExcelPath;//excel绝对路径
InputStream input = null;
XSSFWorkbook wb = null;
int result =0;
try {
input = new FileInputStream(saveUrl);
wb = new XSSFWorkbook(input);
for(int numSheet=0;numSheet<wb.getNumberOfSheets();numSheet++){
XSSFSheet sheet = wb.getSheetAt(numSheet);
int count = sheet.getLastRowNum();
for (int i = 1; i <= count; i++) {
XSSFRow row = sheet.getRow(i);
//学生信息
String school = getCellStringValue(row, 0); // 学校
String trueName = getCellStringValue(row, 1); // 姓名
String sex = getCellStringValue(row, 2); //性别
String usercard = getCellStringValue(row, 3); // 身份证
String type = getCellStringValue(row, 8);//用户类型
String tel = getCellStringValue(row, 9);//联系方式
if(StringUtil.isEmpty(usercard)){
continue;
}