Processing Forum

Screen name:
alex89rm

alex89rm's Profile

1 Posts

1 Responses

0 Followers

Activity Trend

Last 30 days

Loading Chart...

Show:

Expanded view
List view

Array assignment issue ..

[2 Replies]
- 13-May-2012 08:30 AM
- Forum: Contributed Library Questions
Hy guys ! I'm writing a program to read some position stored in a db and show them on a map using unfolding library. During the sql query I wanna parse the gps data into a float array (lat[], lng[]). I get stucked if i try to put them in the array but it works fine if I store in a float. Sorry if the code is such a shame but I'm a newbie ;-)
2. import guicomponents.*;
3. import de.bezier.data.sql.*;
4. import java.text.SimpleDateFormat;
5. import java.util.Date;
6. import processing.opengl.*;
7. import codeanticode.glgraphics.*;
8. import de.fhpotsdam.unfolding.*;
9. import de.fhpotsdam.unfolding.geo.*;
10. import de.fhpotsdam.unfolding.utils.*;
12. Date start,end;
13. SQLite db;
14. de.fhpotsdam.unfolding.Map map;
15. float m = millis();
17. GTextField txf_1, txf_2;
18. GTextField s_day, s_month, s_year, e_day, e_month, e_year, consolefield;
19. GLabel lblgiorno,lblmese,lblanno,lblinizio,lblfine;
20. GButton ok;
21. int x,y;
22. String a,sd,sm,sy,ed,em,ey,startdate,enddate;
24. void setup() {
25. db = new SQLite( this, "prova.db" ); // open database file
26. int xmain=1280,ymain=700;
27. x=80;
28. y=ymain-46;
30. //MAPPA
31. map = new de.fhpotsdam.unfolding.Map(this, "map",10,10,xmain-230,y-20);
32. map.zoomAndPanTo(new Location(41.75192, 12.85258), 15);
33. MapUtils.createDefaultEventDispatcher(this, map);
40. size(xmain, ymain, GLConstants.GLGRAPHICS);
41. //posizione form
43. //txf_1 = new GTextField(this, "Hello ", 10, 10, 160, 20, false);
44. //txf_1.setBorder(0);
45. //txf_1.addEventHandler(this, "handleMyTextFieldEvents");
46. //txf_2 = new GTextField(this, "Goodbye ", 10, 40, 160, 20, false);
48. consolefield = new GTextField(this, "", xmain-210, 10, 200, ymain-20, true);
49. s_day = new GTextField(this, "dd", x, y, 28, 16);
50. s_day.addEventHandler(this, "handle_s_dayEvents");
51. s_month = new GTextField(this, "mm", x+40, y, 30, 16);
52. s_month.addEventHandler(this, "handle_s_monthEvents");
53. s_year = new GTextField(this, "yyyy", x+80, y, 50, 16);
54. s_year.addEventHandler(this, "handle_s_yearEvents");
56. e_day = new GTextField(this, "dd", x, y+20, 28, 16);
57. e_day.addEventHandler(this, "handle_e_dayEvents");
58. e_month = new GTextField(this, "mm", x+40, y+20, 30, 16);
59. e_month.addEventHandler(this, "handle_e_monthEvents");
60. e_year = new GTextField(this, "yyyy", x+80, y+20, 50, 16);
61. e_year.addEventHandler(this, "handle_e_yearEvents");
63. //lblgiorno= new GLabel(this, "giorno", 10,10,40,16);
64. //lblmese= new GLabel(this, "mese", 50,10,40,16);
65. //lblanno= new GLabel(this, "anno", 90,10,40,16);
66. lblinizio= new GLabel(this, "Inizio", x-50,y,40,16);
67. lblfine= new GLabel(this, "Fine", x-50,y+20,40,16);
69. ok = new GButton(this, "Ok", x+160, y+10, 30, 20);
70. ok.tag = "Button OK";
72. }
74. public void handleMyTextFieldEvents(GTextField t) {
75. println("textField");
76. if (t.eventType == GTextField.ENTERED) {
77. println(" Event type ENTERED");
78. }
79. else if (t.eventType == GTextField.CHANGED) {
80. println(" Event type CHANGED");
81. }
82. else if (t.eventType == GTextField.SET) {
83. println(" Event type SET");
84. }
85. }
89. void handleTextFieldEvents(GTextField t) {
90. println("textField");
91. if (t.eventType == GTextField.ENTERED) {
92. println(" Event type ENTERED");
93. }
94. else if (t.eventType == GTextField.CHANGED) {
95. println(" Event type CHANGED");
96. a=t.getText() ;
99. }
102. }
104. void handleButtonEvents(GButton button) {
105. if(button == ok){
106. startdate = (sd+"/"+sm+"/"+sy);
107. enddate = (ed+"/"+em+"/"+ey);
108. println(startdate);
109. println(enddate);
110. estraidb();
111. }
113. }
115. void draw() {
116. background(255);
117. map.draw();
118. //dotrender();
119. if (millis()>m+20000){
120. println("passati 20 secondi");
121. m=millis();
122. checkdb();
123. }
124. }
126. void dotrender() {
127. for (int p=0; p<i; p++){
128. Location loc = new Location((coord[p][0]),(coord[p][1]));
129. float xyonmap[] = map.getScreenPositionFromLocation(loc);
131. fill(200, 0, 0, 100);
132. float s = map.getZoom();
133. ellipse(xyonmap[0], xyonmap[1], s, s);
134. }
136. }
139. import de.bezier.data.sql.*;
140. import java.text.SimpleDateFormat;
141. import java.util.Date;
142. int i=0;
143. long laststamp=0;
144. long numerosonda=+3912345;
145. float coord[][];
146. float xyonmap[];
147. String data;
148. String[] dataparsed;
149. float[] lat;
150. float[] lng;
153. public void estraidb()
154. {
155. DateFormat df = new SimpleDateFormat("dd/MM/yyyy");
156. try {
157. start = df.parse(sd+"/"+sm+"/"+sy);
158. end = df.parse(ed+"/"+em+"/"+ey);
159. } catch(ParseException e) {
160. println(e);}
162. long startstamp = start.getTime()/1000;
163. long endstamp = end.getTime()/1000;
165. if ( db.connect() )
166. {
169. // read all in table "table_one"
170. db.query( "SELECT * FROM message where date BETWEEN '"+startstamp+"' AND'"+endstamp+"' AND address='+3912345'" );
172. while (db.next())
173. {
174. estraicoordinate();
175. println(data);
176. println(dataparsed[0]);
177. println(dataparsed[1]);
178. //println(lat[0]);
179. }
181. }
182. }
187. void checkdb(){
189. if (db.connect()){
190. db.query( "SELECT * from message where address='"+numerosonda+"' AND date >'"+laststamp+"'" );
191. if (db.next()) {
192. println("Nuovi dati disponibili") ;
193. //estraidb(); //PASSARE IL PARAMETRO LASTSTAMP AL METODO !!
194. }
195. else println("Database aggiornato");
196. }
197. }
199. void estraicoordinate() {
200. data=db.getString("text");
201. dataparsed = splitTokens(data, ",");
202. println(i);
204. lat[i]=float(dataparsed[0]);
205. lng[i]=float(dataparsed[1]);
209. //coord[0][i]=prova;
210. //coord[1][i]=float(dataparsed[1]);
211. laststamp=db.getLong("date");
212. i++;
213. }

«Prev
Next »