PVRwW6pR

1package com.example.pr_idi.mydatabaseexample;
2
3/**
4 * MySQLiteHelper
5 * Created by pr_idi on 10/11/16.
6 */
7import android.content.ContentValues;
8import android.content.Context;
9import android.database.sqlite.SQLiteDatabase;
10import android.database.sqlite.SQLiteOpenHelper;
11import android.util.Log;
12
13public class MySQLiteHelper extends SQLiteOpenHelper {
14
15    public static final String TABLE_BOOKS = "books";
16    public static final String COLUMN_ID = "_id";
17    public static final String COLUMN_TITLE = "title";
18    public static final String COLUMN_AUTHOR = "author";
19    public static final String COLUMN_YEAR = "year";
20    public static final String COLUMN_PUBLISHER= "publisher";
21    public static final String COLUMN_CATEGORY= "category";
22    public static final String COLUMN_PERSONAL_EVALUATION = "personal_evaluation";
23
24
25    private static final String DATABASE_NAME = "books.db";
26    private static final int DATABASE_VERSION = 1;
27
28    // Database creation sql statement
29    private static final String DATABASE_CREATE = "create table " + TABLE_BOOKS + "( "
30            + COLUMN_ID + " integer primary key autoincrement, "
31            + COLUMN_TITLE + " text not null, "
32            + COLUMN_AUTHOR + " text not null, "
33            + COLUMN_YEAR + " integer, "
34            + COLUMN_PUBLISHER + " text not null, "
35            + COLUMN_CATEGORY + " text not null, "
36            + COLUMN_PERSONAL_EVALUATION + " text"
37            + ");";
38
39    public MySQLiteHelper(Context context) {
40        super(context, DATABASE_NAME, null, DATABASE_VERSION);
41    }
42
43    @Override
44    public void onCreate(SQLiteDatabase database) {
45        database.execSQL(DATABASE_CREATE);
46        InsertLlibres(database);
47    }
48
49    @Override
50    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
51        Log.w(MySQLiteHelper.class.getName(),
52                "Upgrading database from version " + oldVersion + " to "
53                        + newVersion + ", which will destroy all old data");
54        db.execSQL("DROP TABLE IF EXISTS " + TABLE_BOOKS);
55        onCreate(db);
56    }
57
58    void InsertLlibres(SQLiteDatabase database) {
59        ContentValues llibre1, llibre2, llibre3, llibre4;
60        llibre1 = new ContentValues();
61        llibre2 = new ContentValues();
62        llibre3 = new ContentValues();
63        llibre4 = new ContentValues();
64        llibre1.put(COLUMN_TITLE,"The Lord Of The Rings");
65        llibre1.put(COLUMN_AUTHOR,"J.R.R.Tolkien");
66        llibre1.put(COLUMN_YEAR,1950);
67        llibre1.put(COLUMN_PUBLISHER,"minotauro");
68        llibre1.put(COLUMN_CATEGORY,"Fantasia");
69        llibre1.put(COLUMN_PERSONAL_EVALUATION,"regular");
70        llibre2.put(COLUMN_TITLE,"Harry Potter");
71        llibre2.put(COLUMN_AUTHOR,"J.K.Rowling");
72        llibre2.put(COLUMN_YEAR,1995);
73        llibre2.put(COLUMN_PUBLISHER,"Salamanca");
74        llibre2.put(COLUMN_CATEGORY,"Fantasia");
75        llibre2.put(COLUMN_PERSONAL_EVALUATION,"molt bo");
76        llibre3.put(COLUMN_TITLE,"Pirates Of The Caribbean");
77        llibre3.put(COLUMN_AUTHOR,"Disney");
78        llibre3.put(COLUMN_YEAR,2000);
79        llibre3.put(COLUMN_PUBLISHER,"Rob Kid");
80        llibre3.put(COLUMN_CATEGORY,"Fantasia");
81        llibre3.put(COLUMN_PERSONAL_EVALUATION,"molt bo");
82        llibre4.put(COLUMN_TITLE,"Star Wars");
83        llibre4.put(COLUMN_AUTHOR,"George Lucas");
84        llibre4.put(COLUMN_YEAR,1970);
85        llibre4.put(COLUMN_PUBLISHER,"DK");
86        llibre4.put(COLUMN_CATEGORY,"Fantasia");
87        llibre4.put(COLUMN_PERSONAL_EVALUATION,"molt bo");
88        database.insert(TABLE_BOOKS,null,llibre1);
89        database.insert(TABLE_BOOKS,null,llibre2);
90        database.insert(TABLE_BOOKS,null,llibre3);
91        database.insert(TABLE_BOOKS,null,llibre4);
92    }
93
94}