SQLite查询语句的问题,急呀!!!
判空的是传递的参数,刚从J2ME转Android,请帮忙看看应该怎么写。
需要判断的主要是lat 和lon 的范围,这样使用Bewteen...and对不对啊,完全搞不懂唉!
StringBuffer sql = new StringBuffer("SELECT * FROM "
+ Database.TABLE_NAME + " WHERE lat BEWTEEN " + latMin
+ " AND " + latMax + " AND lon BEWTEEN " + lonMin + " AND "
+ lonMax);
if (shopType != null)
{
sql.append(" AND ");
sql.append("shopType = " + shopType);
}
if (privilege_1 != null)
{
sql.append(" AND ");
sql.append("privilege_1 = " + privilege_1);
}
if (privilege_2 != null)
{
sql.append(" AND ");
sql.append("privilege_2 = " + privilege_2);
}
if (privilege_3 != null)
{
sql.append(" AND ");
sql.append("privilege_3 = " + privilege_3);
}
Cursor cursor = db.rawQuery(sql.toString(), null);