(android) how to use variable in sql?

Question

I want to use variable value in where condition in select query.

But database reconnized it as a String.

What should i do?

Here is code

public static void getCommentListOnlyTwoFromDB(int id) {
       
        String sql = "SELECT writer, contents, rating, time, recommend FROM CommentList WHERE movieID=id"; // HERE
        ArrayList<CommentModel> data = new ArrayList<>();
        Cursor cursor = database.rawQuery(sql, null );
    }

When I execute this code. 'WHERE movieID=id' is just String as movieID=id...

I want to put id value in movieID.

please help me.

THANK YOU!

mostafa3dmax · Accepted Answer · 2020-11-28 17:55:45Z

2

public static void getCommentListOnlyTwoFromDB(int id) {
       
        String sql = "SELECT writer, contents, rating, time, recommend FROM CommentList WHERE movieID=" + id; // HERE
        ArrayList<CommentModel> data = new ArrayList<>();
        Cursor cursor = database.rawQuery(sql, null );
    }

answered Nov 28, 2020 at 17:55

mostafa3dmax

1,0478 silver badges21 bronze badges

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

1 Comment

ybybyb Over a year ago

OMG..... I'm so so EMBARRASSED. I tried various things. But i don't tried to "movieID=" + id...i tried to "movieID" + "=id".. i'm stupid.. i'm sorry.. and THX

Collectives™ on Stack Overflow

(android) how to use variable in sql?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related