sqlit dba access my user info in taxt view

hey i want set user data in next screen in perticuler textview when i search record by clicking button.....so how can i creat that code??? i have already creat data table in first activity....now i want set all data step by step in perticuler feild.

I would save username to sharedpreferences, because app will have only one user, you don't need to save just one entry to your database. But if you insist on getting it from database, then add this function to your DatabaseHelper.

public String getUsername() throws SQLException {
String username = "";
Cursor cursor = this.getReadableDatabase().query(
TABLE_NAME, new String[] { KEY_NAME },
null, null, null, null, null);
if (cursor.moveToFirst()) {
do {
username = cursor.getString(0);
} while (cursor.moveToNext());
}
cursor.close();
return username;
}

and later you can use this code to get username in your drawer activity:

textView.setText(helper.getUsername());

P.S. you should really really refactor your code. And use SharedPreferences instead of SQLite for storing single values. SQLite is designed to store massive data containers, like cached list data and so on.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manikandan Murugesan9y ago
Accepted answer
I would save username to sharedpreferences, because app will have only one user, you don't need to save just one entry to your database. But if you insist on getting it from database, then add this function to your DatabaseHelper.
public String getUsername() throws SQLException {
                 String username = "";
                 Cursor cursor = this.getReadableDatabase().query(
                                                  TABLE_NAME, new String[] { KEY_NAME },
                                                  null, null, null, null, null);
                 if (cursor.moveToFirst()) {
                     do {
                           username = cursor.getString(0);
                        } while (cursor.moveToNext());
                 }
                 cursor.close();

                 return username;
   }

and later you can use this code to get username in your drawer activity:

textView.setText(helper.getUsername());

P.S. you should really really refactor your code. And use SharedPreferences instead of SQLite for storing single values. SQLite is designed to store massive data containers, like cached list data and so on.