我使用
eclipse在
java中创建了一个
Android应用程序,它创建了一个Sqlite数据库,并允许用户向其添加数据.用户还可以搜索现有数据.
我使用了android游标对象.
查询完成后如何清除文本框?
例如,我键入“value”以检索与该值关联的所有记录.现在我想进行另一次搜索.当我单击文本框时,我希望清除文本框以进行下一次搜索.
这是我插入和检索数据的代码的一部分:
db.execSQL("CREATE TABLE IF NOT EXISTS " + MY_DATABASE_TABLE + " (id INTEGER PRIMARY KEY AUTOINCREMENT, " + " name TEXT," + " number TEXT);");
Cursor cur = db.rawQuery("INSERT INTO " + MY_DATABASE_TABLE + " (name, number)" + " VALUES ( \"" + newname + "\", \"" + newnumber + "\");", null);
cur.moveToFirst();
while (cur.isAfterLast() == false)
{
result.append("\n" + "Id: " + cur.getString(0) + " | " + "Name: " + cur.getString(1) + " | " + "Phone Number: " + cur.getString(2) + "\n");
cur.moveToNext();
}
cur.close();
Cursor c = db.rawQuery("SELECT * FROM " + MY_DATABASE_TABLE, new String [] {} );
c.moveToFirst();
while (c.isAfterLast() == false) {
result.append("\n" + "Id: " + c.getString(0) + " | " + "Name: " + c.getString(1) + " | " + "Phone Number: " + c.getString(2) + "\n");
c.moveToNext();
}
c.close();
谢谢.