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 tagvc=new Vector(); @SuppressWarnings("rawtypes") public static Vector 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 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 getshebeivc(String tagid){ Vector tagvc1=new Vector(); tb_shebei data =get_tag(tagid); if(data!=null) { tagvc1.add(data); } return tagvc1; } public static Vector getTagvc() { return tagvc; } public static void setTagvc(Vector tagvc) { Dell_shebei.tagvc = tagvc; } }