SQLite数据库与我使用Android中SQLite数据库条款
之间沿选择查询。我在SQLite数据库中使用了rawQuery
。我该数据库的方法如下:SQLite数据库与我使用Android中SQLite数据库条款
public Cursor selectedDate(String from_dt ,String to_dt)
{
try
{
String str_k="select RowId,Bill_Date from SalesMaster Where Bill_Date between '"+
from_dt+ "'and'"+to_dt+ "'";
System.out.println(str_k);
Cursor c1 = sqldb.rawQuery(
"select RowId from SalesMaster Where Bill_Date between '"+
from_dt+ "'and'"+to_dt+ "'", null);
return c1;
}
catch(Exception e)
{
System.out.println("inside database file "+ e);
return null;
}
}
和我的java文件是
public void ReportSell(String from_dt,String to_dt)
{
System.out.println("report selling method has been called");
String RowId="";
item db1 = new item(getBaseContext());
db1.openDb();
try
{
final Cursor cursor = db1.selectedDate(from_dt, to_dt);
if(cursor.moveToFirst())
{
do
{
RowId= cursor.getString(cursor.getColumnIndex("RowId")).toString();
System.out.println("inside java Row Id file "+ RowId);
salesid.add(RowId);
ArrayAdapter <String> adapter = new ArrayAdapter <String>(this,
android.R.layout.simple_list_item_1,
salesid);
} while(cursor.moveToNext());
}
else
{
Toast.makeText(getApplicationContext(), "No data found",
Toast.LENGTH_LONG).show();
}
} catch(Exception e)
{
System.out.println("inside java file "+ e);
}
db1.closeDb();
}
的主要问题是,它会从salesMaster
表返回RowId
按照从最新的和最新,但实际的问题是它会返回值,但不包括最新的到期日期。
例如,如果我想从RowId
到25/02/2015 28/02/2015 所以它会给RowId
从25/02/2015到27/02/2015,但不包括28/02/2015 。
必须更换between
到
表达(分< = EXPR和EXPR < =最大值)
更改您查询到
String str_k="SELECT * from TABLE_NAME Where COLUMN_NAME >='"+from_date+ "' AND <= '"+to_date+ "'";
System.out.println(str_k);
其返回的语法错误附近“ =” – 2015-03-03 03:46:43
请发布您的str_k完整的字符串由System.out.println(str_k)打印; – IshRoid 2015-03-03 05:04:12
所以,你要添加1天to yourDate – 2015-03-02 11:59:10