cKzNaS3t

1package com.example.darles.cadastropessoas;
2
3import android.annotation.SuppressLint;
4import android.content.Intent;
5import android.database.Cursor;
6import android.database.sqlite.SQLiteDatabase;
7import android.support.v7.app.AppCompatActivity;
8import android.os.Bundle;
9import android.view.KeyEvent;
10import android.view.View;
11import android.widget.AdapterView;
12import android.widget.Button;
13import android.widget.EditText;
14import android.widget.ListView;
15import android.widget.SimpleCursorAdapter;
16import android.widget.Toast;
17
18public class MainActivity extends AppCompatActivity {
19    private SQLiteDatabase db = null;
20    private SimpleCursorAdapter adt = null;
21
22    @SuppressLint("WrongConstant")
23    @Override
24    protected void onCreate(Bundle savedInstanceState) {
25        super.onCreate(savedInstanceState);
26        setContentView(R.layout.activity_main);
27
28        //Criar o banco de dados
29        db = openOrCreateDatabase("crud.db", SQLiteDatabase.CREATE_IF_NECESSARY, null);
30
31        String tarefas = "CREATE TABLE IF NOT EXISTS tarefas (_id INTEGER PRIMARY KEY autoincrement, " +
32                "tarefa VARCHAR(50), categoria VARCHAR(50), data VARCHAR(50), hora VARCHAR(50))";
33
34        db.execSQL(tarefas);
35
36
37
38
39        Button btnCliente = (Button) findViewById(R.id.btnCliente);
40        btnCliente.setOnClickListener(new View.OnClickListener() {
41            @Override
42            public void onClick(View v) {
43                startActivity(new Intent(getBaseContext(), CadastroActivity.class));
44            }
45        });
46
47        final EditText txtBusca = (EditText) findViewById(R.id.txtBusca);
48        txtBusca.setOnKeyListener(new View.OnKeyListener() {
49            @Override
50            public boolean onKey(View v, int keyCode, KeyEvent event) {
51                //Prencher o ListView
52                String[] busca = new String[]{"%" + txtBusca.getText().toString() + "%"};
53                Cursor cursor = db.query("tarefas", new String[]{"_id", "tarefa", "categoria"}, "tarefa LIKE ?", busca, null, null, "_id ASC", null);
54                adt.changeCursor(cursor);
55
56
57                ListView ltwDados = (ListView) findViewById(R.id.ltWdados);
58                ltwDados.setAdapter(adt);
59                return false;
60            }
61        });
62
63    }
64        @Override
65        public void onResume(){
66            super.onResume();
67            //Prencher o ListView
68            Cursor cursor = db.query("tarefas", new String[]{"_id", "tarefa", "categoria", "data", "hora"}, null, null, null, null, "_id ASC", null);
69            String[] campos = {"_id", "tarefa", "categoria", "data", "hora"};
70            int[] ids = {R.id.txvID, R.id.txvTAREFA, R.id.txvCATEGORIA, R.id.txvDATA, R.id.txvHORA};
71            adt = new SimpleCursorAdapter(getBaseContext(), R.layout.model_clientes, cursor, campos, ids, 0);
72            ListView ltwDados = (ListView) findViewById(R.id.ltWdados);
73            ltwDados.setAdapter(adt);
74
75
76            ltwDados.setOnItemClickListener(new AdapterView.OnItemClickListener() {
77                @Override
78                public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
79                    Cursor retornoCursor = (Cursor) adt.getItem(position);
80                    Intent it = new Intent(getBaseContext(), EditarActivity.class);
81                    it.putExtra("codigo", retornoCursor.getInt(0));
82                    it.putExtra("tarefa", retornoCursor.getString(1));
83                    it.putExtra("categoria", retornoCursor.getString(1));
84                    it.putExtra("data", retornoCursor.getString(1));
85                    it.putExtra("hora", retornoCursor.getString(retornoCursor.getColumnIndex("hora")));
86                    startActivity(it);
87
88                }
89            });
90        }
91    }