SQLite的查询:与BETWEEN子句选择查询 [英] SQLite Query : Select Query with BETWEEN clause
本文介绍了SQLite的查询:与BETWEEN子句选择查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我要运行Android应用程序此查询:
选择场1 FROM表1
其中,字段1 =?(enteredField1)和Field2 =?(enteredField2)
和enteredField3之间FIELD3,字段4
;
我的数据库架构
表1(字段1,场2,FIELD3,字段4,字段5)
enteredField1,2,3 =是参数将被检查。
我希望我清楚我的问题。
这里是功能 -
公共布尔checkData(字符串独立写作,字符串DTE1,字符串startTime1)
{ //字段1 =任务,fiels 2 = DTE,现场3 = startHr,现场4 = endHr
// enteredField 1,2,3 =独立写作,DTE1,startTime1
//这里我要插入查询 INT A = cursor.getCount();
如果(一个大于0)
{
返回true;
}
返回false;
}
解决方案
您可以使用的 SQLiteQueryBuilder 解决您的问题。下面是一个例子,希望能有所帮助。
SQLiteQueryBuilder QB =新SQLiteQueryBuilder();
SQLiteDatabase DB = NULL; //这里得到你的数据库实例。
qb.setTables(表1);
qb.appendWhere(字段1 = 1和Field2 =?);
qb.query(DB,新的String [] {字段1},enteredField3之间FIELD3和字段4,
新的String [] {enteredField1,enteredField2},NULL,NULL,NULL);
I want to run this query in Android Application :
SELECT field1 FROM table1
where field1 = ?(enteredField1) AND field2 = ?(enteredField2)
AND enteredField3 BETWEEN field3 , field4
;
my DB schema
table1(field1, field2, field3, field4, field5)
enteredField1 , 2 , 3 = are parameters which is to be checked.
I hope I am clear with my question.
here is the function -
public boolean checkData(String task1, String dte1, String startTime1 )
{
// field 1 = task , fiels 2 = dte, field 3 = startHr, field 4 = endHr
// enteredField 1,2,3 = task1, dte1, startTime1
// here I want to insert the query
int a = cursor.getCount();
if(a>0)
{
return true;
}
return false;
}
解决方案
you can use SQLiteQueryBuilder to solve your problem. Following is an example for you, hope it can help.
SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
SQLiteDatabase db = null; // get your database instance here.
qb.setTables("table1");
qb.appendWhere("field1 = ? AND field2 = ?");
qb.query(db, new String[] { "field1" }, "enteredField3 BETWEEN field3 AND field4",
new String[] { "enteredField1", "enteredField2"}, null, null, null);
这篇关于SQLite的查询:与BETWEEN子句选择查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文