java - Codename one SQLite data issue -
i working on codename 1 sqlite project, while getting issues, trying when clicking on specific date on calendar check whether date present in database or not, when firstly click on particular date after application starts gives accurate occurrence of date, @ second time add previous date occurrence present date occurrence , display summation of that. how can resolve it?
below code:-
public class customised extends calendar{ arraylist<string[]> data = new arraylist<>(); public customised(){ } @override protected void updatebuttondaydate(button daybutton, int currentmonth, int day) { daybutton.settext(""+day); daybutton.addactionlistener(new actionlistener() { @override public void actionperformed(actionevent evt) { try{ cur = db.executequery("select date calendardata date = ? ", datelabel.gettext()); int columns = cur.getcolumncount(); if(columns > 0) { boolean next = cur.next(); if(next) { string[] columnnames = new string[columns]; for(int iter = 0 ; iter < columns ; iter++) { columnnames[iter] = cur.getcolumnname(iter); } while(next) { row currentrow = cur.getrow(); string[] currentrowarray = new string[columns]; for(int iter = 0 ; iter < columns ; iter++) { currentrowarray[iter] = currentrow.getstring(iter); } data.add(currentrowarray); next = cur.next(); } object[][] arr = new object[data.size()][]; data.toarray(arr); } } }catch(ioexception e){ e.printstacktrace(); } int i; for( = 0 ; i< data.size(); i++){ log.p(data.get(i)[0]); } label = new label(datelabel.gettext()); label b = new label(""+i); container container1 = tablelayout.enclosein(2, a,b); calendar.add(container1); util.cleanup(data); // daybutton.getallstyles().setbgcolor(0xef5555); // daybutton.settext("* "+day); } }); } @override protected button createday() { button day = new button(); day.setalignment(center); day.setuiid("calendarday"); day.setendswith3points(false); day.settickerenabled(false); return day; } } }
i got answer problem:-
@override protected void updatebuttondaydate(button daybutton, int currentmonth, int day) { daybutton.settext(""+day); daybutton.addactionlistener(new actionlistener() { @override public void actionperformed(actionevent evt) { try{ cur = db.executequery("select date calendardata date = ? ", datelabel.gettext()); int columns = cur.getcolumncount(); if(columns > 0) { boolean next = cur.next(); if(next) { string[] columnnames = new string[columns]; for(int iter = 0 ; iter < columns ; iter++) { columnnames[iter] = cur.getcolumnname(iter); } while(next) { row currentrow = cur.getrow(); string[] currentrowarray = new string[columns]; for(int iter = 0 ; iter < columns ; iter++) { currentrowarray[iter] = currentrow.getstring(iter); } data.add(currentrowarray); next = cur.next(); } object[][] arr = new object[data.size()][]; data.toarray(arr); } } }catch(ioexception e){ e.printstacktrace(); } for( = 0 ; i< data.size(); i++){ log.p(data.get(i)[0]); } label = new label(datelabel.gettext()); label b = new label(""+i); container container1 = tablelayout.enclosein(2, a,b); if(calendar.contains(container1)== true){ calendar.removecomponent(container1); calendar.add(container1); }else{ calendar.add(container1); } data.clear(); // daybutton.getallstyles().setbgcolor(0xef5555); // daybutton.settext("* "+day); } }); } and response.
Comments
Post a Comment