|
First Steps wrote: I hope I have clarified. Not in any useful way. We have no idea what your code is doing so we cannot begin to guess what might be the cause. You will need to do some debugging and collect some information about exactly what is happening for anyone to be able to help you.
|
|
|
|
|
Thanks for sharing this...!!!
|
|
|
|
|
i want coding for creating sqlite database in android project and its connectivity.reply quickly
|
|
|
|
|
|
Why have you posted this to me?
|
|
|
|
|
You can refer my following code
You can customize this code as a library for sqllite
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 {
private static final int DATABASE_VERSION = 1;
private static final String DATABASE_NAME = "menuitemsordered";
private static final String TABLE_MENUITEMS = "menuitems";
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);
}
@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);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + TABLE_MENUITEMS);
onCreate(db);
}
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());
lInsertedID = db.insert(TABLE_MENUITEMS, null, values);
db.close();
return lInsertedID;
}
ordereditems getitem(int id) {
SQLiteDatabase db = this.getReadableDatabase();
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 item1;
}
public List<ordereditems> getAllorderedmenuitems() {
List<ordereditems> itemList = new ArrayList<ordereditems>();
String selectQuery = "SELECT id, menuid, name, price, description FROM "
+ TABLE_MENUITEMS;
SQLiteDatabase db = this.getWritableDatabase();
Cursor cursor = db.rawQuery(selectQuery, null);
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));
itemList.add(ordereditem);
} while (cursor.moveToNext());
}
return itemList;
}
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());
return db.update(TABLE_MENUITEMS, values, KEY_UNIQUEID + " = ?",
new String[] { String.valueOf(ordereditem.getID()) });
}
public void deleteMenuItem(ordereditems contact) {
SQLiteDatabase db = this.getWritableDatabase();
db.delete(TABLE_MENUITEMS, KEY_UNIQUEID + " = ?",
new String[] { String.valueOf(contact.getID()) });
db.close();
}
public int getMenuItemsCount() {
String countQuery = "SELECT * FROM " + TABLE_MENUITEMS;
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.rawQuery(countQuery, null);
cursor.close();
return cursor.getCount();
}
}
|
|
|
|
|
Hello, 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? Please I need help. My e-mail address is ulokoemmanuel39@gmail.com
|
|
|
|
|
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? I could somewhat understand such a question from a first year student, but to see such from a final year student is just pathetic.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
|
|
|
|
|
I'm new to android programming. plus i'm not a computer science student. I study Enginnering. So I'm not ashamed to ask for help. My professor(supervisor) said android programming will be good for me, so I developed interest. I have programming skills. I just haven't delved into android programming before
|
|
|
|
|
Member 10790070 wrote: plus i'm not a computer science student. I study Enginnering. There is a lot of overlap between these two disciplines, research being one such aspect. From my viewpoint point, you've spent more time on this forum compiling your question and responses than it would have taken to do a simple Google search, the later of which would have provided you with a plethora of information and examples. Android articles here at CP are becoming more and more prevalent each day.
Member 10790070 wrote: So I'm not ashamed to ask for help. Nor should you be.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
|
|
|
|
|
Member 10790070 wrote: I'm a final year student in the university Has any part of your course suggested that you need to learn how to do research? Typing "Android development" into Google will find you a wealth of useful information. You could also look at some of the aticles at http://www.codeproject.com/KB/android/[^].
|
|
|
|
|
thank you very much Mr Richard MacCutchan. your advice has been helpful
|
|
|
|
|
When you visited this website, did you even look around here? There is a section on the main page. You can go to that section[^], and you will find a lot of good content for Android programming.
Good luck.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Thank you very much Mr Afzaal Ahmad Zeeshan
|
|
|
|
|
|
Thank you sir, I really appreciate your support. I'll check out the links you referred. Thanks again
|
|
|
|
|
|
I need a source code for android DISCUSSION forum activity and also for WISHLIST activity if possible means anyone help me out
|
|
|
|
|
|
We'll gladly help answer specific questions when you get stuck in code but no one here is going to give you all the source code.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Here I want to know that for implementing InAppPurchase, It is necessary to upload apk on google play store for testing. And Also Suggest me best tutorial.
Thank You !
|
|
|
|
|
Awesome Sohel wrote: Also Suggest me best tutorial. That's a question for Google, and you have to decide which is best.
|
|
|
|
|
You wanted to read the Android's official documentation about In-app billing system. You can read those out on the Android's developer resources, http://developer.android.com/google/play/billing/billing_overview.html[^].
Secondly, if you want to upload the APK, then you need to first create an account on Google Play, and then you can upload the APKs. Remember they do no test the APK; unless there is a potential threat. You have to make sure that your application is good enough to be uploaded to the users over the Google play network.
You can read from millions of thousands of articles from third-party or indie developers about Android programming. Which one is best, that is your own choice. Google it.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Just curios to see how many Eclipse hold outs there were for android development. If you are holding out, maybe why and have you tried the latest Android Studio.
|
|
|
|
|
To date, I've only used Eclipse for Android development. I'm trying to get my feet wet with Android Studio but I find it hard to navigate, counterintuitive, and it creates a ridiculously deep folder structure for projects. Given that it is the go-forward IDE for Android development, I know I must suffer through it. Maybe in time...
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
|
|
|
|