Working with the SQLite-Database - Cursors

nbagade · by **nbagade** » Fri Nov 20, 2009 8:14 am

Hi plusminus,

I am creating mobile application where I need to take the vaues from Database.

Actually I am new to android sdk.I have work experience of Dot net technology and sql server databse in creating windows desktop application.

where there will be one centrailize databse server and u can access the data from our application through sqlconnection by using sql query or storeprocedure.

Is this concept is there in android sqllite databse.

can i create comman databse for all my application.?

If I create the databse where it will save physically.
How to access the data from android code.

please guide me .

Thanks a Lot in Advance.
Nbagade

nbagade · by **nbagade** » Tue Dec 01, 2009 10:59 am

I am waiting for help sir.

achie1266 · by **achie1266** » Thu Dec 03, 2009 8:32 pm

nbagade wrote:Hi plusminus,

I am creating mobile application where I need to take the vaues from Database.

Actually I am new to android sdk.I have work experience of Dot net technology and sql server databse in creating windows desktop application.

where there will be one centrailize databse server and u can access the data from our application through sqlconnection by using sql query or storeprocedure.

Is this concept is there in android sqllite databse.

can i create comman databse for all my application.?

If I create the databse where it will save physically.
How to access the data from android code.

please guide me .

Thanks a Lot in Advance.
Nbagade

No sqlite is not a server.
You do not need stored procedures.You can directly query your database.
You might want to look at the notepad tutorial on android to get an idea of how database stuff works in android.

http://developer.android.com/guide/tuto ... index.html

vasuravada · by **vasuravada** » Mon Jan 04, 2010 10:27 pm

Hi...paul...

This post is really very helpful in understanding the functionality of SQLite databases
in an Android application.....I was corrected my all mistakes by looking at the older posts by so
many frndzzz.....

Thank you so much to all buddies ......

dpace32 · by **dpace32** » Sat Mar 27, 2010 9:09 pm

Hello -

For some reason I can never execute the full source code. I download the ZIP, import it into Eclipse but when I try to run this one (for example) I get a list of errors such as the attached list. Do you know what the issue could be? I edited the library to point to the correct SDK version. Any help on this would be greatly appreciated.

Thanks,
-Adam

hendra40 · by **hendra40** » Sun Apr 04, 2010 12:56 am

Hello, everyone.
I am beginner in the android programming.

Two days ago, I face same problem about connecting to database in android.
But now, I have found solution code to connect to database in android.

Please try this code ( You only create a new project and copy this code in .java and change the package name ) :

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

 
package com.Android.Beta; //Please change with your package name
 
import android.app.Activity;
 
import android.database.Cursor;
 
import android.database.sqlite.SQLiteDatabase;
 
import android.os.Bundle;
 
import android.util.Log;
 
import android.widget.TextView;
 
public class insert extends Activity {  // change class name too 
 
 /** Called when the activity is first created. */
 
 @Override
 
 public void onCreate(Bundle savedInstanceState) {
 
  super.onCreate(savedInstanceState);
 
  SQLiteDatabase myDB= null;
 
  String TableName = "dictionary";
 
  String Data = "";
 
  /* Create a Database. */
 
  try {
 
   myDB = this.openOrCreateDatabase("handwriting", MODE_PRIVATE, null);
 
   /* Create a Table in the Database. */
 
   myDB.execSQL("CREATE TABLE IF NOT EXISTS "
 
     + TableName
 
     + " (japan_word VARCHAR, english_word VARCHAR);");
 
   /* Insert data to a Table*/
 
   myDB.execSQL("INSERT INTO "
 
     + TableName
 
     + " (japan_word, english_word)"
 
     + " VALUES ('konpyuta ', 'computer');");
 
   /*retrieve data from database */
 
   Cursor c = myDB.rawQuery("SELECT * FROM " + TableName , null);
 
   int Column1 = c.getColumnIndex("japan_word");
 
   int Column2 = c.getColumnIndex("english_word");
 
   // Check if our result was valid.
 
   c.moveToFirst();
 
   if (c != null) {
 
    // Loop through all Results
 
    do {
 
     String word1 = c.getString(Column1);
 
     String word2 = c.getString(Column2);
 
     Data =Data +word1+"/"+word2+"\n";
 
    }while(c.moveToNext());
 
   }
 
   TextView tv = new TextView(this);
 
   tv.setText(Data);
 
   setContentView(tv);
 
  }
 
  catch(Exception e) {
 
   Log.e("Error", "Error", e);
 
  } finally {
 
   if (myDB != null)
 
    myDB.close();
 
  }
 
 }
 
}
 
