calculate making problem while using while() loop in ResultSet

[raj.mscking@gmail.com]

Have A Happy Day To All!

i wants to calculate the total value of total rows of the particular column (Total)

this is my java code

float total=0.0f;


public void getFeeTotal() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "root", "root");
            PreparedStatement ps100 = conn.prepareStatement("select Total from fees where AdmisonNo=? and Name=?");
            ps100.setString(1, Adno.getText());
            ps100.setString(2, nmm.getText());
            ResultSet rs100 = ps100.executeQuery();
            while (rs100.next()) 
            {
             
                    float mmm = rs100.getFloat(1);
                    
                    //for(int n=1;n<rs100.getRow();n++)
                    {
                        float temp=mmm;
                         total=mmm+temp; 
                    }
                     System.Out.Println(total)
            }
             
            conn.close();
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, e);
        }
    }

values in column of total are

Total

25750.0
800.0
36000.0
16200.0

i wants to calculate the total value of above (Total) field ..,

what changes i have to do with my code sir..,

Thank you sir..,

[Ranjiz]

while (rs100.next())
{

float mmm = rs100.getFloat(1);


total=total+mmm;


}
System.Out.Println(total);

[achill]

change your SQL-Statement to

select sum(Total) from fees where AdmisonNo=? and Name=?

and mySQL calculates the sum for you...

[Tolls]

There I was, reading the OP thinking "why not just use SQL?" and all ready to post, and see achill beat me to it...
:)

[raj.mscking@gmail.com]

Thank you very much sir!
i try now self by your idea..,

[raj.mscking@gmail.com]

sir i have no way to thanks you.
Because you each and every brainpower teach me a lesson by our technology for each time..,
Thank you! very much, it is working well sir..,

[achill]

You are welcome.