Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.example.xavie.llistatgossos;
- import android.content.Context;
- import android.database.Cursor;
- import android.database.sqlite.SQLiteDatabase;
- import android.support.v7.app.AppCompatActivity;
- import android.os.Bundle;
- import android.view.View;
- import android.widget.ArrayAdapter;
- import android.widget.EditText;
- import android.widget.ListView;
- import java.util.ArrayList;
- import java.util.List;
- public class MainActivity extends AppCompatActivity {
- private static SQLiteDatabase db;
- private EditText nom;
- private EditText propietari;
- private EditText raza;
- private ListView listView;
- @Override
- protected void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.activity_main);
- db = openOrCreateDatabase("Gossos", Context.MODE_PRIVATE, null);
- db.execSQL("CREATE TABLE IF NOT EXISTS gossos (nom VARCHAR, propietari VARCHAR, raza VARCHAR); ");
- nom = (EditText) findViewById(R.id.Nom);
- propietari = (EditText) findViewById(R.id.Propietari);
- raza = (EditText) findViewById(R.id.Raza);
- listView = (ListView) findViewById(R.id.llista);
- }
- public void afegir(View v) {
- String nombre = nom.getText().toString();
- String propietario=propietari.getText().toString();
- String tipo=raza.getText().toString();
- db.execSQL("INSERT INTO gossos VALUES('"+nombre+"','"+propietario+"','"+tipo+"');");
- }
- public void esborrar(View view){
- String nombre = nom.getText().toString();
- String propietario = propietari.getText().toString();
- db.execSQL("DELETE FROM gossos WHERE nom = '"+nombre+"' AND propietari = '"+propietario+"' ;");
- }
- public void Listar(View v) {
- ArrayAdapter<String> adaptador;
- List<String> llista = new ArrayList<String>();
- //La teva QUERY amb un Cursor anomenat c
- Cursor c = db.rawQuery("SELECT * FROM gossos", null);
- if (c.getCount() == 0)
- llista.add("No hay registros");
- else {
- while (c.moveToNext())
- llista.add("Nom: "+c.getString(0) +", Propietari: " + c.getString(1)+ ", Raça: "+c.getString(2));
- adaptador = new ArrayAdapter<>(getApplicationContext(),android.R.layout.simple_list_item_1,llista);
- listView.setAdapter(adaptador);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement