My Database Helper Code is Here
public class DataHelper extends SQLiteOpenHelper {
public static final String DB_NAME="myDb";
public static final String Table_Pro="student";
public static final String Create_Pro="Create table if not exists "+Table_Pro+"(id integer primary key autoincrement,pname not null unique,age int,qual text)";
public static final String Delete\_Pro="Drop table if exists "+Table\_Pro;
public DataHelper(Context context) {
super(context, DB\_NAME, null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(Create\_Pro);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL(Delete\_Pro);
// db.execSQL("DROP TABLE IF EXISTS "+Table\_Pro);
onCreate(db);
}
public void insertProvince(String pname,int age,String qual)
{
SQLiteDatabase db=this.getWritableDatabase();
db.beginTransaction();
ContentValues values;
try
{
values=new ContentValues();
values.put("pname",pname);
values.put("age",age);
values.put("qual",qual);
db.insert(Table\_Pro, null, values);
db.setTransactionSuccessful();
}catch (Exception e)
{
e.printStackTrace();
}
finally {
db.endTransaction();
db.close();
}
}
public ArrayList<String> getAllProvinces()
{
ArrayList<String> list=new ArrayList<String>();
SQLiteDatabase db=this.getReadableDatabase();
db.beginTransaction();
try
{
String selectQuery = " SELECT \* FROM "+ Table\_Pro;
Cursor cursor=db.rawQuery(selectQuery,null);
if(cursor.getCount()>0)
{
while (cursor.moveToNext())
{
String pname=cursor.getString(cursor.getColumnIndex("pname"));
list.add(pname);
}
}
db.setTransactionSuccessful();
}catch (Exception e)
{
e.printStackTrace();
}
finally {
db.endTransaction();
db.close();
}
return list;
}
public Cursor getAllDa