package rtkanchor;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
import DataBase.DatabaseManagement;
|
import Method.GetNowTime;
|
import home.Open_soft_dialog;
|
public class Dell_jizhan {
|
static Vector<Jizhan> jizhan_vector=new Vector<Jizhan>();//²î·Ö»ùÕ¾¶ÔÏóµÄ¼¯ºÏ
|
|
|
/**³õʼ»¯tb_rtkanchorÊý¾Ý±í*/
|
@SuppressWarnings("rawtypes")
|
public static void chushihua_tb_rtkac() {
|
Open_soft_dialog.addara("¼ÓÔØtb_rtkanchor");
|
Iterator iterator = DatabaseManagement.table_base("tb_rtkanchor","DESC", "id").iterator();
|
while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËØ¸øµ½info¼¯ºÏ
|
Jizhan jz=new Jizhan();
|
String acid=(String)info.get(1);
|
String state=(String)info.get(2);
|
String jingdu=(String)info.get(3);
|
String weidu=(String)info.get(4);
|
String gaodu=(String)info.get(5);
|
String posx=(String)info.get(6);
|
String posy=(String)info.get(7);
|
String floor=(String)info.get(8);
|
String distance=(String)info.get(9);
|
String port=(String)info.get(10);
|
String ip=(String)info.get(11);//4G¿¨µØÖ·
|
String gport=(String)info.get(12);//4G¿¨¶Ë¿Ú
|
String time=(String)info.get(22);
|
jz.setAcid(acid);
|
jz.setState(state);
|
jz.setJingdu(jingdu);
|
jz.setWeidu(weidu);
|
jz.setGaodu(gaodu);
|
jz.setPosx(posx);
|
jz.setPosy(posy);
|
jz.setFloor(floor);
|
jz.setDistance(distance);
|
jz.setPort(port);
|
jz.setBaoliu1(ip);
|
jz.setBaoliu2(gport);
|
jz.setAddtime(time);
|
jizhan_vector.add(jz);
|
}
|
}
|
|
/**Ð޸ĻùÕ¾µØÖ·¶Ë¿Ú*/
|
public static void alertiport(String port,String ip,String port1) {
|
Jizhan jz=get_2port_jizhan(port);
|
if(jz !=null) {
|
jz.setBaoliu1(ip);
|
jz.setBaoliu2(port1);
|
jz.setState("ÔÚÏß");
|
jz.setAddtime(GetNowTime.now());
|
}
|
}
|
|
/**ͨ¹ý±êÇ©idÕÒµ½Ä³¸ö»ùÕ¾¶ÔÏó*/
|
public static Jizhan get_jizhan(String acid) {
|
Jizhan jz=null;
|
if(jizhan_vector.size() !=0) {
|
Iterator<Jizhan> it=jizhan_vector.iterator();
|
while(it.hasNext()) {
|
Jizhan jz1=it.next();
|
String idtag=jz1.getAcid();
|
if(acid.equals(idtag)) {
|
jz=jz1;
|
break;
|
}
|
}
|
}
|
return jz;
|
}
|
|
/**ͨ¹ý»ùÕ¾½ÓÊÕ¶Ë¿ÚÕÒµ½Ä³¸ö»ùÕ¾¶ÔÏó*/
|
public static Jizhan get_2port_jizhan(String port) {
|
Jizhan jz=null;
|
if(jizhan_vector.size() !=0) {
|
Iterator<Jizhan> it=jizhan_vector.iterator();
|
while(it.hasNext()) {
|
Jizhan jz1=it.next();
|
String idtag=jz1.getPort();
|
if(port.equals(idtag)) {
|
jz=jz1;
|
break;
|
}
|
}
|
}
|
return jz;
|
}
|
|
/**ͨ¹ý»ùÕ¾IPÕÒµ½Ä³¸ö»ùÕ¾¶ÔÏó*/
|
public static Jizhan get_2ip_jizhan(String ip) {
|
Jizhan jz=null;
|
if(jizhan_vector.size() !=0) {
|
Iterator<Jizhan> it=jizhan_vector.iterator();
|
while(it.hasNext()) {
|
Jizhan jz1=it.next();
|
String idtag=jz1.getBaoliu1();
|
if(ip.equals(idtag)) {
|
jz=jz1;
|
break;
|
}
|
}
|
}
|
return jz;
|
}
|
|
/**ÐÂÔöÒ»¸ö»ùÕ¾¶ÔÏó*/
|
public static void add_ajizhan(
|
String acid,
|
String state,
|
String jingdu,
|
String weidu,
|
String gaodu,
|
String posx,
|
String posy,
|
String floor,
|
String distance,
|
String port) {
|
Jizhan jz=new Jizhan();
|
jz.setAcid(acid);
|
jz.setState(state);
|
jz.setJingdu(jingdu);
|
jz.setWeidu(weidu);
|
jz.setGaodu(gaodu);
|
jz.setPosx(posx);
|
jz.setPosy(posy);
|
jz.setFloor(floor);
|
jz.setDistance(distance);
|
jz.setPort(port);
|
jizhan_vector.add(jz);
|
}
|
|
|
/**ÐÞ¸ÄÒ»¸ö»ùÕ¾¶ÔÏó*/
|
public static void alter_ajizhan(
|
String acid,
|
String jingdu,
|
String weidu,
|
String gaodu,
|
String posx,
|
String posy,
|
String floor,
|
String distance,
|
String port) {
|
if(get_jizhan(acid) !=null) {
|
Jizhan jz=get_jizhan(acid);
|
jz.setAcid(acid);
|
jz.setJingdu(jingdu);
|
jz.setWeidu(weidu);
|
jz.setGaodu(gaodu);
|
jz.setPosx(posx);
|
jz.setPosy(posy);
|
jz.setFloor(floor);
|
jz.setDistance(distance);
|
jz.setPort(port);
|
}
|
|
}
|
/**ɾ³ýij¸ö¶ÔÏó*/
|
public static void delete(String acid) {
|
Jizhan jz=get_jizhan(acid);
|
if(jz !=null) {
|
jizhan_vector.removeElement(jz);
|
String deleteSql="DELETE FROM tb_rtkanchor WHERE acid='"+acid+"'";
|
DatabaseManagement.update(deleteSql);
|
}
|
}
|
|
/**»ñÈ¡²î·Ö»ù×¼Õ¾¶ÔÏóµÄ¼¯ºÏ*/
|
public static Vector<Jizhan> getJizhan_vector() {
|
return jizhan_vector;
|
}
|
|
public static void setJizhan_vector(Vector<Jizhan> jizhan_vector) {
|
Dell_jizhan.jizhan_vector = jizhan_vector;
|
}
|
|
}
|