Deals with Database

Hello
here is code for database halper class in android
how to insert data and select data from database




package com.drc.cricketapp;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.ArrayAdapter;


public class DbHelper extends SQLiteOpenHelper {
SQLiteDatabase db;
DbHelper mdb;

private final String KEY_NAME="tNAME";
public DbHelper(Context context) {
super(context, "Cricket", null, 1);
// TODO Auto-generated constructor stub
}


@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String mCreateTable="CREATE TABLE TEAM( _id INTEGER PRIMARY KEY AUTOINCREMENT ,"+
"tNAME VARCHAR(20) )";
db.execSQL(mCreateTable);

}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
String mPlayer="CREATE TABLE PLAYER(_id INTEGER PRIMARY KEY AUTOINCREMENT ,"+
"tId INTEGER, pName VARCHAR(20))";
db.execSQL(mPlayer);
}
public long mInsertTeam(String tname){
ContentValues cv= new ContentValues();
cv.put("tNAME",tname);
return db.insert("TEAM", null, cv);
}
public long mInsertPlayer(SQLiteDatabase db,int id,String pname){
ContentValues cv = new ContentValues();
cv.put("tID", id);
cv.put("pName", pname);
return db.insert("tPlayer",null, cv);
}
public void getAll(SQLiteDatabase db){
Cursor cr;
//String selection="tNAME='India'";
cr = db.query("TEAM", null, null, null, null, null, null);
cr.moveToFirst();
while(cr.isAfterLast() == false) {
System.out.println(cr.getString(1));

String tm=cr.getString(1);
System.out.println("Values of tm:--"+tm);
cr.moveToNext();
}

}
}