`
fwgforce
  • 浏览: 9351 次
  • 性别: Icon_minigender_1
  • 来自: 中国
最近访客 更多访客>>
社区版块
存档分类
最新评论

POI导入EXCLE,支持2003和2007

阅读更多

POI导入EXCLE,支持2003和2007

作者:fwgforce

[本文原创]

一.目的:实现将EXCEL的数据插入到数据库的一张表中

 1,例子POJO

 

import java.util.Date;
import java.math.BigDecimal;

/**
 * Enterprise entity.
 * 
 * @author fwgforce
 */

@SuppressWarnings("serial")
public class Enterprise implements java.io.Serializable {

	private String EName;// 企业名称
	private String ERegNo;// 注册号
	private String EManager;// 负责人
	private Date ESetupDate;// 成立日期
	private BigDecimal ERegisteredCapital;// 注册资金
	private String EAddress;// 住所地址
	private String ETel;// 电话
	private String EBusinessScope;// 经营范围
	private Date EStartDate;// 营业日期(起)
	private Date EEndDate;// 营业日期(止)
	private String ETrade;// 所属行业
	private String ETradeNo;// 行业编码
	private String ERegGov;// 登记机关
	private String EManageGov;// 管辖机关
	private String EBusinessPlace;// 工商所
	private Date EConfirmDate;// 核准日期
	private String EType;// 企业类型(市局)
	private String EState;// 企业状态(市局)
	private String EBusinessPlaceMemo;// 工商所备注
	private String EHotTrade;// 重热点行业
	private String ESupplierType;// 经营户类别
	private Date EAdddate;// 加入日期
	private Date EUpdatedate;// 更新日期
	private String ERoomNo;// 楼层房间号
	private String ELinkman;// 联系人
	private String ELinkTel;// 联系电话
	private String EPlaceType;// 住所管理分类
	private String EPlaceMark;// 住所标注
	private String ERealityAddress;// 实际经营地址
	private String ERealityTel;// 实际联系电话
	private String ERealityType;// 实际经营地分类
	private String ERealityStatus;// 实际经营地状况
	private String ERealityBuilding;// 实际经营地所在写字楼
	private String ERealityArea;// 实际经营地面积
	private String ERealityReason;// 异地经营原因
	private String ERealityMemo;// 异地经营备注
	private BigDecimal ERealityIncome;// 实收资本
	private String EType2;// 企业类型
	private String EProperties;// 经营主体性质
	private String EPermision;// 前置许可
	private String ETradeType;// 行业分类
	private String e3mark;// 三区标注
	private String ERegionName;// 园区名称
	private String ETaxGov;// 缴税机关名称
	private String EZentLimit;// 租赁协议期限
	private String EPlaceStatus;// 住所状态
	private String EFoodSafe;// 食品安全监管
	private String EImportantRegion;// 重点地域
	private String EAd;// 广告情况
	private String ELogo;// 商标情况
	private String EBName;// 住所写字楼
	private String CreditLevel;// 信用等级
	private String ManagerWidth;// 责任区(管片)
	private String BusinessLogo;// 业务标志
	private String isOff;// 是否已注销;已注销为 "是";不是已注销为 "否"
	private String isSimpleEnt;// 是否是异地注册/经营企业;如果是异地注册/经营则为 是, 如果不是 则为否
	private String INCEntDate;// 新增日期
	private String DECEntDate;// 注销日期
	private String ENumber;// 税号
	private String isNullENumber;// 税号是否为空,警告。为空 "是",不为空 "否"
	private String isDeleteYet;// 企业是否已清除,已清除 "是",未清除 "否";
	private Date EDate;// 做表信息导入时间
	private Integer EId;
	private Integer TSid;
	private Integer EBId;

	// 日期字符串
	private String ESetupDateStr;
	private String EConfirmDateStr;
	private String EStartDateStr;
	private String EEndDateStr;
	private String EAdddateStr;
	private String EUpdatedateStr;

	// public Enterprise(String name, String regNo, String manager,
	// Date setupDate, BigDecimal registeredCapital, String address,
	// String tel, String businessScope, Date startDate, Date endDate,
	// String trade, String tradeNo, String regGov, String manageGov,
	// String businessPlace, Date confirmDate, String type, String state,
	// String businessPlaceMemo, String hotTrade, String supplierType,
	// Date adddate, Date updatedate, String roomNo, String linkman,
	// String linkTel, String placeType, String placeMark,
	// String realityAddress, String realityTel, String realityType,
	// String realityStatus, String realityBuilding, String realityArea,
	// String realityReason, String realityMemo, BigDecimal realityIncome,
	// String type2, String properties, String permision,
	// String tradeType, String e3mark, String regionName, String taxGov,
	// String zentLimit, String placeStatus, String foodSafe,
	// String importantRegion, String ad, String logo, String name2,
	// Date date) {
	// super();
	// EName = name;
	// ERegNo = regNo;
	// EManager = manager;
	// ESetupDate = setupDate;
	// ERegisteredCapital = registeredCapital;
	// EAddress = address;
	// ETel = tel;
	// EBusinessScope = businessScope;
	// EStartDate = startDate;
	// EEndDate = endDate;
	// ETrade = trade;
	// ETradeNo = tradeNo;
	// ERegGov = regGov;
	// EManageGov = manageGov;
	// EBusinessPlace = businessPlace;
	// EConfirmDate = confirmDate;
	// EType = type;
	// EState = state;
	// EBusinessPlaceMemo = businessPlaceMemo;
	// EHotTrade = hotTrade;
	// ESupplierType = supplierType;
	// EAdddate = adddate;
	// EUpdatedate = updatedate;
	// ERoomNo = roomNo;
	// ELinkman = linkman;
	// ELinkTel = linkTel;
	// EPlaceType = placeType;
	// EPlaceMark = placeMark;
	// ERealityAddress = realityAddress;
	// ERealityTel = realityTel;
	// ERealityType = realityType;
	// ERealityStatus = realityStatus;
	// ERealityBuilding = realityBuilding;
	// ERealityArea = realityArea;
	// ERealityReason = realityReason;
	// ERealityMemo = realityMemo;
	// ERealityIncome = realityIncome;
	// EType2 = type2;
	// EProperties = properties;
	// EPermision = permision;
	// ETradeType = tradeType;
	// this.e3mark = e3mark;
	// ERegionName = regionName;
	// ETaxGov = taxGov;
	// EZentLimit = zentLimit;
	// EPlaceStatus = placeStatus;
	// EFoodSafe = foodSafe;
	// EImportantRegion = importantRegion;
	// EAd = ad;
	// ELogo = logo;
	// EBName = name2;
	// EDate = date;
	// }

	public Enterprise(String name, String regNo, String manager,
			Date setupDate, BigDecimal registeredCapital, String address,
			String tel, String businessScope, Date startDate, Date endDate,
			String trade, String tradeNo, String regGov, String manageGov,
			String businessPlace, Date confirmDate, String type, String state,
			String businessPlaceMemo, String hotTrade, String supplierType,
			Date adddate, Date updatedate, String roomNo, String linkman,
			String linkTel, String placeType, String placeMark,
			String realityAddress, String realityTel, String realityType,
			String realityStatus, String realityBuilding, String realityArea,
			String realityReason, String realityMemo, BigDecimal realityIncome,
			String type2, String properties, String permision,
			String tradeType, String e3mark, String regionName, String taxGov,
			String zentLimit, String placeStatus, String foodSafe,
			String importantRegion, String ad, String logo, String name2,
			String creditLevel, String managerWidth, String businessLogo,
			String isOff, String isSimpleEnt, String entDate, String entDate2,
			String number, String isNullENumber, String isDeleteYet, Date date,
			Integer id, Integer sid, Integer id2) {
		super();
		EName = name;
		ERegNo = regNo;
		EManager = manager;
		ESetupDate = setupDate;
		ERegisteredCapital = registeredCapital;
		EAddress = address;
		ETel = tel;
		EBusinessScope = businessScope;
		EStartDate = startDate;
		EEndDate = endDate;
		ETrade = trade;
		ETradeNo = tradeNo;
		ERegGov = regGov;
		EManageGov = manageGov;
		EBusinessPlace = businessPlace;
		EConfirmDate = confirmDate;
		EType = type;
		EState = state;
		EBusinessPlaceMemo = businessPlaceMemo;
		EHotTrade = hotTrade;
		ESupplierType = supplierType;
		EAdddate = adddate;
		EUpdatedate = updatedate;
		ERoomNo = roomNo;
		ELinkman = linkman;
		ELinkTel = linkTel;
		EPlaceType = placeType;
		EPlaceMark = placeMark;
		ERealityAddress = realityAddress;
		ERealityTel = realityTel;
		ERealityType = realityType;
		ERealityStatus = realityStatus;
		ERealityBuilding = realityBuilding;
		ERealityArea = realityArea;
		ERealityReason = realityReason;
		ERealityMemo = realityMemo;
		ERealityIncome = realityIncome;
		EType2 = type2;
		EProperties = properties;
		EPermision = permision;
		ETradeType = tradeType;
		this.e3mark = e3mark;
		ERegionName = regionName;
		ETaxGov = taxGov;
		EZentLimit = zentLimit;
		EPlaceStatus = placeStatus;
		EFoodSafe = foodSafe;
		EImportantRegion = importantRegion;
		EAd = ad;
		ELogo = logo;
		EBName = name2;
		CreditLevel = creditLevel;
		ManagerWidth = managerWidth;
		BusinessLogo = businessLogo;
		this.isOff = isOff;
		this.isSimpleEnt = isSimpleEnt;
		INCEntDate = entDate;
		DECEntDate = entDate2;
		ENumber = number;
		this.isNullENumber = isNullENumber;
		this.isDeleteYet = isDeleteYet;
		EDate = date;
		EId = id;
		TSid = sid;
		EBId = id2;
	}

	/** default constructor */
	public Enterprise() {
	}

	public Enterprise(Integer id) {
		this.EId = id;
	}

	public Enterprise(String etrade, Long count) {
	}

	// EId,EName,building,EManager,ETrade,ERegisteredCapital,EType2,ELinkman,ETel
	public Enterprise(Integer id, String name, String ebname, String manager,
			String trade, BigDecimal registeredcapital, String linkman,
			String tel) {
		this.EId = id;
		this.EName = name;
		this.EBName = ebname;
		this.EManager = manager;
		this.ETrade = trade;
		this.ERegisteredCapital = registeredcapital;
		this.ELinkman = linkman;
		this.ETel = tel;

	}

	public Enterprise(Integer id,Integer ebid, String name, String ebname, String trade,
			BigDecimal registeredcapital, String eRegNo, String eBusinessScope,
			String eNumber, String isDeleteYet, String isNullENumber,
			String ERealityBuilding, String ERealityAddress) {
		this.EId = id;
		this.EBId = ebid;
		this.EName = name;
		this.EBName = ebname;
		this.ETrade = trade;
		this.ERegisteredCapital = registeredcapital;
		this.ERegNo = eRegNo;
		this.EBusinessScope = eBusinessScope;
		this.ENumber = eNumber;
		this.isDeleteYet = isDeleteYet;
		this.isNullENumber = isNullENumber;
		this.ERealityBuilding = ERealityBuilding;
		this.ERealityAddress = ERealityAddress;

	}

	// 异地
	public Enterprise(Integer id, String name, String ebname, String address,
			String eRegNo, String eNumber, String isDeleteYet,
			String isNullENumber, String ERealityBuilding,
			String ERealityAddress) {
		this.EId = id;
		this.EName = name;
		this.EBName = ebname;
		this.ERegNo = eRegNo;
		this.EAddress = address;
		this.ENumber = eNumber;
		this.isDeleteYet = isDeleteYet;
		this.isNullENumber = isNullENumber;
		this.ERealityBuilding = ERealityBuilding;
		this.ERealityAddress = ERealityAddress;

	}

	public Integer getEId() {
		return this.EId;
	}

	public void setEId(Integer EId) {
		this.EId = EId;
	}

	public String getEName() {
		return this.EName;
	}

	public void setEName(String EName) {
		this.EName = EName;
	}

	public String getERegNo() {
		return this.ERegNo;
	}

	public void setERegNo(String ERegNo) {
		this.ERegNo = ERegNo;
	}

	public String getEManager() {
		return this.EManager;
	}

	public void setEManager(String EManager) {
		this.EManager = EManager;
	}

	public Date getESetupDate() {
		return this.ESetupDate;
	}

	public void setESetupDate(Date ESetupDate) {
		this.ESetupDate = ESetupDate;
	}

	public BigDecimal getERegisteredCapital() {
		return this.ERegisteredCapital;
	}

	public void setERegisteredCapital(BigDecimal ERegisteredCapital) {
		this.ERegisteredCapital = ERegisteredCapital;
	}

	public String getEAddress() {
		return this.EAddress;
	}

	public void setEAddress(String EAddress) {
		this.EAddress = EAddress;
	}

	public String getETel() {
		return this.ETel;
	}

	public void setETel(String ETel) {
		this.ETel = ETel;
	}

	public String getEBusinessScope() {
		return this.EBusinessScope;
	}

	public void setEBusinessScope(String EBusinessScope) {
		this.EBusinessScope = EBusinessScope;
	}

	public Date getEStartDate() {
		return this.EStartDate;
	}

	public void setEStartDate(Date EStartDate) {
		this.EStartDate = EStartDate;
	}

	public Date getEEndDate() {
		return this.EEndDate;
	}

	public void setEEndDate(Date EEndDate) {
		this.EEndDate = EEndDate;
	}

	public String getETrade() {
		return this.ETrade;
	}

	public void setETrade(String ETrade) {
		this.ETrade = ETrade;
	}

	public String getETradeNo() {
		return this.ETradeNo;
	}

	public void setETradeNo(String ETradeNo) {
		this.ETradeNo = ETradeNo;
	}

	public String getERegGov() {
		return this.ERegGov;
	}

	public void setERegGov(String ERegGov) {
		this.ERegGov = ERegGov;
	}

	public String getEManageGov() {
		return this.EManageGov;
	}

	public void setEManageGov(String EManageGov) {
		this.EManageGov = EManageGov;
	}

	public String getEBusinessPlace() {
		return this.EBusinessPlace;
	}

	public void setEBusinessPlace(String EBusinessPlace) {
		this.EBusinessPlace = EBusinessPlace;
	}

	public Date getEConfirmDate() {
		return this.EConfirmDate;
	}

	public void setEConfirmDate(Date EConfirmDate) {
		this.EConfirmDate = EConfirmDate;
	}

	public String getEType() {
		return this.EType;
	}

	public void setEType(String EType) {
		this.EType = EType;
	}

	public String getEState() {
		return this.EState;
	}

	public void setEState(String EState) {
		this.EState = EState;
	}

	public String getEBusinessPlaceMemo() {
		return this.EBusinessPlaceMemo;
	}

	public void setEBusinessPlaceMemo(String EBusinessPlaceMemo) {
		this.EBusinessPlaceMemo = EBusinessPlaceMemo;
	}

	public String getEHotTrade() {
		return this.EHotTrade;
	}

	public void setEHotTrade(String EHotTrade) {
		this.EHotTrade = EHotTrade;
	}

	public String getESupplierType() {
		return this.ESupplierType;
	}

	public void setESupplierType(String ESupplierType) {
		this.ESupplierType = ESupplierType;
	}

	public Date getEAdddate() {
		return this.EAdddate;
	}

	public void setEAdddate(Date EAdddate) {
		this.EAdddate = EAdddate;
	}

	public Date getEUpdatedate() {
		return this.EUpdatedate;
	}

	public void setEUpdatedate(Date EUpdatedate) {
		this.EUpdatedate = EUpdatedate;
	}

	public String getERoomNo() {
		return this.ERoomNo;
	}

	public void setERoomNo(String ERoomNo) {
		this.ERoomNo = ERoomNo;
	}

	public String getELinkman() {
		return this.ELinkman;
	}

	public void setELinkman(String ELinkman) {
		this.ELinkman = ELinkman;
	}

	public String getELinkTel() {
		return this.ELinkTel;
	}

	public void setELinkTel(String ELinkTel) {
		this.ELinkTel = ELinkTel;
	}

	public String getEPlaceType() {
		return this.EPlaceType;
	}

	public void setEPlaceType(String EPlaceType) {
		this.EPlaceType = EPlaceType;
	}

	public String getEPlaceMark() {
		return this.EPlaceMark;
	}

	public void setEPlaceMark(String EPlaceMark) {
		this.EPlaceMark = EPlaceMark;
	}

	public String getERealityAddress() {
		return this.ERealityAddress;
	}

	public void setERealityAddress(String ERealityAddress) {
		this.ERealityAddress = ERealityAddress;
	}

	public String getERealityTel() {
		return this.ERealityTel;
	}

	public void setERealityTel(String ERealityTel) {
		this.ERealityTel = ERealityTel;
	}

	public String getERealityType() {
		return this.ERealityType;
	}

	public void setERealityType(String ERealityType) {
		this.ERealityType = ERealityType;
	}

	public String getERealityStatus() {
		return this.ERealityStatus;
	}

	public void setERealityStatus(String ERealityStatus) {
		this.ERealityStatus = ERealityStatus;
	}

	public String getERealityBuilding() {
		return this.ERealityBuilding;
	}

	public void setERealityBuilding(String ERealityBuilding) {
		this.ERealityBuilding = ERealityBuilding;
	}

	public String getERealityArea() {
		return this.ERealityArea;
	}

	public void setERealityArea(String ERealityArea) {
		this.ERealityArea = ERealityArea;
	}

	public String getERealityReason() {
		return this.ERealityReason;
	}

	public void setERealityReason(String ERealityReason) {
		this.ERealityReason = ERealityReason;
	}

	public String getERealityMemo() {
		return this.ERealityMemo;
	}

	public void setERealityMemo(String ERealityMemo) {
		this.ERealityMemo = ERealityMemo;
	}

	public BigDecimal getERealityIncome() {
		return this.ERealityIncome;
	}

	public void setERealityIncome(BigDecimal ERealityIncome) {
		this.ERealityIncome = ERealityIncome;
	}

	public String getEType2() {
		return this.EType2;
	}

	public void setEType2(String EType2) {
		this.EType2 = EType2;
	}

	public String getEProperties() {
		return this.EProperties;
	}

	public void setEProperties(String EProperties) {
		this.EProperties = EProperties;
	}

	public String getEPermision() {
		return this.EPermision;
	}

	public void setEPermision(String EPermision) {
		this.EPermision = EPermision;
	}

	public String getETradeType() {
		return this.ETradeType;
	}

	public void setETradeType(String ETradeType) {
		this.ETradeType = ETradeType;
	}

	public String getE3mark() {
		return this.e3mark;
	}

	public void setE3mark(String e3mark) {
		this.e3mark = e3mark;
	}

	public String getERegionName() {
		return this.ERegionName;
	}

	public void setERegionName(String ERegionName) {
		this.ERegionName = ERegionName;
	}

	public String getETaxGov() {
		return this.ETaxGov;
	}

	public void setETaxGov(String ETaxGov) {
		this.ETaxGov = ETaxGov;
	}

	public String getEZentLimit() {
		return this.EZentLimit;
	}

	public void setEZentLimit(String EZentLimit) {
		this.EZentLimit = EZentLimit;
	}

	public String getEPlaceStatus() {
		return this.EPlaceStatus;
	}

	public void setEPlaceStatus(String EPlaceStatus) {
		this.EPlaceStatus = EPlaceStatus;
	}

	public String getEFoodSafe() {
		return this.EFoodSafe;
	}

	public void setEFoodSafe(String EFoodSafe) {
		this.EFoodSafe = EFoodSafe;
	}

	public String getEImportantRegion() {
		return this.EImportantRegion;
	}

	public void setEImportantRegion(String EImportantRegion) {
		this.EImportantRegion = EImportantRegion;
	}

	public String getEAd() {
		return this.EAd;
	}

	public void setEAd(String EAd) {
		this.EAd = EAd;
	}

	public String getELogo() {
		return this.ELogo;
	}

	public void setELogo(String ELogo) {
		this.ELogo = ELogo;
	}

	public String getEBName() {
		return EBName;
	}

	public void setEBName(String ebname) {
		EBName = ebname;
	}

	public String getINCEntDate() {
		return INCEntDate;
	}

	public void setINCEntDate(String entDate) {
		INCEntDate = entDate;
	}

	public String getDECEntDate() {
		return DECEntDate;
	}

	public void setDECEntDate(String entDate) {
		DECEntDate = entDate;
	}

	public String getIsSimpleEnt() {
		return isSimpleEnt;
	}

	public void setIsSimpleEnt(String isSimpleEnt) {
		this.isSimpleEnt = isSimpleEnt;
	}

	public String getCreditLevel() {
		return CreditLevel;
	}

	public void setCreditLevel(String creditLevel) {
		CreditLevel = creditLevel;
	}

	public String getManagerWidth() {
		return ManagerWidth;
	}

	public void setManagerWidth(String managerWidth) {
		ManagerWidth = managerWidth;
	}

	public String getBusinessLogo() {
		return BusinessLogo;
	}

	public void setBusinessLogo(String businessLogo) {
		BusinessLogo = businessLogo;
	}

	public String getIsOff() {
		return isOff;
	}

	public void setIsOff(String isOff) {
		this.isOff = isOff;
	}

	public Integer getEBId() {
		return EBId;
	}

	public void setEBId(Integer id) {
		EBId = id;
	}

	public Integer getTSid() {
		return TSid;
	}

	public void setTSid(Integer sid) {
		TSid = sid;
	}

	public Date getEDate() {
		return EDate;
	}

	public void setEDate(Date date) {
		EDate = date;
	}

	public String getESetupDateStr() {
		return ESetupDateStr;
	}

	public void setESetupDateStr(String setupDateStr) {
		ESetupDateStr = setupDateStr;
	}

	public String getEConfirmDateStr() {
		return EConfirmDateStr;
	}

	public void setEConfirmDateStr(String confirmDateStr) {
		EConfirmDateStr = confirmDateStr;
	}

	public String getEStartDateStr() {
		return EStartDateStr;
	}

	public void setEStartDateStr(String startDateStr) {
		EStartDateStr = startDateStr;
	}

	public String getEEndDateStr() {
		return EEndDateStr;
	}

	public void setEEndDateStr(String endDateStr) {
		EEndDateStr = endDateStr;
	}

	public String getEAdddateStr() {
		return EAdddateStr;
	}

	public void setEAdddateStr(String adddateStr) {
		EAdddateStr = adddateStr;
	}

	public String getEUpdatedateStr() {
		return EUpdatedateStr;
	}

	public void setEUpdatedateStr(String updatedateStr) {
		EUpdatedateStr = updatedateStr;
	}

	public String getENumber() {
		return ENumber;
	}

	public void setENumber(String number) {
		ENumber = number;
	}

	public String getIsNullENumber() {
		return isNullENumber;
	}

	public void setIsNullENumber(String isNullENumber) {
		this.isNullENumber = isNullENumber;
	}

	public String getIsDeleteYet() {
		return isDeleteYet;
	}

	public void setIsDeleteYet(String isDeleteYet) {
		this.isDeleteYet = isDeleteYet;
	}

}

2.Enterprise.hbm.xml配置如下:

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="com.btwob.squall.bmis.model.Enterprise" table="Enterprise">
        <id name="EId" type="java.lang.Integer">
            <column name="E_ID" />
            <generator class="identity" />
        </id>
        <property name="TSid" type="java.lang.Integer">
            <column name="T_SID"/>
        </property>
         <property name="EBId" type="java.lang.Integer">
            <column name="E_BID"/>
        </property>
        <property name="EBName" type="java.lang.String">
            <column name="E_BName" length="100" />
        </property>
        <property name="EName" type="java.lang.String">
            <column name="E_Name" length="100" />
        </property>
        <property name="ERegNo" type="java.lang.String">
            <column name="E_RegNo" length="100" />
        </property>
        <property name="EManager" type="java.lang.String">
            <column name="E_Manager" length="50" />
        </property>
        <property name="ESetupDate" type="java.util.Date" >
            <column name="E_SetupDate" length="23" />
        </property>
        <property name="ERegisteredCapital" type="java.math.BigDecimal">
            <column name="E_RegisteredCapital" precision="18" scale="2" />
        </property>
        <property name="EAddress" type="java.lang.String">
            <column name="E_Address" length="255" />
        </property>
        <property name="ETel" type="java.lang.String">
            <column name="E_Tel" length="50" />
        </property>
        <property name="EBusinessScope" type="java.lang.String">
            <column name="E_BusinessScope" length="8000" />
        </property>
        <property name="EStartDate" type="java.util.Date">
            <column name="E_StartDate" length="23" />
        </property>
        <property name="EEndDate" type="java.util.Date">
            <column name="E_EndDate" length="23" />
        </property>
        <property name="ETrade" type="java.lang.String">
            <column name="E_Trade" length="50" />
        </property>
        <property name="ETradeNo" type="java.lang.String">
            <column name="E_TradeNo" length="50" />
        </property>
        <property name="ERegGov" type="java.lang.String">
            <column name="E_RegGov" length="50" />
        </property>
        <property name="EManageGov" type="java.lang.String">
            <column name="E_ManageGov" length="50" />
        </property>
        <property name="EBusinessPlace" type="java.lang.String">
            <column name="E_BusinessPlace" length="50" />
        </property>
        <property name="EConfirmDate" type="java.util.Date">
            <column name="E_ConfirmDate" length="23" />
        </property>
        <property name="EType" type="java.lang.String">
            <column name="E_Type" length="100" />
        </property>
        <property name="EState" type="java.lang.String">
            <column name="E_State" />
        </property>
        <property name="EBusinessPlaceMemo" type="java.lang.String">
            <column name="E_BusinessPlaceMemo" length="200" />
        </property>
        <property name="EHotTrade" type="java.lang.String">
            <column name="E_HotTrade" length="50" />
        </property>
        <property name="ESupplierType" type="java.lang.String">
            <column name="E_SupplierType" length="50" />
        </property>
        <property name="EAdddate" type="java.util.Date">
            <column name="E_Adddate" length="23" />
        </property>
        <property name="EUpdatedate" type="java.util.Date">
            <column name="E_Updatedate" length="23" />
        </property>
        <property name="ERoomNo" type="java.lang.String">
            <column name="E_RoomNo" length="200" />
        </property>
        <property name="ELinkman" type="java.lang.String">
            <column name="E_Linkman" length="50" />
        </property>
        <property name="ELinkTel" type="java.lang.String">
            <column name="E_LinkTel" length="50" />
        </property>
        <property name="EPlaceType" type="java.lang.String">
            <column name="E_PlaceType" length="50" />
        </property>
        <property name="EPlaceMark" type="java.lang.String">
            <column name="E_PlaceMark" length="50" />
        </property>
        <property name="ERealityAddress" type="java.lang.String">
            <column name="E_RealityAddress" length="255" />
        </property>
        <property name="ERealityTel" type="java.lang.String">
            <column name="E_RealityTel" length="50" />
        </property>
        <property name="ERealityType" type="java.lang.String">
            <column name="E_RealityType" length="50" />
        </property>
        <property name="ERealityStatus" type="java.lang.String">
            <column name="E_RealityStatus" length="50" />
        </property>
        <property name="ERealityBuilding" type="java.lang.String">
            <column name="E_RealityBuilding" length="100" />
        </property>
        <property name="ERealityArea" type="java.lang.String">
            <column name="E_RealityArea" length="50" />
        </property>
        <property name="ERealityReason" type="java.lang.String">
            <column name="E_RealityReason" length="100" />
        </property>
        <property name="ERealityMemo" type="java.lang.String">
            <column name="E_RealityMemo" length="200" />
        </property>
        <property name="ERealityIncome" type="java.math.BigDecimal">
            <column name="E_RealityIncome" precision="18" scale="2" />
        </property>
        <property name="EType2" type="java.lang.String">
            <column name="E_Type2" length="50"/>
        </property>
        <property name="EProperties" type="java.lang.String">
            <column name="E_Properties" length="50" />
        </property>
        <property name="EPermision" type="java.lang.String">
            <column name="E_Permision" />
        </property>
        <property name="ETradeType" type="java.lang.String">
            <column name="E_TradeType" length="50" />
        </property>
        <property name="e3mark" type="java.lang.String">
            <column name="E_3Mark" length="50" />
        </property>
        <property name="ERegionName" type="java.lang.String">
            <column name="E_RegionName" length="100" />
        </property>
        <property name="ETaxGov" type="java.lang.String">
            <column name="E_TaxGov" length="100" />
        </property>
        <property name="EZentLimit" type="java.lang.String">
            <column name="E_ZentLimit" length="50" />
        </property>
        <property name="EPlaceStatus" type="java.lang.String">
            <column name="E_PlaceStatus" length="50" />
        </property>
        <property name="EFoodSafe" type="java.lang.String">
            <column name="E_FoodSafe" length="50" />
        </property>
        <property name="EImportantRegion" type="java.lang.String">
            <column name="E_ImportantRegion" length="50" />
        </property>
        <property name="EAd" type="java.lang.String">
            <column name="E_AD" length="100" />
        </property>
        <property name="INCEntDate" type="java.lang.String">
            <column name="INCEntDate" length="100" />
        </property>
          <property name="DECEntDate" type="java.lang.String">
            <column name="DECEntDate" length="100" />
        </property>
         <property name="isSimpleEnt" type="java.lang.String">
            <column name="isSimpleEnt" length="50" />
        </property>
          <property name="CreditLevel" type="java.lang.String">
            <column name="CreditLevel" length="50" />
        </property>
         <property name="ManagerWidth" type="java.lang.String">
            <column name="ManagerWidth" length="50" />
        </property>
         <property name="BusinessLogo" type="java.lang.String">
            <column name="BusinessLogo" length="50" />
        </property>
         <property name="isOff" type="java.lang.String">
            <column name="isOff" length="50" />
        </property>
        <property name="ELogo" type="java.lang.String">
            <column name="E_Logo" length="100" />
        </property>
          <property name="ENumber" type="java.lang.String">
            <column name="E_Number" length="100" />
        </property>
         <property name="isNullENumber" type="java.lang.String">
            <column name="isNullENumber" length="50" />
        </property>
          <property name="isDeleteYet" type="java.lang.String">
            <column name="isDeleteYet" length="50" />
        </property>
        <property name="EDate" type="java.util.Date">
            <column name="E_Date" length="23" />
        </property>
      </class>
</hibernate-mapping>

 

3.公有方法:

import java.io.File;
import java.math.BigDecimal;
import java.sql.Date;
import java.util.Calendar;
import java.util.HashMap;
import java.util.Map;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

/**
 * 对读取数据进行格式处理
 * 
 * @author fwgforce
 * @date 2010-3-3
 * 
 */
public class ChangeMethod {
	/*
	 * 获取Excel表内日期(yyyy-MM-dd)
	 */
	@SuppressWarnings("deprecation")
	public Date getExcelDate(String str) {
		@SuppressWarnings("unused")
		String[] strArray = str.split("-");
		Integer month = Integer.valueOf(getMonth(strArray[1])) - 1;// 获取月
		Integer year = Integer.valueOf(strArray[2]) - 1900;// 获取年
		Date date = new Date(year, month, Integer.valueOf(strArray[0]));// 依据西方日期规则
		return date;
	}

	/*
	 * 将数字月转换成字符串月显示出来
	 */
	public static Integer getMonth(String str) {
		Integer i = 1;
		if (str.equals("二月")) {
			i = 2;
		} else if (str.equals("三月")) {
			i = 3;
		} else if (str.equals("四月")) {
			i = 4;
		} else if (str.equals("五月")) {
			i = 5;
		} else if (str.equals("六月")) {
			i = 6;
		} else if (str.equals("七月")) {
			i = 7;
		} else if (str.equals("八月")) {
			i = 8;
		} else if (str.equals("九月")) {
			i = 9;
		} else if (str.equals("十月")) {
			i = 10;
		} else if (str.equals("十一月")) {
			i = 11;
		} else if (str.equals("十二月")) {
			i = 12;
		}
		return i;
	}

	/*
	 * 数据为空字符串
	 */
	/*
	 * 数据为空字符串
	 */
	@SuppressWarnings("deprecation")
	public String isNullStr(Cell cell) {
		String result = "";
		if (null == cell)
			return result;
		else {
			switch (cell.getCellType()) {
			case Cell.CELL_TYPE_NUMERIC:
				cell.setCellType(1);
				result = cell.getStringCellValue().trim();
				break;
			case Cell.CELL_TYPE_STRING:
				result = cell.getStringCellValue().trim();
				break;

			}
			return result;
		}
	}

	/*
	 * // 公式型求值 @SuppressWarnings("deprecation") public BigDecimal
	 * isBigDecimalVal(Cell cell) { Double result = null; if (null == cell)
	 * return BigDecimal.valueOf(0.00); else { if (Cell.CELL_TYPE_ERROR ==
	 * cell.getCellType()) { result = 0.00; } return BigDecimal.valueOf(result); } }
	 */
	/*
	 * 数据为空Integer
	 */
	@SuppressWarnings( { "deprecation", "deprecation", "unused" })
	public Integer isNullInteger(Cell cell) {
		int result = 0;
		if (null == cell)
			return null;
		else {
			switch (cell.getCellType()) {
			case Cell.CELL_TYPE_NUMERIC:
				String tmpStr = String.valueOf(cell.getNumericCellValue());
				result = Integer.parseInt(tmpStr.substring(0, tmpStr
						.indexOf(".")));
				break;
			case Cell.CELL_TYPE_STRING:
				result = Integer.parseInt(cell.getStringCellValue().trim());
				break;
			}
			return result;
		}
	}

	/*
	 * 数据为空bigDecimal 导出
	 */
	@SuppressWarnings( { "unused", "deprecation" })
	public BigDecimal isNullBigDecimal(Cell cell) {
		Double result = null;
		if (null == cell) {
			return null;
		} else {
			switch (cell.getCellType()) {
			case Cell.CELL_TYPE_NUMERIC:
				if (cell != null) {
					result = cell.getNumericCellValue();
				} else {
					result = 0.00;
				}

				break;
			case Cell.CELL_TYPE_STRING:
				if ("".equals(cell.getStringCellValue().trim())) {
					return null;
				} else {
					result = Double.valueOf(cell.getStringCellValue());
				}
				break;
			case Cell.CELL_TYPE_BLANK:
				result = 0.00;
				break;
			}
			if (null == result) {
				return null;
			} else {
				return BigDecimal.valueOf(result);
			}
		}
	}

	/*
	 * 数据为空bigDecimal 导入
	 */
	@SuppressWarnings( { "unused", "deprecation" })
	public BigDecimal isNullBigDecimalImport(Cell cell) {
		Double result = null;
		if (null == cell)
			return null;
		else {
			switch (cell.getCellType()) {
			case Cell.CELL_TYPE_NUMERIC:
				result = cell.getNumericCellValue();
				break;
			case Cell.CELL_TYPE_STRING:
				if ("".equals(cell.getStringCellValue().trim()))
					return null;
				else
					result = Double.valueOf(cell.getStringCellValue());
				break;
			}
			return BigDecimal.valueOf(result);
		}
	}

	/*
	 * 数据为空bigDecimal 日期 返回String
	 */
	@SuppressWarnings( { "deprecation", "unused" })
	public Date isNullDate(Cell cell) {
		Date result = null;
		if (cell != null) {
			cell.setCellType(1);
			String stringCellValue = cell.getStringCellValue();
			int indexOf = stringCellValue.indexOf(".");
			if (-1 != indexOf) {
				stringCellValue = stringCellValue.substring(0, indexOf);
			}

			boolean date = isDate(stringCellValue);
			if (!date) {
				Long numericCellValue = Long.valueOf(stringCellValue);
				String stringDate = getStringDate(numericCellValue);
				result = Date.valueOf(stringDate);

			} else {
				result = strDate(stringCellValue);
			}

		}

		return result;
	}

	/**
	 * 返回当前月的总天数
	 * 
	 * @author fwgforce
	 * @param year
	 * @param month
	 * @return
	 */
	public String getEndDay(String year, String month) {
		String daycount = null;// 当前月的天数
		Calendar c = Calendar.getInstance();
		c.set(Integer.valueOf(year), 1, 29);
		int m = c.get(Calendar.MONTH) + 1;
		switch (Integer.valueOf(month)) {
		case 1:
		case 3:
		case 5:
		case 7:
		case 8:
		case 10:
		case 12:
			daycount = "31";
			break;
		case 4:
		case 6:
		case 9:
		case 11:
			daycount = "30";
			break;
		case 2:
			if (m == 2) {// 判断当前年份是否为闰年
				daycount = "29";
			} else {
				daycount = "28";
			}
			break;
		default:
			break;
		}

		return daycount;
	}

	/**
	 * 对日期进行封装(01-2月-2010转成2010-2-01)
	 * 
	 * @author fwgforce
	 * @param str
	 * @return
	 */
	public String dateStr(String str) {
		String[] strArray = str.split("-");
		String day = strArray[0];// 日
		String month = getMonth(strArray[1]).toString();// 月
		String year = strArray[2];// 年
		String str1;
		if (Integer.valueOf(month) < 10) {
			str1 = year + "-0" + month + "-" + day;
		} else {
			str1 = year + "-" + month + "-" + day;
		}
		return str1;
	}

	/**
	 * 对日期进行封装(2010-1-1转成2010-01-01)
	 * 
	 * @author fwgforce
	 * @param str
	 * @return
	 */
	public String dateStr2(String str) {
		String[] strArray = str.trim().split("-");
		String day = strArray[2];// 日
		String month = strArray[1].toString();// 月
		String year = strArray[0];// 年
		String str1;
		if (Integer.valueOf(month) < 10) {
			str1 = year + "-0" + month + "-" + day;
		} else {
			str1 = year + "-" + month + "-" + day;
		}
		return str1;
	}

	/**
	 * 封装成Date类型
	 * 
	 * @author fwgforce
	 */
	@SuppressWarnings("deprecation")
	public Date strDate(String str) {
		Date date = null;
		if (!str.equals("")) {
			String[] strArray = str.trim().split("-");
			String month = strArray[1].toString();// 月
			String year = strArray[0];// 年
			Integer month2 = Integer.valueOf(month) - 1;// 获取月
			Integer year2 = Integer.valueOf(year) - 1900;// 获取年
			date = new Date(year2, month2, Integer.valueOf(strArray[2]
					.toString()));// 依据西方日期规则
		}
		return date;
	}

	/**
	 * 对excel取出为数字类型的将其转成日期格式例如(2010-3-4 数字为40241,后台读取为40241 ,插入数据库需转成日期格式)
	 * 
	 * @author fwgforce
	 * @param date
	 * @return
	 */
	public String getStringDate(Long date) {
		Calendar c = Calendar.getInstance();
		Long year = 0L;// 需加的年份
		Long dayleft = date;// 总天数
		String datetime = "";// 返回日期
		if (date > 367) {// 相对1900-1-1差额天数
			date = date - 367;
			for (long i = 1;; i++) {
				Long s = i + 1900;
				Integer valueOf = Integer.valueOf(s.toString());
				c.set(valueOf, 1, 29);
				int m = c.get(Calendar.MONTH) + 1;
				if (m == 2) {
					date -= 366;
				} else {
					date -= 365;
				}
				year = i;
				if (date < 0) {
					if (m == 2) {
						dayleft = date + 366;
					} else {
						dayleft = date + 365;
					}
					break;
				}

			}
			Long left = 0L;// 剩余天数
			Long month = 0L;// 需加月份
			for (long j = 1; j < 13; j++) {
				Long daynext = Long.valueOf(getEndDay(year.toString(),
						((Long) j).toString()));
				dayleft -= daynext;
				if (dayleft < 0) {
					month = j - 1;
					left = dayleft + daynext;
					break;
				}

			}
			datetime = ((Long) (1900 + year)).toString() + "-"
					+ ((Long) (1 + month)).toString() + "-"
					+ ((Long) (left + 1)).toString();

		}
		return dateStr2(datetime);
	}

	/**
	 * 判断导入报表日期(年、月)与所选日期是否一致
	 * 
	 * @author fwgforce
	 * 
	 * @param date
	 *            表日期
	 * @param selectyear
	 *            所选年份
	 * @param selectmonth
	 *            所选季度
	 * @return
	 */
	@SuppressWarnings("deprecation")
	public boolean isTrueDate(Date date, String selectyear, String selectquarter) {
		Integer year = date.getYear() + 1900;
		Integer month = date.getMonth() + 1;
		String whichQuarter = isWhichQuarter(month);// 当前月季度
		Integer selectYear = Integer.valueOf(selectyear);
		if (year.equals(selectYear) && whichQuarter.equals(selectquarter)) {
			return true;
		}

		return false;

	}

	/**
	 * 将数字月转换成字符串季度(2转换成"第二季度")
	 * 
	 * @author fwgforce
	 * @param month
	 * @return
	 */
	public String isWhichQuarter(int month) {
		String quarter = "";
		switch (month) {
		case 1:
		case 2:
		case 3:
			quarter = "第一季度";
			break;
		case 4:
		case 5:
		case 6:
			quarter = "第二季度";
			break;
		case 7:
		case 8:
		case 9:
			quarter = "第三季度";
			break;
		case 10:
		case 11:
		case 12:
			quarter = "第四季度";
			break;

		default:
			break;
		}
		return quarter;
	}

	/*	*//**
			 * 判断所导报表与所选单位是否一致
			 * 
			 * @author fwgforce
			 * @param companyName
			 * @param getCellName
			 * @return
			 */
	/*
	 * public boolean isTrueCompanyName(String companyName, String getCellName) {
	 * if (companyName.equals(getCellName)) { return true; } return false; }
	 */

	/**
	 * 判断用户所导报表日期是否和所选日期一致
	 * 
	 * @author fwgforce
	 * @param wb
	 * @param selectyear
	 * @param selectquarter
	 * @return
	 */
	public boolean isTrueQuarter(Workbook wb, String selectyear,
			String selectquarter) {
		boolean right = true;
		for (int i = 0; i < 3; i++) {
			Sheet hssfsheet = wb.getSheetAt(i);
			Row hssfrow = hssfsheet.getRow(1);
			if (hssfrow == null) {// 判断Excel表中是否有数据
				right = false;
				break;
			}
			Date date = isNullDate(hssfrow.getCell((short) 0));// 依据西方日期规则获取时间,getExcelDate方法调用
			boolean trueDate = isTrueDate(date, selectyear, selectquarter);
			if (!trueDate) {// 判断所选年,季度与所导报表年,季度是否一致
				right = false;
				break;
			}
		}

		return right;
	}

	/**
	 * 判断该字符串日期是否为JDBC日期格式
	 * 
	 * @author fwgforce
	 * @param s
	 * @return
	 */
	public boolean isDate(String s) {
		boolean t = false;
		if (s != null && !s.equals("")) {
			String[] split = s.split("-");
			if (split.length > 1) {
				t = true;
			}
		} else if (s == null || s.equals("")) {
			t = true;
		}
		return t;

	}


}

 

 ACTION实现类,具体实现:

 

@SuppressWarnings( { "deprecation", "static-access" })
	public String TaxEnterprise() throws IOException {
		HttpServletRequest request = ServletActionContext.getRequest();

		try {
			// 获取excel 文件
			FileInputStream fis = new FileInputStream(upfile);
			// 通过得到的文件输入流inputstream创建一个Wordbook对象
			Workbook wb = null;
			if (flag) {// true为2007 excel版本
				wb = new XSSFWorkbook(fis);
			} else {// false 为2003 excel版本
				wb = new HSSFWorkbook(fis);
			}
			Sheet hssfsheet = wb.getSheetAt(0);// 第一个工作表
			Row hssfrow = hssfsheet.getRow(0);// 第一行
			ChangeMethod cm = new ChangeMethod();
			if (null == hssfrow) {// 判断Excel表中是否有数据
				request.setAttribute("taxNull", 1);// 空数据
				return Action.ERROR;
			} else {
				// Cell hssfCell = hssfrow.getCell((short) 0);// 获取首行首列的日期元素
				// String str = hssfCell.toString();
				// Date date=cm.getExcelDate(str);//
				// 依据西方日期规则获取时间,getExcelDate方法调用
				// 根据isTrue值判断是否对数据库操作
				// if (date.toString().equals(cm.dateStr(str))) {//判断首行日期是否正确
				int length = 0;

				// 遍历该行所有的行,j表示行数 getPhysicalNumberOfRows行的总数
				for (int j = 1; j < hssfsheet.getPhysicalNumberOfRows()
						+ length; j++) {
					input = j;
					hssfrow = hssfsheet.getRow(j);
					// 判断是否还存在需要导入的数据
					if (null == hssfrow) {
						length++;
						continue;
					}
					// 循环插入当前row的对象属性
					if (!"".equals(hssfrow.getCell((short) 0))) {
						// 企业注册信息表
						String ERegNo = cm.isNullStr((hssfrow
								.getCell((short) 1)));// 注册号
						String EName = cm.isNullStr(hssfrow.getCell((short) 0));// 获取企业名称
						ename = EName;
						Enterprise enterpriseByOne = entService
								.getEnterpriseByNo(EName, ERegNo);
						Enterprise ent = new Enterprise();
						if (null != enterpriseByOne) {
							ent = enterpriseByOne;
						}
						// 如果税表里存在当前月份的税表信息就更新

						ERegNo = cm.isNullStr(hssfrow.getCell((short) 1));// 获取注册号
						String EManager = cm.isNullStr(hssfrow
								.getCell((short) 2));// 获取负责人
						rownumber = 4;
						Date ESetupDate = cm.isNullDate(hssfrow
								.getCell((short) 3));// 获取成立日期
						rownumber = 5;
						BigDecimal ERegisteredCapital = cm
								.isNullBigDecimal(((hssfrow.getCell((short) 4))));// 获取注册资金
						String EAddress = cm.isNullStr(hssfrow
								.getCell((short) 5));// 获取住所地址
						String ETel = cm.isNullStr(hssfrow.getCell((short) 6));// 获取电话
						String EBusinessScope = cm.isNullStr(hssfrow
								.getCell((short) 7));// 获取经营范围
						rownumber = 9;
						Date EStartDate = cm.isNullDate(hssfrow
								.getCell((short) 8));// 获取营业日期(起)
						rownumber = 10;
						Date EEndDate = cm.isNullDate(hssfrow
								.getCell((short) 9));// 营业日期(止)
						String ETrade = cm.isNullStr(hssfrow
								.getCell((short) 10));// 所属行业
						String ETradeNo = cm.isNullStr(hssfrow
								.getCell((short) 11));// 行业编码
						String ERegGov = cm.isNullStr(hssfrow
								.getCell((short) 12));// 登记机关
						String EManageGov = cm.isNullStr(hssfrow
								.getCell((short) 13));// 管辖机关
						String EBusinessPlace = cm.isNullStr(hssfrow
								.getCell((short) 14));// 工商所
						rownumber = 16;
						Date EConfirmDate = cm.isNullDate(hssfrow
								.getCell((short) 15));// 核准日期
						String EType = cm
								.isNullStr(hssfrow.getCell((short) 16));// 企业类型(市局)
						String EState = cm.isNullStr(hssfrow
								.getCell((short) 17));// 企业状态(市局)
						String EBusinessPlaceMemo = cm.isNullStr(hssfrow
								.getCell((short) 18));// 工商所备注
						String EHotTrade = cm.isNullStr(hssfrow
								.getCell((short) 19));// 重热点行业
						String ESupplierType = cm.isNullStr(hssfrow
								.getCell((short) 20));// 经营户类别
						rownumber = 22;
						Date EAdddate = cm.isNullDate(hssfrow
								.getCell((short) 21));// 加入日期
						rownumber = 23;
						Date EUpdatedate = cm.isNullDate(hssfrow
								.getCell((short) 22));// 更新日期
						String EBname = cm.isNullStr(hssfrow
								.getCell((short) 23));// 住所写字楼
						String ERoomNo = cm.isNullStr(hssfrow
								.getCell((short) 24));// 楼层房间号
						String ELinkman = cm.isNullStr(hssfrow
								.getCell((short) 25));// 联系人
						String ELinkTel = cm.isNullStr(hssfrow
								.getCell((short) 26));// 联系电话
						String EPlaceType = cm.isNullStr(hssfrow
								.getCell((short) 27));// 住所管理分类
						String EPlaceMark = cm.isNullStr(hssfrow
								.getCell((short) 28));// 住所标注
						String ERealityAddress = cm.isNullStr(hssfrow
								.getCell((short) 29));// 实际经营地址
						String ERealityTel = cm.isNullStr(hssfrow
								.getCell((short) 30));// 实际联系电话
						String ERealityType = cm.isNullStr(hssfrow
								.getCell((short) 31));// 实际经营地分类
						String ERealityStatus = cm.isNullStr(hssfrow
								.getCell((short) 32));// 实际经营地状况
						String ERealityBuilding = cm.isNullStr(hssfrow
								.getCell((short) 33));// 实际经营地所在写字楼
						String ERealityArea = cm.isNullStr(hssfrow
								.getCell((short) 34));// 实际经营地面积
						String ERealityReason = cm.isNullStr(hssfrow
								.getCell((short) 35));// 异地经营原因
						String ERealityMemo = cm.isNullStr(hssfrow
								.getCell((short) 36));// 异地经营备注
						BigDecimal ERealityIncome = cm
								.isNullBigDecimal((hssfrow.getCell((short) 37)));// 实收资本
						String EType2 = cm.isNullStr(hssfrow
								.getCell((short) 38));// 企业类型
						String EProperties = cm.isNullStr(hssfrow
								.getCell((short) 39));// 经营主体性质
						String EPermision = cm.isNullStr(hssfrow
								.getCell((short) 40));// 前置许可
						String ETradeType = cm.isNullStr(hssfrow
								.getCell((short) 41));// 行业分类
						String e3mark = cm.isNullStr(hssfrow
								.getCell((short) 42));// 三区标注
						String ERegionName = cm.isNullStr(hssfrow
								.getCell((short) 43));// 园区名称
						String ETaxGov = cm.isNullStr(hssfrow
								.getCell((short) 44));// 缴税机关名称
						String EZentLimit = cm.isNullStr(hssfrow
								.getCell((short) 45));// 租赁协议期限
						String EPlaceStatus = cm.isNullStr(hssfrow
								.getCell((short) 46));// 住所状态
						String EFoodSafe = cm.isNullStr(hssfrow
								.getCell((short) 47));// 食品安全监管
						String EImportantRegion = cm.isNullStr(hssfrow
								.getCell((short) 48));// 重点地域
						String EAd = cm.isNullStr(hssfrow.getCell((short) 49));// 广告情况
						String ELogo = cm
								.isNullStr(hssfrow.getCell((short) 50));// 商标情况
						// 插入操作
						ent.setERegNo(ERegNo);
						ent.setE3mark(e3mark);
						ent.setEAd(EAd);
						if (null != EAdddate) {
							ent.setEAdddate(EAdddate);
						}
						ent.setEAddress(EAddress);
						ent.setEBusinessPlace(EBusinessPlace);
						ent.setEBusinessScope(EBusinessScope);
						if (null != EConfirmDate) {
							ent.setEConfirmDate(EConfirmDate);
						}
						if (null != EEndDate) {
							ent.setEEndDate(EEndDate);
						}
						ent.setEFoodSafe(EFoodSafe);
						ent.setEHotTrade(EHotTrade);
						ent.setEImportantRegion(EImportantRegion);
						ent.setELinkman(ELinkman);
						ent.setELinkTel(ELinkTel);
						ent.setELogo(ELogo);
						ent.setEManageGov(EManageGov);
						ent.setEManager(EManager);
						ent.setEName(EName);
						ent.setEPermision(EPermision);
						ent.setEPlaceMark(EPlaceMark);
						ent.setEPlaceStatus(EPlaceStatus);
						ent.setEPlaceType(EPlaceType);
						ent.setEProperties(EProperties);
						ent.setERealityAddress(ERealityAddress);
						ent.setERealityArea(ERealityArea);
						if (ERealityBuilding.equals("台儿庄路6、7号(原9号)")) {
							ERealityBuilding = "六号院创意产业园";
						}
						ent.setERealityBuilding(ERealityBuilding);
						if (null != ERealityIncome) {
							ent.setERealityIncome(ERealityIncome);
						}
						ent.setERealityMemo(ERealityMemo);
						ent.setERealityReason(ERealityReason);
						ent.setERealityStatus(ERealityStatus);
						ent.setERealityTel(ERealityTel);
						ent.setERealityType(ERealityType);
						ent.setERegGov(ERegGov);
						ent.setETel(ETel);
						ent.setETrade(ETrade);
						ent.setETradeNo(ETradeNo);
						ent.setETradeType(ETradeType);
						ent.setEType(EType);
						ent.setEType2(EType2);
						if (null != EUpdatedate) {
							ent.setEUpdatedate(EUpdatedate);
						}
						ent.setEZentLimit(EZentLimit);
						ent.setERegionName(ERegionName);
						if (null != ESetupDate) {
							ent.setESetupDate(ESetupDate);
						}
						if (null != EStartDate) {
							ent.setEStartDate(EStartDate);
						}
						ent.setESupplierType(ESupplierType);
						ent.setEState(EState);
						ent.setEBusinessPlaceMemo(EBusinessPlaceMemo);
						ent.setETaxGov(ETaxGov);
						ent.setERoomNo(ERoomNo);
						if (null != ERegisteredCapital) {
							ent.setERegisteredCapital(ERegisteredCapital);
						}
						ent.setEBName(EBname);
						if (null != ERealityBuilding
								&& !"".equals(ERealityBuilding)) {
							ent.setEBId(taxLicenseService
									.getBuildId(ERealityBuilding));
						} else {
							if (null != EBname && !"".equals(EBname)) {
								ent.setEBId(taxLicenseService
										.getBuildId(EBname));
							}
						}
						ent.setIsSimpleEnt("否");
						ent.setIsOff("否");
						if (null != enterpriseByOne) { // 如果数据库存在该对象则进行更新,否则执行else语句
							entService.updateEnterprise(ent);
						} else {
							entService.addEnterprise(ent);
						}
					}

				}
				return Action.SUCCESS;
			}
		} catch (Exception e) {
			request.setAttribute("importFalse", "taxEnterprise");
			if (input > 0) {
				throw new RuntimeException("第" + (input + 1) + "行,第"
						+ rownumber + "列数据格式有误!企业名称:" + ename + "", e);
			} 
		}
		return Action.SUCCESS;
	}

 

   提供支持03,07通用版本的POI3.6  jar包下载 !

1
2
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics