SQLite example in Android

// activity

package com.example.testingproject;

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

public class MainActivity extends Activity {

String user,pass;
MyDatabase db;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.testing);
       
        db = new MyDatabase(MainActivity.this);
       
        Button addbtn = (Button)findViewById(R.id.button1);
       
        addbtn.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub

EditText username = (EditText)findViewById(R.id.editText1);
EditText password = (EditText)findViewById(R.id.editText2);

user = username.getText().toString();
pass = password.getText().toString();

long xyz = db.insert(user, pass);

if (xyz == -1) {
Toast.makeText(getApplicationContext(), "Not Inserted ", Toast.LENGTH_SHORT).show();
} else {

Toast.makeText(getApplicationContext(), "Value Inserted ", Toast.LENGTH_SHORT).show();
}

}
});
       
       
       
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.main, menu);
        return true;
    }
   
}

// db class

package com.example.testingproject;

import android.content.ContentValues;

import android.content.Context;

import android.database.SQLException;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

public class MyDatabase extends SQLiteOpenHelper {

public static final String TABLE_NAME = "login";

 public static final String COLUMN_ID = "_id";

 public static final String COLUMN_USERNAME = "username";

 public static final String COLUMN_PASSWORD = "password";

 private static final String DATABASE_NAME = "login.db";

 private static final int DATABASE_VERSION = 1;

 SQLiteDatabase sd;

 public MyDatabase(Context context) {

super(context, DATABASE_NAME, null, DATABASE_VERSION);

// TODO Auto-generated constructor stub

}

@Override

public void onCreate(SQLiteDatabase db) {

// TODO Auto-generated method stub

String DATABASE_CREATE = "create table "

     + TABLE_NAME + "(" + COLUMN_ID

     + " integer primary key autoincrement, " + COLUMN_USERNAME + " text not null," + COLUMN_PASSWORD + " text not null);";

db.execSQL(DATABASE_CREATE);

}

public void open() throws SQLException

{

SQLiteDatabase sd = this.getWritableDatabase();

//Here database is open for read and write operation

}

public void close()

{

if (sd != null)

{

sd.close();

}

}

@Override

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

// TODO Auto-generated method stub

}

public long insert(String user,String pass)

{

long abc = 0;

open();

SQLiteDatabase sd = this.getWritableDatabase();

ContentValues values = new ContentValues();

values.put(COLUMN_USERNAME, user);

values.put(COLUMN_PASSWORD, pass);

 

abc = sd.insert(TABLE_NAME, null, values);

close();

return abc;

}

}

// activity 

<?xml version="1.0" encoding="utf-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    android:orientation="vertical" >

    <TableRow

        android:id="@+id/tableRow1"

        android:layout_width="match_parent"

        android:layout_height="wrap_content" >

        <TextView

            android:id="@+id/textView1"

            android:layout_width="wrap_content"

            android:layout_height="wrap_content"

            android:layout_weight="1"

            android:text="TextView" />

        <EditText

            android:id="@+id/editText1"

            android:layout_width="wrap_content"

            android:layout_height="wrap_content"

            android:layout_weight="1"

            android:ems="10" >

            <requestFocus />

        </EditText>

    </TableRow>

    <TableRow

        android:id="@+id/tableRow2"

        android:layout_width="match_parent"

        android:layout_height="wrap_content" >

        <TextView

            android:id="@+id/textView2"

            android:layout_width="wrap_content"

            android:layout_height="wrap_content"

            android:layout_weight="1"

            android:text="TextView" />

        <EditText

            android:id="@+id/editText2"

            android:layout_width="wrap_content"

            android:layout_height="wrap_content"

            android:layout_weight="1"

            android:ems="10"

            android:inputType="textPassword" />

    </TableRow>

    <TableRow

        android:id="@+id/tableRow3"

        android:layout_width="match_parent"

        android:layout_height="wrap_content" >

        <Button

            android:id="@+id/button1"

            android:layout_width="wrap_content"

            android:layout_height="wrap_content"

            android:layout_marginLeft="100dp"

            android:layout_marginTop="30dp"

            android:text="Button" />

    </TableRow>

</LinearLayout>

// manifest.xml

<?xml version="1.0" encoding="utf-8"?>

<manifest xmlns:android="http://schemas.android.com/apk/res/android"

    package="com.example.testingproject"

    android:versionCode="1"

    android:versionName="1.0" >

    <uses-sdk

        android:minSdkVersion="8"

        android:targetSdkVersion="17" />

    <application

        android:allowBackup="true"

        android:icon="@drawable/ic_launcher"

        android:label="@string/app_name"

        android:theme="@style/AppTheme" >

        <activity

            android:name="com.example.testingproject.MainActivity"

            android:label="@string/app_name" >

            <intent-filter>

                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />

            </intent-filter>

        </activity>

        <activity 

            android:name=".MyDatabase"></activity>

    </application>

</manifest>