java读取加密excel_Java读取、创建Excel；验签，加密

package com.fanqi.test;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.security.MessageDigest;

import java.security.NoSuchAlgorithmException;

import java.util.ArrayList;

import java.util.Iterator;

import java.util.List;

import java.util.Map;

import java.util.Set;

import java.util.TreeMap;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import org.json.JSONArray;

import org.json.JSONObject;

public class TestDemo1 {

/*

* 读取Excel数据

*/

public List> readExcel(String filename) {

FileInputStream in;

XSSFWorkbook workbook = null;

try {

in = new FileInputStream(filename);

workbook = new XSSFWorkbook(in);

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

XSSFSheet sheet = workbook.getSheetAt(0);

int num = 0;

List> listCanshu = new ArrayList>();

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

Map map = new TreeMap();

String cell0 = sheet.getRow(i).getCell(0).getStringCellValue();

String cell1 = sheet.getRow(i).getCell(1).getStringCellValue();

map.put("canshu1", cell0);

map.put("canshu2", cell1);

listCanshu.add(map);

}

return listCanshu;

}

/*

* 组装成JSON形式

*/

public JSONArray zuZhuangCanShu(List> listCanshu) {

JSONArray jArray = new JSONArray();

for(int i=0;i

JSONObject json = new JSONObject(listCanshu.get(i));

jArray.put(json);

}

return jArray;

}

/*

* 验签，加密

*/

public List signMD5(List> l) {

List list = new ArrayList();

for(int i=0;i

String str = "";

StringBuffer buffer = null;

byte[] result = null;

Set set = l.get(i).entrySet();

Iterator it = set.iterator();

while(it.hasNext()){

Map.Entry mapEntry = (Map.Entry) it.next();

String key = (String) mapEntry.getKey();

String value = (String) mapEntry.getValue();

str = str + key + "=" + value + "&";

}

str = str.substring(0, str.length()-1);

try {

MessageDigest md = MessageDigest.getInstance("MD5");

result = md.digest(str.getBytes());

buffer = new StringBuffer();

for(byte r : result){

String s =Integer.toHexString(0xff & r);

if(s.length()==1){

buffer.append("0"+s);

}else{

buffer.append(s);

}

}

} catch (NoSuchAlgorithmException e) {

e.printStackTrace();

}

list.add(buffer.toString());

}

return list;

}

public static void main(String[] args) throws Exception {

// TODO Auto-generated method stub

TestDemo1 t = new TestDemo1();

List> l = t.readExcel("D:\\1.xlsx");

JSONArray jArray = t.zuZhuangCanShu(l);

List list = t.signMD5(l);

System.out.println(list.get(0));

System.out.println(list.get(1));

System.out.println(list.get(2));

}

}