Actually it is a render time log. No connection with java code. I also have same log. and i feel its cause by : SupportMapFragment in xml file. When i touch Map, GL render layout and prints this log.
It is inside Map Library. So we can't modify it. but i think sometimes it cause memory overload. and so system calls GC to dump memory.
It's just a warning. So ignore it for now. but it should be fix by Google map library maker.
Android platform includes the SQLite embedded database and provides out of the box support to use it via Android APIs. In this tutorial we shall see how to get started with SQLitedatabase in Android. SQLiteis nothing but a relational database and our SQLskills will help.
How to Use SQLite with Android?
To use SQLitein Android, a java class should be created as a sub class of SQLiteOpenHelper.
This class will act as a database controller which will have the
methods to perform the CRUD operations. This custom java class should
override the methods named onCreate()and .onUpgrade() onCreate() method will be called for the first time when
the Android application is run. First the database instance should be
created using the method like getReadableDatabase() or getWritableDatabase() based on the type of access required. Android supports this method by providing in-built methods. For that, SQLiteQueryBuilder class should be imported.
Lets have three Android Activity for List, Add and Edit operations and ensure that these are declared in manifest file. And then we need to create subclass of SQLiteHelper to manage SQLite database.
+------------+------------+------------------------------+---+--------+--+
| Field Name | Field Type | Sample |
+------------+------------+------------------------------+---+--------+--+
| ID | PRIMARY KEY [Auto Generated] | 1 |
| Name | TEXT | Chintan Khetiya |
| Number | TEXT | 787-806-0124 |
| Email | TEXT | khetiya.chintan@gmail.com |
+------------+------------+------------------------------+---+--------+--+
Create or Setup Database:
DatabaseHandler.java is going to be our custom java class that will
manage the SQLite database. We should extend SQLiteOpenHelper and
override the essential methods. The constructor is the hook that will be
used to setup the database. While running the Android application, the
database will be created for the first time.
SQLiteOpenHelper provides callback methods and we should override it to get our job done. Those callback methods that we can override are onCreate(), onUpgrade(), onOpen() and onDowngrade(). And onCreate() and onUpgrade() are abstract methods and must be overridden. onCreate(SQLiteDatabase database) – is the method which
is called first time when the database is created and we need to use
this method to create the tables and populate it as per the need.
db.execSQL("DROP TABLE IF EXISTS "+ TABLE_CONTACTS);
// Create tables again
onCreate(db);
}
@Override
public void onCreate(SQLiteDatabase db) {
String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "(" +
KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT," +
KEY_PH_NO + " TEXT," + KEY_EMAIL + " TEXT" + ")";
db.execSQL(CREATE_CONTACTS_TABLE);
}
onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)– is the method called when upgrade is done.We can drop the database and reset
if required.
// Upgrading database
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// Drop older table if existed
db.execSQL("DROP TABLE IF EXISTS " + TABLE_CONTACTS);
// Create tables again
onCreate(db);
}
How it looks after all task ?
Add New user
Update Record
Delete Record
View All
Note:The Contact details are fake or random
Do some Task :
We shall have other user defined methods to handle the sql aobve
operations. The <code>Contact table </code> will be created
when the onCreate() method is invoked while installing the application. For performing operations like insert, update, the SQLiteDatabase instance should be created using the methods like getReadableDatabase() or getWritableDatabase(). ContentValues() are used to pass values to the query.
