Create SQLite database in android

by

Better example is here

 try {
   myDB = this.openOrCreateDatabase("DatabaseName", MODE_PRIVATE, null);

   /* Create a Table in the Database. */
   myDB.execSQL("CREATE TABLE IF NOT EXISTS "
     + TableName
     + " (Field1 VARCHAR, Field2 INT(3));");

   /* Insert data to a Table*/
   myDB.execSQL("INSERT INTO "
     + TableName
     + " (Field1, Field2)"
     + " VALUES ('Saranga', 22);");

   /*retrieve data from database */
   Cursor c = myDB.rawQuery("SELECT * FROM " + TableName , null);

   int Column1 = c.getColumnIndex("Field1");
   int Column2 = c.getColumnIndex("Field2");

   // Check if our result was valid.
   c.moveToFirst();
   if (c != null) {
    // Loop through all Results
    do {
     String Name = c.getString(Column1);
     int Age = c.getInt(Column2);
     Data =Data +Name+"/"+Age+"\n";
    }while(c.moveToNext());
   }

More Related Contents:

  1. Android :: SQLIte Db don't insert the datas
  2. How can I avoid concurrency problems when using SQLite on Android?
  3. Android SQLite database: slow insertion
  4. Pros and Cons of SQLite and Shared Preferences [closed]
  5. Share SQLite database between 2 android apps?
  6. Android: upgrading DB version and adding new table
  7. How do I view the SQLite database on an Android device? [duplicate]
  8. Best way to work with dates in Android SQLite [closed]
  9. Android SQLite Example [closed]
  10. Android database encryption
  11. Import .csv file to Sqlite in Android
  12. How to add new Column to Android SQLite Database?
  13. What is a Full Android Database Helper class for an existing SQLite database? [closed]
  14. How do I create a database in android? [closed]
  15. How to save images into Database
  16. Android SimpleCursorAdapter doesn’t update when database changes
  17. Android SQLite Database, WHY drop table and recreate on upgrade
  18. SQLite simultaneous reading and writing
  19. update sql database with ContentValues and the update-method
  20. How does one check if a table exists in an Android SQLite database?
  21. Could not allocate CursorWindow
  22. Saving ArrayLists in SQLite databases
  23. android, how to exec a sql file in sqlitedatabase
  24. SQLiteOpenHelper – creating database on SD card
  25. SQLite android column not found
  26. How to store JSON object in SQLite database
  27. H2 Database vs SQLite on Android [closed]
  28. SQLiteOpenHelper onUpgrade() Confusion Android
  29. Using COLLATE in Android SQLite – Locales is ignored in LIKE statement
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment