Using jTable to display query result

[zenith666]

hey guys.

i'm new here and i'm sorry if this had been posted before. i am trying to display a query result from ms access into a jTable through a search function.

here is my code:

private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {                                            
}                                          

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        

   try{
          String woorder = jTextField1.getText();
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          Connection con = DriverManager.getConnection("jdbc:odbc:scmdatabase");
          PreparedStatement st=con.prepareStatement("select * from table1 where workorderno = ?");
           st.setString(1, woorder);
           ResultSet rs=st.executeQuery();

          while(rs.next()){
              System.out.println(rs.getString("invoiceno")+" "+rs.getString("invoicedate")+" "+rs.getString("amount"));
          }
       }
       catch(Exception e){
           System.out.println(e);
       }

the item that i need to display in the jTable is this part:

System.out.println(rs.getString("invoiceno")+" "+rs.getString("invoicedate")+" "+rs.getString("amount"));

really hope that you guys can help me.

[DarrylBurke]

Read the API for JTable and follow the link to the Swing tutorial on How to Use Tables.

Then give it a shot yourself and if you can't get the desired result, post your best efforts with a clear description of where you're stuck, in the form of an SSCCE (Short, Self Contained, Compilable and Executable) example.

db

[zenith666]

thanks darryl,

i already figured out how to display the result in the jTable.
my only problem for now is i want to calculate sum of the third column of the jTable. i just can't figured out on how to do it.
i've tried the getvalueat method, but i don't know how to do the looping of addition and to set the class type.