Connectivity

create Database.java file::

package com.AJ.android;

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

public class Database extends SQLiteOpenHelper {
private static final String MYDATABASE = “names”;
private static final int VERSION = 1;

public Database(Context connection) {
super(connection, MYDATABASE, null, VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(“CREATE TABLE AJ_first(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT);”);
}

@Override
public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {
db.execSQL(“DROP TABLE IF EXIST AJ_first”);
onCreate(db);
}
}

create data.xml file::

<?xml version=”1.0″ encoding=”utf-8″?>
<LinearLayout xmlns:android=”http://schemas.android.com/apk/res/android&#8221;
android:orientation=”vertical”
android:layout_width=”fill_parent”
android:layout_height=”fill_parent”
>
<EditText android:layout_height=”wrap_content” android:layout_x=”84dp” android:id=”@+id/et” android:layout_y=”26dp” android:layout_width=”184dp”>
<requestFocus></requestFocus>
</EditText>
<Button android:layout_width=”wrap_content” android:text=”Enter” android:layout_height=”wrap_content” android:layout_x=”134dp” android:id=”@+id/btn” android:layout_y=”102dp”></Button>
<TextView android:layout_height=”wrap_content” android:id=”@+id/textView1″ android:text=”” android:textAppearance=”?android:attr/textAppearanceLarge” android:layout_x=”87dp” android:layout_y=”222dp” android:layout_width=”116dp”></TextView>
</LinearLayout>

create DatabaseActivity.java::

package com.AJ.android;

import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;

public class DatabaseActivity extends Activity {
private Database names;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
names = new Database(this);
final EditText name=(EditText) findViewById(R.id.et);

Button b1=(Button) findViewById(R.id.btn);

b1.setOnClickListener(new View.OnClickListener() {

public void onClick(View v) {
try{
AddDATA(name.getText().toString());
Cursor cursor = ShowDATA();
ShowDATA(cursor);
}
finally{
names.close();
}
}
});

}

private void AddDATA(String ResultName){

SQLiteDatabase db = names.getWritableDatabase();
ContentValues datas = new ContentValues();
datas.put(“name”, ResultName);
db.insertOrThrow(“ournames”, null, datas);
}

private String[] SELECT = {“id”, “name”};

private Cursor ShowDATA(){
SQLiteDatabase db = names.getReadableDatabase();
Cursor cursor = db.query(“ournames”, SELECT, null, null, null, null, null);

startManagingCursor(cursor);
return cursor;
}

private void ShowDATA(Cursor cursor){
StringBuilder builder = new StringBuilder(“RESULTS!:\n”);

while(cursor.moveToNext()){

String whatthenameis = cursor.getString((cursor.getColumnIndex(“name”)));
builder.append(whatthenameis).append(“\n”);
}

TextView text = (TextView)findViewById(R.id.textView1);
text.setText(builder);
}

}