veternar

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent"
    android:layout_height="match_parent" android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    android:paddingBottom="@dimen/activity_vertical_margin" tools:context=".MainActivity">


    <TextView
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Korisnicko ime"
        android:layout_centerHorizontal="true"
        android:textSize="20sp"
        android:id="@+id/text1"
        />
    <EditText
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_below="@id/text1"
        android:id="@+id/edit1"
        />
    <TextView
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:id="@+id/text2"
        android:text="Lozinka"
        android:textSize="20sp"
        android:layout_below="@+id/edit1"
        android:layout_centerHorizontal="true"
        />
    <EditText
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_below="@+id/text2"
        android:id="@+id/edit2"
        />
    <Button
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_below="@+id/edit2"
        android:layout_centerHorizontal="true"
        android:text="Login"
        android:onClick="klik"/>





package com.example.veterinar;

import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.TextView;
import android.widget.Toast;

import java.util.ArrayList;

public class MainActivity extends AppCompatActivity {

    ArrayList<String> listItems;
    ArrayAdapter<String> adapter;
    ListView listView;
    SQLiteDatabase myDB = null;

    String T_ime="";
    String T_vlasnik="";
    String T_godina="";
    int _ID =0;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);


        try {
            myDB = this.openOrCreateDatabase("korisnici", MODE_PRIVATE, null);
            myDB.execSQL("DROP TABLE IF EXISTS pacijenti");
            myDB.execSQL("CREATE TABLE IF NOT EXISTS pacijenti (id INTEGER PRIMARY KEY AUTOINCREMENT, username VARCHAR(20), password VARCHAR(20));");
            myDB.execSQL("INSERT INTO pacijenti (username,password) VALUES ('Keko','123');");
        } catch (Exception e) {
            Log.e("Error", "Error", e);
        } finally {
            if (myDB != null) myDB.close();
        }


    }
    public void dodaj(View V)
    {
        try {
            EditText edit1 = (EditText) findViewById(R.id.ime);
            EditText edit2 = (EditText) findViewById(R.id.vlasnik);
            EditText edit3 = (EditText) findViewById(R.id.god);
            myDB = this.openOrCreateDatabase("veterinar", MODE_PRIVATE, null);
            myDB.execSQL("INSERT INTO pacijenti (ime,vlasnik, god) VALUES ('"+edit1.getText()+"','"+edit2.getText()+"', "+Integer.parseInt(edit3.getText().toString())+");");
        } catch (Exception e) {
            Log.e("Error", "Error", e);
        } finally {
            if (myDB != null) myDB.close();
        }
        refreshList();
    }

    public void brisi (View v){
        try {
            myDB = this.openOrCreateDatabase("veterinar", MODE_PRIVATE, null);
            myDB.execSQL("DELETE FROM pacijenti WHERE id="+_ID);
        } catch (Exception e) {
            Log.e("Error", "Error", e);
        } finally {
            if (myDB != null) myDB.close();
        }
        refreshList();
    }
    public void promjeni (View v){
        try {
            EditText edit1 = (EditText) findViewById(R.id.ime);
            EditText edit2 = (EditText) findViewById(R.id.vlasnik);
            EditText edit3 = (EditText) findViewById(R.id.god);
            myDB = this.openOrCreateDatabase("veterinar", MODE_PRIVATE, null);
            myDB.execSQL("UPDATE pacijenti SET ime='"+edit1.getText().toString()+
                    "' , vlasnik='"+edit2.getText().toString()+
                    "' , god='"+edit3.getText().toString()+
                    "' WHERE id="+_ID);

        } catch (Exception e) {
            Log.e("Error", "Error", e);
        } finally {
            if (myDB != null) myDB.close();
        }
        refreshList();
    }
    public void refreshList()
    {
        String podaci_iz_baze="";
        try {
            myDB = this.openOrCreateDatabase("veterinar", MODE_PRIVATE, null);
            Cursor c = myDB.rawQuery("SELECT * FROM pacijenti", null);
            listItems.clear();
            c.moveToFirst();        // pomak na prvi dohvaćeni zapis
            if (c != null) {
                // prolaz kroz podatke
                do {
                    int id = c.getInt(c.getColumnIndex("id"));
                    String ime = c.getString(c.getColumnIndex("ime"));
                    String vlas = c.getString(c.getColumnIndex("vlasnik"));
                    int god = c.getInt(c.getColumnIndex("god"));
                    podaci_iz_baze = id+" "+ime + " " + vlas + " " + god;
                    listItems.add(podaci_iz_baze);
                } while (c.moveToNext());
            }

            adapter.notifyDataSetChanged();
        } catch (Exception e) {
            Log.e("Error", "Error", e);
        } finally {
            if (myDB != null) myDB.close();
        }
    }
    public void klik(View view)
    {
        EditText korisnicko = (EditText)findViewById(R.id.edit1);
        EditText password = (EditText)findViewById(R.id.edit2);


        String username = ""+korisnicko.getText().toString();
        String passw = ""+password.getText().toString();


        boolean logInSuc=false;
        int id= 0;
        try {
            myDB = this.openOrCreateDatabase("korisnici", MODE_PRIVATE, null);
            Cursor c = myDB.rawQuery("SELECT * FROM pacijenti WHERE username ='"+username+"' AND password='"+passw+"'", null);
            c.moveToFirst();
            if (c.getCount()>0) {
                logInSuc=true;
                id = c.getInt(c.getColumnIndex("id"));
            }
        }
        catch(Exception e) {
            Log.e("Error", "Error", e);
        } finally {
            if (myDB != null) myDB.close();
        }
        if(logInSuc)
        {
            Intent i = new Intent(MainActivity.this, Zivotinje.class);
            i.putExtra("id", id);
            startActivity(i);
        }
        else
            Toast.makeText(view.getContext(), "Krivo korisničko ime ili lozinka", Toast.LENGTH_SHORT).show();
        logInSuc = false;
    }

}





<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent"
    android:layout_height="match_parent" android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    android:paddingBottom="@dimen/activity_vertical_margin" tools:context=".MainActivity">



    <ListView
        android:layout_width="match_parent"
        android:layout_height="170dp"
        android:id="@+id/lista1"
        android:transcriptMode="alwaysScroll">
    </ListView>

    <EditText
        android:layout_below="@+id/lista1"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:id="@+id/ime"
        />
    <EditText
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_below="@+id/ime"
        android:id="@+id/vlasnik"
        />
    <EditText
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_below="@+id/vlasnik"
        android:id="@+id/god"/>
    <Button
        android:layout_below="@+id/god"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:id="@+id/dodaj"
        android:text="DODAJ"
        android:onClick="dodaj"
        />
    <Button
        android:layout_toRightOf="@+id/dodaj"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:id="@+id/brisi"
        android:layout_below="@+id/god"
        android:text="OBRISI"
        android:onClick="brisi"
        />
    <Button
        android:layout_toRightOf="@+id/brisi"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_below="@+id/god"
        android:id="@+id/premeni"
        android:text="promjeni"
        android:onClick="promjeni"
        />
</RelativeLayout>