Try popular Android Application by Feliz-Droid

Try popular Android Application by Feliz-Droid

Speaking Caller logo
Speaking Caller
   
Battery temperature logo
Battery Temperature
   
Dual Photo logo
Dual Photo
   
Ganesh Wallpapersl ogo
Lord Ganesh Wallpaper
   
Girly Pink Keyboard l ogo
Girly Pink Keyboard

Monday, November 21, 2011

sqlite example in android

Dear friends we will see how to create a sample project demo using SQLite.
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world.

steps to create  a demo on sqlite.

1. copy below code of DatabaseHelper.java class.

/**
 *
 */
package com.android.sqlite.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;

/**
 * @author Sandeep
 * @since 18 Nov 2011
 */
public class DatabaseHelper extends SQLiteOpenHelper {

    private static final String DB_PATH = "/data/data/com.android.sqlite/databases/";
    private static final String DB_NAME = "example.db";

    /**
     * @param context
     * @param name
     * @param factory
     * @param version
     */
    public DatabaseHelper(Context context, String name, CursorFactory factory,
            int version) {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {

        // TBL_CONTACT
        String query = "CREATE TABLE CONTACT "+" "+" (ID INTEGER, FName TEXT, LName TEXT, Contact_no TEXT);";

        db.execSQL(query);


    }

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

    }

    /**
     * Check if the database already exist to avoid
     * re-copying the file each time you open the application.
     * @return true if it exists, false if it doesn't
     */
    public 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){
            checkDB.close();
        }

        return checkDB != null ? true : false;
    }
}


2. Now create a class DBOperation.java which contain all insert,delete functions.

package com.android.sqlite.db;


import com.android.sqlite.newcontact;
import com.android.sqlite.welcome;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class DbOperation {
    DatabaseHelper dbHelper = null;

    public DbOperation() {
        dbHelper = welcome.dbHelper;
    }

    /* Add contact */
    public void addContact(String fname, String lname, String number) {
        SQLiteDatabase db = dbHelper.getWritableDatabase();

        ContentValues cv = new ContentValues();
        cv.put("FName", fname);
        cv.put("LName", lname);
        cv.put("Contact_no", number);
        db.insert("CONTACT", null, cv);
        db.close();
    }

    public String[][] getAll(String query){
        String[][] array = null;
        SQLiteDatabase db = null;
        Cursor cursor = null;
       
        try {
            db = dbHelper.getReadableDatabase();
            cursor = db.rawQuery(query, null);
           
            if(!cursor.isFirst()){
                cursor.moveToFirst();
            }
           
            int rowCount = cursor.getCount();
            int columnCount = cursor.getColumnCount();
           
            array = new String[rowCount][columnCount];
           
            int index =0;
           
            if(cursor.isFirst()){
                do{
                    for(int j=0;j<columnCount;j++){
                        array[index][j]= cursor.getString(j);
                        System.out.println(cursor.getColumnName(j)+":"+cursor.getString(j));
                        System.out.println();
                    }
                    index++;
                }while(cursor.moveToNext());
            }
           
        } catch (Exception e) {
            e.printStackTrace();
        }finally{
            if(cursor!=null)
            cursor.close();
            if(db!=null)
            db.close();
        }
        return array;
    }
}


3. Now copy these code in main.java
package com.android.sqlite;



import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

import com.android.sqlite.db.DatabaseHelper;
import com.android.sqlite.db.DbOperation;

/**
 *
 * @author Sandeep Sharma
 *
 */
public class welcome extends Activity {
   
    public static DatabaseHelper dbHelper=null;
    public DbOperation dboper=null;
    private boolean dbExist;
    private EditText fname,lname,contact;
    Button newcontact;
   
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.lead_list);
       
       
      //---create db ---
        dbHelper = new DatabaseHelper(this,"example.db",
                null,1);
        dbExist = dbHelper.checkDataBase();
        dboper=new DbOperation();
       
        fname=(EditText)findViewById(R.id.edt_Fname);
        lname=(EditText)findViewById(R.id.edt_Lname);
        contact=(EditText)findViewById(R.id.edt_contact);
       
        newcontact=(Button)findViewById(R.id.button1);
       
        newcontact.setOnClickListener(new OnClickListener() {
           
            @Override
            public void onClick(View v) {
           
                dboper.addContact(fname.getText().toString()   , lname.getText().toString(), contact.getText().toString());
               
                Toast.makeText(getApplicationContext(), "Record Saved!", Toast.LENGTH_SHORT).show();
               
               }
        });      
      }
}
 

