package?com;

import?java.io.File;
import?java.io.FileOutputStream;
import?java.text.ParseException;
import?java.text.SimpleDateFormat;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;

import?org.apache.poi.ss.usermodel.Workbook;
import?org.jeecgframework.poi.excel.ExcelExportUtil;
import?org.jeecgframework.poi.excel.ExcelImportUtil;
import?org.jeecgframework.poi.excel.entity.ExportParams;
import?org.jeecgframework.poi.excel.entity.ImportParams;
public?class?IporDataServer?{
	public?static?void?main（String[]?args）?{
		IporDataServer?ss=new?IporDataServer（）;
		//讀取excel
			ss.domMain（“user.xls“）;
	}
	public??void?domMain（String?wj）?{
		String?wjm=“C:/user/“+wj;
		//讀取excel
		List?listimpor=this.imporExcel（wjm）;
		System.out.println（“文件：“+wj+“????條數：“+listimpor.size（）+“------------“）;
		//處理數據
		List?handlist=this.handData（listimpor）;
		//獲取調用數據
		//調用接口
		List?explist=handExpData（handlist）;
		//結果寫入excel
		try?{
		Workbook?workbook?=?ExcelExportUtil.exportExcel（new?ExportParams（“用戶數據““用戶“）
				userData?.class?explist）;
			FileOutputStream?fos?=?new?FileOutputStream（“C:/user/data/“+wj）;
			workbook.write（fos）;
			fos.close（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		
		
	}
	
	private?List?imporExcel（String?wjm）{
		File??myfile?=?new?File（wjm）;
//		Listject[]>?list=ExcelUpLoadUtil.excelUpLoad（myfile?wjm）;
		ImportParams?params?=?new?ImportParams（）;
	????params.settitleRows（0）;
	????params.setHeadRows（1）;
		List?list?=?ExcelImportUtil.importExcel（myfile?userData.class?params）;
		return?list;
	}
	
	private?List?handData（List?listimpor）{
		List?list=new?ArrayList（）;
		for?（int?i?=?0;?i?			//單條處理
			userData?bean=listimpor.get（i）;
//			System.out.println（bean.toString（））;
			String?sfz=bean.getZjh（）;
			if（sfz==null）continue;
			userData?one=new?userData（）;
			one.setXh（bean.getXh（）.trim（））;
			one.setXm（bean.getXm（）.trim（））;
			one.setBirthDay（bean.getBirthDay（）.trim（））;
			one.setZjh（bean.getZjh（）.trim（））;
			list.add（one）;
			
		}
		
		return?list;
	}
	
	private?String?getDate（String?rq）?{
		String?str?=?““;
		try?{
			String?qdrq?=?rq.replace（“-“?“/“）;
			SimpleDateFormat?s?=?new?SimpleDateFormat（“yyyy/MM/dd“）;
			SimpleDateFormat?s1?=?new?SimpleDateFormat（“yyyy/MM/dd?HH:mm:ss“）;
			SimpleDateFormat?sdf?=?new?SimpleDateFormat（“yyyy-MM-dd?HH:mm:ss“）;
			Date?date;
			if（rq.trim（）.length（）>11）{
				?date?=?s1.parse（qdrq）;
			}else{
				date?=?s.parse（qdrq）;
			}
			str=sdf.format（date）;
		}?catch?（ParseException?e）?{
			str=“1888-01-01?00:00:00“;
		}
		
		return?str;
	}
	private?List?handExpData（List?listimpor）{
		List??list=new?ArrayList（）;
		for?（int?i?=?0;?i?			userData?fh=this.getOneData（listimpor.get（i））;
			list.add（f

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1093??2018-10-24?10:27??easyPoi_demo\.classpath

?????文件???????1195??2018-10-24?10:27??easyPoi_demo\.project

?????文件????????522??2018-10-24?10:27??easyPoi_demo\.settings\.jsdtscope

?????文件?????????74??2018-10-24?10:29??easyPoi_demo\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2018-10-24?10:27??easyPoi_demo\.settings\org.eclipse.jdt.core.prefs

?????文件????????495??2018-10-24?10:27??easyPoi_demo\.settings\org.eclipse.wst.common.component

?????文件????????414??2018-10-24?10:28??easyPoi_demo\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-10-24?10:27??easyPoi_demo\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-10-24?10:27??easyPoi_demo\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3226??2018-10-24?10:47??easyPoi_demo\src\com\IporDataServer.java

?????文件???????1031??2018-10-24?10:51??easyPoi_demo\src\com\userData.java

?????文件????????834??2018-10-24?10:27??easyPoi_demo\WebRoot\index.jsp

?????文件?????????39??2018-10-24?10:27??easyPoi_demo\WebRoot\meta-INF\MANIFEST.MF

?????文件???????5066??2018-10-24?10:47??easyPoi_demo\WebRoot\WEB-INF\classes\com\IporDataServer.class

?????文件???????1681??2018-10-24?10:51??easyPoi_demo\WebRoot\WEB-INF\classes\com\userData.class

?????文件?????412642??2018-10-20?17:24??easyPoi_demo\WebRoot\WEB-INF\lib\commons-lang3-3.3.jar

?????文件???????4823??2018-10-20?16:03??easyPoi_demo\WebRoot\WEB-INF\lib\easypoi-annotation-2.4.0.jar

?????文件?????229994??2018-10-20?16:03??easyPoi_demo\WebRoot\WEB-INF\lib\easypoi-base-2.4.0.jar

?????文件??????20480??2018-10-20?16:03??easyPoi_demo\WebRoot\WEB-INF\lib\easypoi-web-2.4.0.jar

?????文件????1869113??2018-10-20?16:03??easyPoi_demo\WebRoot\WEB-INF\lib\poi-3.9.jar

?????目錄??????????0??2018-10-24?10:29??easyPoi_demo\WebRoot\WEB-INF\classes\com

?????目錄??????????0??2018-10-24?10:29??easyPoi_demo\WebRoot\WEB-INF\classes

?????目錄??????????0??2018-10-24?10:28??easyPoi_demo\WebRoot\WEB-INF\lib

?????目錄??????????0??2018-10-24?10:29??easyPoi_demo\src\com

?????目錄??????????0??2018-10-24?10:27??easyPoi_demo\WebRoot\meta-INF

?????目錄??????????0??2018-10-24?10:27??easyPoi_demo\WebRoot\WEB-INF

?????目錄??????????0??2018-10-24?10:29??easyPoi_demo\.settings

?????目錄??????????0??2018-10-24?10:29??easyPoi_demo\src

?????目錄??????????0??2018-10-24?10:27??easyPoi_demo\WebRoot

?????目錄??????????0??2018-10-24?10:27??easyPoi_demo

............此處省略4個文件信息