java - JTable , update the table whenever click on a button -


i trying learn jtable mysql. i've set database jtable , added gui using scroll pane.

my question is, how can make function renew database or search operation (both same thing so..) whenever click on button.

here code (i reading database informations .ini file)

final vector columnnames = new vector(); final vector data = new vector(); try { // connect access database driver = inifonksiyon.inisvnokut(driver, "databasebilgileri", "driver");//"com.mysql.jdbc.driver"; url = inifonksiyon.iniokut(url, "databasebilgileri", "url");//"jdbc:mysql://localhost:3306/"; userid = inifonksiyon.iniokut(userid, "databasebilgileri", "kullanici"); password = inifonksiyon.iniokut(password, "databasebilgileri", "sifre"); dbname = inifonksiyon.iniokut(dbname, "databasebilgileri", "dbismi"); class.forname( driver ); connection connection = drivermanager.getconnection( url+dbname , userid, password ); // read data table string sql = "select * profildb.tbl_detailed"; statement stmt = connection.createstatement(); resultset rs = stmt.executequery( sql ); resultsetmetadata md = rs.getmetadata(); int columns = md.getcolumncount(); // column names (int = 1; <= columns; i++) { columnnames.addelement( md.getcolumnname(i) ); } // row data while (rs.next()) { vector row = new vector(columns); (int = 1; <= columns; i++) { row.addelement( rs.getobject(i) ); } data.addelement( row ); } rs.close(); stmt.close(); connection.close(); } catch(exception e) { system.out.println( e ); } // create table database data final jtable table = new jtable(data, columnnames) { /** * */ private static final long serialversionuid = 1l; public class getcolumnclass(int column) { (int row = 0; row < getrowcount(); row++) { object o = getvalueat(row, column); if (o != null) { return o.getclass(); } } return object.class; } };

this code handles creating table, directly connected main gui function, how can refresh/do operation search function?

it easier use table model. see related tutorial. can use defaulttablemodel or own implementation of tablemodel. extension of abstracttablemodel common approach if defaulttablemodel not satisfy needs.

for better performance , responsiveness of swing application execution of long running tasks should not happen on edt. so, best access database thread other edt.

swingworker can used such purpose. data database in swingworker.doinbackground(). then, either build or update model in swingworker.done().

there many variations of such implementation. these specific application's nature , requirements. instance can use swingworker's publish()/process() tandem process data in chunks. may choose incorporate database access logic model or create commands extend swingworker.


Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more