How to insert multiple database rows into JTable

If you want to insert rows with data into a JTable by fetching from the database, this is the easyest way to do it.


//Statement is got through mysql connection
sql="select code,name,type from item_table"
ResultSet resultset = 
                statement.executeQuery(sql);

Vector rows=new Vector();


while(resultset.next()){
 Vector one_row=new Vector();
 one_row.add(resultset.getString('code'));
 one_row.add(resultset.getString('name'));
 one_row.add(resultset.getString('type'));

 rows.add(one_row);

}

DefaultTableModel model=new DefaultTableModel();

Iterator i=rows.iterator();
int count=0
while(i.hasNext()){
 model.insertRow(count,(Vector)i.next());
 count++;
}

//Table is the JTable instance
table.setModel(model);

Comments

  1. e-shaNApril 26, 2013 at 2:51 AM

    please explain my mistake here..

    DefaultTableModel dtm = (DefaultTableModel) jTable1.getModel();

    try {
    while (dtm.getRowCount() > 0) {
    dtm.removeRow(0);
    }
    Vector vbig = new Vector(); //-----big-ass vector to keep multiple tables


    //
    ResultSet r0 = jdbc.con().createStatement().executeQuery("select * from author");
    while (r0.next()) {
    //---second resultset opening to search subject name using above resultset ID
    ResultSet rsubid = jdbc.con().createStatement().executeQuery("select name from subject where idsubject='" + r0.getString("subject_idsubject") + "'");

    //------normally adding results from 1st resultset
    Vector v0 = new Vector();
    v0.add(r0.getString("employee_idemployee"));
    v0.add(r0.getString("name"));
    v0.add("Author");
    //--special addition of subject name
    while (rsubid.first()) {
    v0.add(rsubid.getString("name"));
    }
    rsubid.close();//--finish special addition of subject name;
    //----second resultset closed

    //-----adding first table's vector to big vector
    System.out.println("first vector addition");
    vbig.add(v0);
    }
    r0.close();
    //


    //
    ResultSet r1 = jdbc.con().createStatement().executeQuery("select * from editor");
    while (r1.next()) {
    Vector v1 = new Vector();
    v1.add(r1.getString("employee_idemployee"));
    v1.add(r1.getString("name"));
    v1.add("Editor");
    v1.add("---");

    //-----adding second table's vector to big vector
    System.out.println("second vector addition");
    vbig.add(v1);
    }

    r1.close();
    //

    //----adding big vector to table
    dtm.addRow(vbig);
    System.out.println("big vector added to table");

    System.gc();
    System.out.println("author_editor table refreshing complete");
    } catch (Exception e) {
    System.out.println("error refreshing author_editor table");
    System.out.println(e);
    }

    ReplyDelete
  2. e-shaNApril 26, 2013 at 2:56 AM

    oh fine, i got it, now i see why have the iterator .. thanks a lot btw,
    send regards to lakshika and aunty too :)

    ReplyDelete
  3. UnknownMarch 20, 2014 at 11:59 AM

    can you give me the syntax of inserting values from jtable to database in netbeans

    ReplyDelete

Post a Comment

Popular posts from this blog

PHP-SOAP web service with out a WSDL

This article is going to describe how to create a simple web service with php-soap step by step. Requirements     Server to run php (apache, xampp , wamp)     PHP-SOAP extension Steps Let's write a simple web service to find the length of a given string. So here is the code for StringLengthServer.php   <?php # StringLengthServer.php # Copyright (c) 2011 by Lakmali Baminiwatta #     function findLength($string) {            return "Length of the string " . $string . "is : ".strlen($string);     }            $server = new SoapServer(null,               array('uri' => "urn://www.lakmali.lk"));        $server->addFunction("findLength");        $server->handle();  ?> First thing done here is to writ...
Keep reading

Boomi Mapping - Removing special chars from an input

Image
Dell Boomi mapping shape provides numerous ways to modify/enrich an input via functions. In this post I am going to show how I validated and removed special chars from an input using Scripting and do it along with another string function. The user defined functions available with mapping, allows us to apply sequence of functions to the input. In this example, I am going to use it. Use Case: I have two input strings coming from the source profile (first_name and last_name), which I want to first concatanate together and then remove non-alphanumeric characters if present. Solution In your map, add an User Defined function and add two inputs; first_name, last_name.  Add User Defined function into the map Added inputs to the user defined function As the first step, add a function "String Concat" under the  "String" category.  Specify first_name and last_name as the inputs. Also set a delimiter, if you need a one. In my case, I want to concatena...
Keep reading

Boomi Mapping - User Defined function based on list of elements in a collection

Image
Recently I came across a requirement to validate all the elements in a collection and return an output based on that. Let me explain it with an example. I have a XML document containing information about users including a collection to indicate the roles of the person. Source Document <users> <user> <first_name></first_name> <roles> <role> admin </role> <role> subscriber </role> <role> creator </role> </roles> </user> </users> Destination Document I want to map this into a destination profile which has elements to indicate whther the user is an admin or a subsriber. <users> <user> <isAdmin> true </isAdmin> <isSubscriber> true </isSubscriber> <user> <users> </users> In order to achieve this I have to write a map funtion. But for a map funtion, we can't input a collection. If we map the "roles" collect...
Keep reading