package com.highsoft.bus;

import java.util.ArrayList;
import java.util.List;

import com.highsoft.bo.BoSql;
import com.highsoft.dao.Dao;
import com.highsoft.dao.DaoDB7;
import com.highsoft.item.ReadXml;
import com.highsoft.po.XmlBean;

public class Bus {
	
	public String start()
	{
		BackupDB2 back=new BackupDB2();
		boolean flag=false;
		boolean delflag=false;
		BoSql bs=new BoSql();
		DaoDB7 dao=new DaoDB7();
		ReadXml rx=new ReadXml();
		List db7list=rx.Readdb7();
		List db8list=rx.Readdb8();
		List resultlist=new ArrayList();
		StringBuffer sb=new StringBuffer();
		for (int i = 0; i < db7list.size(); i++) {
			//要讀取的表
			XmlBean xb=(XmlBean) db7list.get(i);
			XmlBean xb8=(XmlBean) db8list.get(i);
			String delsql=bs.del(xb8.getName());
			System.out.println("要刪除的表為:"+delsql);
			delflag=back.deldate(delsql);
			if(delflag=false)
			{
				return "清空數據出錯,請重新執行.或手動把數據清空";
			}
			//得到要插入的數據
			resultlist=dao.select(bs.select(xb.getName(), xb.getValues()));
			
			//把得到的數據傳入此方法
			bs.Insert(xb8.getName(), xb8.getValues(), resultlist, xb.getValues());
			
			//清空list，不知道有沒有用
			resultlist.clear();
			System.out.println("當前結果集里有 "+resultlist.size()+" 條數據");
		}
		resultlist.clear();
		return "數據已全部導入成功...............";
	}

	public static void main(String[] args) {
		Bus b=new Bus();
		BackupDB2 back=new BackupDB2();
		Zip zip=new Zip();
		List list=back.Backup();
		String path=(String) list.get(0);
		String name=(String) list.get(1);
		boolean flag=zip.createzip(path, name);
		if(flag)
		{
			System.out.println(b.start());
		}
		
	}
}