Android

First Steps wrote:

I hope I have clarified.

package com.zindio.app;
 
import java.util.ArrayList;
import java.util.List;
 
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
 
public class DataBaseHandler extends SQLiteOpenHelper {
 
	// All Static variables
	// Database Version
	private static final int DATABASE_VERSION = 1;
 
	// Database Name
	private static final String DATABASE_NAME = "menuitemsordered";
 
	// Ordered Menu Items table name
	private static final String TABLE_MENUITEMS = "menuitems";
 
	// Ordered Menu Items Table Columns names
	private static final String KEY_UNIQUEID = "id";
	private static final String KEY_MENUID = "menuid";
	private static final String KEY_NAME = "name";
	private static final String KEY_PRICE = "price";
	private static final String KEY_DESCRIPTION = "description";
 
	public DataBaseHandler(Context context) {
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
	}
 
	// Creating Tables
	@Override
	public void onCreate(SQLiteDatabase db) {
		String CREATE_MENUITEMS_TABLE = "CREATE TABLE " + TABLE_MENUITEMS + "("
				+ KEY_UNIQUEID + " INTEGER PRIMARY KEY," + KEY_MENUID
				+ " TEXT," + KEY_NAME + " TEXT," + KEY_PRICE + " TEXT,"
				+ KEY_DESCRIPTION + " TEXT" + ")";
		db.execSQL(CREATE_MENUITEMS_TABLE);
	}
 
	// Upgrading database
	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// Drop older table if existed
		db.execSQL("DROP TABLE IF EXISTS " + TABLE_MENUITEMS);
 
		// Create tables again
		onCreate(db);
	}
 
	/**
	 * All CRUD(Create, Read, Update, Delete) Operations
	 */
 
	// Adding new ordered item
	Long additem(ordereditems item) {
 
		Long lInsertedID;
		SQLiteDatabase db = this.getWritableDatabase();
		
		
		ContentValues values = new ContentValues();
		values.put(KEY_NAME, item.getName());
		values.put(KEY_PRICE, item.getamount());
		values.put(KEY_MENUID, item.getmenuitemid());
		// Inserting Row

		lInsertedID = db.insert(TABLE_MENUITEMS, null, values);
		db.close(); // Closing database connection
		return lInsertedID;
	}
 
	// Getting single contact
	ordereditems getitem(int id) {
		SQLiteDatabase db = this.getReadableDatabase();
		// private static final String KEY_UNIQUEID = "id";
		// private static final String KEY_MENUID = "menuid";
		// private static final String KEY_NAME = "name";
		// private static final String KEY_PRICE = "price";
		// private static final String KEY_DESCRIPTION = "description";
		Cursor cursor = db.query(TABLE_MENUITEMS, new String[] { KEY_UNIQUEID,
				KEY_MENUID, KEY_NAME, KEY_PRICE, KEY_DESCRIPTION },
				KEY_UNIQUEID + "=?", new String[] { String.valueOf(id) }, null,
				null, null, null);
		if (cursor != null)
			cursor.moveToFirst();
 
		ordereditems item1 = new ordereditems(Integer.parseInt(cursor
				.getString(0)), cursor.getString(1), cursor.getString(2),
				cursor.getString(3), cursor.getString(4));
		// return contact
		return item1;
	}
 
	// Getting All Contacts
	public List<ordereditems> getAllorderedmenuitems() {
		List<ordereditems> itemList = new ArrayList<ordereditems>();
		// Select All Query
		String selectQuery = "SELECT  id, menuid, name, price, description FROM "
				+ TABLE_MENUITEMS;
 
		SQLiteDatabase db = this.getWritableDatabase();
		Cursor cursor = db.rawQuery(selectQuery, null);
		// private static final String KEY_UNIQUEID = "id";
		// private static final String KEY_MENUID = "menuid";
		// private static final String KEY_NAME = "name";
		// private static final String KEY_PRICE = "price";
		// private static final String KEY_DESCRIPTION = "description";
		// looping through all rows and adding to list
		if (cursor.moveToFirst()) {
			do {
				ordereditems ordereditem = new ordereditems();
				ordereditem.setID(Integer.parseInt(cursor.getString(0)));
				ordereditem.setmenuitemid(cursor.getString(1));
				ordereditem.setName(cursor.getString(2));
				ordereditem.setamount(cursor.getString(3));
				ordereditem.setdescription(cursor.getString(4));
				// Adding contact to list
				itemList.add(ordereditem);
			} while (cursor.moveToNext());
		}
 
		// return menu item list
		return itemList;
	}
 
	// Updating single menu item
	public int updateMenuItem(ordereditems ordereditem) {
		SQLiteDatabase db = this.getWritableDatabase();
 
		ContentValues values = new ContentValues();
		values.put(KEY_NAME, ordereditem.getName());
		values.put(KEY_PRICE, ordereditem.getamount());
		values.put(KEY_MENUID, ordereditem.getmenuitemid());
		values.put(KEY_DESCRIPTION, ordereditem.getdescription());
		// updating row
		return db.update(TABLE_MENUITEMS, values, KEY_UNIQUEID + " = ?",
				new String[] { String.valueOf(ordereditem.getID()) });
	}
 
	// Deleting single contact
	public void deleteMenuItem(ordereditems contact) {
		SQLiteDatabase db = this.getWritableDatabase();
		db.delete(TABLE_MENUITEMS, KEY_UNIQUEID + " = ?",
				new String[] { String.valueOf(contact.getID()) });
		db.close();
	}
 
	// Getting contacts Count
	public int getMenuItemsCount() {
		String countQuery = "SELECT  * FROM " + TABLE_MENUITEMS;
		SQLiteDatabase db = this.getReadableDatabase();
		Cursor cursor = db.rawQuery(countQuery, null);
		cursor.close();
 
		// return count
		return cursor.getCount();
	}
 
}

Member 10790070 wrote:

I'm a final year student in the university and my project is on android programming. Please Does anyone have journals on android programming? or a link to the journals?

Member 10790070 wrote:

plus i'm not a computer science student. I study Enginnering.

Member 10790070 wrote:

So I'm not ashamed to ask for help.

Member 10790070 wrote:

I'm a final year student in the university

Awesome Sohel wrote:

Also Suggest me best tutorial.