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
经验分享 程序员 微信小程序 职场和发展