A small example of SQLite search in Android _android

Name Hobby

Tom Football

Peter Basketball

What do we do if we want to look for a line of data on hobbies that are football? Find a lot of methods on the Internet, feel all say not to the idea, so wasted a lot of time, fortunately finally solved, the solution is as follows

[Java]

Copy Code code as follows:

Cursor Mcursor=msqlitedatabase.query (tablename, new string[]{"id as _id", "name", "Hobby"}, "Hobby=?", New string[]{ Hobbyinput}, NULL, NULL, NULL);

Cursor Mcursor=msqlitedatabase.query (tablename, new string[]{"id as _id", "name", "Hobby"}, "Hobby=?", New string[]{ Hobbyinput}, NULL, NULL, NULL);

Basically is such a statement how so simple a word, many people on the net write is not right, notice hobbyinput is a variable, can write football or basketball again or is you define a formal parameter