Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.me.doctor.doctor_me;
- import android.content.Context;
- import android.database.Cursor;
- import android.database.DatabaseUtils;
- import android.database.sqlite.SQLiteDatabase;
- import android.database.sqlite.SQLiteQueryBuilder;
- import com.readystatesoftware.sqliteasset.SQLiteAssetHelper;
- public class DatabaseOperation extends SQLiteAssetHelper {
- public static final int DB_VERSION = 1;
- public static final String DB_NAME= "my_doc_db.db";
- public DatabaseOperation(Context context) {
- super(context, DB_NAME,null, DB_VERSION);
- }
- // Verify user Loggin
- public boolean loginUser(String email, String password) {
- SQLiteDatabase db = this.getReadableDatabase();
- SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
- String sqlTables = "users";
- qb.setTables(sqlTables);
- //Cursor c = qb.query(db,null,"email = ? AND password = ?",new String[]{email,password},null,null,null);
- Cursor c = qb.query(db,null,null,null,null,null,null);
- DatabaseUtils.dumpCursor(c);
- System.out.println("count "+c.getCount());
- //DatabaseUtils.dumpCursor(c);
- if (c.getCount() > 0) {
- return true;
- } else {
- return false;
- }
- }
- }
- com.me.doctor.doctor_me I/System.out:
- Dumping cursor android.database....
- 0 {
- user_id=1
- user_name=test
- telephone=0711229266
- nic=952444140v
- gender=Male
- email=test@gmail.com
- password=test
- }
- 10-03 10:30:45.910 3619-3619/com.me.doctor.doctor_me I/System.out:
- = indexsqlite_autoindex_users_1users
- ÈÁÁÁ B '!+test user two077123456791236129vFemaletest2@gmail.comtest2 + test user three ? )!)t; !!+test20711229266941234566vFemaletest2@gmail.comtest26 !!)test0711229266952444140vMaletest@gmail.comtest
- ö üöäää
Add Comment
Please, Sign In to add comment