• After 15+ years, we've made a big change: Android Forums is now Early Bird Club. Learn more here.

Apps A cursor question

Jump to latest Follow Reply
Sort by date Sort by votes
G

Gumtrees

Lurker
Mar 27, 2017
4
0
#1
Hi guys, sorry for registering and then immediately asking a question, but I'm at a loss. I'm trying to make a register/login function, with a local database (I know it's pointless to make a local login database function, but I'm a beginner and just want to make it work to prove to myself, before I make an actual working one)

I have a database helper that looks like ...

Code: 
public class DatabaseHelperClass extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "User.db";
    public static final String TABLE_NAME = "user_Info";
    public static final String COL_1 = "ID";
    public static final String COL_2 = "NAME";
    public static final String COL_3 = "EMAIL";
    public static final String COL_4 = "PASSWORD";

    public DatabaseHelperClass(Context context) {  //Constructor
        super(context, DATABASE_NAME, null, 1);

    }

    [USER=1021285]@override[/USER]
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AUTOINCREMENT,NAME TEXT,EMAIL TEXT,PASSWORD TEXT)");
        //Auto incrementing PRIMARY KEY so it remains unique

    }

    [USER=1021285]@override[/USER]
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
        onCreate(db);
    }//On edit


    public boolean insertData(String name, String email, String password) {

        SQLiteDatabase db = this.getWritableDatabase();    //Putting data into database
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL_2, name);
        contentValues.put(COL_3, email);
        contentValues.put(COL_4, password);
        long result = db.insert(TABLE_NAME, null, contentValues);
        if (result == -1)
            return false;
        else
            return true;
    }
}

Now I have a 'Register Page' which the user can add their data to the database, that works fine. Now I just need to be able to read the database, and match a user's email and password with an entry within the database. Can anyone point me in the right direction? Or to any useful tutorials, because most of the ones I've came across aren't really that useful. I know I need to use cursors, but I just need a starting point really. Any help appreciated.

Thanks.
 
Last edited by a moderator:
#2
You can do this with a simple query method in your DatabaseHelperClass.
The following checks that the cursor contains exactly one record. Watch out for the " and ' characters.

