ssh excel 导入 mysql_导入excel表的数据到数据库ssh

InputExcel.java

package com.gxuwz.Market.util;

import java.io.File;

import java.io.FileInputStream;

import java.io.InputStream;

import java.lang.reflect.Field;

import java.lang.reflect.Method;

import java.util.ArrayList;

import java.util.List;

import jxl.Sheet;

import jxl.Workbook;

public class InputExcel {

public List realExcel(File file,Class> clazz){

List list = new ArrayList();

try{

InputStream is = new FileInputStream(file.getAbsolutePath());

Workbook wb = Workbook.getWorkbook(is);

//Excel的页签数量

Sheet sheet = wb.getSheet(0);

for(int i = 1;i < sheet.getRows();i++){

Object o = clazz.newInstance();

for(int j = 0;j < sheet.getColumns();j++){

String cellInfo = sheet.getCell(j,i).getContents();

setMethod(o, formatMethodName(sheet.getCell(j,0).getContents()), cellInfo);

}

list.add((T) o);

}

}catch(Exception e){

e.printStackTrace();

}

return list;

}

/**

* 通过

* @param o

* @param methodName

* @return

* @throws NoSuchFieldException

* @throws SecurityException

* @throws IllegalArgumentException

* @throws IllegalAccessException

*/

public static Object setMethod(Object o,String methodName,String value) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException{

Field field = o.getClass().getDeclaredField(methodName);

field.setAccessible(true);

field.set(o, value);

return o;

}

/**

* 属性名：格式化

* @param name

* @return

*/

public static String formatMethodName(String name){

String[] names = name.split("_");

String s = names[0];

for(int i = 1;i < names.length;i++){

s += names[i].substring(0, 1).toUpperCase()+names[i].substring(1);

}

return s;

}

//获取属性值

private static Object getMethod(Object o, String methodName) {

try {

Method get = o.getClass().getMethod(methodName);

Object result = get.invoke(o);

return result;

} catch (Exception e) {

e.getMessage();

}

return null;

}

}

action中的执行方法要包含以下代码

InputExcel ie = new InputExcel();

List list = ie.realExcel(file.get(0),ShopInfo.class);

shopService.addShops(list);