1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
| package urt;
| import BaoWen.Stac;
| import DataBase.DatabaseManagement;
| import Method.GetNowTime;
| import tbDataModel.Tb_gps;
| /**¸Ã·½·¨ÓÃÓÚ½«GNGGA×ø±ê²åÈëÀúÊ·¹ì¼£Êý¾Ý¿â*/
| public class HistoryGNGGA {
|
| static StringBuffer suffix = new StringBuffer(); // ±£´æsqlºó׺
| static int jishu=0;
| /**gps_utc_time
| * gps_weidu
| * gsp_jingdu
| * gps_num
| * gps_haiba_gao
| * tagid
| * gps_power
| * gps_sos
| * addtime**/
|
| public static void putInHistory(
| Tb_gps gps,
| String gps_utc_time,
| String gps_weidu,
| String gsp_jingdu,
| String gps_num,
| String gps_haiba_gao,
| String tagid,
| String gps_power,
| String gps_sos,
| String gps_state,
| String gps_hdop,
| String gps_chafen_time,
| String addtime
| ) {
| if(Stac.isSaveguiji()) {
| String tb_track="tb_gps_track_"+GetNowTime.getyearmd();
| String prefix = "INSERT INTO "+tb_track+" (gps_utc_time,"
| + "gps_weidu,"
| + "gsp_jingdu,"
| + "gps_num,"
| + "gps_haiba_gao,"
| + "tagid,"
| + "gps_power,"
| + "gps_sos,"
| + "gps_state,"
| + "gps_hdop,"
| + "gps_chafen_time,"
| + "addtime) VALUES ";
|
| //½«±êGNGGAʱλÖòåÈëÀúÊ·¹ì¼£Êý¾Ý¿âÖÐ
| jishu++;
| suffix.append("('"+gps_utc_time+"','"
| +gps_weidu+"','"
| +gsp_jingdu+"','"
| +gps_num+"','"
| +gps_haiba_gao+"','"
| +tagid+"','"
| +gps_power+"','"
| +gps_sos+"','"
| +gps_state+"','"
| +gps_hdop+"','"
| +gps_chafen_time+"','"
| +addtime+"'),");
| if(jishu==100) {
| StringBuffer sql =new StringBuffer(prefix + suffix.substring(0, suffix.length() - 1)) ; // ¹¹½¨ÍêÕûsql
| DatabaseManagement.insert_fast(sql.toString(),6);
| suffix.setLength(0);
| jishu=0;
| }
|
| tb_track=null;
| prefix =null;
| }
| }
|
| }
|
|
