UjF9hz9J

1package com.example.lab01_professor.myapplication;
2
3import android.content.ContentValues;
4import android.database.sqlite.SQLiteDatabase;
5import android.os.Bundle;
6import android.support.v7.app.AppCompatActivity;
7import android.view.View;
8import android.widget.EditText;
9import android.widget.Toast;
10
11public class MainActivity extends AppCompatActivity {
12
13    public static final String NOME_BANCO = "APPTeste";
14    public static final String TABELA = "usuarios";
15    public static final String ID = "id";
16    public static final String NOME = "nome";
17    public static final String EMAIL = "email";
18    public static final String SENHA = "senha";
19
20    public SQLiteDatabase db;
21
22    public EditText editTextNome;
23    public EditText editTextEmail;
24    public EditText editTextSenha;
25
26    @Override
27    protected void onCreate(Bundle savedInstanceState) {
28
29        super.onCreate(savedInstanceState);
30        setContentView(R.layout.activity_main);
31
32        editTextNome = (EditText) findViewById(R.id.editText);
33        editTextEmail = (EditText) findViewById(R.id.editText2);
34        editTextSenha = (EditText) findViewById(R.id.editText3);
35
36        db = openOrCreateDatabase(NOME_BANCO, MODE_PRIVATE, null);
37
38        String sql = "CREATE TABLE IF NOT EXISTS " + TABELA + "( " + ID + " integer primary key autoincrement," + NOME + "text," + EMAIL + "text," + SENHA + "text" +")";
39        db.execSQL(sql);
40
41    }
42
43    public void cadastrar(View v) {
44
45        String nome = editTextNome.getText().toString();
46        String email = editTextEmail.getText().toString();
47        String senha = editTextSenha.getText().toString();
48
49        ContentValues values = new ContentValues();
50
51        values.put("nome", nome);
52        values.put("email", email);
53        values.put("senha", senha);
54
55        if(nome != "" && email != "" && senha != "") {
56            db.insert(TABELA, null, values);
57            Toast.makeText(this, "Usuário cadastrado com sucesso!", Toast.LENGTH_SHORT).show();
58        } else {
59            Toast.makeText(this, "Erro ao cadastrar, por favor tente novamente.", Toast.LENGTH_SHORT).show();
60        }
61
62    }
63
64
65}