android sqlite cannot insert and select

hallz13

Hello guys I have tried this code, but it didn't work.. I cannot insert and select from database sqlite android.

Question : Did i something wrong?

Code:

public class Test extends SQLiteOpenHelper {

private static final String DATABASE_CREATE = "CREATE TABLE PLS (" + 
         "id text, " + 
         "nama text);";

public Test(Context context) {
    super(context, "ABC.db", null, 1);
    // TODO Auto-generated constructor stub
}


@Override
public void onCreate(SQLiteDatabase db) {
    // TODO Auto-generated method stub
    db.execSQL(DATABASE_CREATE);
    db.execSQL("INSERT INTO PLS VALUES('1', 'dede');");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    // TODO Auto-generated method stub
    db.execSQL("DROP TABLE IF EXISTS PLS");
    onCreate(db);
}

public ArrayList<HashMap<String, String>> getUser() {
    ArrayList<HashMap<String, String>> wordList;
    wordList = new ArrayList<HashMap<String, String>>();
    String selectQuery = "SELECT id, nama FROM PLS";
    SQLiteDatabase database = this.getWritableDatabase();
    Cursor cursor = database.rawQuery(selectQuery, null);
    if (cursor.moveToFirst()) {
      do {
        HashMap<String, String> map = new HashMap<String, String>();
        map.put("id", cursor.getString(0));
        map.put("nama", cursor.getString(1));
      } while (cursor.moveToNext());
    }
    return wordList;
}

public void addUser(String id, String nama) {
    SQLiteDatabase database = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put("id", id);
    values.put("nama", nama);
    database.insert("PLS", null, values);
    database.close();
  }
}

And here is the code for inserting and selecting to and from sqlite:

    controller = new Test(this);
    user = new ArrayList<HashMap<String,String>>();
    controller.addUser("1", "daniel");

    user = controller.getUser();

    for(int i=0; i<user.size(); i++){
        tempMenu = new HashMap<String, String>();
        tempMenu = user.get(i);
        i1.setText(tempMenu.get("id"));
        i2.setText(tempMenu.get("nama"));
    }
MohamedZaatari

I think you code is right except that you forgot to fill wordList variable! before you returned it in getUser() function...

if (cursor.moveToFirst()) {
  do { 
    HashMap<String, String> map = new HashMap<String, String>();
    map.put("id", cursor.getString(0));
    map.put("nama", cursor.getString(1));
    //Here you forgot wordList.add(map);
  } while (cursor.moveToNext());
} 

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0

関連記事

分類Dev

Android SQLite select with like

分類Dev

Android:SQLITE Select Query

分類Dev

Android SQLite:insert()の問題

分類Dev

Android Sqlite insert speed when query for duplicates

分類Dev

Use SQLite INSERT code with a string in android

分類Dev

Android sqlite if rowid exsist update else insert

分類Dev

Android SQLite SELECTクエリ

分類Dev

Android sqlite select querywhere句と配列値

分類Dev

SQLite: How to retrieve data from column in one table using SELECT to insert retrieved data in another table

分類Dev

SQLite INSERT OR REPLACE with condition

分類Dev

SQLite trigger before insert

分類Dev

Select cannot be pressed in android phone, but can be selected in iphone

分類Dev

Android - ListView with Spinner - cannot select the list item (as a whole)

分類Dev

SQL Select In Select for insert Stement

分類Dev

Cannot insert data in laravel

分類Dev

postgresql:INSERT INTO ...(SELECT * ...)

分類Dev

Insert ... select with enums in jOOQ

分類Dev

Apache Camel select then insert

分類Dev

Select if exist else insert?

分類Dev

SQL CASE SELECT INSERT

分類Dev

SQL select and insert if not exists

分類Dev

converting insert into to select

分類Dev

MySql Insert Into Select Sum

分類Dev

INSERT INTO ... mysqlのSELECT

分類Dev

SQLite Slow Select Query

分類Dev

SQLite select numbers of album

分類Dev

Error with a bash loop for sqlite insert

分類Dev

Insert String into JDBC SQLite database

分類Dev

MySQL equivelant of SQLite INSERT or REPLACE INTO