M2Gnsakg

1package com.example.teacher.listofdebtors;
2
3import android.content.ContentValues;
4import android.content.Context;
5import android.database.Cursor;
6import android.database.sqlite.SQLiteDatabase;
7import android.database.sqlite.SQLiteOpenHelper;
8
9public class DBList {
10
11    private SQLiteDatabase mDataBase;
12
13    public DBList(Context context) {
14        OpenHelper mOpenHelper = new OpenHelper(context);
15        mDataBase = mOpenHelper.getWritableDatabase();
16    }
17
18    public long insert(String name, Integer total) {
19        ContentValues cv = new ContentValues();
20        cv.put("name", name);
21        cv.put("total", total);
22        return mDataBase.insert("debtors", null, cv);
23    }
24
25    public String select(){
26        Cursor mCursor = mDataBase.query("debtors", null, "total < 13", null, null, null, null);
27        mCursor.moveToFirst();
28        String result = "";
29        while(!mCursor.isAfterLast()){
30            result += mCursor.getString(1) + "\t" + mCursor.getString(2) + "\n";
31            mCursor.moveToNext();
32        }
33        return result;
34    }
35
36    private class OpenHelper extends SQLiteOpenHelper {
37
38        OpenHelper(Context context) {
39            super(context, "DBList", null, 1);
40        }
41
42        @Override
43        public void onCreate(SQLiteDatabase db) {
44            String query = "CREATE TABLE if not exists debtors(\n" +
45                            "id INTEGER PRIMARY KEY AUTOINCREMENT not null,\n" +
46                            "name varchar not null,\n" +
47                            "total integer\n" +
48                            ")";
49            db.execSQL(query);
50        }
51
52        @Override
53        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
54        }
55    }
56}