在Android的SQLite数据库的选择查询与从句之间沿 [英] SQLite Database in Android for select query along with between clause

问题描述

我正在使用Android的SQLite数据库。我在SQLite数据库中使用 rawQuery 。我该数据库的方法如下：

I am using SQLite Database in Android. I have used rawQuery in SQLite database. My Database method for that is as follows:

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文件是

and my .java file is

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(); 
}

主要的问题是，它会返回的RowId 从 salesMaster 表按从最新的和最新但实际的问题是，它会返回值，但不包括最后的更新。

The main problem is that it will return RowId from salesMaster table as per from-date and to-date, but actual problem is it will return values but not include last to-date.

例如，如果我想的RowId 从25/02/2015到28/02/2015
所以它会给的RowId 从25/02/2015到27/02/2015，但不包括28/02/2015。

For example, if I want to RowId from 25/02/2015 to 28/02/2015 so it will give RowId from 25/02/2015 to 27/02/2015 but not included 28/02/2015.

推荐答案

您必须更换 之间

防爆pression（分钟＆lt; = EXPR EXPR和LT＆=最大值）

Expression (min <= expr AND expr <= max)

更改您查询到

 String str_k="SELECT * from TABLE_NAME Where COLUMN_NAME >='"+from_date+ "' AND <= '"+to_date+ "'";

            System.out.println(str_k);

这篇关于在Android的SQLite数据库的选择查询与从句之间沿的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！