Question

我正在开发一个海底数据库应用程序。我只想知道,哪一部法典能够更快地实施,它们之间的差别如何?

www.un.org/Depts/DGACM/index_spanish.htm 学历:1

db.rawQuery("select * from user_table where user_id =" + userId, null);

www.un.org/Depts/DGACM/index_spanish.htm 学历: 2

db.query(USER_TABLE_NAME, ALL_COLUMNS, "user_id = " + userId, null, null, null, null);

Answer 1

使用查询。

简便的问询和使用太多不同的原始查询可能会引起履约问题。

Use rawQuery only when absolutely needed.

Also, both your example have a MAJOR security issue of SQL Injection.

你们应当使用户感到.。

The most obvious thing to do is let Android do it by using:

db.query(USER_TABLE_NAME, ALL_COLUMNS, "user_id = ?", new String[] {userId}, null, null, null);

Answer 2

Looking at SQLiteDatabase.java in the android source shows that the query(..) ends up calling the QueryBuilder to build the query as a single string and then it essentially calls rawQuery(). They should be roughly equivalent, assuming that you also did the same work to build your own statement.

友情链接