yGpGZ4DG

1package com.example.reto2;
2
3import android.content.Context;
4import android.database.Cursor;
5import android.database.sqlite.SQLiteDatabase;
6import android.database.sqlite.SQLiteOpenHelper;
7
8import androidx.annotation.Nullable;
9
10import java.util.ArrayList;
11
12public class DataBaseSQL extends SQLiteOpenHelper {
13    protected SQLiteDatabase db;
14    public DataBaseSQL( Context context){
15        super(context, "Reto2", null, 1);
16    }
17
18    @Override
19    public void onCreate(SQLiteDatabase db) {
20        db.execSQL(
21                "create table frasesanimo " +
22                        "(id integer primary key autoincrement not null, frase text)"
23        );
24        db.execSQL("INSERT INTO frasesanimo (frase) VALUES('Frase 1') ");
25        db.execSQL("INSERT INTO frasesanimo (frase) VALUES('Frase 2') ");
26        db.execSQL("INSERT INTO frasesanimo (frase) VALUES('Frase 3') ");
27        db.execSQL("INSERT INTO frasesanimo (frase) VALUES('Frase 4') ");
28        db.execSQL("INSERT INTO frasesanimo (frase) VALUES('Frase 5') ");
29        db.execSQL("INSERT INTO frasesanimo (frase) VALUES('Frase 6') ");
30        db.execSQL("INSERT INTO frasesanimo (frase) VALUES('Frase 7') ");
31        db.execSQL("INSERT INTO frasesanimo (frase) VALUES('Frase 8') ");
32        db.execSQL("INSERT INTO frasesanimo (frase) VALUES('Frase 9') ");
33        db.execSQL("INSERT INTO frasesanimo (frase) VALUES('Frase 10') ");
34    }
35
36    @Override
37    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
38        db.execSQL("DROP table IF exists frasesanimo");
39    }
40
41    public ArrayList<String> getAll(){
42        db = this.getReadableDatabase();
43        ArrayList<String> frases = new ArrayList<String>();
44        Cursor res = null;
45        res = db.rawQuery("SELECT * FROM frasesanimo ORDER BY id ASC", null);
46        res.moveToFirst();
47        while (res.isAfterLast()==false){
48            frases.add(res.getString(res.getColumnIndex("frase")));
49            res.moveToNext();
50        };
51        return frases;
52    }
53}
54