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

@SuppressWarnings("rawtypes")
public class Dell_tagpower {
	static Vector<tagpower> tagpower_vector = new Vector<tagpower>();// ±êÇ©µÄ¼¯ºÏ
	static {
		String sql = "select * from tb_tagpower ";		
		Iterator iterator = DatabaseManagement.serch(sql).iterator();
		while (iterator.hasNext()) {// µü´úÆ÷´æÔÚÔªËØ
			List info = (List) iterator.next();// ½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			tagpower tp=new tagpower();
			tp.setTagid((String)info.get(1));
			tp.setPower((String)info.get(2));
			tp.setTime((String)info.get(3));
			tp.setHz((String)info.get(4));
			tp.setName((String)info.get(5));
			tagpower_vector .add(tp);
		}
	}
	
	/** ͨ¹ý±êÇ©id»ñȡijһ¸ö±êÇ©¶ÔÏó */
	public static tagpower get_tag(String tagid) {
		tagpower tag = null;
		if (tagpower_vector.size() != 0) {
			Iterator<tagpower> it = tagpower_vector.iterator();
			while (it.hasNext()) {
				tagpower tag1 = it.next();
				String idtag = tag1.getTagid();
				if (tagid.equals(idtag)) {
					tag = tag1;
					break;
				}
			}
		}

		return tag;
	}
	
	
	/**ɾ³ýÊý¾Ý¿âÖÐij¸ö±êÇ©*/
	public static void delte(String tagid) {
		if(get_tag(tagid) !=null) {
			tagpower_vector.removeElement(get_tag(tagid));
			String deleteSql="DELETE FROM tb_tagpower WHERE tagid='"+tagid+"'";
			DatabaseManagement.update(deleteSql);
		}
	}
	
	/**ÐÂÔöÒ»¸ö±êÇ©**/
	public static void add(String tagid,String name,String hz,String power) {
		if(get_tag(tagid) ==null) {
			tagpower tp=new tagpower();
			tp.setTagid(tagid);
			String time=GetNowTime.now();
			tp.setTime(time);
			tp.setName(name);
			tp.setHz(hz);
			tp.setPower(power);
			tagpower_vector.add(tp);			
			String[]  ziduan= {"tagid","power","time","hz","name" };
			String[] zhi= {tagid,power,time,hz,name };
			DatabaseManagement.insertfast("tb_tagpower", ziduan, zhi);
			
		}
	}
	
	/**ɾ³ýÈ«²¿±êÇ©*/
	public static void delteall() {
			tagpower_vector.removeAllElements();
			String deleteSql="TRUNCATE TABLE tb_tagpower";
			DatabaseManagement.update(deleteSql);
	}


	public static Vector<tagpower> getTagpower_vector() {
		return tagpower_vector;
	}
	
}