6nNC6hqr

1package br.com.caelum.cadastro_de_alunos;
2
3import android.content.ContentValues;
4import android.content.Context;
5import android.database.Cursor;
6import android.database.sqlite.SQLiteDatabase;
7import android.database.sqlite.SQLiteOpenHelper;
8import android.provider.ContactsContract;
9
10import java.util.ArrayList;
11import java.util.List;
12
13/**
14 * Created by android7543 on 10/05/18.
15 */
16
17public class AlunoDAO extends SQLiteOpenHelper {
18
19    private static final int VERSAO = 1;
20    private static final String TABELA = "Alunos";
21    private static final String DATABASE = "CadastroCaelum";
22
23
24    public AlunoDAO (Context context){
25        super(context, DATABASE, null, VERSAO);
26    }
27
28    @Override
29    public void onCreate(SQLiteDatabase d) {
30    String ddl = "CREATE TABLE "+ TABELA +" (id INTEGER PRIMARY KEY, "+" nome TEXT NOT NULL, "+" telefone TEXT, "+" endereco TEXT, "+" email TEXT, "+" nota REAL);";
31        d.execSQL(ddl);
32
33
34    }
35
36    @Override
37    public void onUpgrade(SQLiteDatabase d, int versaoAntiga, int versaoNova) {
38        String sql = "DROP TABLE IF EXISTS" + TABELA;
39        d.execSQL(sql);
40        onCreate(d);
41
42    }
43    public void salva(Aluno aluno){
44        ContentValues values = new ContentValues();
45
46        values.put("nome", aluno.getNome());
47        values.put("telefone", aluno.getTelefone());
48        values.put("endereco", aluno.getEndereco());
49        values.put("email", aluno.getEmail());
50        values.put("nota", aluno.getNota());
51
52        getWritableDatabase().insert(TABELA, null, values);
53    }
54
55    public List<Aluno> getLista(){
56        List<Aluno> alunos = new ArrayList<Aluno>();
57
58        SQLiteDatabase d = getReadableDatabase();
59
60        Cursor c = d.rawQuery("SELECT * FROM " + TABELA + ";", null);
61
62        while (c.moveToNext()){
63            Aluno aluno = new Aluno();
64
65            aluno.setId(c.getLong(c.getColumnIndex("id")));
66            aluno.setNome(c.getString(c.getColumnIndex("nome")));
67            aluno.setTelefone(c.getString(c.getColumnIndex("telefone")));
68            aluno.setEndereco(c.getString(c.getColumnIndex("endereco")));
69            aluno.setEmail(c.getString(c.getColumnIndex("email")));
70            aluno.setNota(c.getDouble(c.getColumnIndex("nota")));
71
72            alunos.add(aluno);
73        }
74        c.close();
75        return alunos;
76    }
77    public void deletar(Aluno aluno){
78        String[] args = {aluno.getId().toString()};
79        getWritableDatabase().delete(TABELA, "id=?", args);
80    }
81    public void altera (Aluno aluno){
82        ContentValues values = new ContentValues();
83
84        values.put("nome", aluno.getNome());
85        values.put("telefone", aluno.getTelefone());
86        values.put("email", aluno.getEmail());
87        values.put("endereco", aluno.getEndereco());
88        values.put("nota", aluno.getNota());
89
90        getWritableDatabase().update(TABELA, values, "id=?", new String[]{aluno.getId().toString()});
91    }
92
93
94
95}