Android!! Fetch database row in new activiy

Question

0.00/5 (No votes)

See more:

I have a sqlite database that the user can register to! I have successfully created a login form and when the login is successful (username & password match the database's) the user is redirected to another activity. What i want is in the activity that the user is redirected,
to display his entire database row (id,username, books,email,course, password, student name)!! Any ideas?? I would really appreciate if you could help me as this is the final task to complete my final year project..I use Android Studio!! I have created staff like Adapters database helpers ans cursorsThis is urgent!!!

Here is my database creation code:

SQL

static final String DATABASE_CREATE = "create table "+"LOGIN"+
        "( " +"ID"+" integer primary key autoincrement,"+ "USERNAME  varchar2," +
        "PASSWORD varchar2, COURSE varchar2, EMAIL varchar2, STUDENT_NAME varchar2); ";

Here is how I store data in the database:

Java

public void insertEntry(String userName,String password,String course,String email, String student_name)
{
    ContentValues newValues = new ContentValues();
    // Assign values for each row.
    newValues.put("USERNAME", userName);
    newValues.put("PASSWORD",password);
    newValues.put("COURSE", course);
    newValues.put("EMAIL",email);
    newValues.put("STUDENT_NAME", student_name);
 
    // Insert the row into your table
    db.insert("LOGIN", null, newValues);
    ///Toast.makeText(context, "Reminder Is Successfully Saved", Toast.LENGTH_LONG).show();
}

And finally here is the login that starts the new activity code:

C#

if(password.equals(storedPassword))
            {
                Toast.makeText(MyActivity.this, "Congrats: Login Successfull", Toast.LENGTH_LONG).show();
                dialog.dismiss();
                startActivity(new Intent(MyActivity.this, Login_home.class));
            }
            else
            {
                Toast.makeText(MyActivity.this, "User Name or Password does not match", Toast.LENGTH_LONG).show();
            }

Posted 22-Mar-15 2:05am

Member 11522447

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2015-03-22T02:35:00

Solution 1

A walk through of the following code snippets:
1. in the LoginActivity:

// create a bundle object to store user's data
Bundle bundle = new Bundle();
// assign the values as key-value pairs
bundle.putString("username", username);
bundle.putString("email", email);
      
// create the intent
Intent i = new Intent(LoginActivity.this, NewActivity.class);
// assign the bundle to the intent
i.putExtras(bundle);
// finally start the new activity
startActivity(i);

2. in the NewActivity

//create a bundle object to store the extras
Bundle bundle=getIntent().getExtras();
//get the values by their keys
String username=bundle.getString("username");
String email=bundle.getString("email");
// do whatever you like to the data

Posted 22-Mar-15 2:35am

Peter Leow

Updated 22-Mar-15 2:37am

v3

Comments

Member 11522447 22-Mar-15 9:13am

Thanks a lot for your reply :) The public void insertEntry (which holds the variables username and email) is in the LoginAdapter class which I call in the register Activity to register the user!! So when I create the Bundle in the login activity it cannot find the variables username and email!!

Peter Leow 22-Mar-15 9:30am

Actually, when the user logs in successfully, you can send his username as an extra to the new activity, then in the new activity, retrieve his particulars from the sqlite based on his username.
To learn of the sqlite, read my article http://www.codeproject.com/Articles/816470/Handling-Input-and-Storage-on-Android#sqlite

Member 11522447 22-Mar-15 9:14am

If you want I can send you my Java and XML code files with email to see for yourself what I mean!!

Peter Leow 22-Mar-15 9:33am

That will come with a cost but defeats my purpose here. So no.

Member 11522447 22-Mar-15 9:35am

Sorry for the continually asking but as you can see I am a beginner!! What would be a good way to pass the username to the new activity?

Peter Leow 22-Mar-15 10:06am

At the point when the user logs in, you would have got hold of the username from his input, right? When the log in is successful, put its username as an bundle extra and start the new activity with this bundle. An example is already shown in Solution 1.

Member 11522447 22-Mar-15 11:02am

I used the Bundle to pass the username to the next activity like the example!! Then I went in the login adapter and created this function and called it in the new activity:

public Cursor FetchRow (String username){

return db.query("LOGIN",null,"USERNAME='"+username,null,null,null,null);

}

When I call it on the activity and assign the username that is being held by the bundle and launch the emulator it crushes!!

Bundle bundle = getIntent().getExtras();
String username = bundle.getString("username");

loginDataBaseAdapter.FetchRow(username);

Mcs Stu 22-Mar-21 8:58am

Un understand able for me