Parsed in 0.038 seconds,  using GeSHi 1.0.8.4

I hope this code help you.
I use eclipse 3.5 and Android 2.1

Normano · by **Normano** » Thu Apr 08, 2010 8:22 pm

Do anyone know how to update the list on change on other activity?
I've tried

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

public void onResume(Bundle icicle) {
 
                c.requery();
 
    }
Parsed in 0.030 seconds,  using GeSHi 1.0.8.4

But that dosen't work

MorbidDestiny · by **MorbidDestiny** » Thu May 20, 2010 12:13 pm

Hi!

Is it possible to store the Database on a SDCard?

If so, could you please help me in making it?

Thanks

karthik8687 · by **karthik8687** » Fri Sep 03, 2010 9:31 am

hi
thanks for the tutorial

.. i really understood the concepts.. basically i'm not able to execute it... problem with SDK version i guess... can i expect some changes in source code which make it compatible with newer version...
I'm not getting where all I need to make changes....

Another request.. how to add data to SQLite database using checkbox???

please help me..

farhan · by **farhan** » Sun Oct 24, 2010 6:10 pm

http://mfarhan133.wordpress.com/2010/10 ... r-android/

Its an excellent tutorial for android DB CRUD with
COMPLETE SOURCE CODE

kumar1234567 · by **kumar1234567** » Tue Nov 02, 2010 1:47 pm

Hello sir,

I had a doubt in Android SQLite database connectivity.

First.java
I had create a activity class that have UI components such as (TextView & EditView for UserName) and (TextView & EditView for Password) and button (Login).

SampleSql.java
I had created sqlite database and one table with attribute like usarname and password in varchar and then i insert five people account.

I dont know how to connect these two classes and when i enter the some value in username and password, it want to check in database, when the both the value are correct it goes to another page by using intent.
My question is how to connect the sqlite database with activity class. I know this very simple question in java but i'm not familiar with sqlite database.
Please suggest me any ideas or send me a code,.

Thanks in advance,
kumar.

ericharlow · by **ericharlow** » Tue Nov 02, 2010 8:13 pm

Normano wrote:Do anyone know how to update the list on change on other activity?
I've tried
Syntax: [ Download ] [ Hide ]
Syntax: [ Download ] [ Show ]
Using java Syntax Highlighting
public void onResume(Bundle icicle) {

c.requery();

}

Parsed in 0.033 seconds, using GeSHi 1.0.8.4

But that dosen't work

yes. All you need to do is add a line of code like this.

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

public void onResume(Bundle icicle) {
                c.requery();
                getListView().invalidateViews();
    }
Parsed in 0.034 seconds,  using GeSHi 1.0.8.4

kumar1234567 · by **kumar1234567** » Tue Nov 09, 2010 11:16 am

hello sir,

i created database and tables and inserted some values. I want to retrieve values whenever user enter some value in the editview textbox.

It check the value whether it is in database and if it correct i want to go to next page.

could anyone please give any sample code or suggest ideas..?

thanks in advance
kumar.

david.treshansky · by **david.treshansky** » Sat Dec 04, 2010 7:11 pm

Plusminus,

I am a novice (but again this is a novice forum). How do I take the attached code and import it into a project in Eclipse so I can learn from it? Thanks in advance for your assistance.

sheikh.aman · by **sheikh.aman** » Tue Jan 25, 2011 9:06 am

Working with the SQLite-Database - Cursors

Android database concept

Help

Re: Android database concept

Thank you So..much

Re: Working with the SQLite-Database - Cursors

Re: Working with the SQLite-Database - Cursors

Re: Working with the SQLite-Database - Cursors

Re: Working with the SQLite-Database - Cursors

Re:

Re: Working with the SQLite-Database - Cursors

Re: Working with the SQLite-Database - Cursors

Re: Working with the SQLite-Database - Cursors

Who is online