Friday, 13 September 2013

How to get the single value from the database from the android?

How to get the single value from the database from the android?

I have a database for the employee details,i want to get the password from
the database.am trying to get the value but am facing problem.How to
retrieve the password from the databasssse....i have column
keyid,fistname,lastname,mobile,dateofbirth,email,gender,personal id,date
of joining,security question,answer,username,password.
need to retrieve the password value
public List<String> credientials(String eid) {
List<String> labels = new ArrayList<String>();
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.query(TABLE_EMPLOY, new String[] {
KEY_PASSWORD,
}, KEY_USERNAME + " = ?", new String[] { String.valueOf(eid) },
null, null, null, null);
if (cursor != null){
do{
cursor.moveToFirst();
labels.add(cursor.getString(12));
} while (cursor.moveToNext());
}cursor.close();
db.close();
return labels;
}
My Error log Cat
09-13 13:24:00.354: E/AndroidRuntime(28252): FATAL EXCEPTION: main
09-13 13:24:00.354: E/AndroidRuntime(28252): java.lang.OutOfMemoryError:
[memory exhausted]
09-13 13:24:00.354: E/AndroidRuntime(28252): at
dalvik.system.NativeStart.main(Native Method)
09-13 13:24:00.373: E/SQLiteDatabase(28252): close() was never explicitly
called on database '/data/data/com.example.analyticbeans/databases/jk'
09-13 13:24:00.373: E/SQLiteDatabase(28252):
android.database.sqlite.DatabaseObjectNotClosedException: Application did
not close the cursor or database object that was opened here
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1943)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:1007)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:986)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:1051)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:770)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:221)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:157)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:231)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
com.example.analyticbeans.dataBaseHelper.credientials(dataBaseHelper.java:129)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
com.example.analyticbeans.existinguserActivity.getData(existinguserActivity.java:86)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
com.example.analyticbeans.existinguserActivity.login(existinguserActivity.java:80)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
com.example.analyticbeans.existinguserActivity$1.onClick(existinguserActivity.java:55)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.view.View.performClick(View.java:3511)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.view.View$PerformClick.run(View.java:14105)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.os.Handler.handleCallback(Handler.java:605)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.os.Handler.dispatchMessage(Handler.java:92)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.os.Looper.loop(Looper.java:137)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
android.app.ActivityThread.main(ActivityThread.java:4424)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
java.lang.reflect.Method.invokeNative(Native Method)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
java.lang.reflect.Method.invoke(Method.java:511)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
09-13 13:24:00.373: E/SQLiteDatabase(28252): at
dalvik.system.NativeStart.main(Native Method)
09-13 13:24:00.484: E/System(28252): Uncaught exception thrown by finalizer
09-13 13:24:00.573: E/System(28252): java.lang.IllegalStateException:
Don't have database lock!
09-13 13:24:00.573: E/System(28252): at
android.database.sqlite.SQLiteDatabase.verifyLockOwner(SQLiteDatabase.java:2090)
09-13 13:24:00.573: E/System(28252): at
android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2182)
09-13 13:24:00.573: E/System(28252): at
android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2178)
09-13 13:24:00.573: E/System(28252): at
android.util.LruCache.trimToSize(LruCache.java:197)
09-13 13:24:00.573: E/System(28252): at
android.util.LruCache.evictAll(LruCache.java:285)
09-13 13:24:00.573: E/System(28252): at
android.database.sqlite.SQLiteDatabase.deallocCachedSqlStatements(SQLiteDatabase.java:2143)
09-13 13:24:00.573: E/System(28252): at
android.database.sqlite.SQLiteDatabase.closeClosable(SQLiteDatabase.java:1126)
09-13 13:24:00.573: E/System(28252): at
android.database.sqlite.SQLiteDatabase.finalize(SQLiteDatabase.java:1914)
09-13 13:24:00.573: E/System(28252): at
java.lang.Daemons$FinalizerDaemon.doFinalize(Daemons.java:182)
09-13 13:24:00.573: E/System(28252): at
java.lang.Daemons$FinalizerDaemon.run(Daemons.java:168)
09-13 13:24:00.573: E/System(28252): at
java.lang.Thread.run(Thread.java:856)

No comments:

Post a Comment