Question 128841 in Android Studio Question posted in
The official documentation can be found here.

Android Studio – Fetch all values from column in mysql table and sum the values in java

Name   Id
aa      1
bb      5

I use this to fetch all values from id column

SELECT id FROM name_table;

I want to sum the values in the id column. To be clear, I am making a financial application and want to add up all the money recorded in the msql database

Tags:

2

Answers


  1. 0

    If you want to just get sum of all ID values, then this would work:

    SELECT SUM(id) FROM name_table
    Login or Signup to reply.
  2. 0 
        int sum = 0;
    while (res.next()) {
    int i = res.getInt(1); or rs.getString("id "); //using column name
    sum = sum + i;
    System.out.println(sum);
 OR
  String q= "SELECT SUM(id) as totalSum FROM tableName";
  PreparedStatement pst = connectio.prepareStatement(q);
  ResultSet rs = pst.executeQuery();
   if (rs.next()) {
    sum = rs.getString("totalSum");
   System.out.print("total sum" + sum);
    } else {
  System.out.print("Query didn't return any results");
  }
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search