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

How to group boxplot outliers in gnuplot -

i have large set of data points. try plot them boxplot, of outliers exact same value , represented on line beside each other. found how set horizontal distance between outliers in gnuplot boxplot , doesn't much, apparently not possible. is possible group outliers together, print 1 point , print number in brackets beside indicate how many points there are? think make more readable in graph. for information, have 3 boxplots 1 x value , times 6 in 1 graph. using gnuplot 5 , played around pointsize, doesn't reduce distance anymore. hope can help! edit: set terminal pdf set output 'dat.pdf' file0 = 'dat1.dat' file1 = 'dat2.dat' file2 = 'dat3.dat' set pointsize 0.2 set notitle set xlabel 'x' set ylabel 'y' header = system('head -1 '.file0); n = words(header) set xtics ('' 1) set [i=1:n] xtics add (word(header, i) i) set style data boxplot plot file0 using (1-0.25):1:(0.2) boxplot lw 2 lc rgb '#8b0000...
Read more

cakephp - simple blog with croogo -

i not problem, made simple blog in croogo, problem is not adding or modifying or delete, because arabic language ?? function add in controller `public function admin_add() { $this->set('title_for_layout', __('add part')); if (!empty($this->request->data)) { $this->part->create(); if ($this->part->save($this->request->data)) { $this->session->setflash(__('the part has been saved'), 'default', array('class' => 'success')); $this->redirect(array('action' => 'index'));//, $this->part->id)); } else { $this->session->setflash(__('the part not saved. please, try again.'), 'default', array('class' => 'error')); } } }` => model `class part extends appmodel { public $name = 'part'; var $belongst...
Read more