可能重复：结果  在android系统 sqlite的示例程序

Possible Duplicate: sqlite example program in android

您好我是新来的Andr​​oid和我有一些很难找到一个很好的教程SQLite数据库。我想要做的是存储一行在数据库中的数据，随后参考，然后删除它一旦其被引用。正如我刚才所说我是新来这样的事情，并没有任何线索，甚至任何东西的语法是如此，如果有一个简单的教程在那里，我想知道。

Hi I'm new to android and I am having some trouble finding a good tutorial for an SQLite database. What I wanted to do was to store a line of data in the database, reference it later and then delete it once its been referenced. As I have said I am new to this sort of thing and have no clue even what any of the syntax is so if there is a simple tutorial out there I would like to know.

推荐答案

试试这个

try { // creating a database called db and a Table inside it, called
            // userdetails. With username and password as columns.

        db = openOrCreateDatabase("UserDetails.db",
                Context.MODE_PRIVATE, null); // optional CursorFactory
        db.execSQL("drop table if exists userdetails");
        db.execSQL("create table userdetails " + " ( username TEXT,"
                + "password TEXT);");

    } catch (SQLException x) {
        x.printStackTrace();
        Log.e(LOG_TAG_NAME, "Database creation error");

    }

//.........................................................................
    // and insert values into the database table.
    try {
        db.execSQL("INSERT INTO " + "userdetails"
                + " (username,password)" + " VALUES ('hi','hello');");
        db.execSQL("INSERT INTO " + "userdetails"
                + " (username,password)" + " VALUES ('chris','gayle');");
        db.execSQL("INSERT INTO " + "userdetails"
                + " (username,password)" + " VALUES ('v','v');");
    } catch (Exception e) {
        e.printStackTrace();
        Log.e(LOG_TAG_NAME, "inserting table values error");
    }
    String[] columns = { "username", "password" };
    Cursor c = db.query("userdetails", columns, null, null, null, null,
            null);

现在使用的游标检索值

now use the cursor to retrieve values

也看看

http://developer.android.com/guide/topics/data/data-storage.html#db

希望这一切帮助