Import and Export SQLite Database file into Android Eclipse using SQLite Browser

Hai Friends today i am going to explain how to import and export SQLite Database file into Eclipse

         First of all we have to locate our database file...

         Here you can refer how to locate database file in Eclipse (Refer Here)

         (Note:  First Run Your Program then only you can Find your Database file)

For Export:

Step 1:

Select our Database File and Click "Pull a file from the device " button (top left corner)

 Step 2:

      Browse Location and Press Save button

Now your database file Successfully Exported.

You can see data with use of SQLite Browser

For Import:

Step 1:

Select database folder and Click "Push a file onto the device" button(top Left Corner)

Step 2:

 Browse File Location and Press Open Button

Step 3:

Now Your file has successfully imported...

         

         Thanks For Visiting...

How to Create Simple table in SQLite Browser

Hai friends now i going to explain how to create table in SQLite Browser,

First think we need to download SQLite Browser

Step 1:
Download SQLite Browser (click here)

Step 2:

Install SQLite Browser into our Computer

Step 3:
Select File->New->Database

Step 4:
Give name for Database and press save button

Step 5:
Give table name for database
and add column name and type...

Step 6:
Press Create button..
Now your table has created..

Step7:
Select Browse Data Tab and choose table name

Step8:
Press New Record button and enter values..


Thanks for Visiting...

Android with SQLite Database Connectivity in Simple Way

Hai Friends today i am going to share about how we can connect android with SQLite Database in Simple way for Efficient Purpose..
Try this program on Android Ginger bread Version.

Snapshots:

Copy and Paste following code into Eclipse and Run the Program.

LoginSecurity.java

package login.log;

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.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class LoginSecurity {
 String DbName="NewLogin";
 String DbTable="logi";
 int DbVersion=1;
 String Key_Name="Name";
 String Key_Pass="Password";
 String CreateTable="create table logi(Name text not null, Password text not null);";
 sqlitehelper shelp;
 SQLiteDatabase sbase;
 Context con;
 public LoginSecurity(Context c)
 {
  con=c;
 }
 public LoginSecurity openforread() throws SQLException
 {
  shelp=new sqlitehelper(con, DbName, null, DbVersion);
  sbase=shelp.getReadableDatabase();
  return this;
 }
 public LoginSecurity openforwrite() throws SQLException
 {
  shelp=new sqlitehelper(con, DbName, null, DbVersion);
  sbase=shelp.getWritableDatabase();
  return this;
 }
 public void close()
 {
  shelp.close();
 }
 public long insert(String s1, String s2)
 {
  ContentValues cv=new ContentValues();
  cv.put(Key_Name, s1);
  cv.put(Key_Pass, s2);
  return sbase.insert(DbTable, null, cv);
 }
 public String getPass(String pa)
 {
  String[] col=new String[]{Key_Name, Key_Pass};
  Cursor c=sbase.query(DbTable, col, null, null, null, null, null);
  String result="";
  int index=c.getColumnIndex(Key_Pass);
  for(c.moveToFirst();!c.isAfterLast();c.moveToNext())
  {
   result=c.getString(index);
  }
  return result;
  
 }
 
 public class sqlitehelper extends SQLiteOpenHelper
 {

   public sqlitehelper(Context context, String name,
    CursorFactory factory, int version) {
   super(context, name, factory, version);
   // TODO Auto-generated constructor stub
  }

   @Override
  public void onCreate(SQLiteDatabase db) {
   // TODO Auto-generated method stub
   db.execSQL(CreateTable);
   
  }

   @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
   // TODO Auto-generated method stub
   
  }
  
 }

}

LoginSeminar.java

package login.log;

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

public class LoginSeminar extends Activity {
    /** Called when the activity is first created. */
 Button btsub,btcan;
 Button btnreg;
 EditText myuser,mypass;
 LoginSecurity ls;
 
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        btnreg=(Button)findViewById(R.id.button3);
        btcan=(Button)findViewById(R.id.button2);
        myuser=(EditText)findViewById(R.id.editText1);
        mypass=(EditText)findViewById(R.id.editText2);
        btsub=(Button)findViewById(R.id.button1);
        ls=new LoginSecurity(this);
        try
        {
        
        btsub.setOnClickListener(new View.OnClickListener() {
   
   public void onClick(View v) {
    // TODO Auto-generated method stub
    String x=myuser.getText().toString();
    String y=mypass.getText().toString();
    String temp="";
    ls.openforread();
    temp=ls.getPass(x);
    ls.close();
    if(temp.equals(y))
    {
     Toast.makeText(getApplicationContext(), "You are valid user", Toast.LENGTH_SHORT).show();
     
    }
    else
    {
     Toast.makeText(getApplicationContext(), "Sorry u r not valid user", Toast.LENGTH_SHORT).show();
    }
    
   }
  });
        }
        catch(Exception e)
        {
         Toast.makeText(getApplicationContext(), "ur login not exists pls register here", Toast.LENGTH_SHORT).show();
        }
        btnreg.setOnClickListener(new View.OnClickListener() {
   
   public void onClick(View v) {
    // TODO Auto-generated method stub
    Intent i=new Intent(getApplicationContext(), RegisterAccount.class);
    startActivity(i);
    
   }
  });
    }
}

RegisterAccount.java

Locate SQLite Database File in Android Eclipse

Hai Friends now i am going to share about how we can locate the SQLite database file in Eclipse IDE

Step 1:

Select Window -> Open Perspective -> DDMS

 Step 2:
 Select data from File Explorer tab

Step 3:
Select data folder from File Explorer tab

Step 4:
Again Select data folder from data tree folder

Step 4:

in data folder you have to choose your package folder name

Step 6:
Select Database .. Here you will see your database..

Thanks For Visiting...