This section describes how we can calculate the sum of specific column data in the 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

Related Tags for Sum of Column in a Database Table:
c,  database,  query,  ide,  table,  data,  io,  column,  numbers,  number,  sum,  using,  this,  id,  simple,  tab,  student,  university,  if,  ie,  example,  where,  work,  to,  base,  exam,  ci,  e,  il,  manual,  it,  des,  rsi,  section,  can,  ul,  pe,  im,  man,  in,  cal,  as,  calc,  m,  nt,  sid,  side,  ca,  calculate,  j,  es,  spec,  ase,  all,  me,  how,  do,  describe,  umn,  xa,  xamp,  s,  su,  sp,  so,  ee,  col,  at,  any,  late,  k,  is,  ll,  iv,  mpl,  ea,  doi,  cons,  specific,  sim,  scr,  s,  s,  ri,  th,  bes,  st,  chi,  ab,  abl,  either,  manu,  lum,  ple,  pl,  on,  om,  ol,  o

More Tutorials from this section

• Jdbc Mysql Connection Url
• JDBC Example with MySQL
• Adding a New Column Name in Database Table
• Retrieving Tables from a Database
• Change Column Name of a Table
• Arrange a Column of Database Table
• Arrange a Column of Database Table
• Getting Column Names from a database table in Java
• Jdbc Mysql Connection String
• Copy One Database Table to Another
• Copy Table in a MySQL Database
• Count Records using the Prepared Statement
• Count Rows from a Database Table
• Creating a Database in MySQL
• Creating a MySQL Database Table to store Java Types
• Creating a Database Table
• Cross Join Tables in a Specific Database
• Deleting All Rows from a Database Table
• Delete a Column from a Database Table
• Deleting Records using the Prepared Statement