7B77prvW

1package a.agendamento.agendacontato.DAO;
2
3import android.content.ContentValues;
4import android.content.Context;
5import android.database.Cursor;
6import android.database.sqlite.SQLiteDatabase;
7import android.database.sqlite.SQLiteOpenHelper;
8
9import java.util.ArrayList;
10import java.util.List;
11
12import a.agendamento.agendacontato.modelo.Contato;
13
14public class ContatoDAO extends SQLiteOpenHelper {
15    private static final int VERSAO = 1;
16    private static final String TABELA = "Contatos";
17    private static final String DATABASE = "CadastroContato";
18
19    public ContatoDAO(Context context){
20        super(context, DATABASE, null, VERSAO);
21    }
22
23    @Override
24    public void onCreate(SQLiteDatabase db) {
25        String ddl = "CREATE TABLE " + TABELA
26                + " (id INTEGER PRIMARY KEY, "
27                + " nome TEXT NOT NULL, "
28                + " telefone TEXT, "
29                + " endereco TEXT);";
30        db.execSQL(ddl);
31
32    }
33
34    @Override
35    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
36        String sql = "DROP TABLE IF EXISTS " + TABELA;
37        db.execSQL(sql);
38        onCreate(db);
39    }
40
41    public void insere(Contato contato){
42        ContentValues values = new ContentValues();
43
44        values.put("nome", contato.getNome());
45        values.put("telefone", contato.getTelefone());
46        values.put("endereco", contato.getEndereco());
47
48        getWritableDatabase().insert(TABELA, null, values);
49    }
50
51    public List<Contato> getLista(){
52        List<Contato> contatos = new ArrayList<Contato>();
53
54        SQLiteDatabase db = getWritableDatabase();
55
56        Cursor c = db.rawQuery("SELECT * FROM " + TABELA + ";", null);
57
58        while (c.moveToNext()){
59            Contato contato = new Contato();
60            contato.setId(c.getLong(c.getColumnIndex("id")));
61            contato.setNome(c.getString(c.getColumnIndex("nome")));
62            contato.setTelefone(c.getString(c.getColumnIndex("telefone")));
63            contato.setEndereco(c.getString(c.getColumnIndex("endereco")));
64            contatos.add(contato);
65        }
66        c.close();
67
68        return contatos;
69    }
70
71    public void deletar(Contato contato){
72        String[] args = {contato.getId().toString()};
73        getWritableDatabase().delete(TABELA, "id=?", args);
74    }
75}