java导入excel数据到mysql_java批量导入excel到Mysql数据库
package com.google.i_sales.service.data;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashSet;
import java.util.List;
import java.util.Locale;
import java.util.Map;
import java.util.Set;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.WorkbookSettings;
import jxl.read.biff.BiffException;
import org.extremecomponents.table.limit.Limit;
import org.hibernate.Criteria;
import org.hibernate.JDBCException;
import org.hibernate.criterion.CriteriaSpecification;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projection;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.hibernate.impl.CriteriaImpl;
import org.springframework.util.Assert;
import org.springside.core.dao.HibernateEntityDao;
import org.springside.core.dao.support.Page;
import org.springside.core.utils.BeanUtils;
import com.google.i_sales.components.acegi.domain.User;
import com.google.i_sales.domain.Business;
import com.google.i_sales.domain.Dcompany;
import com.google.i_sales.domain.MsalesCompany;
import com.google.i_sales.domain.Reject;
import com.google.i_sales.domain.SalesCompany;
import com.google.i_sales.domain.Service;
import com.google.i_sales.domain.TelephoneCompany;
import com.google.i_sales.domain.TradeType;
import com.google.i_sales.domain.UnitInfo;
import com.google.i_sales.domain.Vcompany;
import com.google.i_sales.service.common.BusinessManager;
import com.google.i_sales.service.common.RejectManager;
import com.google.i_sales.service.common.ServiceManager;
import com.google.i_sales.service.common.TradeTypeManager;
import com.google.i_sales.service.msales.MsalesCompanyManager;
import com.google.i_sales.service.sales.DcompanyManager;
import com.google.i_sales.service.sales.SalesCompanyManager;
import com.google.i_sales.service.securit
package com.google.i_sales.service.data; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.util.ArrayList; import java.util.Date; import java.util.HashSet; import java.util.List; import java.util.Locale; import java.util.Map; import java.util.Set; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.WorkbookSettings; import jxl.read.biff.BiffException; import org.extremecomponents.table.limit.Limit; import org.hibernate.Criteria; import org.hibernate.JDBCException; import org.hibernate.criterion.CriteriaSpecification; import org.hibernate.criterion.Order; import org.hibernate.criterion.Projection; import org.hibernate.criterion.Projections; import org.hibernate.criterion.Restrictions; import org.hibernate.impl.CriteriaImpl; import org.springframework.util.Assert; import org.springside.core.dao.HibernateEntityDao; import org.springside.core.dao.support.Page; import org.springside.core.utils.BeanUtils; import com.google.i_sales.components.acegi.domain.User; import com.google.i_sales.domain.Business; import com.google.i_sales.domain.Dcompany; import com.google.i_sales.domain.MsalesCompany; import com.google.i_sales.domain.Reject; import com.google.i_sales.domain.SalesCompany; import com.google.i_sales.domain.Service; import com.google.i_sales.domain.TelephoneCompany; import com.google.i_sales.domain.TradeType; import com.google.i_sales.domain.UnitInfo; import com.google.i_sales.domain.Vcompany; import com.google.i_sales.service.common.BusinessManager; import com.google.i_sales.service.common.RejectManager; import com.google.i_sales.service.common.ServiceManager; import com.google.i_sales.service.common.TradeTypeManager; import com.google.i_sales.service.msales.MsalesCompanyManager; import com.google.i_sales.service.sales.DcompanyManager; import com.google.i_sales.service.sales.SalesCompanyManager; import com.google.i_sales.service.securit