package data_model;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
public class Dell_door {
	static Vector<Tb_door> Tb_doorvc=new Vector<Tb_door>();
	@SuppressWarnings("rawtypes")
	public static  Vector<Tb_door> getvec() {
		Vector<Tb_door> jiancevc=new Vector<Tb_door>();
		String databasename="tb_door";
			Iterator iterator = DatabaseManagement.table_addtime(databasename,"DESC").iterator();		
			while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
				List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
				Tb_door data=new Tb_door();				 
				String id=(String) info.get(0);  
				String tagid=(String) info.get(1);   
				String anchorid=(String) info.get(2);  
				String distance=(String) info.get(3);  
				String power=(String) info.get(4);   
				String addtime =(String) info.get(5); 
				data.setId(id);  
				data.setTagid(tagid);   
				data.setAnchorid(anchorid);  
				data.setDistance(distance);  
				data.setPower(power);   
				data.setAddtime(addtime); 
				jiancevc.add(data);
			}
			return jiancevc;
	}
	
	public static Vector<Tb_door> serch(String tagid){
		Vector<Tb_door> jiancevc=new Vector<Tb_door>();
		int size=getvec().size();
		for(int i=0;i<size;i++) {
			Tb_door a1=getvec().get(i);
			String tagid1=a1.getTagid();
			if(tagid1.equals(tagid)) {
				jiancevc.add(a1);
			}
		}
		return jiancevc;
	}

	public static Vector<Tb_door> getTb_doorvc() {
		return Tb_doorvc;
	}
	
	public static void insert_tbdoor(String tagid,String anchorid,String distance,String power,String addtime) {
		Tb_door data=new Tb_door();
		data.setTagid(tagid);   
		data.setAnchorid(anchorid);  
		data.setDistance(distance);  
		data.setPower(power);   
		data.setAddtime(addtime); 
		Tb_doorvc.add(data);
		
	}

	public void setTb_doorvc(Vector<Tb_door> tb_doorvc) {
		Tb_doorvc = tb_doorvc;
	}
}