Insert Data in SQLite Database using Android Application

Hello user, today i am going to show how to create database in SQLite and Learn to insert data in database.
Here two field i have taken no and name.
To set watermark on field take <editText android:hint="No" />

<linearlayout android:baselinealigned="false" android:layout_height="match_parent" android:layout_width="match_parent" android:orientation="vertical" xmlns:android= "http://schemas.android.com/apk/res/android"> <textview android:layout_height="wrap_content" android:layout_width="fill_parent" android:text="@string/hello"> <edittext android:hint="No" android:id="@+id/txtNo" android:layout_height="wrap_content" android:layout_width="match_parent"> <requestfocus></requestfocus> </edittext> <edittext android:hint="Name" android:id="@+id/txtName" android:layout_height="wrap_content" android:layout_width="match_parent"></edittext> <button android:id="@+id/Save" android:layout_height="wrap_content" android:layout_width="wrap_content" android:text="Save"></button> </textview></linearlayout>

Now Let start with coding.
DatabaseDemo.java

package com.databasedemo.db;


import android.app.Activity;
import android.os.Bundle;
import android.preference.EditTextPreference;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;


public class DatabaseDemo1Activity extends Activity implements OnClickListener 
{
    /** Called when the activity is first created. */
    EditText etno,etname;
    Button btnSave;
    DatabaseAdapter dbAdapter;
@Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        dbAdapter=new DatabaseAdapter(getApplicationContext());
        
        etno=(EditText)findViewById(R.id.txtNo);
        etname=(EditText)findViewById(R.id.txtName);
        btnSave=(Button)findViewById(R.id.Save);
        btnSave.setOnClickListener(this);
    }
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
if(v.getId()==R.id.Save)
{
//Toast.makeText(getApplicationContext(), "save",Toast.LENGTH_LONG).show();
String no=etno.getText().toString();
String name=etname.getText().toString();
dbAdapter.open();
long inserted=dbAdapter.insertTest(no,name);
if(inserted>=0)
{
Toast.makeText(getApplicationContext(), "data saved",Toast.LENGTH_LONG).show();

etno.setText("");
etname.setText("");
}
else
{
Toast.makeText(getApplicationContext(), "data not saved",Toast.LENGTH_LONG).show();

}
dbAdapter.close();
}
}
}

Here i marked some text in red color, use it after creating DatabaseAdapter Class.
Now Take DatabaseOpenHelper class.


In DatabaseOpenHelper.java
In this class we will create database test_database.db and Table= test.
Make sure there must be space between create table and TABLE_NAME

package com.databasedemo.db;


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


public class DatabaseOpenHelper extends SQLiteOpenHelper {


public static final String DBName = "test_database.db";
public static final String TABLE_NAME = "test";
public static final String TABLE_SQL = "Create Table "+ TABLE_NAME 
+"(_id INTEGER PRIMARY KEY AUTOINCREMENT, "
+"no TEXT, "
+"name TEXT);";

public DatabaseOpenHelper(Context context) {
super(context, DBName, null, 1);
// TODO Auto-generated constructor stub
}


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


@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
// TODO Auto-generated method stub


}


}

To check whether Database is created or not check.
1. click on DDMS TAB.
2. click File Explorer tab.
3. click "data" to expand 
4. again click on "data" to expand
5. see the package name that we create."com.databasedemo.db"
6. in package you will see the "database" click on it
7. after clicking you will see the database name that we named.
do all this when you run application.
Now create DatabaseAdapter class.


In DatabaseAdapter.java

package com.databasedemo.db;


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


public class DatabaseAdapter {
SQLiteDatabase database;
DatabaseOpenHelper dbHelper;

public DatabaseAdapter(Context context)
{
       dbHelper=new DatabaseOpenHelper(context);
       
}
public void open()
{
database=dbHelper.getWritableDatabase();
}
public void close()
{
database.close();
}
public long insertTest(String no,String name)
{
ContentValues values=new ContentValues();
values.put("no", no);
values.put("name", name);

return database.insert("test",null, values);
}
}

In next session we will see how to retrieve data
OUTPUT