package tbDataModel_Dell;
/**´¦ÀíÀúÊ·µçÁ¿µÄ¼¯ºÏ*/

import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
import tbDataModel.AcHispower;
import tbDataModel.Hispower;
public class Dell_hispower {
	static Vector<Hispower> hispower_vec=new Vector<>();
	static Vector<AcHispower> achispower_vec=new Vector<>();

	public static Vector<Hispower> getHispower_vec() {
		return hispower_vec;
	}
	
	/**»ñȡij¸ö±êÇ©µÄÀúÊ·µçÁ¿Êý¾Ý*/
	@SuppressWarnings("rawtypes")
	public static void  insert(String tagid) {
		String sql="select * from tb_history_power where tagid='"+tagid+"'";
		Iterator iterator = DatabaseManagement.serch(sql).iterator();//´´½¨µü´úÆ÷		
		while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ			
			List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			Hispower row = new Hispower();	
			row.setPower(String.valueOf(info.get(2)));
			String data=String.valueOf(info.get(3)).substring(5,10);
			row.setData(data);
			row.setTagid(tagid);
			hispower_vec.add(row);
			}	
	}


	@SuppressWarnings("rawtypes")
	public static void  insert2(String anchorId) {
		String sql="select * from tb_ac_history_power where anchorId='"+anchorId+"'";
		Iterator iterator = DatabaseManagement.serch(sql).iterator();//´´½¨µü´úÆ÷
		while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
			List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			AcHispower row = new AcHispower();
			row.setPower(String.valueOf(info.get(2)));
			String data=String.valueOf(info.get(3)).substring(5,10);
			row.setData(data);
			row.setAnchorid(anchorId);
			achispower_vec.add(row);
		}
	}

}