4. Overwrite your main.xml with below code.
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:orientation="vertical" >

    <TextView
        android:id="@+id/lbl_Fname"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@string/FName"
        android:textAppearance="?android:attr/textAppearanceLarge" />
   
    <EditText
        android:id="@+id/edt_Fname"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
       
        android:inputType="textPersonName" >

        <requestFocus />
    </EditText>

        <TextView
        android:id="@+id/lbl_Lname"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@string/LName"
        android:textAppearance="?android:attr/textAppearanceLarge" />

   
    <EditText
        android:id="@+id/edt_Lname"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:inputType="textPersonName" >

        <requestFocus />
    </EditText>
       
        <TextView
        android:id="@+id/lbl_contact"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@string/Contact"
        android:textAppearance="?android:attr/textAppearanceLarge" />

   
    <EditText
        android:id="@+id/edt_contact"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:inputType="textPersonName" >

        <requestFocus />
    </EditText>

    <Button
        android:id="@+id/button1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Save" android:gravity="center_vertical|center_horizontal" android:layout_gravity="center_horizontal" android:layout_margin="30dip"/>
       
</LinearLayout>


Now try to run code. If any variable declaration missing please correct it.

Now once you get these demo working you can find sqlite database file.

to get sqlite database file switch to ddms perspective. open file explorer you can see your database file in path below.
data/data/your_packagename/databases/example.db  
to open this file you need sqlite browser.click here to download sqlite browser



Monday, September 26, 2011

How to get the sqlite path, in asset folder

Dear all.
If there is a situation that you have to keep your database file in assets folder and you require path for the sqlite file.
Solution: Then you need to copy that file to data/data/yourapplication/database the folder where your applications database are stored.
But Always keep in mind that database file(i.e *.sqlite) can have only  1 mb size. If still you want to keep your larger size (>1 mb) then there is a trick. make the extension of database file as jpeg So your assets folder allow you to keep jpeg file of any size.

