java - Display data on a Jtable after excuting a search -

-

basically code searching first name or surname in table. once search has been done, example 'peter' , occur data placed text boxes.

the issue want data displayed onto table, have tried many times not seem work, have tried using line of code. 'table_stats' name of table. table_stats.setmodel(dbutils.resultsettotablemodel(result));

i pretty new this, can 1 please help, appreciated thank you!

private void searchkeyreleased(java.awt.event.keyevent evt) {                                        // todo add handling code here:     try{       string sql = "select * statistics first_name =? "  ;        string sql2 = "select * statistics surname =? "  ;       prepared=conn.preparestatement(sql);       prepared=conn.preparestatement(sql2);       prepared.setstring (1, search.gettext());       result = prepared.executequery();       if(result.next()){           string add1 = result.getstring("player_id");           player_id.settext(add1);           string add2 = result.getstring("first_name");           first_name.settext(add2);           string add3 = result.getstring("surname");           surname.settext(add3);           string add4 = result.getstring("goal_scored");           goal_scored.settext(add4);           string add5 = result.getstring("assist");           assist.settext(add5);          }      }     catch(exception e)       {      joptionpane.showmessagedialog(null, e);     }    }

i think can use defaultablemodel: (http://docs.oracle.com/javase/7/docs/api/javax/swing/table/defaulttablemodel.html)

or can implement own subclass of abstractablemodel: (http://docs.oracle.com/javase/7/docs/api/javax/swing/table/abstracttablemodel.html)

anyway should separate code querying database table gui code (for example create separate class method getplayers returns table model).


Popular posts from this blog

Php - Delimiter must not be alphanumeric or backslash -

-
this question has answer here: delimiter must not alphanumeric or backslash , preg_match 5 answers this question has been asked don't know how fix problem in situation. getting following php errror: php message: php warning: preg_match(): delimiter must not alphanumeric or backslash in... on line 227 line 227 following: if (preg_match($match, $_server['http_user_agent'])) and function: $oslist = array ( 'windows 3.11' => 'win16', 'windows 95' => '(windows 95)|(win95)|(windows_95)', 'windows 98' => '(windows 98)|(win98)', 'windows 2000' => '(windows nt 5.0)|(windows 2000)', 'windows xp' => '(windows nt 5.1)|(windows xp)', 'windows server 2003' => '(windows nt 5.2)', 'windows vista' => '(windows nt 6.0)', 'w...
Read more

Delphi interface implements -

-
i expect reference counting should work on outer aggregating object in interface implementation. if can refer example: clarity in classes implementing multiple interfaces (alternative delegation): here minimal reproduction of behaviour: program so16210993; {$apptype console} type ifoo = interface procedure foo; end; tfooimpl = class(tinterfacedobject, ifoo) procedure foo; end; tcontainer = class(tinterfacedobject, ifoo) private ffoo: ifoo; public constructor create; destructor destroy; override; property foo: ifoo read ffoo implements ifoo; end; procedure tfooimpl.foo; begin writeln('tfooimpl.foo called'); end; constructor tcontainer.create; begin inherited; ffoo := tfooimpl.create; end; destructor tcontainer.destroy; begin writeln('tcontainer.destroy called');//this line never runs inherited; end; procedure main; var foo : ifoo; begin foo := tcontainer.create; foo.foo; end; begin main; readln...
Read more

java - How to create Table using Apache PDFBox -

-
java - How to create Table using Apache PDFBox - we planning migrate our pdf generation utilities itext pdfbox (due licensing issues in itext). effort, able write , position text, draw lines etc. creating tables text embedded in table cells challenge, went through documentation, examples, google, stackoverflow couldn't find thing. wondering if pdfbox provides native back upwards creating tables embedded text. lastly resort utilize link https://github.com/eduardohl/paginated-pdfbox-table-sample thanks links provided tilman. using boxable api ( https://github.com/dhorions/boxable ) able create table wanted to. fyi wanted create table variable number of cells. illustration row 1 have 2 cells, row 2 have 5 cells , row 3 have 3 cells. able ease. followed example1.java in link mentioned above. java pdf pdfbox
Read more