SQLite query data that returns a Integer Array

Question

Hello any help would be great thank you! i have 3 fields in my database table

public static final String colExpID = "ExpenseID";      
public static final String colExpExpense = "ExpenseDisc";
public static final String colExpAmount = "Amount";

My method to query data

public Integer[] queryHouse() {
        // TODO Auto-generated method stub
        String[] columns = new String[]{colExpID,colExpExpense,colExpAmount};
        Integer[] Result = new Integer[]{};     
        Cursor c = ourDatabase.query(ExpenseTable, columns, null, null, null, null, null);
        int iExpense = c.getColumnIndex(colExpExpense);
        int iAmount = c.getColumnIndex(colExpAmount);
        for(int i = 0; i < c.getCount();i++){   
            if(c.getString(iExpense) == "House"){
            Result[i] = Integer.parseInt(c.getString(iAmount));
            }
        }
        return Result;
    }

I'm not sure what i'm missing thank you!

I'm also not sure what you missing, since you have not specified what it is you are trying to accomplish, and how you are failing at that. — SWeko
– SWeko, Commented Mar 18, 2012 at 10:04

giorashc · Accepted Answer · 2012-03-18 10:06:32Z

3

You are comparing string with == which is NOT correct. use equals :

  if(c.getString(iExpense).equals("House")) 
    .
    .
    .

answered Mar 18, 2012 at 10:06

giorashc

13.7k3 gold badges38 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user996502 Over a year ago

public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub db.execSQL("create table " + IncomeTable + " (" + colID + " Integer PRIMARY KEY AUTOINCREMENT, " + colIncome + " money);"); db.execSQL("create table " + ExpenseTable + " (" + colExpID + " Integer PRIMARY KEY AUTOINCREMENT, " + colExpExpense + " text, " + colExpAmount + " money);"); }

user996502 · Accepted Answer · 2012-03-18 19:36:51Z

0

public void onCreate(SQLiteDatabase db) {
            // TODO Auto-generated method stub
            db.execSQL("create table " + IncomeTable + " (" + colID + " Integer PRIMARY KEY AUTOINCREMENT, " + colIncome + " money);");
            db.execSQL("create table " +  ExpenseTable + " (" + colExpID + " Integer PRIMARY KEY AUTOINCREMENT, " + colExpExpense + " text, " + colExpAmount + " money);");

        }

answered Mar 18, 2012 at 19:36

user996502

3071 gold badge8 silver badges19 bronze badges

Collectives™ on Stack Overflow

SQLite query data that returns a Integer Array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related