package data_model;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
import DataBase.DatabaseManagement;
|
import publicclass.GetNowTime;
|
public class Dell_shebei {
|
static Vector<tb_shebei> tagvc=new Vector<tb_shebei>();
|
@SuppressWarnings("rawtypes")
|
public static Vector<tb_shebei> getvec() {
|
String databasename="tb_shebei";
|
Iterator iterator = DatabaseManagement.table_addtime(databasename,"ASC").iterator();
|
while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËØ¸øµ½info¼¯ºÏ
|
tb_shebei data=new tb_shebei();
|
String tagid=(String) info.get(1);
|
String name=(String) info.get(2);
|
String ip=(String) info.get(3);
|
String state="0";
|
String icid=(String) info.get(5);
|
String addtime=(String) info.get(6);
|
String gengxintime=(String) info.get(7);
|
String baoliu1=(String) info.get(8);
|
String baoliu2=(String) info.get(9);
|
data.setTagid(tagid);
|
data.setName(name);
|
data.setIp(ip);
|
data.setState(state);
|
data.setIcid(icid);
|
data.setAddtime(addtime);
|
data.setGengxintime(gengxintime);
|
data.setBaoliu1(baoliu1);
|
data.setBaoliu2(baoliu2);
|
tagvc.add(data);
|
}
|
return tagvc;
|
}
|
|
/** ͨ¹ý±êÇ©id»ñȡijһ¸öÉ豸¶ÔÏó */
|
public static tb_shebei get_tag(String tagid) {
|
tb_shebei tag = null;
|
if (tagvc.size() != 0) {
|
Iterator<tb_shebei> it = tagvc.iterator();
|
while (it.hasNext()) {
|
tb_shebei tag1 = it.next();
|
String idtag = tag1.getTagid();
|
if (tagid.equals(idtag)) {
|
tag = tag1;
|
break;
|
}
|
}
|
}
|
return tag;
|
}
|
|
|
/**²åÈëÒ»¸öÉ豸*/
|
public static void add_shebei(String tagid,String ip,String icid,String name) {
|
tb_shebei data =get_tag(tagid);
|
String time=GetNowTime.now();
|
if(data==null) {
|
tb_shebei data2 =new tb_shebei();
|
data2.setTagid(tagid);
|
data2.setName(name);
|
data2.setIp(ip);
|
data2.setState("1");
|
data2.setIcid(icid);
|
data2.setAddtime(time);
|
data2.setGengxintime(time);
|
tagvc.add(data2);
|
insertdatabase(tagid,ip,icid,time);//²åÈëÊý¾Ý¿â
|
}else {
|
data.setIp(ip);
|
data.setState("1");
|
data.setIcid(icid);
|
data.setGengxintime(time);
|
}
|
}
|
|
/**²åÈëÊý¾Ý½øÈëÊý¾Ý¿â*/
|
public static void insertdatabase(String tagid,String ip,String icid,String time) {
|
String[] ziduan= {"tagid","ip","state","icid","addtime","gengxintime"};
|
String[] zhi= {tagid,ip,"1",icid,time,time};
|
DatabaseManagement.insertfast("tb_shebei", ziduan, zhi);
|
}
|
|
public static Vector<tb_shebei> getshebeivc(String tagid){
|
Vector<tb_shebei> tagvc1=new Vector<tb_shebei>();
|
tb_shebei data =get_tag(tagid);
|
if(data!=null) {
|
tagvc1.add(data);
|
}
|
return tagvc1;
|
}
|
|
public static Vector<tb_shebei> getTagvc() {
|
return tagvc;
|
}
|
public static void setTagvc(Vector<tb_shebei> tagvc) {
|
Dell_shebei.tagvc = tagvc;
|
}
|
|
}
|