Android check user in Database

Question

First sorry for my poor english :)

I click button but app close automaticly

I want if user exist database , read editttext "exist"

Database activity code:

public Boolean varmi(String KULLANICI) {
    // TODO Auto-generated method stub

    Cursor c = DB_Database.query(DATABASE_TABLOSU, kolonlar, K_ADI + "=" + KULLANICI, null, null, null, null);

    if(c.moveToFirst()){
        return true;
    }
    else{
        return null;
    }
}

Main activity code:

buttonGiris.setOnClickListener(new View.OnClickListener() {

        @Override
        public void onClick(View v) {
            // TODO Auto-generated method stub
            String KULLANICI=editKullanici.getText().toString();
            db.dbyiac();
            if(db.varmi(KULLANICI) != null){
                textBilgiler.setText("User exist");
            }
            else{textBilgiler.setText("User don't exist");}
            db.dbyikapat();


        }

Stacktrace, please. stackoverflow.com/questions/23353173/… — laalto
– laalto, Commented Dec 28, 2014 at 18:17

laalto · Accepted Answer · 2014-12-28 18:17:20Z

1

String literals in SQL must be in single quotes. Better yet, use ? literal placeholder and argument binding:

Cursor c = DB_Database.query(DATABASE_TABLOSU, kolonlar, K_ADI + "=?", new String[] { KULLANICI }, null, null, null);

answered Dec 28, 2014 at 18:17

laalto

153k68 gold badges293 silver badges306 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

previousdeveloper · Accepted Answer · 2014-12-28 18:12:43Z

0

cursor.getColumnIndex(String columnName) returns -1 if, the column doesn't exist :) and call this method textBilgiler.setText("User don't exist"); :) kolay gele.

answered Dec 28, 2014 at 18:12

previousdeveloper

3172 gold badges6 silver badges12 bronze badges

1 Comment

androboy Over a year ago

Dostum yukarıdakinin söylediği işe yaradı teşekkürler keşke türkçe yazaydın sende :D

Collectives™ on Stack Overflow

Android check user in Database

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related