Checking username and password in Android using SQLite database

Question

I want to get query from SQLite Database in my APP that consist of name, surname, username and also password.

when I click login button, it made crash. here is my code ##

public String Login(String Username, String Password) {

    String Q = "SELECT * FROM " + DBHelper.TBLname + " WHERE "
            + DBHelper.ColumnUser + " = " + Username
            + " AND " + DBHelper.ColumnPass + " = " + Password;

    Cursor LoginQuery = MyDB.rawQuery(Q, null);

    if (LoginQuery == null) {
        LoginQuery.close();
        String LoginResult = "Wrong User Name and Password";
        return LoginResult;
    }
        LoginQuery.moveToFirst();
        String LoginResult = LoginQuery.getString(3);
        LoginQuery.close();
    return LoginResult;
}

it only revert "com.etudedevelopres.etude E/SQLiteLog: (1) " — Araz Mohammadnejad, Mar 30 '17 at 14:43

A Farmanbar · Accepted Answer · 2022-02-04T15:20:05.540

1

Try this without dbhelper:

SELECT * FROM YOUR_TABLE WHERE Username=YOUR_USERNAME AND Password=YOUR_PASSWORD

edited Feb 04 '22 at 15:20

answered Mar 30 '17 at 14:43

A Farmanbar

4,381
5
24
42

I disabled LoginQuery.close, but problem still exists – Araz Mohammadnejad Mar 30 '17 at 14:49
try this:don't user dbhelper and use predefined names and execute the program maybe problem be your dbhelper. – A Farmanbar Mar 30 '17 at 14:54
by the way ,without error log it's impossible for us to solve the problem. – A Farmanbar Mar 30 '17 at 14:57
Here is my Log: FATAL EXCEPTION: main Process: com.etudedevelopres.etude, PID: 3224 android.database.sqlite.SQLiteException: near "AND": syntax error (code 1): , while compiling: SELECT * FROM TblUsers WHERE Username = AND Password = – Araz Mohammadnejad Mar 30 '17 at 15:39
E/SQLiteLog: (1) near "AND": syntax error – Araz Mohammadnejad Mar 30 '17 at 15:40
your error resource is here:DBHelper.ColumnPass check it – A Farmanbar Mar 30 '17 at 16:05
I found new error: FATAL EXCEPTION: main Process: com.etudedevelopres.etude, PID: 29735 android.database.sqlite.SQLiteException: no such column: Araz (code 1): , while compiling: SELECT * FROM TblUsers WHERE Username = Araz AND Password = 313 – Araz Mohammadnejad Mar 30 '17 at 16:10
but as I double checked my database, Tblusers in my devise, Username column is exists – Araz Mohammadnejad Mar 30 '17 at 16:11
i think your db wouldn't create ur db or your table name is incorrect – A Farmanbar Mar 30 '17 at 16:12
as i told you the problem is your helper – A Farmanbar Mar 30 '17 at 16:12
Mr. AF, problem was solved by changeing the Quer code with below: String Q = "SELECT * FROM " + DBHelper.TBLname + " WHERE " + DBHelper.ColumnUser + " = '" + Username + "' AND " + DBHelper.ColumnPass + " = '" + Password+"'"; – Araz Mohammadnejad Mar 30 '17 at 16:31
it needs single quotes before/after input Username and password – Araz Mohammadnejad Mar 30 '17 at 16:33

Checking username and password in Android using SQLite database

when I click login button, it made crash. here is my code ##

1 Answers1