Code: 
public boolean passwordOk(String email, String password) {
     SQLiteDatabase db = this.getReadableDatabase();
     Cursor res =  db.rawQuery( "select * from " +  TABLE_NAME + " where " + COL_3 + "='"+ email + '" and " + COL_4 + "='" + password + "'", null );
 
     return (res.getCount() == 1);
   }
 
Last edited by a moderator:
Upvote 0
#3
Thanks for the response! Just had chance to look at it. Within my MainActivity class, I've put the following code

Code: 
public void passwordOK(){

    loginB.setOnClickListener(
            new View.OnClickListener() {
                public void onClick(View v) {
               boolean isInsert = myD.passwordOk(editEmail.getText().toString(), editPassword.getText().toString());
                    if (isInsert ==true)
                        Toast.makeText(MainActivity.this, "You Have Successfully Logged in", Toast.LENGTH_LONG).show();
             else  Toast.makeText(MainActivity.this, "You Have Not Logged In", Toast.LENGTH_LONG).show();



                }
            }
    );
}


With this in my DatabaseHelper

Code: 
public boolean passwordOk(String email, String password) {
    SQLiteDatabase db = this.getReadableDatabase();
    Cursor res =  db.rawQuery( "select * from " +  TABLE_NAME + " where " + COL_3
            + "='"+ email +  COL_4 + "='" + password + "'", null );

    return (res.getCount() == 1);
}


But it isn't working. Any pointers? I know I'm probably missing something obvious, but I'm such a rookie to Android I'm not sure what.

thanks for any more help.
 
Last edited by a moderator:
Upvote 0
#5
It's closing my application. I just want it to iterate through the database, and find a matching email/password

Here's the log;

03-29 21:15:08.929 4402-4402/com.example.onein.jobgosite I/art: Not late-enabling -Xcheck:jni (already on)
03-29 21:15:08.946 4402-4407/com.example.onein.jobgosite E/art: Failed sending reply to debugger: Broken pipe
03-29 21:15:08.946 4402-4407/com.example.onein.jobgosite I/art: Debugger is no longer active
03-29 21:15:08.961 4402-4402/com.example.onein.jobgosite W/art: Failed execv(/system/bin/dex2oat --runtime-arg -classpath --runtime-arg --debuggable --instruction-set=x86 --instruction-set-features=smp,ssse3,-sse4.1,-sse4.2,-avx,-avx2 --runtime-arg -Xrelocate --boot-image=/system/framework/boot.art --runtime-arg -Xms64m --runtime-arg -Xmx512m --instruction-set-variant=x86 --instruction-set-features=default --dex-file=/data/app/com.example.onein.jobgosite-1/split_lib_dependencies_apk.apk --oat-file=/data/dalvik-cache/x86/data@app@com.example.onein.jobgosite-1@split_lib_dependencies_apk.apk@classes.dex) because non-0 exit status
03-29 21:15:09.042 4402-4402/com.example.onein.jobgosite W/art: Failed execv(/system/bin/dex2oat --runtime-arg -classpath --runtime-arg --debuggable --instruction-set=x86 --instruction-set-features=smp,ssse3,-sse4.1,-sse4.2,-avx,-avx2 --runtime-arg -Xrelocate --boot-image=/system/framework/boot.art --runtime-arg -Xms64m --runtime-arg -Xmx512m --instruction-set-variant=x86 --instruction-set-features=default --dex-file=/data/app/com.example.onein.jobgosite-1/split_lib_slice_0_apk.apk --oat-file=/data/dalvik-cache/x86/data@app@com.example.onein.jobgosite-1@split_lib_slice_0_apk.apk@classes.dex) because non-0 exit status
03-29 21:15:09.056 4402-4402/com.example.onein.jobgosite W/art: Failed execv(/system/bin/dex2oat --runtime-arg -classpath --runtime-arg --debuggable --instruction-set=x86 --instruction-set-features=smp,ssse3,-sse4.1,-sse4.2,-avx,-avx2 --runtime-arg -Xrelocate --boot-image=/system/framework/boot.art --runtime-arg -Xms64m --runtime-arg -Xmx512m --instruction-set-variant=x86 --instruction-set-features=default --dex-file=/data/app/com.example.onein.jobgosite-1/split_lib_slice_1_apk.apk --oat-file=/data/dalvik-cache/x86/data@app@com.example.onein.jobgosite-1@split_lib_slice_1_apk.apk@classes.dex) because non-0 exit status
03-29 21:15:09.067 4402-4402/com.example.onein.jobgosite W/art: Failed execv(/system/bin/dex2oat --runtime-arg -classpath --runtime-arg --debuggable --instruction-set=x86 --instruction-set-features=smp,ssse3,-sse4.1,-sse4.2,-avx,-avx2 --runtime-arg -Xrelocate --boot-image=/system/framework/boot.art --runtime-arg -Xms64m --runtime-arg -Xmx512m --instruction-set-variant=x86 --instruction-set-features=default --dex-file=/data/app/com.example.onein.jobgosite-1/split_lib_slice_2_apk.apk --oat-file=/data/dalvik-cache/x86/data@app@com.example.onein.jobgosite-1@split_lib_slice_2_apk.apk@classes.dex) because non-0 exit status
03-29 21:15:09.079 4402-4402/com.example.onein.jobgosite W/art: Failed execv(/system/bin/dex2oat --runtime-arg -classpath --runtime-arg --debuggable --instruction-set=x86 --instruction-set-features=smp,ssse3,-sse4.1,-sse4.2,-avx,-avx2 --runtime-arg -Xrelocate --boot-image=/system/framework/boot.art --runtime-arg -Xms64m --runtime-arg -Xmx512m --instruction-set-variant=x86 --instruction-set-features=default --dex-file=/data/app/com.example.onein.jobgosite-1/split_lib_slice_3_apk.apk --oat-file=/data/dalvik-cache/x86/data@app@com.example.onein.jobgosite-1@split_lib_slice_3_apk.apk@classes.dex) because non-0 exit status
03-29 21:15:09.089 4402-4402/com.example.onein.jobgosite W/art: Failed execv(/system/bin/dex2oat --runtime-arg -classpath --runtime-arg --debuggable --instruction-set=x86 --instruction-set-features=smp,ssse3,-sse4.1,-sse4.2,-avx,-avx2 --runtime-arg -Xrelocate --boot-image=/system/framework/boot.art --runtime-arg -Xms64m --runtime-arg -Xmx512m --instruction-set-variant=x86 --instruction-set-features=default --dex-file=/data/app/com.example.onein.jobgosite-1/split_lib_slice_4_apk.apk --oat-file=/data/dalvik-cache/x86/data@app@com.example.onein.jobgosite-1@split_lib_slice_4_apk.apk@classes.dex) because non-0 exit status
03-29 21:15:09.101 4402-4402/com.example.onein.jobgosite W/art: Failed execv(/system/bin/dex2oat --runtime-arg -classpath --runtime-arg --debuggable --instruction-set=x86 --instruction-set-features=smp,ssse3,-sse4.1,-sse4.2,-avx,-avx2 --runtime-arg -Xrelocate --boot-image=/system/framework/boot.art --runtime-arg -Xms64m --runtime-arg -Xmx512m --instruction-set-variant=x86 --instruction-set-features=default --dex-file=/data/app/com.example.onein.jobgosite-1/split_lib_slice_5_apk.apk --oat-file=/data/dalvik-cache/x86/data@app@com.example.onein.jobgosite-1@split_lib_slice_5_apk.apk@classes.dex) because non-0 exit status
03-29 21:15:09.111 4402-4402/com.example.onein.jobgosite W/art: Failed execv(/system/bin/dex2oat --runtime-arg -classpath --runtime-arg --debuggable --instruction-set=x86 --instruction-set-features=smp,ssse3,-sse4.1,-sse4.2,-avx,-avx2 --runtime-arg -Xrelocate --boot-image=/system/framework/boot.art --runtime-arg -Xms64m --runtime-arg -Xmx512m --instruction-set-variant=x86 --instruction-set-features=default --dex-file=/data/app/com.example.onein.jobgosite-1/split_lib_slice_6_apk.apk --oat-file=/data/dalvik-cache/x86/data@app@com.example.onein.jobgosite-1@split_lib_slice_6_apk.apk@classes.dex) because non-0 exit status
03-29 21:15:09.120 4402-4402/com.example.onein.jobgosite W/art: Failed execv(/system/bin/dex2oat --runtime-arg -classpath --runtime-arg --debuggable --instruction-set=x86 --instruction-set-features=smp,ssse3,-sse4.1,-sse4.2,-avx,-avx2 --runtime-arg -Xrelocate --boot-image=/system/framework/boot.art --runtime-arg -Xms64m --runtime-arg -Xmx512m --instruction-set-variant=x86 --instruction-set-features=default --dex-file=/data/app/com.example.onein.jobgosite-1/split_lib_slice_7_apk.apk --oat-file=/data/dalvik-cache/x86/data@app@com.example.onein.jobgosite-1@split_lib_slice_7_apk.apk@classes.dex) because non-0 exit status
03-29 21:15:09.131 4402-4402/com.example.onein.jobgosite W/art: Failed execv(/system/bin/dex2oat --runtime-arg -classpath --runtime-arg --debuggable --instruction-set=x86 --instruction-set-features=smp,ssse3,-sse4.1,-sse4.2,-avx,-avx2 --runtime-arg -Xrelocate --boot-image=/system/framework/boot.art --runtime-arg -Xms64m --runtime-arg -Xmx512m --instruction-set-variant=x86 --instruction-set-features=default --dex-file=/data/app/com.example.onein.jobgosite-1/split_lib_slice_8_apk.apk --oat-file=/data/dalvik-cache/x86/data@app@com.example.onein.jobgosite-1@split_lib_slice_8_apk.apk@classes.dex) because non-0 exit status
03-29 21:15:09.142 4402-4402/com.example.onein.jobgosite W/art: Failed execv(/system/bin/dex2oat --runtime-arg -classpath --runtime-arg --debuggable --instruction-set=x86 --instruction-set-features=smp,ssse3,-sse4.1,-sse4.2,-avx,-avx2 --runtime-arg -Xrelocate --boot-image=/system/framework/boot.art --runtime-arg -Xms64m --runtime-arg -Xmx512m --instruction-set-variant=x86 --instruction-set-features=default --dex-file=/data/app/com.example.onein.jobgosite-1/split_lib_slice_9_apk.apk --oat-file=/data/dalvik-cache/x86/data@app@com.example.onein.jobgosite-1@split_lib_slice_9_apk.apk@classes.dex) because non-0 exit status
03-29 21:15:09.142 4402-4402/com.example.onein.jobgosite W/System: ClassLoader referenced unknown path: /data/app/com.example.onein.jobgosite-1/lib/x86
03-29 21:15:09.143 4402-4402/com.example.onein.jobgosite I/InstantRun: Starting Instant Run Server for com.example.onein.jobgosite


EDIT - Sorry for the messy log
 
Upvote 0
#7
Woops, sorry. Here it is

03-30 12:10:54.949 2605-2605/com.example.onein.jobgosite E/AndroidRuntime: FATAL EXCEPTION: main
Process: com.example.onein.jobgosite, PID: 2605
android.database.sqlite.SQLiteException: near "doh": syntax error (code 1): , while compiling: select * from user_Info where EMAIL='doPASSWORD='doh'
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:887)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:498)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)
at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1255)
at com.example.onein.jobgosite.DatabaseHelperClass.passwordOk(DatabaseHelperClass.java:62)
at com.example.onein.jobgosite.MainActivity$2.onClick(MainActivity.java:55)
at android.view.View.performClick(View.java:5198)
at android.view.View$PerformClick.run(View.java:21147)
at android.os.Handler.handleCallback(Handler.java:739)
at android.os.Handler.dispatchMessage(Handler.java:95)
at android.os.Looper.loop(Looper.java:148)
at android.app.ActivityThread.main(ActivityThread.java:5417)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)
 
Upvote 0
You must log in or register to reply here.

BEST TECH IN 2023

We've been tracking upcoming products and ranking the best tech since 2007. Thanks for trusting our opinion: we get rewarded through affiliate links that earn us a commission and we invite you to learn more about us.

Smartphones

Best Android Phones

See All
  1. Google Pixel 8 Pro Check Price
  2. Samsung Galaxy S23 Ultra Check Price
  3. Samsung Galaxy Z Fold5 Check Price
  4. Google Pixel 8 Check Price
  5. Samsung Galaxy S23 Check Price

Upcoming

See All
  1. Samsung Galaxy S24 Early Access

Best iPhones

See All
  1. Apple iPhone 15 Pro Max Check Price
  2. Apple iPhone 15 Pro Check Price
  3. Apple iPhone 15 Plus Check Price
  4. Apple iPhone 15 Check Price
  5. Apple iPhone SE (2022) Check Price

Upcoming

See All
  1. Apple iPhone 16 Early Access

Tablets

Best Tablets

See All
  1. Samsung Galaxy Tab S9 Ultra Check Price
  2. Apple iPad Pro (2022) Check Price
  3. Apple iPad Air (2022) Check Price
  4. Apple iPad Mini (2021) Check Price
  5. Microsoft Surface Pro 9 Check Price

