dboperations

public class MainActivity extends Activity implements OnClickListener {
DataBase db;

SQLiteDatabase sDb;
Button btn,vi;
EditText e1,e2,e3;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);

db=new DataBase(getApplicationContext());

e1=(EditText)findViewById(R.id.editText1);
e2=(EditText)findViewById(R.id.editText2);
e3=(EditText)findViewById(R.id.editText3);

btn=(Button)findViewById(R.id.button1);
vi=(Button)findViewById(R.id.button2);
btn.setOnClickListener(this);
vi.setOnClickListener(this);



}
@Override
public void onClick(View v) {

switch(v.getId()){
case R.id.button1:
String id=e1.getText().toString();
String nm=e2.getText().toString();
String ad=e3.getText().toString();

sDb = db.getWritableDatabase();
db.insertValues(id,nm,ad,sDb);
db.close();

break;
case R.id.button2:

sDb = db.getWritableDatabase();
ArrayList<dbModel> values = db.getValues(sDb);

for(int i=0;i<values.size();i++)
{
Log.e("ss",""+values.get(i).name);
}
db.close();


break;
}


......................................................................................................
public class DataBase extends SQLiteOpenHelper {
public static final String DATABASE_NAME = "RajaDaTa";
public static final int DB_VER = 1;
public static final String Create_Table = "create table Rajasekhar(id text,name text,address text)";

SQLiteDatabase db;
Context context;

public DataBase(Context context) {

super(context, DATABASE_NAME, null, DB_VER);

}

@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(Create_Table);
}

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

}



public void insertValues(String id, String nm, String ad, SQLiteDatabase db) {
ContentValues cv = new ContentValues();
cv.put("id", id);
cv.put("name", nm);
cv.put("address", ad);

try {
long v = db.insert("Rajasekhar", null, cv);

if (v == 1)
Log.e("inserted", "inserted");
} catch (SQLiteException e) {
e.printStackTrace();
}
}

public ArrayList<dbModel> getValues(SQLiteDatabase db) {
// TODO Auto-generated method stub

ArrayList<dbModel> arr = new ArrayList<dbModel>();
try {
Cursor cr = db.rawQuery("select * from Rajasekhar", null);

if(cr !=null)
{
if(cr.getCount()>0)
{
Log.e("c", ""+cr.getCount());

while (cr.moveToNext()) {
dbModel d = new dbModel();
d.name = cr.getString(1);
Log.e("Name", ""+cr.getString(1));
}
}
}

} catch (SQLiteException e) {
e.printStackTrace();
}


return arr;
}



}