package engbs;
|
import java.util.Vector;
|
import BaoWen.Dell_55AA01;
|
import DataBase.DatabaseManagement;
|
import Method.GetNowTime;
|
import anchor.Anchor_Dell;
|
import fence.kaoqing.Dell_KaoQing;
|
import person.person_Dell;
|
import tbDataModel_Dell.Tb_Warnig_Dell;
|
|
/**¸ÃÀàÓÃÓÚ¸üÐÂͳ¼ÆÊý¾Ý*/
|
public class Tongji {
|
|
static int yingqingint=0;
|
static int heartnum=0;
|
|
|
static Vector<String> shishiv=new Vector<String>();
|
static Vector<String> tongjiv=new Vector<String>();//ͳ¼ÆÊý¾Ý¿â
|
static {
|
shishiv.add("λÖÃ");
|
shishiv.add("ÒýÇæ");
|
shishiv.add("¿¼ÇÚ");
|
|
for(int i=0;i<9;i++) {
|
tongjiv.add(i+1+"");
|
}
|
}
|
|
|
|
public static void gengxin() {
|
String time=GetNowTime.now();
|
Vector<String> id=new Vector<String>();
|
Vector<String> num=new Vector<String>();
|
Vector<String> time1=new Vector<String>();
|
|
Vector<String> num2=new Vector<String>();
|
Vector<String> time2=new Vector<String>();
|
|
int online_num=person_Dell.get_online_person();//ÔÚÏß
|
int off_online=person_Dell.getPerson_vector().size()-online_num;//ÀëÏß
|
int anchor_online_num=Anchor_Dell .get_online_anchornum()[0];//»ùÕ¾ÔÚÏßÊýÁ¿
|
int anchor_online_off=Anchor_Dell .get_online_anchornum()[1];//»ùÕ¾ÀëÏßÊýÁ¿
|
int onlinecar=person_Dell.get_online_car()[0];//ÔÚÏß³µÁ¾
|
int offcar=person_Dell.get_online_car()[1];//ÀëÏß³µÁ¾
|
int onlinewuzi=person_Dell.get_online_wuzi()[0];//ÔÚÏßÎï×Ê
|
int offwuzi=person_Dell.get_online_wuzi()[1];//ÀëÏßÎï×Ê
|
int SOSwarning=Tb_Warnig_Dell.get_warning_num("SOS");//sos¸æ¾¯
|
int powernum=Tb_Warnig_Dell.get_warning_num("µÍµçÁ¿");//µÍµçÁ¿¸æ¾¯
|
int infencenum=Tb_Warnig_Dell.get_warning_num("½øÈë¸æ¾¯");//½øÈë¸æ¾¯
|
|
StringBuffer sql=new StringBuffer("UPDATE tb_tongji SET ");
|
StringBuffer sql2=new StringBuffer("UPDATE tb_shishi SET ");
|
|
id.add("1");
|
id.add("2");
|
id.add("3");
|
id.add("4");
|
id.add("5");
|
id.add("6");
|
id.add("7");
|
id.add("8");
|
id.add("9");
|
|
num.add(online_num+":"+off_online);
|
num.add(onlinecar+":"+offcar);
|
num.add(onlinewuzi+":"+offwuzi);
|
num.add(anchor_online_num+":"+anchor_online_off);
|
num.add(SOSwarning+"");
|
num.add(powernum+"");
|
num.add(infencenum+"");
|
num.add(Dell_55AA01.getSs()+"");
|
num.add(GetNowTime.HH_MM_SS());
|
|
|
time1.add(time);
|
time1.add(time);
|
time1.add(time);
|
time1.add(time);
|
time1.add(time);
|
time1.add(time);
|
time1.add(time);
|
time1.add(time);
|
time1.add(time);
|
|
|
String weizhi=String.valueOf(Dell_55AA01.getGuji());
|
String yingqing=String.valueOf(yingqingint);
|
String kaoqing=String.valueOf(Dell_KaoQing.size());
|
time2.add(time);
|
time2.add(time);
|
time2.add(time);
|
|
|
num2.add(weizhi);
|
num2.add(yingqing);
|
num2.add(kaoqing);
|
|
sql.append(engine_do.getinfo(num,"num",id,"id")+" , ");
|
sql.append(engine_do.getinfo(time1,"addtime",id,"id")+" ");
|
sql.append(engine_do.getlast(id,"id"));
|
|
sql2.append(engine_do.getinfo(num2,"num",shishiv,"type")+" , ");
|
sql2.append(engine_do.getinfo(time2,"addtime",shishiv,"type")+" ");
|
sql2.append(engine_do.getlast(shishiv,"type"));
|
|
//¸üÐÂÊý¾Ý¿â
|
DatabaseManagement.update(sql.toString());
|
DatabaseManagement.update(sql2.toString());
|
|
sql.setLength(0);//Çå¿Õ
|
sql2.setLength(0);//Çå¿Õ
|
|
|
}
|
|
|
public static int getYingqingint() {
|
return yingqingint;
|
}
|
|
|
public static void setYingqingint(int yingqingint) {
|
Tongji.yingqingint = yingqingint;
|
}
|
|
/**ÐÄÌøÊý¾Ý´æÈëÐÄÌøÊý¾Ý¿â
|
* C/SÒýÇæÐÄÌø°ü£¬ÐÄÌøÊý¾ÝĬÈÏ10ÃëÖÓ·¢ËÍÒ»´Î¡£
|
* hxzk_heart,[length],[timestamp],[mark]*/
|
public static void intsert_hear(String message) {
|
heartnum++;
|
String[] a=message.split(",");
|
String biaozhi=a[3];
|
String[] ziduan= {"biaozhi","time"};
|
String[] zhi= {biaozhi,GetNowTime.now()};
|
DatabaseManagement.insertfast("tb_heart", ziduan, zhi);
|
if(heartnum==60) {
|
heartnum=0;
|
String deleteSql="TRUNCATE TABLE tb_heart";
|
DatabaseManagement.update(deleteSql);
|
}
|
}
|
|
|
public static int getHeartnum() {
|
return heartnum;
|
}
|
|
|
}
|
