Android中模糊查询: 1:使用拼接字符串形式写sql语句 findUrl = "select * from personinfo where name like '%" + name + "%'";
cursor = SQLiteOperater.getDbInstance().queryBySQL(findUrl, null);
2:使用占位符来写sql语句 findUrl = "select * from personinfo where name like ?";
cursor = SQLiteOperater.getDbInstance().queryBySQL(findUrl, new String[]{ "%"+name+"%"});
建立表建立主键的sql语句:
CREATE TABLE personinfo (
id integer primary key autoincrement ,
name varchar,
age integer,
sex varchar,
job varchar
);