Question

我计划制作一个数据,让用户从一个特定数据库中选择记录,例如:

               name    favorite_color       favorite_team  
               sue        red                  Dal
               mike       blue                 Mia
               sam        purple               Bal

My problem is that most of the tutorials that I have come across only demonstrates examples using a table with one column. What if my pre-populated database more then on column? What if it had 100 columns? Does anyone know how this is done?????

Answer 1

例如:

步骤1:DeclarekouiteDatabase,Declare Databasehelper

步骤2:将标记或编号用作钥匙或使其成为意图(例如增长)

步骤3:在“网上”方法中,添加类似于以下的编码线:

        String query="select * from my_table_name where _id="+rowid;
        Cursor myCursor = database.rawQuery(query,null);
        myCursor.moveToFirst();
        //This line implies i am getting data from column four of selected row
        String x=myCursor.getString(4);
        //This line implies i am getting data from column two of selected row
        String y=myCursor.getString(4);
        myCursor.close();

Note: a)Don t forget that your database size must not exceed 1.2mb

b) 包括一个名称栏,每个表格的自动安装可使用qlite浏览器。

c) 还在贵数据库中设立以下表格:

CREATE TABLE "android_metadata" ("locale" TEXT DEFAULT  en_US )

现在,在“Rodid_metadata”表中插入一行,其文本为_US

INSERT INTO "android_metadata" VALUES ( en_US )

Answer 2

this。获取散射信息的另一个途径是使用类似于点燃的口服避孕药。 I m在i ve开发的各种器具中使用,而且使用简单。

友情链接