passing a parameter from MainActivity.java into my SQLiteOpenHelper class

Kevin

I have set up my SQLiteOpenHelper class and all working ok to retrieve all data in the sqLite database. I now want tp pass a parameter from mainActivity into my SQLiteOpenHelper class to find certain records. User will enter search criteria into a field and i want to pass that user entry to be searched. Currently i have hard coded to search for category 161 but this is where i want to be able to use the parameter passed by the user. I have put my SQLiteOpenerHelper code and my mainActivty code below. I have tried passing a parameter into the getAllUsers() in mainActivity file but Android will not accept parameters. Can someone please help in showing me what i need to do to pass the parameter i need into the sqLite query

SQLiteOpenHelper class

public ArrayList<HashMap<String, String>> getAllUsers() {
        ArrayList<HashMap<String, String>> usersList;
        usersList = new ArrayList<HashMap<String, String>>();
        String[] columns = {"id", "company", "firstname", "lastname", "category"};

        SQLiteDatabase database = this.getWritableDatabase();
        Cursor cursor = database.query("members", columns, "category = 161", null, null, null, "company");
        if (cursor.moveToFirst()) {
            do {
                HashMap<String, String> map = new HashMap<String, String>();
                map.put("id", cursor.getString(0));
                map.put("company", cursor.getString(1));
                map.put("firstname", cursor.getString(2));
                map.put("lastname", cursor.getString(3));
                map.put("category", cursor.getString(4));

                usersList.add(map);
            } while (cursor.moveToNext());
        }
        database.close();
        return usersList;
    }

mainActivity.java

@Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        // Get User records from SQLite DB
        ArrayList<HashMap<String, String>> userList = controller.getAllUsers();
Nabin Bhandari

I don't see a problem here. Just define the method as:

public ArrayList < HashMap< String, String >> getAllUsers(int category){
    //
}

Then instead of "category = 161", use "category = " + category as the third parameter in query.

And call it from main activity as:

ArrayList < HashMap< String , String>> userList = controller.getAllUsers(161);

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Passing data from the class to the MainActivity

From Dev

My class derived from SQLiteOpenHelper is getting huge

From Dev

My class derived from SQLiteOpenHelper is getting huge

From Dev

Passing parameter to sh file from java class

From Dev

Passing parameter to anonymous class in Java

From Dev

Passing value from MainActivity to custom listview adapter class

From Dev

How can my method, which is being called by another class, obtain a variable from that class without passing it as a parameter?

From Dev

Passing a parameter from Jenkins into Java

From Dev

Having trouble running a method from my SQLiteOpenHelper class in an Async task in another class

From Dev

Passing Enums as parameter from abstract class

From Dev

Passing a parameter to a class based view from a redirect

From Dev

Java boolean not passing from class

From Dev

Java boolean not passing from class

From Dev

Passing a variable from MainActivity to a Fragment

From Dev

Passing a List From the MainActivity to a Fragment

From Dev

Passing a class with type parameter as type parameter for generic method in Java

From Dev

Passing parameter from Java to Python and vise versa

From Dev

Parameter Passing using java/jdbc from a JtextField

From Dev

Passing parameter from Java to Python and vise versa

From Dev

Java - Passing a parameter to a class constructor, when an array of that class is being created

From Dev

Passing a class as function parameter

From Dev

Passing Child class as parameter

From Dev

Passing Scala Class as parameter?

From Dev

Passing class as a Parameter

From Dev

Passing Child class as parameter

From Dev

JAVA: Passing values from one class to another

From Dev

Passing an ArrayList from one class to another in Java

From Dev

Run a java method by passing class name and method name as parameter

From Dev

No PlaceholderFragment class in MainActivity.java

Related Related

  1. 1

    Passing data from the class to the MainActivity

  2. 2

    My class derived from SQLiteOpenHelper is getting huge

  3. 3

    My class derived from SQLiteOpenHelper is getting huge

  4. 4

    Passing parameter to sh file from java class

  5. 5

    Passing parameter to anonymous class in Java

  6. 6

    Passing value from MainActivity to custom listview adapter class

  7. 7

    How can my method, which is being called by another class, obtain a variable from that class without passing it as a parameter?

  8. 8

    Passing a parameter from Jenkins into Java

  9. 9

    Having trouble running a method from my SQLiteOpenHelper class in an Async task in another class

  10. 10

    Passing Enums as parameter from abstract class

  11. 11

    Passing a parameter to a class based view from a redirect

  12. 12

    Java boolean not passing from class

  13. 13

    Java boolean not passing from class

  14. 14

    Passing a variable from MainActivity to a Fragment

  15. 15

    Passing a List From the MainActivity to a Fragment

  16. 16

    Passing a class with type parameter as type parameter for generic method in Java

  17. 17

    Passing parameter from Java to Python and vise versa

  18. 18

    Parameter Passing using java/jdbc from a JtextField

  19. 19

    Passing parameter from Java to Python and vise versa

  20. 20

    Java - Passing a parameter to a class constructor, when an array of that class is being created

  21. 21

    Passing a class as function parameter

  22. 22

    Passing Child class as parameter

  23. 23

    Passing Scala Class as parameter?

  24. 24

    Passing class as a Parameter

  25. 25

    Passing Child class as parameter

  26. 26

    JAVA: Passing values from one class to another

  27. 27

    Passing an ArrayList from one class to another in Java

  28. 28

    Run a java method by passing class name and method name as parameter

  29. 29

    No PlaceholderFragment class in MainActivity.java

HotTag

Archive