How to save the results of a selection query into several LIST Java ordered by ID? -

-

i want save results of query in several java list grouped id.

this result of request:

image

i want have java list follows: list 1 (id = 1, latitude, longitude) / list2 (id = 2, latitude, longitude) ......

this incomplete code: 

public string  getdistancetraveled() {      string f = "" ;     double distance = 0;     alldevicelist = (arraylist<device>) devicebean.getlistalldevice();// list of device      list<eventdata> list = devicebean.getlatandlongdeviceid();// list of eventdata     map<string, list<eventdata>> map= new hashmap<string, list<eventdata>>();           for(eventdata eventdata : list){               if(map.containskey(eventdata.getdevice().getdeviceid())){                       list<eventdata> templist = map.get(eventdata.getdevice().getdeviceid());                      templist.add(eventdata);                      map.put(eventdata.getdevice().getdeviceid(), templist);                      //system.out.println("event data device id: "+"'"+"'"+"'" +eventdata.getdevice().getdeviceid()+" ");             }              else{                       list<eventdata> templist = new arraylist<eventdata>();                      templist.add(eventdata);                      map.put(eventdata.getdevice().getdeviceid(), templist);                      //system.out.println("event data device id: "+"'"+"'"+"'" +eventdata.getdevice().getdeviceid()+" ");                     }          }          for(string deviceid: map.keyset()){                       list<eventdata> eventdatalistfrommap = map.get(deviceid);                       if(eventdatalistfrommap.size() > 1){                           for(int i=0; < eventdatalistfrommap.size()-1; i++){                               eventdata div1=eventdatalistfrommap.get(i);                              eventdata div2 = eventdatalistfrommap.get(i+1);                             distance = calculatedistancebylatlong(div1.getlatitude(), div1.getlongitude(), div2.getlatitude(), div2.getlongitude());                               //distance = point2d.distance(div1.getlatitude(), div1.getlongitude(), div2.getlatitude(), div2.getlongitude()); //save distance eventdata id div1.getid() } } }                             //system.out.println("j'affiche la distance ici"+distance+"'"+ " " +div1.getdevice().getdeviceid()+" " +div2.getdevice().getdeviceid()+"");                              numberformat formatter = new decimalformat("###.##");                             f = formatter.format(distance);                               system.out.println("j'affiche la distance ici: "+"'"+ " " +f+""+ " " +div1.getdevice().getdeviceid()+" " +div2.getdevice().getdeviceid()+"");                          }                     }         }

you use multivaluedmap apache commons collection in order simplify code:

list<eventdata> list = devicebean.getlatandlongdeviceid(); multivaluedmap<string, eventdata> map= new arraylistvaluedhashmap<string, eventdata>(); for(eventdata eventdata : list) {      map.put(eventdata.getdevice().getdeviceid(), eventdata); }

or better, if project java 8:

map<string, list<eventdata>> map = list.stream()         .collect(collectors.groupingby(eventdata-> eventdata.getdevice().getdeviceid());

Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more