Get total of all row values of one column in Java tutorial

0
30

Get total of all row values of one column in Java tutorial

This tutorial is all about Get total of all row values of one column in Java tutorial. In this tutorial you will learn how to add all the rows in one column using java. This is useful when you want to make the report and you want to get all the rows in one column and add it all. Getting the sum of one column row will help you to determine automatically the total of all that numbers. This tutorial using one jtable components and one button. Please follow all the steps below to complete this tutorial.

 

Get total of all row values of one column in Java tutorial steps

First of all, you must create your project by clicking File at the top left of your netbeans and the new project. You can name you project whatever you want. After creating project, the next is to create your own jframe form by right clicking the Source Packages and then clicking New JFrame Form, Drag one table and one button and double click your button and copy and paste the code below:

 

  1. int sum  = 0;
  2.  
  3. int rowsCount  = tableName.getRowCount();
  4.  
  5. for(int i=0; i<rowsCount;i++){
  6.  
  7. sum += Integer.parseInt(tableName.getValueAt(i, 1).toString());
  8.  
  9.  
  10.  
  11. }
  12.  
  13. JOptionPane.showMessageDialog(null, "The total amount is "+ String.valueOf(sum));
  14.  
  15.  

 

Take note that get value at 1, is the index of your column in my case its 1 because counting starts with 0

 

Then you’re done, run your project and see if it works.

For more questions or any other concerns or thesis/capstone creation with documentation, you can contact me through the following:

E-Mail: ryansalem221996@gmail.com

Facebook: facebook.com/RyyanSalem

Contact No.: +639098911050

Ryan A. Salem

BSIT Graduate, soon to be MIT.

Java Developer / System Developer

Related topic(s) that you make like:

1.) How to resize column in jtable using java
2.) Delete Confirmation Dialog in Java using Netbeans IDE

Facebook Comments
(Visited 32 times, 1 visits today)

LEAVE A REPLY

Please enter your comment!
Please enter your name here