nNS31DS1

1package com.feevale.william.trabalhoprogiv;
2
3/**
4 * Created by william on 10/16/16.
5 */
6import android.content.ContentValues;
7import android.content.Context;
8import android.database.Cursor;
9import android.database.sqlite.SQLiteDatabase;
10import android.database.sqlite.SQLiteOpenHelper;
11
12import java.util.ArrayList;
13import java.util.List;
14
15public class AmeacaDBDAO {
16    private static final String NOME_BANCO = "ameaca.db";
17    private static final String TAB_AMEACA = "AMEACAS";
18    private static final int VERSAO_BANCO = 10;
19
20    private static final String COL_ID = "ID";
21    private static final String COL_NOME = "NOME";
22    private static final String COL_ENDERECO = "ENDERECO";
23    private static final String COL_BAIRRO = "BAIRRO";
24    private static final String COL_NIVEL = "NIVEL";
25
26    private ameacasDBHelper dbHelper;
27    private SQLiteDatabase db;
28    private Context ctx;
29
30    public AmeacaDBDAO(Context ctx){
31        dbHelper = new ameacasDBHelper (ctx, NOME_BANCO, null, VERSAO_BANCO);
32        this.ctx = ctx;
33    }
34
35    public void abrir(){
36        db = dbHelper.getWritableDatabase();
37    }
38
39    public void fechar(){
40
41        db.close();
42    }
43
44    public void adicionarAmeaca (Ameaca a){
45        ContentValues values = new ContentValues();
46        values.put(COL_NOME, a.getNome_ameaca());
47        values.put(COL_ENDERECO,a.getEndereco());
48        values.put(COL_BAIRRO,a.getBairro());
49        values.put(COL_NIVEL,a.getNivel());
50        db.insert(TAB_AMEACA,null,values);
51    }
52
53    public void atualizarAmeaca (Ameaca a){
54        ContentValues values = new ContentValues();
55        values.put(COL_NOME, a.getNome_ameaca());
56        values.put(COL_ENDERECO, a.getEndereco());
57        values.put(COL_BAIRRO, a.getBairro());
58        //values.put(COL_NIVEL, a.getNivel());
59        db.update(TAB_AMEACA, values, COL_ID +" = ? " , new String[] {a.getId().toString()});
60    }
61    public List<Ameaca>listarAmeacas(){
62        List<Ameaca> ameacas = new ArrayList<Ameaca>();
63        Ameaca ameaca;
64        String[] colunas = {COL_ID, COL_NOME, COL_ENDERECO, COL_BAIRRO, COL_NIVEL};
65        Cursor cursor = db.query(TAB_AMEACA,colunas,null,null,null,null,COL_ID);
66        if (cursor.getCount() == 0){
67            return ameacas ;
68        }
69
70        cursor.moveToFirst();
71
72        do {
73            ameaca = new Ameaca();
74            ameaca.setId(cursor.getInt(cursor.getColumnIndex(COL_ID)));
75            ameaca.setNome_ameaca(cursor.getString(cursor.getColumnIndex(COL_NOME)));
76            ameaca.setEndereco(cursor.getString(cursor.getColumnIndex(COL_ENDERECO)));
77            ameaca.setBairro(cursor.getString(cursor.getColumnIndex(COL_BAIRRO)));
78            ameaca.setNivel(cursor.getInt(cursor.getColumnIndex(COL_NIVEL)));
79            ameacas.add(ameaca);
80        }while (cursor.moveToNext());
81        return ameacas;
82    }
83
84    public Integer deletarAmeaca(int Id){
85
86        return db.delete(TAB_AMEACA,COL_ID +"="+ Id, null);
87    }
88
89    private static class ameacasDBHelper extends SQLiteOpenHelper{
90
91        public ameacasDBHelper (Context ctx, String nome, SQLiteDatabase.CursorFactory factory, int versao){
92            super(ctx, nome, factory, versao);
93        }
94
95        @Override
96        public void onCreate(SQLiteDatabase db){
97            String SQL_TABELA_AMEACAS = "create table " + TAB_AMEACA + "(" +
98                    COL_ID + " integer primary key," +
99                    COL_NOME + " text not null," +
100                    COL_ENDERECO + " text not null," +
101                    COL_BAIRRO + " text not null," +
102                    COL_NIVEL + " integer not null)";
103            db.execSQL(SQL_TABELA_AMEACAS);
104        }
105
106        @Override
107        public void onUpgrade (SQLiteDatabase db, int oldVersion, int newVersion){
108            db.execSQL("DROP TABLE IF EXISTS " + TAB_AMEACA);
109            onCreate(db);
110        }
111    }
112
113}