<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
'-//Hibernate/Hibernate Configuration DTD 3.0//EN'
'http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd'>
<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>
<session-factory>
<property name='dialect'>
org.hibernate.dialect.MySQLDialect
</property>
<property name='connection.url'>
jdbc:mysql://localhost:3306/scgl?characterEncoding=utf-8
</property>
<property name='connection.username'>root</property>
<property name='connection.password'>fen</property>
<property name='connection.driver_class'>
com.mysql.jdbc.Driver
</property>
<property name='myeclipse.connection.profile'>mysql</property>
<property name='show_sql'>true</property>
<mapping resource='com/scgl/pojo/TblBadpro.hbm.xml' />
<mapping resource='com/scgl/pojo/SysCode.hbm.xml' />
<mapping resource='com/scgl/pojo/TblManager.hbm.xml' />
<mapping resource='com/scgl/pojo/TblCustomer.hbm.xml' />
<mapping resource='com/scgl/pojo/TblWork.hbm.xml' />
<mapping resource='com/scgl/pojo/TblProduce.hbm.xml' />
<mapping resource='com/scgl/pojo/TblGoods.hbm.xml' />
<mapping resource='com/scgl/pojo/TblOrder.hbm.xml' />
</session-factory>
</hibernate-configuration>
/**
* 保存顾客信息
* @param customer
* @return 返货顾客id
*/
public static int savecustomer(TblCustomer customer){
CustomerDao cdao=new CustomerDao();
cdao.saveOrUpdateObject(customer);
String hql='select max(id) from TblCustomer';
return (Integer)cdao.getList(hql).get(0);
}
//保存订单
public static void saveorder(TblOrder order){
OrderDao dao=new OrderDao();
dao.saveObject(order);
}
//保存生产信息
public static void saveproduce(TblProduce produce){
OrderDao dao=new OrderDao();
dao.saveObject(produce);
}
public String execute() throws Exception {
Workbook workbook=createWorkBook(new FileInputStream(excelFile));
Sheet sheet=workbook.getSheetAt(0);
excelWorkSheet=new ExcelWorkSheet<ImportBean>();
//保存工作单名称
excelWorkSheet.setSheetName(sheet.getSheetName());
Row firstRow=sheet.getRow(0);
Iterator<Cell> iterator=firstRow.iterator();
//保存列名
List<String> cellNames=new ArrayList<String>();
while(iterator.hasNext()){
cellNames.add(iterator.next().getStringCellValue());
}
excelWorkSheet.setColumns(cellNames);
for(int i=1;i<sheet.getLastRowNum();i++){
Row row=sheet.getRow(i);
ImportBean ibean=new ImportBean();
ibean.setId((int)row.getCell(0).getNumericCellValue());
ibean.setCname(row.getCell(1).getStringCellValue());
ibean.setCaddress(row.getCell(2).getStringCellValue());
String phone=String.valueOf((long)row.getCell(3).getNumericCellValue());
ibean.setCphone(String.valueOf(phone));
ibean.setGid((int)row.getCell(4).getNumericCellValue());
ibean.setGnumber((int)row.getCell(5).getNumericCellValue());
excelWorkSheet.getData().add(ibean);
}
//开始将数据存入数据库
int oid=0;
int cid=0;
for(int i=0;i<excelWorkSheet.getData().size();i++){
TblOrder order=new TblOrder();
TblCustomer customer=new TblCustomer();
TblProduce produce=new TblProduce();
ImportBean ibean=excelWorkSheet.getData().get(i);
if(!ibean.getId().equals(0)){
//开始保存顾客信息
customer.setName(ibean.getCname());
customer.setAddress(ibean.getCaddress());
customer.setPhone(ibean.getCphone());
cid=savecustomer(customer);
//开始保存订单
order.setId(ibean.getId());
order.setCid(cid);
order.setRank(0);
Calendar now=Calendar.getInstance();
order.setCretime(DateHelper.getStringFt3(now.getTime()));
order.setStatu('未确定');
saveorder(order);
oid=ibean.getId();
}produce.setId(String.valueOf(oid)+String.valueOf(ibean.getGid()));
produce.setOid(oid);
produce.setGid(ibean.getGid());
produce.setGnumber(ibean.getGnumber());
produce.setStatu(Short.valueOf('0'));
saveproduce(produce);
}
return SUCCESS;
}
public class ExcelWorkSheet<T> {
private String sheetName;//工作单名称
private List<T> data=new ArrayList<T>();//数据行
private List<String> columns;//列名
public String getSheetName() {
return sheetName;
}
public void setSheetName(String sheetName) {
this.sheetName = sheetName;
}
public List<T> getData() {
return data;
}
public void setData(List<T> data) {
this.data = data;
}
public List<String> getColumns() {
return columns;
}
public void setColumns(List<String> columns) {
this.columns = columns;
}
public class ImportBean {
//订单号
private Integer id;
//顾客名字
private String cname;
//联系地址
private String caddress;
//手机号
private String cphone;
//货号
private Integer gid;
//数目
private Integer gnumber;
public Integer getId() {
return id;}
public void setId(Integer id) {
this.id = id;}
public String getCname() {
return cname;}
public void setCname(String cname) {
this.cname = cname;}
public String getCaddress() {
return caddress;}
public void setCaddress(String caddress) {
this.caddress = caddress;}
public String getCphone() {
return cphone;}
public void setCphone(String cphone) {
this.cphone = cphone;}
public Integer getGid() {
return gid;}
public void setGid(Integer gid) {
this.gid = gid;}
public Integer getGnumber() {
return gnumber;}
public void setGnumber(Integer gnumber) {
this.gnumber = gnumber;
}
