package Method;
|
import DataBase.DatabaseManagement;
|
import PbuliClass.Systems;
|
|
/**¸ÃÀàÓÃÓÚ¹ÜÀíÀúÊ·¹ì¼£±í*/
|
public class About_tb_track {
|
|
//¹ì¼£±£´æµÄÌìÊý
|
static int saveday=Integer.parseInt(Systems.sys().getGui_ji());
|
|
/**´´½¨±£´æÈÕÆÚÕÅÀúÊ·¹ì¼£±í£¬Èç±£´æÈÕÆÚ30Ìì¾Í´´½¨µ±Ç°µ½30ÌìºóµÄ±í*/
|
public static void create_tb_track() {
|
|
//´´½¨¹ì¼£±£´æÌìÊýÕűí
|
for(int i=0;i<saveday;i++) {
|
|
//±íÃû³ÆÎª
|
String table_name="tb_track_"+GetNowTime.addDay(i);
|
|
String sql="CREATE TABLE IF NOT EXISTS "+table_name+" ("
|
+ " id INT AUTO_INCREMENT PRIMARY KEY,"
|
+ " tagid VARCHAR(10),"
|
+ " x VARCHAR(30),"
|
+ " y VARCHAR(30),"
|
+ " z VARCHAR(30),"
|
+ " layer VARCHAR(10),"
|
+ " time VARCHAR(100),"
|
+ " baoliu1 VARCHAR(50),"//·Ã¿ÍID
|
+ " baoliu2 VARCHAR(50),"//¾¶È
|
+ " baoliu3 VARCHAR(50),"//γ¶È
|
+ " baoliu4 VARCHAR(50),"//¸ß³Ì
|
+ " baoliu5 VARCHAR(50),"
|
+ " baoliu6 VARCHAR(50),"
|
+ " baoliu7 VARCHAR(50),"
|
+ " baoliu8 VARCHAR(50),"
|
+ " baoliu9 VARCHAR(50),"
|
+ " baoliu10 VARCHAR(100))";
|
|
DatabaseManagement.update(sql);
|
|
|
}
|
delte_tb_track();
|
}
|
|
/**×Ô¶¯Ôö¼Ógps¹ì¼£±í*/
|
public static void tb_gps_track() {
|
//´´½¨¹ì¼£±£´æÌìÊýÕűí
|
for(int i=0;i<saveday;i++) { //±íÃû³ÆÎª
|
String table_name="tb_gps_track_"+GetNowTime.addDay(i);
|
String sql="CREATE TABLE IF NOT EXISTS "+table_name+" ("
|
+" id INT AUTO_INCREMENT PRIMARY KEY,"
|
+" gps_utc_time VARCHAR(50),"
|
+" gps_weidu VARCHAR(50),"
|
+" gps_NS VARCHAR(50),"
|
+" gsp_jingdu VARCHAR(50),"
|
+" gps_EW VARCHAR(50),"
|
+" gps_state VARCHAR(50),"
|
+" gps_num VARCHAR(50),"
|
+" gps_hdop VARCHAR(50),"
|
+" gps_haiba_gao VARCHAR(50),"
|
+" gps_tuoqiu VARCHAR(50),"
|
+" gps_chafen_time VARCHAR(50),"
|
+" gps_chafen_id VARCHAR(50),"
|
+" gps_jiaoyan VARCHAR(50),"
|
+" tagid VARCHAR(50),"
|
+" gps_kahao VARCHAR(50),"
|
+" gps_power VARCHAR(10),"
|
+" gps_sos VARCHAR(10),"
|
+" addtime VARCHAR(100))";
|
DatabaseManagement.update(sql);
|
|
|
}
|
|
}
|
|
|
/**Çå¿ÕËùÓбíÖеÄÊý¾Ý*/
|
public static void delete_all() {
|
|
//´´½¨¹ì¼£±£´æÌìÊýÕűí
|
for(int i=1;i<saveday;i++) {
|
//±íÃû³ÆÎª
|
String table_name="tb_track_"+GetNowTime.addDay(-i);
|
String deleteSql="TRUNCATE TABLE "+table_name;
|
DatabaseManagement.update(deleteSql);
|
|
String table_name2="tb_gps_track_"+GetNowTime.addDay(-i);
|
String deleteSql2="TRUNCATE TABLE "+table_name2;
|
DatabaseManagement.update(deleteSql2);
|
}
|
|
}
|
|
/**ɾ³ýÊý¾Ý±í*/
|
public static void dropt(String data) {
|
String a=data.replace("-", "");
|
String name="tb_track_"+a;
|
String deleteSql="DROP TABLE "+name;
|
DatabaseManagement.update(deleteSql);
|
|
String table_name2="tb_gps_track_"+a;
|
String deleteSql2="DROP TABLE "+table_name2;
|
DatabaseManagement.update(deleteSql2);
|
}
|
|
|
/**ɾ³ý³¬¹ý±£´æÈÕÆÚµÄǰ30ÌìµÄ±í*/
|
public static void delte_tb_track() {
|
//ɾ³ýÒª±£´æÈÕÆÚǰ30ÌìÊý¾Ý±í
|
for(int i=saveday;i<4*saveday;i++) {
|
//±íÃû³ÆÎª
|
String table_name="tb_track_"+GetNowTime.addDay(-i);
|
String sql1="DROP TABLE IF EXISTS "+table_name;
|
|
String table_name2="tb_gps_track_"+GetNowTime.addDay(-i);
|
String sql2="DROP TABLE IF EXISTS "+table_name2;
|
DatabaseManagement.update(sql1);
|
DatabaseManagement.update(sql2);
|
}
|
|
}
|
|
|
/**ÐÂÔö±£´æÈÕÆÚÌìÊý+1ÌìµÄ¹ì¼£±íͬʱɾ³ýµ±Ç°ÈÕÆÚ¼õÈ¥¼õÈ¥±£´æÌìÊý+1ÌìµÄ±í*/
|
public static void add_and_delete_a_tbtrack() {
|
//±íÃû³ÆÎª
|
String table_name="tb_track_"+GetNowTime.addDay(saveday+1);
|
String sql="DROP TABLE IF EXISTS "+ table_name;
|
DatabaseManagement.update(sql);
|
|
String table_name2="tb_track_"+GetNowTime.addDay(-(saveday+1));
|
|
String sql2="DROP TABLE IF EXISTS "+ table_name2;
|
DatabaseManagement.update(sql2);
|
|
|
String table_name3="tb_gps_track_"+GetNowTime.addDay(saveday+1);
|
String sql3="DROP TABLE IF EXISTS "+ table_name3;
|
DatabaseManagement.update(sql3);
|
|
String table_name4="tb_gps_track_"+GetNowTime.addDay(-(saveday+1));
|
|
String sql4="DROP TABLE IF EXISTS "+ table_name4;
|
DatabaseManagement.update(sql4);
|
|
}
|
|
/**¹ì¼£ÈÕÆÚµÄ¼¯ºÏ*/
|
public static String[] get_tbtrack() {
|
String[] datas=new String[saveday];
|
for(int i=0;i<saveday;i++) {
|
datas[i]=GetNowTime.addDay1(-i);
|
}
|
return datas;
|
}
|
|
}
|