Upcoming

See All
  1. Apple iPad Air 6 Early Access
  2. Apple iPad Fold Early Access

Laptops

Best Laptops

See All
  1. Apple Macbook Pro Check Price
  2. Apple Macbook Air (2023) Check Price
  3. Dell XPS 13 Check Price
  4. Acer Chromebook Spin 714 Check Price
  5. Dell Alienware m18 (2022) Check Price

Upcoming

See All
  1. Microsoft Surface Laptop 6 Early Access
  2. Microsoft Surface Pro 10 Early Access

Televisions

Best TVs

See All
  1. Samsung The Frame TV Check Price
  2. Samsung Neo QLED 4K QN90C Check Price
  3. LG G3 OLED Check Price
  4. LG A2 OLED Check Price
  5. ROKU Plus Series Check Price
  6. Samsung S90C OLED Check Price
  7. SunBriteTV Veranda 3 Check Price

Upcoming

See All
  1. Hisense 110UX ULED X TV Early Access

Game Consoles

Best Game Consoles

See All
  1. Nintendo Switch OLED Check Price
  2. Microsoft XBOX Series X Check Price
  3. Sony Playstation 5 Check Price
  4. Microsoft XBOX Series S Check Price
  5. Nintendo Switch Lite Check Price

Upcoming

See All
  1. Nintendo Switch 2 Early Access

Wearables

Best Wearables

See All
  1. Oura Ring 3 Check Price
  2. Apple Watch Series 9 Check Price
  3. Google Pixel Watch 2 Check Price
  4. Samsung Galaxy Watch 6 Classic Check Price
  5. Fitbit Inspire 3 Check Price
  6. Amazfit Amazfit Band 7 Check Price
  7. Apple Watch SE Check Price
  8. Apple Watch Ultra 2 Check Price

Upcoming

See All
  1. Samsung Galaxy Watch 7 Early Access

Smart Home

Smart Home Tech

See All
  1. Amazon Echo (4th Gen) Check Price
  2. Schlage Encode Smart Lock Check Price
  3. Amazon Blink Smart Cameras Check Price
  4. Google Nest Thermostat Check Price
  5. Phillips Hue Smart Lights Check Price

Upcoming

See All
  1. Apple Homepod Vision Early Access

Similar threads

K
my code works fine in simulator but crashes in play store
Replies
1
Views
906
Android Development
olbriar
olbriar
A
Receive sms on my app from specific number
Replies
3
Views
817
Android Development
Unforgiven
Unforgiven
D
Setting up a RecyclerView
Replies
0
Views
683
Android Development
dwf2008
D
C
Cannot read serial data using USB Host
Replies
1
Views
2K
Android Development
saramarz
saramarz
James_Watson
failed to get cursor when querying URI table for a PDF file in the Downloads folder of an Android 11
Replies
1
Views
3K
Android Development
James_Watson
James_Watson
Top Bottom
Back
Jump to latest Follow Reply
Jump to latest Follow Reply