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;
|
}
|
|
}
|