dimanche 6 septembre 2015

want to hard code data in sqllite database

i want to hard code data in my table kindly guide me in my app there is login and password field i want to hard code it i have created a databasehandler1 class in which i have created one database now i want to enter 1 value like user name "ebad" password "abc" sorry for my bad english this is my class

package com.example.ahmed.vehiclepermitapp;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;


public class DatabaseHandler1 extends SQLiteOpenHelper
{
    private static final int DATABASE_VERSION = 1;
    private static final String DATABASE_NAME ="contact1.db";
    private static final String TABLE_NAME ="users";
    private static final String COLUMN_ID ="id";
    private static final String COLUMN_ADMIN ="admin";
    private static final String COLUMN_PASSWORD ="password";
    SQLiteDatabase da;
    private static final String TABLE_CREATE ="create table users (id integer primary key not null  , " + "admin text not null , password not null);";

    public DatabaseHandler1(Context context){
        super(context , DATABASE_NAME , null , DATABASE_VERSION);
    }

@Override
public void onCreate(SQLiteDatabase da)
    {
        da.execSQL(TABLE_CREATE);
        this.da=da;


    }

    public String searchPass(String admin)
    {
        da = this.getReadableDatabase();
        String query = "select admin , pass from "+TABLE_NAME;
        Cursor cursor= da.rawQuery(query,null);
        String a,b;
        b= "Not found";
        if (cursor.moveToFirst())
        {
            do{
                a= cursor.getString(0);
                if (a.equals(admin)){
                    b= cursor.getString(1);
                    break;

                }

            }
            while(cursor.moveToNext());
        }
        return b;


    }

@Override
public void onUpgrade(SQLiteDatabase da, int i, int i2)
    {
        String query = "DROP TABLE IF EXISTS "+TABLE_NAME;
        da.execSQL(query);
        this.onCreate(da);


    }
}

Aucun commentaire:

Enregistrer un commentaire