/**
* @param fileToUpload
* @param request
* @param response
* @throws Exception
*/
@RequestMapping("/importFile")
@ResponseBody
public BaseResult importFile(@RequestParam("xlsfileToUpload") MultipartFile uploadFile,HttpServletRequest request) throws Exception {
BaseResult res = new BaseResult();
CommonsMultipartFile file = (CommonsMultipartFile) uploadFile;
HttpSession session = request.getSession();
ServletContext application = session.getServletContext();
String serverRealPath = application.getRealPath("/") ;
String absolutePath = serverRealPath + Global.getConfig("tempFileUploadPath");
String tempFilePath =null;
String realPath =null;
try {
realPath = DateUtil.getNowShortDate();
tempFilePath = absolutePath + realPath+File.separator;
File tempFileMk = new File(tempFilePath);
if (!tempFileMk.exists()) {
tempFileMk.mkdirs();
}
} catch (Exception e1) {
e1.printStackTrace();
}
File desFile = null;
if (!file.isEmpty()) {
String suffixName = file.getFileItem().getName();
suffixName = suffixName.substring(suffixName.lastIndexOf("."), suffixName.length());
try {
realPath = realPath + suffixName;
desFile = new File(tempFilePath,suffixName);
file.transferTo(desFile);
res = analyticaliFile(desFile,res);
} catch (Exception e) {
res.setErrorMsg("文件上传失败" + e.getMessage());
e.printStackTrace();
}
res.setData(absolutePath+realPath);
res.setSuccess(true);
} else {
res.setErrorMsg("请选择上传文件");
}
return res;
}
public BaseResult analyticaliFile(File file,BaseResult base) {
try {
// excel转化成的list集合
String[] columns = {"no","username","password","fname","province","city"};
Excel2EntityConfig config = new Excel2EntityConfig();
config.setColumns(columns);
////设置日期的格式，和Excel里的日期格式一至
config.setFormater(new SimpleDateFormat("yyyy/MM/dd"));
////设置从第行开始读，忽略前4行
config.setCurrPosittion(2);
config.setColStartPosittion(1);
ExcelReader<FinancialPlanner> excel = new ExcelReader<FinancialPlanner>();
excel.setExcel2EntityConfig(config);
InputStream in = new FileInputStream(file);
excel.InitExcelReader(in);
FinancialPlanner entity = new FinancialPlanner();
excel.setEntity(entity);
List<FinancialPlanner> list = new ArrayList<FinancialPlanner>();
entity = excel.readLine();
while (entity != null) {
list.add((FinancialPlanner) BeanUtils.cloneBean(entity));
entity = excel.readLine();
}
String url = Global.getNetUrl("saveFinancialUrl");
for (FinancialPlanner financialPlanner : list) {
Map map = JSONObject.parseObject(JSON.toJSON(financialPlanner).toString(),Map.class);
String json = HttpClientUtil.post(url, map);
System.out.println(json);
}
file.delete();
base.setSuccess(true);
} catch (Exception e) {
e.printStackTrace();
base.setErrorMsg("解析异常");
}
return base;
}
import java.util.HashMap;
import java.util.Map;
/**
* 全局配置类
*/
public class Global {
/**
* 保存全局属性值
*/
private static Map<String, String> map = new HashMap();
/**
* 属性文件加载对象
*/
private static PropertiesLoader propertiesLoader = new PropertiesLoader("application.properties");
/**
* 获取配置
*/
public static String getConfig(String key) {
String value = map.get(key);
if (value == null){
value = propertiesLoader.getProperty(key);
map.put(key, value);
}
return value;
}
/**
* 获取管理端根路径
*/
public static String getAdminPath() {
return getConfig("adminPath");
}
public static String getNetUrl(String key) {
return getConfig("url")+getConfig(key);
}
}
import java.io.IOException;
import java.io.InputStream;
import java.util.NoSuchElementException;
import java.util.Properties;
import org.apache.commons.io.IOUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.core.io.DefaultResourceLoader;
import org.springframework.core.io.Resource;
import org.springframework.core.io.ResourceLoader;
/**
* Properties文件载入工具类. 可载入多个properties文件, 相同的属性在最后载入的文件中的值将会覆盖之前的值，但以System的Property优先.
*/
public class PropertiesLoader {
private static Logger logger = LoggerFactory.getLogger(PropertiesLoader.class);
private static ResourceLoader resourceLoader = new DefaultResourceLoader();
private final Properties properties;
public PropertiesLoader(String... resourcesPaths) {
properties = loadProperties(resourcesPaths);
}
public Properties getProperties() {
return properties;
}
/**
* 取出Property，但以System的Property优先,取不到返回空字符串.
*/
private String getValue(String key) {
String systemProperty = System.getProperty(key);
if (systemProperty != null) {
return systemProperty;
}
if (properties.containsKey(key)) {
return properties.getProperty(key);
}
return "";
}
/**
* 取出String类型的Property，但以System的Property优先,如果都为Null则抛出异常.
*/
public String getProperty(String key) {
String value = getValue(key);
if (value == null) {
throw new NoSuchElementException();
}
return value;
}
/**
* 取出String类型的Property，但以System的Property优先.如果都为Null则返回Default值.
*/
public String getProperty(String key, String defaultValue) {
String value = getValue(key);
return value != null ? value : defaultValue;
}
/**
* 取出Integer类型的Property，但以System的Property优先.如果都为Null或内容错误则抛出异常.
*/
public Integer getInteger(String key) {
String value = getValue(key);
if (value == null) {
throw new NoSuchElementException();
}
return Integer.valueOf(value);
}
/**
* 取出Integer类型的Property，但以System的Property优先.如果都为Null则返回Default值，如果内容错误则抛出异常
*/
public Integer getInteger(String key, Integer defaultValue) {
String value = getValue(key);
return value != null ? Integer.valueOf(value) : defaultValue;
}
/**
* 取出Double类型的Property，但以System的Property优先.如果都为Null或内容错误则抛出异常.
*/
public Double getDouble(String key) {
String value = getValue(key);
if (value == null) {
throw new NoSuchElementException();
}
return Double.valueOf(value);
}
/**
* 取出Double类型的Property，但以System的Property优先.如果都为Null则返回Default值，如果内容错误则抛出异常
*/
public Double getDouble(String key, Integer defaultValue) {
String value = getValue(key);
return value != null ? Double.valueOf(value) : defaultValue;
}
/**
* 取出Boolean类型的Property，但以System的Property优先.如果都为Null抛出异常,如果内容不是true/false则返回false.
*/
public Boolean getBoolean(String key) {
String value = getValue(key);
if (value == null) {
throw new NoSuchElementException();
}
return Boolean.valueOf(value);
}
/**
* 取出Boolean类型的Property，但以System的Property优先.如果都为Null则返回Default值,如果内容不为true/false则返回false.
*/
public Boolean getBoolean(String key, boolean defaultValue) {
String value = getValue(key);
return value != null ? Boolean.valueOf(value) : defaultValue;
}
/**
* 载入多个文件, 文件路径使用Spring Resource格式.
*/
private Properties loadProperties(String... resourcesPaths) {
Properties props = new Properties();
for (String location : resourcesPaths) {
//logger.debug("Loading properties file from:" + location);
InputStream is = null;
try {
Resource resource = resourceLoader.getResource(location);
is = resource.getInputStream();
props.load(is);
} catch (IOException ex) {
logger.info("Could not load properties from path:" + location + ", " + ex.getMessage());
} finally {
IOUtils.closeQuietly(is);
}
}
return props;
}
}
原文：http://my.oschina.net/houwanming/blog/531054