How to get sum of column in SqlLite using where condition?

Question

My code is

Button.setOnClickListener(new    View.OnClickListener() 
    { 
        @Override
        public void onClick(View v) { 
            int cv; 
            String getmont="",getyear="";
            getmont=year.getText().toString();
            getyear= (String) sid.getSelectedItem(); 
            SQLiteDatabase db;
            db = openOrCreateDatabase("monthapp", MODE_PRIVATE, null); 
            curtop = db.rawQuery("SELECT    SUM(currentpaid)FROM monthvaluesOrgin WHERE curmonth='" + getmont + "' AND curyear='" + getyear + "'", null);
            if (curtop.moveToNext() ) { 
                cv=curtop.getInt(0);      
                Toast.makeText(getApplicationContext(),cv,Toast.LENGTH_SHORT).show(); 
            } 
        }
     });

How to print/ toast the sum value? It always shows error EofException.

My app shows "unfortunately your app has stopped".

Please give me a solution! Thanks in advance!

You code might be at risk of [SQL injection](https://stackoverflow.com/questions/601300/what-is-sql-injection). You should use query parameters. — litelite, Aug 08 '17 at 14:58
Here's an example https://stackoverflow.com/a/9341246/3072566 — litelite, Aug 08 '17 at 15:00
An EOF does not make sense at that line. Are you sure that an EOFException is shown in logcat? — litelite, Aug 08 '17 at 15:11
So it means it's not an EOF if you could not catch it. Can you post the full logcat crash log — litelite, Aug 08 '17 at 15:18

litelite · Answer 1 · 2017-08-08T15:26:20.623

0

You are using the wrong signature for makeText. Because cv is an int the compiler think you are trying to pass a resource id and since your sum is unlikely to be a valid string ID your app crashes because makeText cannot find that that number in the string resources. Try to use valueOf to convert cv to a string like this :

Toast.makeText(getApplicationContext(),String.valueOf(cv),Toast.LENGTH_SHORT).show();

edited Aug 08 '17 at 15:26

answered Aug 08 '17 at 15:16

litelite

2,857
4
23
33

Which means you sum right now is 0. Check your data, your table might be empty – litelite Aug 08 '17 at 15:25
Are you sure it has values that satisfy your conditions? – litelite Aug 08 '17 at 15:45
Yes ofcourse it does is that possible to send snapshot via email – user8434962 Aug 08 '17 at 15:47
From where does `openOrCreateDatabase` come? I can't find a method with that signature. – litelite Aug 08 '17 at 15:57
I'm using this instead of using database helper It may not be right way But results always shows 0 – user8434962 Aug 10 '17 at 06:07
And what's inside of that? – litelite Aug 10 '17 at 12:22

How to get sum of column in SqlLite using where condition?

1 Answers1