package shiping;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
import DataBase.DatabaseManagement;
|
import Method.GetNowTime;
|
@SuppressWarnings("rawtypes")
|
public class Dell_shiping {
|
|
//ÊÓÆµ¶ÔÏóµÄ¼¯ºÏ
|
static Vector<tb_shipin> shiping_vector=new Vector<tb_shipin>();
|
static {
|
Iterator iterator = DatabaseManagement.get_alldate_indatabase("tb_shipin").iterator();
|
while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËØ¸øµ½info¼¯ºÏ
|
tb_shipin sp=new tb_shipin();
|
sp.setId((String) info.get(0));
|
sp.setFencename((String) info.get(1));
|
sp.setShebeiid((String) info.get(2));
|
sp.setTongdaoid((String) info.get(3));
|
sp.setAddtime((String) info.get(4));
|
sp.setPosx((String) info.get(5));
|
sp.setPosy((String) info.get(6));
|
sp.setPosz((String) info.get(7));
|
sp.setFloor((String) info.get(8));
|
sp.setName((String) info.get(9));
|
sp.setBaoliu1((String) info.get(10));
|
sp.setBaoliu2((String) info.get(11));
|
sp.setBaoliu3((String) info.get(12));
|
sp.setBaoliu4((String) info.get(13));
|
sp.setBaoliu5((String) info.get(14));
|
sp.setBaoliu6((String) info.get(15));
|
sp.setBaoliu7((String) info.get(16));
|
shiping_vector.add(sp);
|
}
|
}
|
|
|
public static Vector<tb_shipin> getShiping_vector() {
|
return shiping_vector;
|
}
|
|
|
/**ͨ¹ýÉ豸idÕÒµ½Ä³¸öÉ豸*/
|
public static tb_shipin get_tb_shipin(String Shebeiid) {
|
tb_shipin sp=null;
|
if(shiping_vector.size() !=0) {
|
Iterator<tb_shipin> it=shiping_vector.iterator();
|
while(it.hasNext()) {
|
tb_shipin sp1=it.next();
|
String Shebeiid1=sp1.getShebeiid();
|
if(Shebeiid.equals(Shebeiid1)) {
|
sp=sp1;
|
break;
|
}
|
}
|
}
|
return sp;
|
}
|
|
/**Ìí¼ÓÒ»¸öÊÓÆµ¶ÔÏó*/
|
public static void add(
|
String fencename,//ÊÓÆµ×÷ÓÃÇøÓòÃû³Æ
|
String shebeiid,//É豸±àºÅ
|
String tongdaoid,//ͨµÀID
|
String posx,//ÊÓÆµ°²×°X×ø±ê
|
String posy,//ÊÓÆµ°²×°Y×ø±ê
|
String posz,//ÊÓÆµ°²×°Z×ø±ê
|
String floor,//ÊÓÆµËùÔÚ²ã
|
String name
|
) {
|
|
if(get_tb_shipin(shebeiid)==null) {
|
tb_shipin sp=new tb_shipin();
|
sp.setFencename(fencename);//ÊÓÆµ×÷ÓÃÇøÓòÃû³Æ
|
sp.setShebeiid(shebeiid);//É豸±àºÅ
|
sp.setTongdaoid(tongdaoid);//ͨµÀID
|
sp.setPosx(posx);//ÊÓÆµ°²×°X×ø±ê
|
sp.setPosy(posy);//ÊÓÆµ°²×°Y×ø±ê
|
sp.setPosz(posz);//ÊÓÆµ°²×°Z×ø±ê
|
sp.setFloor(floor);//ÊÓÆµËùÔÚ²ã
|
sp.setName(name);
|
shiping_vector.add(sp);
|
String addtime=GetNowTime.now();
|
String[] ziduan= {"fencename","shebeiid","tongdaoid","addtime","posx","posy","posz","floor","name"};
|
String[] zhi= {fencename,shebeiid,tongdaoid,addtime,posx,posy,posz,floor,name};
|
DatabaseManagement.insertfast("tb_shipin", ziduan, zhi);
|
}
|
|
}
|
|
/**ÐÞ¸ÄÒ»¸öÊÓÆµ¶ÔÏó*/
|
public static void alert(
|
String fencename,//ÊÓÆµ×÷ÓÃÇøÓòÃû³Æ
|
String shebeiid,//É豸±àºÅ
|
String tongdaoid,//ͨµÀID
|
String posx,//ÊÓÆµ°²×°X×ø±ê
|
String posy,//ÊÓÆµ°²×°Y×ø±ê
|
String posz,//ÊÓÆµ°²×°Z×ø±ê
|
String floor,//ÊÓÆµËùÔÚ²ã
|
String name
|
) {
|
|
if(get_tb_shipin(shebeiid) !=null) {
|
get_tb_shipin(shebeiid).setFencename(fencename);//ÊÓÆµ×÷ÓÃÇøÓòÃû³Æ
|
get_tb_shipin(shebeiid).setTongdaoid(tongdaoid);//ͨµÀID
|
get_tb_shipin(shebeiid).setPosx(posx);//ÊÓÆµ°²×°X×ø±ê
|
get_tb_shipin(shebeiid).setPosy(posy);//ÊÓÆµ°²×°Y×ø±ê
|
get_tb_shipin(shebeiid).setPosz(posz);//ÊÓÆµ°²×°Z×ø±ê
|
get_tb_shipin(shebeiid).setFloor(floor);//ÊÓÆµËùÔÚ²ã
|
get_tb_shipin(shebeiid).setName(name);
|
String addtime=GetNowTime.now();
|
String[] ziduan= {"fencename","tongdaoid","addtime","posx","posy","posz","floor","name","shebeiid"};
|
String[] zhi= {fencename,tongdaoid,addtime,posx,posy,posz,floor,name,shebeiid};
|
DatabaseManagement.fast_alert_dbase("tb_shipin", ziduan, zhi);
|
}
|
|
}
|
|
/**ɾ³ýÒ»¸öÊÓÆµ¶ÔÏó*/
|
public static void delete(String shebeiid) {
|
if(get_tb_shipin(shebeiid) !=null) {
|
shiping_vector.removeElement(get_tb_shipin(shebeiid));
|
}
|
|
}
|
|
/**ɾ³ýËùÓÐÒ»¸öÊÓÆµ¶ÔÏó*/
|
public static void deleteall() {
|
if(shiping_vector.size() !=0) {
|
shiping_vector.removeAllElements();
|
String deleteall="TRUNCATE TABLE tb_shipin";
|
DatabaseManagement.update(deleteall) ;
|
}
|
}
|
|
/**Ìí¼ÓÒ»¸öÊÓÆµ¶ÔÏó*/
|
public static void add2(
|
String fencename,//ÊÓÆµ×÷ÓÃÇøÓòÃû³Æ
|
String shebeiid,//É豸±àºÅ
|
String tongdaoid,//ͨµÀID
|
String posx,//ÊÓÆµ°²×°X×ø±ê
|
String posy,//ÊÓÆµ°²×°Y×ø±ê
|
String posz,//ÊÓÆµ°²×°Z×ø±ê
|
String floor,//ÊÓÆµËùÔÚ²ã
|
String name
|
) {
|
|
if(get_tb_shipin(shebeiid)==null) {
|
tb_shipin sp=new tb_shipin();
|
sp.setFencename(fencename);//ÊÓÆµ×÷ÓÃÇøÓòÃû³Æ
|
sp.setShebeiid(shebeiid);//É豸±àºÅ
|
sp.setTongdaoid(tongdaoid);//ͨµÀID
|
sp.setPosx(posx);//ÊÓÆµ°²×°X×ø±ê
|
sp.setPosy(posy);//ÊÓÆµ°²×°Y×ø±ê
|
sp.setPosz(posz);//ÊÓÆµ°²×°Z×ø±ê
|
sp.setFloor(floor);//ÊÓÆµËùÔÚ²ã
|
sp.setName(name);
|
shiping_vector.add(sp);
|
}
|
|
}
|
|
/**ÐÞ¸ÄÒ»¸öÊÓÆµ¶ÔÏó*/
|
public static void alert2(
|
String fencename,//ÊÓÆµ×÷ÓÃÇøÓòÃû³Æ
|
String shebeiid,//É豸±àºÅ
|
String tongdaoid,//ͨµÀID
|
String posx,//ÊÓÆµ°²×°X×ø±ê
|
String posy,//ÊÓÆµ°²×°Y×ø±ê
|
String posz,//ÊÓÆµ°²×°Z×ø±ê
|
String floor,//ÊÓÆµËùÔÚ²ã
|
String name
|
) {
|
|
if(get_tb_shipin(shebeiid) !=null) {
|
get_tb_shipin(shebeiid).setFencename(fencename);//ÊÓÆµ×÷ÓÃÇøÓòÃû³Æ
|
get_tb_shipin(shebeiid).setTongdaoid(tongdaoid);//ͨµÀID
|
get_tb_shipin(shebeiid).setPosx(posx);//ÊÓÆµ°²×°X×ø±ê
|
get_tb_shipin(shebeiid).setPosy(posy);//ÊÓÆµ°²×°Y×ø±ê
|
get_tb_shipin(shebeiid).setPosz(posz);//ÊÓÆµ°²×°Z×ø±ê
|
get_tb_shipin(shebeiid).setFloor(floor);//ÊÓÆµËùÔÚ²ã
|
get_tb_shipin(shebeiid).setName(name);
|
}
|
|
}
|
|
|
/**ɾ³ýËùÓÐÒ»¸öÊÓÆµ¶ÔÏó*/
|
public static void deleteall2() {
|
if(shiping_vector.size() !=0) {
|
shiping_vector.removeAllElements();
|
}
|
}
|
|
|
|
|
|
|
}
|