package Method;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;

/**±¸·Ý¹Ø¼üÊý¾Ý*/
public class Beifen {

	static Vector<String> benfen=new Vector<String>();
	/**»ñÈ¡±¸·ÝÊý¾ÝµÄ¼¯ºÏ*/
	public static void  Benfen() {
		//±¸·Ý
		tb_data("tb_tag");
		tb_data("tb_achor");
		tb_data("tb_anchor_nearby");
		tb_data("tb_cenggao");
		tb_data("tb_department");
		tb_data("tb_fence");
		tb_data("tb_fence_inout");
		tb_data("tb_forward_data");
		tb_data("tb_icon");
		tb_data("tb_mac");
		tb_data("tb_map");
		tb_data("tb_person");
		tb_data("tb_suanfa");
		tb_data("tb_tongbuanchor");
		tb_data("tb_user");
		StringBuffer str=new StringBuffer();
		for(int i=0;i<benfen.size();i++) {
			str.append(benfen.get(i)+"\n");
		}
		SaveFIleInTxt.bei_fen(str.toString());
		benfen.removeAllElements();
		str=null;
	}
	
	public static void savelog() {
		tb_data("tb_tag");
		tb_data("tb_achor");
		tb_data("tb_anchor_nearby");
		tb_data("tb_cenggao");
		tb_data("tb_department");
		tb_data("tb_fence");
		tb_data("tb_fence_inout");
		tb_data("tb_forward_data");
		tb_data("tb_map");
		tb_data("tb_person");
		tb_data("tb_suanfa");
		tb_data("tb_tongbuanchor");
		StringBuffer str=new StringBuffer();
		for(int i=0;i<benfen.size();i++) {
			str.append(benfen.get(i)+"\n");
		}
		String a="\n---------------ÒÔÏÂÊÇ"+GetNowTime.now()+"±¸·ÝÊý¾Ý---------------";
		SaveFIleInTxt.savelog(a+"\n"+str.toString());
	}


	/**±¸·Ýtb_anchor*/
	@SuppressWarnings("rawtypes")
	public static void tb_data(String tablename) {

		String sql = "select * from "+tablename;
		Iterator iterator = DatabaseManagement.serch(sql).iterator();
		int datalenth=DatabaseManagement.get_columname(tablename).length;
		while (iterator.hasNext()) {// µü´úÆ÷´æÔÚÔªËØ
			StringBuffer message=new StringBuffer();
			List info = (List) iterator.next();// ½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			message.append(tablename+","+info.get(0)+",");
			for(int i=1;i<datalenth;i++) {				
				if(i !=(datalenth-1)) {
					String a=(String) info.get(i);
					if(a==null) {
						a="null";						
					}else if (a.length()<1 ){
						a="null";
					}
					message.append(a+",");
				}else {
					String a=(String) info.get(i);
					if(a==null) {
						a="null";						
					}else if (a.length()<1 ){
						a="null";
					}
					message.append(a);
				}				
			}
			benfen.add(message.toString());
			message=null;

		}

	}

	/**»Ö¸´±¸·ÝµÄÊý¾Ý*/
	public static void huifu(String message) {
		System.out.println(message);
		String[] info=message.split(",");
		String start=info[0];
		huifu(info,start);		
	}


	/**»Ö¸´±íÊý¾ÝµÄ·½·¨*/
	public static void huifu(String[] info,String tablename) {	
		String[] ziduan=DatabaseManagement.get_columname(tablename);
		int size=ziduan.length;
		String[] zhi=new String[size];
		for(int i=0;i<size;i++) {
			zhi[i]=info[i+1];
		}
		String deleteSql="TRUNCATE TABLE "+tablename;	
		DatabaseManagement.update(deleteSql);
		DatabaseManagement.insertfast(tablename, ziduan, zhi);
	}


}