package tbDataModel_Dell;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
import Frame.BaoWenHuiFang;
import Method.TiemDell;
import tbDataModel.YuanShiBaoWen;
public class DellYuanshibaowen {

	static Vector<YuanShiBaoWen> vcysbw=new Vector<YuanShiBaoWen>();


	@SuppressWarnings("rawtypes")
	/**»ñȡԭʼ±¨ÎĵÄÊý¾Ý¼¯ºÏ*/
	public static void get_ysbw(){
			String time="";
			long cha=0;
			int i=0;
			String sql="select * from tb_yuan_shi_bao_wen ";
			if(!BaoWenHuiFang.getStatrtime().equals(BaoWenHuiFang.getStoptime())) {
				sql="SELECT * FROM tb_yuan_shi_bao_wen WHERE  id BETWEEN '" +
						BaoWenHuiFang.getStatrtime()+"' AND '"+BaoWenHuiFang.getStoptime()+"'";
			}
			
			List list = DatabaseManagement.serch(sql);//½«ÁбíÖÐËùÓнá¹û¼¯¸øµ½list¼¯ºÏ			
			Iterator iterator = list.iterator();//´´½¨µü´úÆ÷

			while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
				List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½list¼¯ºÏ
				YuanShiBaoWen ysbw=new YuanShiBaoWen();
				if(i==0) {
					time=(String)info.get(3);
				}else {				
					cha=TiemDell.getTime(time,(String)info.get(3));
					time=(String)info.get(3);
				}		

				ysbw.setIp((String)info.get(1));
				ysbw.setHex((String)info.get(2));
				ysbw.setTime((String)info.get(3));
				ysbw.setJiange((int) cha);
				vcysbw.add(ysbw);// Ïò±í¸ñ¶ÔÏóÌí¼ÓÐÐÊý¾Ý
				i++;			
				ysbw=null;
				info=null;
			}
	}

	public static Vector<YuanShiBaoWen> getVcysbw() {
		return vcysbw;
	}

	public static void setVcysbw(Vector<YuanShiBaoWen> vcysbw) {
		DellYuanshibaowen.vcysbw = vcysbw;
	}
	
	/**Çå¿Õԭʼ±¨Îĵļ¯ºÏ*/
	public static void clear() {
		vcysbw.removeAllElements();
	}

}