Thread: How to get the sum value from a jtable column

login page.jpg

I want this password field (textfield) validated.. as showing *** or …. Instead of showing 12345

&


jtablemenu.jpg


Here in the table I want to get the total amount from Amount column

When I click get total button the total amount (520.00) has to come in this textfld.
It has to be taken from the amount columns

For the Password Field, look at this: JPasswordField

As for the calculating the Total from the Table, like Norm said, what have you tried?

i have a jtable which loads data from a database about items' details and the last column of the table is amount column.. it shows the price of item multiplied by item quantity.
and if i add many items and i want to get the totaol(sum) of all amounts to a textfeild..

here is my code i paste it from IDE
____________________________________________

Connection con = DB.itzMyConnection();
java.sql.Statement S = con.createStatement();

int Itmcd = Integer.parseInt( jTextField8.getText());


ResultSet r = S.executeQuery("Select * from items where ItemCode= '" jTextField8.getText() "'");
while (r.next()) {

String s1 = r.getString("ItemCode");
double unitPrice = Double.parseDouble(r.getString("Price"));
int Qty = Integer.parseInt(jTextField7.getText());

double amnt = unitPrice * Qty;

DefaultTableModel dft = (DefaultTableModel) jTable1.getModel();
Vector v1 = new Vector();
v1.add(s1);
v1.add(r.getString("ItemCategory"));
v1.add(r.getString("ItemName"));
v1.add(jTextField9.getText());
v1.add(Qty);
v1.add(unitPrice);
v1.add(amnt);

dft.addRow(v1);
}

}
here the amount columns total sum should be extracted out. help me pls

i have tried with using methods like getColumnCount(); getRowCount(); and getValueIn() with a for loop, but I had to face a hard time to get done with those coding. so i am not capable of providing a code right now. so if it is possible. can any one direct me through some possible methods and codings.

< DefaultTableModel dft = (DefaultTableModel) jTable1.getModel();
 
 
         int row = dft.getRowCount();
         System.out.println(row);
        int columnCount = dft.getColumnCount();
            System.out.println(columnCount);
 
 
 
         int valueAt = (Integer)jTable1.getValueAt(1, 5);
        System.out.println(valueAt);
 
              for(int i=0; i <= row; i++){
              int i2  =(Integer)dft.getValueAt(i, 6);
              System.out.println(i2);
              >

thank you.
And @Norm how can i add u as a frnd

finally got the solution

  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
 
 
 
        JOptionPane.showMessageDialog(this, "eeeee");
 
        if(evt.getSource().equals(jButton1))
 
        {
 
            JOptionPane.showMessageDialog(this, "tr tyt");
 
 
 
        double total=0;
 
       int  rows = jTable1.getRowCount();
 
        for (int i = 0;  i < rows; i++) 
 
        { 
 
            total += ( Double.parseDouble(jTable1.getValueAt(i, 1).toString())) ; 
 
 
 
        }
 
 
 
        JOptionPane.showMessageDialog(this,total);
 
 
 
        }
 
 
 
    }