NvHZNGAL

1package com.manujcm.dbexampleone;
2
3import android.database.Cursor;
4import android.database.sqlite.SQLiteDatabase;
5import android.support.v7.app.AppCompatActivity;
6import android.os.Bundle;
7import android.util.Log;
8
9public class MainActivity extends AppCompatActivity {
10
11    @Override
12    protected void onCreate(Bundle savedInstanceState) {
13        super.onCreate(savedInstanceState);
14        setContentView(R.layout.activity_main);
15
16        try {
17            // Create database
18            SQLiteDatabase db = this.openOrCreateDatabase("People", MODE_PRIVATE, null);
19
20            // Create tables and insert rows
21            db.execSQL("CREATE TABLE IF NOT EXISTS people (name VARCHAR, age INT(3))");
22            db.execSQL("INSERT INTO people (name, age) VALUES ('Manu', 36)");
23            db.execSQL("INSERT INTO people (name, age) VALUES ('John', 25)");
24            db.execSQL("INSERT INTO people (name, age) VALUES ('Katsu', 30)");
25
26            // Get data from databases
27            Cursor cr = db.rawQuery("SELECT * FROM friends WHERE name LIKE '%a%' AND age > 30 LIMIT 1", null);
28
29            // In Android Studio column indexes are needed
30            int nameIndex = cr.getColumnIndex("name");
31            int ageIndex = cr.getColumnIndex("age");
32
33            cr.moveToFirst();
34            while (cr != null) {
35                String msg = cr.getString(nameIndex) + " - " + Integer.toString(cr.getInt(ageIndex));
36                Log.i("ROW: name - age: ", msg);
37                cr.moveToNext();
38            }
39        }
40        catch (Exception e) {
41            e.printStackTrace();
42        }
43    }
44}