Saturday, 8 October 2011

Custom Dialog without border

In order to create the Dialog without border,we need to create the out custom dialog.To create the custom dialog, our class should extend the Dialog class.
See the below example... is as follows.

import android.content.Context;
import android.view.WindowManager.LayoutParams;
import android.widget.ProgressBar;

public class MyProgressDialog extends Dialog {

    public static MyProgressDialog show(Context context, CharSequence title,
            CharSequence message) {
        return show(context, title, message, false);

    public static MyProgressDialog show(Context context, CharSequence title,
            CharSequence message, boolean indeterminate) {
        return show(context, title, message, indeterminate, false, null);

    public static MyProgressDialog show(Context context, CharSequence title,
            CharSequence message, boolean indeterminate, boolean cancelable) {
        return show(context, title, message, indeterminate, cancelable, null);

    public static MyProgressDialog show(Context context, CharSequence title,
            CharSequence message, boolean indeterminate,
            boolean cancelable, OnCancelListener cancelListener) {
        MyProgressDialog dialog = new MyProgressDialog(context);
        /* The next line will add the ProgressBar to the dialog. */
        dialog.addContentView(new ProgressBar(context), new LayoutParams(LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT));;

        return dialog;

    public MyProgressDialog(Context context) {

The styles.xml file is as like this

<?xml version="1.0" encoding="utf-8"?>
    <style name="NewDialog">
       <item name="android:windowFrame">@null</item>
        <item name="android:windowBackground">@android:color/transparent</item>
        <item name="android:windowIsFloating">true</item>
        <item name="android:windowContentOverlay">@null</item>
        <item name="android:windowTitleStyle">@null</item>
        <item name="android:windowAnimationStyle">@android:style/Animation.Dialog</item>
        <item name="android:windowSoftInputMode">stateUnspecified|adjustPan</item>
        <item name="android:backgroundDimEnabled">true</item>
        <item name="android:background">@android:color/transparent</item>

In the Activity class write like this

MyProgressDialog dialog = new MyProgressDialog(Register.this);

 For more information here

Tuesday, 4 October 2011

Create Database using exiting database

In this tutorial, I am going to create the database by using the existing database. In order to do this , place your existing database into the “assets”  folder. The file is as follows.

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;

public class DBAdapter extends SQLiteOpenHelper {
                private static String DB_PATH = "";
                private static final String DB_NAME = "game.db";
                private SQLiteDatabase myDataBase;
                private final Context myContext;

                private static DBAdapter mDBConnection;
                private DBAdapter(Context context) {
                                super(context, DB_NAME, null, 1);
                                this.myContext = context;
                                DB_PATH = "/data/data/"+ context.getApplicationContext().getPackageName()            + "/databases/";
                public static synchronized DBAdapter getDBAdapterInstance(Context context) {
                                if (mDBConnection == null) {
                                                mDBConnection = new DBAdapter(context);
                                return mDBConnection;

                public void createDataBase() throws IOException {
                                boolean dbExist = checkDataBase();
                                if (dbExist) {
                                                // do nothing - database already exist
                                } else {
                                                // By calling following method
                                                // 1) an empty database will be created into the default system path of your application
                                                // 2) than we overwrite that database with our database.
                                                try {
                                                } catch (IOException e) {
                                                                throw new Error("Error copying database");

                private boolean checkDataBase() {
                                SQLiteDatabase checkDB = null;
                                try {
                                                String myPath = DB_PATH + DB_NAME;
                                                checkDB = SQLiteDatabase.openDatabase(myPath, null,              SQLiteDatabase.OPEN_READONLY);

                                } catch (SQLiteException e) {
                                                // database does't exist yet.
                                if (checkDB != null) {
                                return checkDB != null ? true : false;

                private void copyDataBase() throws IOException {
                                    // Open your local db as the input stream
                                InputStream myInput = myContext.getAssets().open(DB_NAME);
                                    // Path to the just created empty db
                                String outFileName = DB_PATH + DB_NAME;
                                    // Open the empty db as the output stream
                                OutputStream myOutput = new FileOutputStream(outFileName);
                                    // transfer bytes from the inputfile to the outputfile
                                byte[] buffer = new byte[1024];
                                int length;
                                while ((length = > 0) {
                                                myOutput.write(buffer, 0, length);
                                    // Close the streams

                public void openDataBase() throws SQLException {
                                String myPath = DB_PATH + DB_NAME;
                                myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READWRITE);

                public synchronized void close() {
                                if (myDataBase != null)

                public void onCreate(SQLiteDatabase db) {

                public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

                // ----------------------- DATABASE Operations ------------------------------
                 public long insertPuzzle(String problem,String solution,String level, int status)
                                 ContentValues initialValues = new ContentValues();
                                 initialValues.put("problem", problem);
                                 return myDataBase.insert("puzzles", null, initialValues);

In the Activity class call like this

private DBAdapter db=null;
/*try {
} catch (IOException e) {

Monday, 3 October 2011

Store the Image into SQLite Database

In this tutorial, I used the BLOB data type to store the image into the SQLite  database.
BLOB --> Binary Large Object.
This data type is used to store the values in the binary format. This type is used to store the images ,audio and video file.
Here I am going to store the image .So that ,
1.I have to convert the image to byte[].
2.This byte[] is going to be stored in the database.

The DBAdapter .java file


import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteStatement;

public class DBAdapter {         
    private static final String DATABASE_NAME = "myDatabase.db";
    private static final int DATABASE_VERSION = 1;

    private static final String USERDETAILS=
                "create table userdetails(usersno integer primary key autoincrement,userid text not null ,username text not null,password text not null,photo BLOB,visibility text not null);";
    private final Context context;
    private DatabaseHelper DBHelper;
    private SQLiteDatabase db;
    public DBAdapter(Context ctx)     {
        this.context = ctx;
        DBHelper = new DatabaseHelper(context);
    private static class DatabaseHelper extends SQLiteOpenHelper     {
        DatabaseHelper(Context context)         {
            super(context, DATABASE_NAME, null, DATABASE_VERSION);
        public void onCreate(SQLiteDatabase db)         {
        public void onUpgrade(SQLiteDatabase db, int oldVersion,    int newVersion)         {
                db.execSQL("DROP TABLE IF EXISTS users");
    public DBAdapter open() throws SQLException
        db = DBHelper.getWritableDatabase();
        return this;
    public void close()     {
    public long insertUserDetails(String uname,String userid, String pass, byte[] photo,String visibility)     {
        ContentValues initialValues = new ContentValues();
        initialValues.put("username", uname);
        initialValues.put("password", pass);
        return db.insert("userdetails", null, initialValues);
 public Cursor getUserDetails(String userid)    {
                return db.rawQuery("select username,userid,photo,visibility ,usersno from userdetails where userid='"+userid+"'",null);
    public int updateUserDetails(String userid,String username,byte[] photo,String visibility)    {
                ContentValues args = new ContentValues();
        args.put("username", username);
        return db.update("userdetails", args,"userid='" +userid+"'", null);
    public Cursor searchFriends(String username,String to_userid)    {
                return db.rawQuery("select userid,username,photo,usersno from userdetails where username LIKE '%"+username+"%' AND userid <>'"+to_userid+"' AND userid NOT IN (select request_destinationid from requestdetails where request_sourceid='"+to_userid+"' and status=1)",null);
    public void deleteFriend(int l_userid,int dest_userid)   {
                db.delete("requestdetails","request_sourceid="+l_userid+" and request_destinationid="+dest_userid+" and status=1", null);
                db.delete("requestdetails","request_sourceid="+dest_userid+" and request_destinationid="+l_userid+" and status=1", null);

In  the Activity class write like this
To Store into the DB..
private DBAdapter db=new DBAdaptet(this);;
ByteArrayOutputStream baos = new ByteArrayOutputStream(); 
Bitmap bitmap = (BitmapDrawable)getResources().getDrawable(R.drawable.common)).getBitmap();
bitmap.compress(Bitmap.CompressFormat.PNG, 100, baos);  
byte[] photo = baos.toByteArray();
db.insertUserDetails(fullName,userid, password, photo,visibility);

Retrieve from DB..
byte[]  photo=cursor.getBlob(..);
ByteArrayInputStream imageStream = new ByteArrayInputStream(photo);
Bitmap theImage= BitmapFactory.decodeStream(imageStream);