package?com.eas.adddata.core;

import?java.io.File;
import?java.io.FileInputStream;
import?java.lang.reflect.Field;
import?java.lang.reflect.Method;
import?java.sql.Timestamp;
import?java.text.DecimalFormat;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;
import?java.util.Set;

import?org.apache.poi.hssf.usermodel.HSSFDataFormat;
import?org.apache.poi.hssf.usermodel.HSSFDateUtil;
import?org.apache.poi.ss.usermodel.Cell;
import?org.apache.poi.ss.usermodel.DateUtil;
import?org.apache.poi.ss.usermodel.Row;
import?org.apache.poi.ss.usermodel.Sheet;
import?org.apache.poi.ss.usermodel.Workbook;
import?org.apache.poi.ss.usermodel.WorkbookFactory;

import?com.eas.logic.dao.AddData;
import?com.eas.logic.pojo.school.Profession;
import?com.eas.jdbc.util.FormatUtil;
import?com.eas.jdbc.util.ReflectUtil;

public?class?ExcelToSql?{
	public?static??void?ExlToPojo（FileInputStream?isClass?objClass）{
		try?{
			AddData?addData=new?AddData（）;
			//poi中這種方式?Excel?2003/2007/2010?都是可以處理的
????????????Workbook?workbook?=?WorkbookFactory.create（is）;?
????????????int?sheetCount?=?workbook.getNumberOfSheets（）;??//Sheet的數量
????????????System.out.println（“表數“+sheetCount）;
????????????//遍歷每個Sheet
????????????for?（int?s?=?0;?s?????????????	List?list=new?ArrayList<>（）;
????????????????Sheet?sheet?=?workbook.getSheetAt（s）;
????????????????Row?titleRow=sheet.getRow（0）;
????????????????if（titleRow!=null）{
????????????????	int?titleCount=titleRow.getPhysicalNumberOfCells（）;
????????????????	//excel中的列名
????????????????	String[]?titleNames=new?String[titleCount];
????????????????	?//獲得類中的所有屬性
????				Set?totalField=ReflectUtil.findClassField（objClass）;
????				//獲得類中的所有方法
????				Set?totalMethod=ReflectUtil.findClassMethod（objClass）;
????				//獲取行數
????????????????????int?rowCount?=?sheet.getPhysicalNumberOfRows（）;?//獲取總行數
????????????????	//獲取表中的列名
????????????????????for（int?q=0;qtleCount;q++）{
????????????????????	titleNames[q]=titleRow.getCell（q）.getStringCellValue（）;
????????????????????}
????????????????????for（int?x=1;x????????????????????	T?pro=objClass.newInstance（）;
????????????????????	System.out.println（pro.getClass（））;
????????????????????	Row?row=sheet.getRow（x）;
????????????????????	for（int?i=0;itleCount;i++）{
????????????????????		Field?field=ReflectUtil.checkFiled（totalField?titleNames[i]）;
????????????????????????	if（field!=null）{
????????????????????????		Class?type=field.getType（）;
????????????????????????		Cell?cell=row.getCell（i）;
????????????????????????		object?value=null;
????????????????????????		if（type==String.class）{???????????????????		
????								value=reString（cell）.toString（）;
????								System.out.println（value）;
????							}
????							else?if（type==Integer.class||type==int.class）{
//????								value=（int）cell.getNumericCellValue（）;
????								value=Integer.parseInt（reString（cell）.t

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

?????文件????????920??2018-10-17?22:01??教務系統\EAS\.classpath

?????文件???????1036??2018-10-17?22:01??教務系統\EAS\.project

?????文件????????567??2018-10-17?22:02??教務系統\EAS\.settings\.jsdtscope

?????文件????????364??2018-10-17?22:02??教務系統\EAS\.settings\org.eclipse.jdt.core.prefs

?????文件????????461??2018-10-17?22:02??教務系統\EAS\.settings\org.eclipse.wst.common.component

?????文件????????345??2018-10-17?22:02??教務系統\EAS\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-10-17?22:02??教務系統\EAS\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-10-17?22:02??教務系統\EAS\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件??????????3??2018-10-17?22:01??教務系統\EAS\.svn\entries

?????文件??????????3??2018-10-17?22:01??教務系統\EAS\.svn\format

?????文件???????1576??2018-10-17?22:02??教務系統\EAS\.svn\pristine\00\0029cdbfb24b9210a753aa24508bfa4bcb1ce2b5.svn-base

?????文件????????903??2018-10-17?22:02??教務系統\EAS\.svn\pristine\00\00448dfff9a135d426547b6d55f89695fac90385.svn-base

?????文件???????1032??2018-10-17?22:01??教務系統\EAS\.svn\pristine\00\007ca4d93d393a3a7c90d76a5920e7ff70c4515b.svn-base

?????文件????????191??2018-10-17?22:02??教務系統\EAS\.svn\pristine\00\007d2527690783a878e3ec76cce9ac7fc88d3fe7.svn-base

?????文件???????1128??2018-10-17?22:02??教務系統\EAS\.svn\pristine\00\0085482f4a9d17ec726e91da8ea664a844e88eec.svn-base

?????文件????????362??2018-10-17?22:01??教務系統\EAS\.svn\pristine\00\00937b5e8f730c85fccb492b0f05299a00f9d3eb.svn-base

?????文件??????10223??2018-10-17?22:01??教務系統\EAS\.svn\pristine\00\00ac9f49d0e0438836733558388f1c88e33d324f.svn-base

?????文件???????5230??2018-10-17?22:02??教務系統\EAS\.svn\pristine\00\00e22681e68af899d7fdb0a41c1cc3232533163c.svn-base

?????文件???????8817??2018-10-17?22:01??教務系統\EAS\.svn\pristine\01\012392996fd81ce3954a285da35dde60f93624d7.svn-base

?????文件????????716??2018-10-17?22:02??教務系統\EAS\.svn\pristine\01\012984c34092c44cc0540e2b881394662236428e.svn-base

?????文件????????244??2018-10-17?22:02??教務系統\EAS\.svn\pristine\01\0146248c0358eaae6a002fc7ad492483b60ff503.svn-base

?????文件???????2495??2018-10-18?21:26??教務系統\EAS\.svn\pristine\01\017bd1d09a531ea32de58525582f8f4fe210868a.svn-base

?????文件????????861??2018-10-17?22:01??教務系統\EAS\.svn\pristine\01\0187d301cdcfa908f4369437036a57d53a87185c.svn-base

?????文件???????1609??2018-10-17?22:02??教務系統\EAS\.svn\pristine\02\0240f5850e4490cace11e10374fc1a9d7ff58498.svn-base

?????文件??????16882??2018-10-17?22:01??教務系統\EAS\.svn\pristine\02\0245a228bfaaf41ecff461717cd58822baab807c.svn-base

?????文件???????4056??2018-10-17?22:02??教務系統\EAS\.svn\pristine\02\0286bbac023890d980c80d45b5cbf0af4ad82001.svn-base

?????文件????????898??2018-10-17?22:02??教務系統\EAS\.svn\pristine\02\028896a3720a16031a3f3ded9454ce93b83ca319.svn-base

?????文件???????1843??2018-10-17?22:02??教務系統\EAS\.svn\pristine\02\029eb70f92a04ebea82c5c05dd46353f5c03b866.svn-base

?????文件???????1868??2018-10-17?22:01??教務系統\EAS\.svn\pristine\03\031321ba520828b8929ce4e65ec2fe31a3265d1c.svn-base

?????文件???????2335??2018-10-18?11:50??教務系統\EAS\.svn\pristine\03\031c8ae8f37f3d97e3e9d99138758270315e6fb8.svn-base

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