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.166 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.135 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

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

Who is online