Below is the code which can be used to copy database file from assets and pastes in application database folder
So then you can easily get the sqlite path.


  

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;
public class DataBaseHelper1 extends SQLiteOpenHelper{
//The Android's default system path of your application database.
public static String DB_PATH = "/data/data/com.XXX.XXX/databases/";
private static String DB_NAME = "india.sqlite";
private static String DB_NAME_MY = "india.sqlite";
private SQLiteDatabase myDataBase; 
private final Context myContext;

/**
 * Constructor
 * Takes and keeps a reference of the passed context in order to access to the  application assets and resources.
 * @param context
 */

public DataBaseHelper1(Context context){
    super(context, DB_NAME, null, 1);
    this.myContext = context;
 }  

/**
 * Creates a empty database on the system and rewrites it with your own database.
 * */
public void createDataBase() throws IOException{
    // for first database;
    boolean dbExist = checkDataBase(DB_NAME);
    if(!dbExist){
        try {
            copyDataBase(DB_NAME_MY,DB_NAME);
        } catch (Exception e) {
            throw new Error("Error copying database");
        }
    }
}

/**
 * Check if the database already exist to avoid re-copying the file each time you open the application.
 * @return true if it exists, false if it doesn't
 */
private boolean checkDataBase(String DB){
    SQLiteDatabase checkDB = null;
    try{
        String myPath = DB_PATH + DB;
        checkDB = SQLiteDatabase.openDatabase(myPath, null,  SQLiteDatabase.OPEN_READONLY);

    }catch(SQLiteException e){}

    if(checkDB != null){

        checkDB.close();

    }

    return checkDB != null ? true : false;
}
/**
 * Copies your database from your local assets-folder to the just created empty database in the
 * system folder, from where it can be accessed and handled.
 * This is done by transfering bytestream.
 * */
private void copyDataBase(String assetfile,String DB) {

    //Open your local db as the input stream
    InputStream myInput = null;
    //Open the empty db as the output stream
    OutputStream myOutput = null;
    try {
        myInput = myContext.getAssets().open(assetfile);

        // Path to the just created empty db
        String outFileName = DB_PATH + DB;

        myOutput = new FileOutputStream(outFileName);

        //transfer bytes from the inputfile to the outputfile
        byte[] buffer = new byte[1024];
        int length;
        while ((length = myInput.read(buffer))>0){
            myOutput.write(buffer, 0, length);
        }


        System.out.println("***************************************");
        System.out.println("####### Data base copied ##############");
        System.out.println("***************************************");


    } catch (FileNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
     }
          finally{
          //Close the streams
          try {
        myOutput.flush();
        myOutput.close();
        myInput.close();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
 }
}
public void openDataBase() {

    try {
        //Open the database
        String myPath = DB_PATH + DB_NAME;
        myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
}
@Overridepublic synchronized void close() {

        if(myDataBase != null)
            myDataBase.close();

        super.close();
}
@Overridepublic void onCreate(SQLiteDatabase db) {
}
@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}

    // Add your public helper methods to access and get content from the database.
   // You could return cursors by doing "return myDataBase.query(....)" so it'd be easy
   // to you to create adapters for your views.

 }
 
Thanx.. 

Thursday, September 22, 2011

How to copy a file from a directory and move to another directory.

Dear all,
To copy a file from a source directory to destination directory in a android device.

Use below code Snippets.

try {
            File sd = Environment.getExternalStorageDirectory();
         
            if (sd.canWrite()) {
       
                File source= new File(copypath);
                File destination= new File(pastepath);
                if (source.exists()) {
                    FileChannel src = new FileInputStream(source).getChannel();
                    FileChannel dst = new FileOutputStream(destination).getChannel();
                    dst.transferFrom(src, 0, src.size());
                    src.close();
                    dst.close();
                }
            }
        } catch (Exception e) {}

show multiline text inside spinner

Dear all.

To show multiline text inside the spinner follow few steps below and get working.

Step 1: Create a new Layout file name as textview.xml. and overwrite the code with below  one.


<?xml version="1.0" encoding="utf-8"?>
<TextView xmlns:android="http://schemas.android.com/apk/res/android"
    android:text="@+id/TextView01"
    android:id="@+id/TextView01"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:textSize="17sp"></TextView>

Step 2: After that save this file and open the code file (.java)  file where spinner is used. If 
you have used Array Adapter to fill spinner. Then just write below code instead of that.

      ArrayAdapter<CharSequence> adapter = ArrayAdapter.createFromResource(this, R.array.plans,     R.layout.textview);
        spinnername.setAdapter(adapter);


In above code, R.array.plans is the string array which i have used to fill spinner. I you have to fill spinner from the database then just try below code.

adapter = new ArrayAdapter<String>(this,android.R.layout.textview,aLst);

adapter.setDropDownViewResource(R.layout.textview);
spinnername.setAdapter(adapter);  
 
Now you have done with. Enjoy it.
 
Thanks...... 


   

Monday, September 19, 2011

Open file with default application using Intents

Dear all
 Welcome to my blog android rocks, in this post we will see how to open different different  files with default application  using intents.
Below the code snippets 

1. Opening Mp4 Files (Video)

Intent intent = new Intent();
intent.setAction(android.content.Intent.ACTION_VIEW);
File file = new File("/sdcard/test.mp4");
intent.setDataAndType(Uri.fromFile(file), "video/*");
startActivity(intent); 

2. Opening Mp3 Files (Audio)


Intent intent = new Intent();
intent.setAction(android.content.Intent.ACTION_VIEW);
File file = new File("/sdcard/test.mp3");
intent.setDataAndType(Uri.fromFile(file), "audio/*");
startActivity(intent);  
3. Opening HTML Files
 
Intent intent = new Intent();
intent.setAction(android.content.Intent.ACTION_VIEW);
File file = new File("/sdcard/readme.html");
intent.setDataAndType(Uri.fromFile(file), "text/html");
intent.setFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP);
startActivity(intent);   
 

4. Opening PDF Files 
 
Intent intent = new Intent();
intent.setAction(android.content.Intent.ACTION_VIEW);
File file = new File("/sdcard/readme.html");
intent.setDataAndType(Uri.fromFile(file), "application/pdf"); 
intent.setFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP);
startActivity(intent);    

Thanks......