android database raw query

package home.database;

import java.util.ArrayList;

import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.util.Log;

public class CRUDonDB  {

private final String SAMPLE_DB_NAME = "shoppingDb";
private final String SAMPLE_TABLE_NAME = "item_info";
Context context;
SQLiteDatabase sampleDB = null;
ArrayList<String> results = new ArrayList<String>();

public CRUDonDB(Context _context)
{
context = _context;

try
{
sampleDB = context.openOrCreateDatabase(SAMPLE_DB_NAME, context.MODE_WORLD_WRITEABLE,
null);

sampleDB.execSQL("CREATE TABLE IF NOT EXISTS " + SAMPLE_TABLE_NAME
+ " (stationId VARCHAR, stationName VARCHAR,"
+ " shoppingMallName VARCHAR,productName VARCHAR,"
+ " purchased INT(3),UNIQUE(shoppingMallName, productName) ) ;");

Log.d("---------database created-----------", " ");

}
catch (SQLiteException se)
{
Log.e(getClass().getSimpleName(),
"Could not create or Open the database");
Log.d("---------catch-----------", " ");
}
finally
{
Log.d("---------finally-----------", " ");
// if (sampleDB != null)
// sampleDB.execSQL("DELETE FROM " + SAMPLE_TABLE_NAME);
//sampleDB.close();
}
}

public void insert_item_into_db(String etItemOne, String etItemTwo,String etItemThree,String etItemFour)
{
if( !etItemOne.equals("") )
{
try
{
sampleDB.execSQL("INSERT INTO " + SAMPLE_TABLE_NAME
+ " Values ('s3','silom','nondon','"+etItemOne+"','0');");

Log.d("---------insert_item_into_db()-----------", etItemOne.toString() );
}
catch(SQLException e)
{
Log.d("----------SQLException------------", " ");
}
}

if( !etItemTwo.equals("") )
{
try
{
sampleDB.execSQL("INSERT INTO " + SAMPLE_TABLE_NAME
+ " Values ('s3','silom','nondon','"+etItemTwo+"','0');");

Log.d("---------insert_item_into_db()-----------", etItemTwo.toString() );
}
catch(SQLException e)
{
Log.d("----------SQLException------------", " ");
}

}

if( !etItemThree.equals("") )
{
try
{
sampleDB.execSQL("INSERT INTO " + SAMPLE_TABLE_NAME
+ " Values ('s3','silom','nondon','"+etItemThree+"','0');");

Log.d("---------insert_item_into_db()-----------", etItemThree.toString() );
}
catch(SQLException e)
{
Log.d("----------SQLException------------", " ");
}
}

if( !etItemFour.equals("") )
{
try
{
sampleDB.execSQL("INSERT INTO " + SAMPLE_TABLE_NAME
+ " Values ('s3','silom','nondon','"+etItemFour+"','0');");

Log.d("---------insert_item_into_db()-----------", etItemFour.toString() );
}
catch(SQLException e)
{
Log.d("----------SQLException------------", " ");
}
}


}

public Cursor select_item_from_db()
{
Cursor cursor = sampleDB.rawQuery("SELECT * FROM "
+ SAMPLE_TABLE_NAME , null);

/*if (cursor != null) {
if (c.moveToFirst()) {
do {
String firstName = cursor.getString(cursor
.getColumnIndex("FirstName"));
int age = cursor.getInt(cursor.getColumnIndex("Age"));

Log.d("---------firstName"+firstName+"-----------", " ");

results.add("" + firstName + ",Age: " + age);
} while (cursor.moveToNext());
}
}
*/
Log.d("---------select_item_from_db()-----------", " ");

return cursor;
}

public void update_purchased_info(String productName)
{
try
{
sampleDB.execSQL("update " + SAMPLE_TABLE_NAME
+ " set purchased=1 where productName='"+productName+"'");

Log.d("----------update success------------", " ");
}
catch(SQLException e)
{
Log.d("----------update SQLException="+e.getStackTrace().toString()+"------------", " ");
}

}

public void delete_item_info(String productName)
{
try
{
sampleDB.execSQL("delete from " + SAMPLE_TABLE_NAME
+ " where productName='"+productName+"'");

Log.d("----------delete success------------", " ");
}
catch(SQLException e)
{
Log.d("----------update SQLException="+e.getStackTrace().toString()+"------------", " ");
}

}

public void close_db()
{
sampleDB.close();
}

}