Sum of Column in a Database Table

This section describes how we can calculate the sum of specific column data in the database table.

Ads

Tutorials   
Change Column Name in MySQL Java Mysql Connection Example JDBC Example with MySQL Jdbc Mysql Connection String Jdbc Mysql Connection Url Getting Column Names from a database table in Java Count Rows from a Database Table JDBC Example with MySQL Write Text File to Table Inserting Image in Database Table Insert Data in Table Using Stored Procedure Copy One Database Table to Another Copy Table in a MySQL Database Set Timestamp by using the Prepared Statement Set Time by using the Prepared Statement Set Date by using the Prepared Statement Prepared Statement Set Big Decimal Set byte, short and long data types by using the Prepared Statement Set Data Types by using Prepared Statement Using the Prepared Statement Twice Deleting Records using the Prepared Statement Count Records using the Prepared Statement Inserting Records using the Prepared Statement Update Records using Prepared Statement Select Records Using Prepared Statement Prepared Statement With Batch Update Statement Batch Update Prepared Statement Set Object Cross Join Tables in a Specific Database Join tables with the NATURAL RIGHT JOIN operation Join tables with the NATURAL LEFT JOIN operation Join tables in the specific database Delete a Column from a Database Table Delete a Specific Row from a Database Table Deleting All Rows from a Database Table Sum of Column in a Database Table Arrange a Column of Database Table Arrange a Column of Database Table Remove Unique Column in Database Table Make Unique Column in Database Table

Sum of Column in a Database Table

     

This section describes how we can calculate the sum of specific column data in the database table. Consider an example of any university where we need to calculate the sum of  numbers achieved by the student.  Either we can do it manually or by using just the simple query. By doing it manually is a very cumbersome work, but by using simple query it can be done very easily. By seeing the example given below you can easily understand how you can get the sum of specific column. Here we are providing you an example.

Description of program:

In the program the first  task we going to do is to establish the connection with MySQL database by using the JDBC driver. When the connection has been established pass the table name and name of that column of which we want to calculate the sum. If the statement gets processed then it shows the sum of the particular column else it will displays a message "SQL statement is not executed!".

Description of code:

SELECT  SUM(col_name)   FROM  table_name:
This code can be used to calculate the sum of specific column in database table.

Here is the code of program:

import java.io.*;
import java.sql.*;

public class SumColumn{
  public static void main(String[] args) {
  System.out.println("Sum of the specific column!");
  Connection con = null;
  int sum = 0;
  String col_name;
  try{
  Class.forName("com.mysql.jdbc.Driver");
  con = DriverManager.getConnection
("jdbc:mysql://localhost:3306/jdbctutorial","root","root");
  try{
  Statement st = con.createStatement();
  BufferedReader bf = new BufferedReader(new InputStreamReader(System.in));
  System.out.println("Enter table name:");
  String table = bf.readLine();
  System.out.println("Enter column name which have to sum:");
  String col = bf.readLine();
  ResultSet res = st.executeQuery("SELECT SUM"+"("+col+")"+" FROM "+table);
  while (res.next()){
  int c = res.getInt(1);
  sum = sum+c;
  }
  System.out.println("Sum of column = "+sum);
  }
  catch (SQLException s){
  System.out.println("SQL statement is not executed!");
  }
  }
  catch (Exception e){
  e.printStackTrace();
  }
  }
} 

Download this example.

Output of program:

C:\vinod\jdbc\jdbc\jdbc-mysql>javac SumColumn.java

C:\vinod\jdbc\jdbc\jdbc-mysql>java SumColumn
Sum of the specific column!
Enter table name:
emp_sal
Enter column name which have to sum:
Emp_sal
Sum of column = 28100

Advertisements

Ads

 

We have 1000s of tutorials on our website. Search Tutorials tutorials on our website.

Share on Google+Share on Google+

Sum of Column in a Database Table

Posted on: April 13, 2007 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

 

Discuss: Sum of Column in a Database Table  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:1
ahong
February 4, 2013
sum coloumb

i try using it on jtable, i sum the first columb. and its works, but only for one columb. i need to sum 4 columb at the same time how about that

Ads

 

Ads