我是SQLite的新手。我有一个包含3列的表格。
1. Id
2. FoodName
3. Date and time
(ex: '1' 'Chicken' '2012-08-10 13:54')
我曾经看过一篇文章,说Android SQLite不提供日期数据类型。
因此,我使用文本数据类型在本地数据库中存储日期,它运行良好。
现在我想编写一个查询以检索两个日期之间的记录。我尝试过,但是我没有得到结果。
==>> 代码
public class FoodDB {
//Database Related Constants
public static final String KEY_ROWID = "id";
public static final String KEY_NAME = "fooditem";
public static final String KEY_TIMESTAMP = "timestamp";
private static final String DATABASE_NAME = "AJFoodDB";
private static final String DATABASE_TABLE = "AJ_Food";
private static final int DATABASE_VERSION = 1;
Cursor c;
long id;
private static final String DATABASE_CREATE =
"create table "+DATABASE_TABLE+" (id integer primary key autoincrement, "
+ KEY_NAME+" text not null,"
+ KEY_TIMESTAMP+" text not null);";
private final Context context;
private DatabaseHelper DBHelper;
private SQLiteDatabase sqlitedatabase;
public FoodDB(Context ctext){
context = ctext;
}
private static class DatabaseHelper extends SQLiteOpenHelper
{
DatabaseHelper(Context context)
{
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
public void onCreate(SQLiteDatabase db)
{
db.execSQL(DATABASE_CREATE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
{
db.execSQL("DROP TABLE IF EXISTS titles");
onCreate(db);
}
}
//Insert Row
public void insertSSFiltersDetails(String keyname, String timestamp){
try
{
DBHelper = new DatabaseHelper(context);
sqlitedatabase = DBHelper.getWritableDatabase();
insertRow(keyname, timestamp);
sqlitedatabase.close();
} catch (Exception e) {
System.out.println("Error from inserting data->"+e.toString());
}
}
public long insertRow(String keyname, String timestamp){
ContentValues initialValues = new ContentValues();
initialValues.put(KEY_NAME, keyname);
initialValues.put(KEY_TIMESTAMP, timestamp);
return sqlitedatabase.insert(DATABASE_TABLE, null, initialValues);
}
//Close Data Base
public void closeDBHelper(){
if(DBHelper != null){
DBHelper.close();
}
if (c != null) {
c.close();
c = null;
}
} }
查询和表格 选择 * 从 AJ_Food;
1|rice |8/12/2011 16:11
2|Rice |8/13/2012 11:42
3|chicken|8/13/2012 11:42
4|Prawans|8/13/2012 11:43