java - Display data in JTable with selection of check boxes in Swing - 


    string calltype = " ";      if (local_checkbox.isselected()) {         calltype = calltype + "and toc ='local'";     }      if (std_checkbox.isselected()) {         calltype = calltype + "and toc ='std'";     }     if (isd_checkbox.isselected()) {         calltype = calltype + "and toc ='isd'";     }     if (incoming_checkbox.isselected()) {         calltype = calltype + "and toc ='incoming'";      }     if (transfered_checkbox.isselected()) {         calltype = calltype + "and toc ='transfered'";      }     if (conference_checkbox.isselected()) {         calltype = calltype + "and toc ='conference'";     }     if (missed_checkbox.isselected()) {         calltype = calltype + "and toc ='missed'";     }      int = 4;     calltype = calltype.substring(i);     calltype = calltype.replace("and", "or");     calltype = "and\t" + calltype;     i++;   try {          class.forname("com.mysql.jdbc.driver").newinstance();         connection con1 = drivermanager.getconnection(db_url, user, pass);         checkuserinputs chkusrin = new checkuserinputs();         query = chkusrin.formatquery(reporttype, resultdatefrom, resultdateto, empid, trunk, dialedno, duration, site, authcode, extension, cost, department, calltype, time);         system.out.println(query);         ps = con1.preparestatement(query);         rs = ps.executequery();         table1.setmodel(dbutils.resultsettotablemodel(rs));  }catch(exception e) {}     `

i have multiple check boxes. type of calls, check boxes std, isd, missed etc.. in database have column named "type of calls" have values std, isd, missed etc... task given me follows :

  1. to display data in jtable based on selection of check boxes. , if user selects check box std, table show me std calls other details, , if user selects check box isd , table show me isd calls other details , on. i'm able this.
  2. problem when user selects multiple check boxes. select isd , std, table has show std , isd calls values.

the function formatquery has queries , conditions fetch data database.

how implement this?


Comments

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more