private void populatespinner(){
          ArrayAdapter<String> saa=new ArrayAdapter<String>(this, android.R.layout.simple_spinner_item, spentonitems);
          saa.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
          spentonspin.setAdapter(saa);
          
     SQLiteDatabase mydb = null;
          try {
     mydb = this.openOrCreateDatabase(MY_DATABASE_NAME, MODE_PRIVATE, null);
          mydb.execSQL("CREATE TABLE IF NOT EXISTS "+ MY_DATABASE_TABLE + "(spent VARCHAR, num INT(2));");
          mydb.execSQL("INSERT INTO " + MY_DATABASE_TABLE + " (spent, num)" + " VALUES ('TESTING', 2)");

          Cursor c = mydb.rawQuery("SELECT spent,num" + " FROM " + MY_DATABASE_TABLE + " WHERE num > 1;", null);
          
          int spentcol = c.getColumnIndex("spent");
          int numcol = c.getColumnIndex("num");
          String spentonvar;
          if (c != null) {
               if (c.moveToFirst()) {
                    int i = 0;

                    do {
                         i++;
                         spentonvar = c.getString(spentcol);
                         saa.add(spentonvar);
                    } while (c.moveToNext());
               }
          }
      }  finally {
          if (mydb != null)
              mydb.close(); }

}

this.createDatabase(MY_DATABASE_NAME, 1, MODE_PRIVATE, null);

package org.klian.android.Hello_World;

import java.io.FileNotFoundException;
import java.util.ArrayList;

import android.app.ListActivity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.widget.ArrayAdapter;
import android.widget.EditText;
import android.util.Log;

public class Hello_World extends ListActivity {
     private final String MY_DATABASE_NAME = "LoginDB";
    private final String MY_DATABASE_TABLE = "Login1";
    private final String tag="Klian";
   
    public void onCreate(Bundle icicle) {
     super.onCreate(icicle);
     
     ArrayList<String> results = new ArrayList<String>();
        SQLiteDatabase myDB = null;
       
        try{
         
          this.createDatabase(MY_DATABASE_NAME, 1, MODE_PRIVATE, null);
          Log.i(tag,"Base de datos creada");
         
        }catch(Exception e){
          Log.i(tag,"------"+e.getMessage());
            Log.i(tag,"++++++"+e);
        }
    }
}

this.openOrCreateDatabase(MY_DATABASE_NAME, MODE_PRIVATE, null);

this.createDatabase(MY_DATABASE_NAME, 1, MODE_PRIVATE, null);

package com.android.database;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Map;

import android.app.ListActivity;

import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteQueryBuilder;
import android.os.Bundle;


import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.content.Intent;
import android.database.Cursor;
import java.io.FileNotFoundException;

import com.android.Parametros;
import com.android.WsMetodos;
import com.android.WsServicos;

import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;


public class DB extends Activity{
     
     private Context dbContext;
     private static final String DATABASE_NAME = "DViewDB";
     private static final int DATABASE_VERSION = 1;
    private SQLiteDatabase dbDView;
     private WsServicos auxServico = new WsServicos();
     private WsMetodos auxMetodos = new WsMetodos();
     private Parametros auxParametros = new Parametros();
     private Parametros auxReturns = new Parametros();
     
     /**
    * Comandos SQL para criação das tabelas
    */
     private static final String TABLE_SERVICES =
          "CREATE TABLE IF NOT EXISTS tbSERVICES " +
          "(ID_SERVICE integer primary key autoincrement, " +
          "NAME text not null, " +
          "LOCATION text not null);";
     
     private static final String TABLE_METHODS =
          "CREATE TABLE IF NOT EXISTS tbMETHODS " +
          "(ID_METHOD integer primary key autoincrement, " +
          "ID_SERVICE integer not null, " +
          "NAME text not null, " +
          "DESCRIPTION text not null);";
     
     private static final String TABLE_PARAMS =
          "CREATE TABLE IF NOT EXISTS tbPARAMETERS " +
          "(ID_PARAMETER integer primary key autoincrement, " +
          "ID_METHOD integer not null, " +
          "NAME text not null, " +
          "TYPE text not null);";
     
     private static final String TABLE_RETURNS =
          "CREATE TABLE IF NOT EXISTS tbRETURNS " +
          "(ID_RETURN integer primary key autoincrement, " +
          "ID_METHOD integer not null, " +
          "NAME text not null, " +
          "TYPE text not null);";
     
    public DB(Context context) {
     this.dbContext = context;
     
        dbDView = dbContext.openOrCreateDatabase(DATABASE_NAME, MODE_PRIVATE, null);
       
     dbDView.execSQL(TABLE_SERVICES);
     dbDView.execSQL(TABLE_METHODS);
     dbDView.execSQL(TABLE_PARAMS);
     dbDView.execSQL(TABLE_RETURNS);
    }
   
    public void closeDB(){
     dbDView.close();
    }
   
    /**
     * Create a new note using the title and body provided. If the note is successfully created
     * return the new rowId for that note, otherwise return a -1 to indicate failure.
     * @param title the title of the note
     * @param body the body of the note
     * @return rowId or -1 if failed
     */

     public long createElement(String dbTable, ContentValues values) {
          return dbDView.insert(dbTable, null, values);
     }
     
    /**
     * Update the note using the details provided. The note to be updated is specified using
     * the rowId, and it is altered to use the title and body values passed in
     * @param rowId id of note to update
     * @param title value to set note title to
     * @param body value to set note body to
     * @return true if the note was successfully updated, false otherwise
     */
    public boolean updateElement(String dbTable, ContentValues values, String selection) {
        return dbDView.update(dbTable, values, selection, null) > 0;
    }
   
    /**
     * Return a Cursor over the list of all elements in the database
     * @return Cursor over all elements
     */
     public Cursor fetchAllElements(String dbTable, String[] column) {
        return dbDView.query(dbTable, column, null, null, null, null, null);
    }

    /**
     * Return a Cursor positioned at the element that matches the given selection
     * @param
     * @return Cursor positioned to matching element, if found
     * @throws SQLException if element could not be found/retrieved
     */
    //public Cursor fetchElementSQL(String dbTable, String[] column, String selection, String[] selectionArgs) {
   
     public Cursor fetchElementSQL(String sql) {
     return dbDView.rawQuery(sql, null);
    }
     
    /**
     * Return a Cursor positioned at the element that matches the given selection
     * @param
     * @return Cursor positioned to matching element, if found
     * @throws SQLException if element could not be found/retrieved
     */
    public Cursor fetchElement(String dbTable, String[] column, String selection, String[] selectionArgs) {
     
     SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
     qb.setTables(dbTable);
     qb.appendWhere(selection);
     
     Cursor c = qb.query(dbDView, null, null, selectionArgs, null, null, null);
     return c;
     /*
     Cursor result = mDb.query(dbTable, column, selection, selectionArgs, null, null, null);
        if ((result.getCount() == 0) || !result.isFirst()) {
            throw new SQLException("No element matching ID: " + column);
        }
        return result;
        */
    }
   
    public Boolean saveServices(Map services){
     
     ContentValues values = new ContentValues();
     int qntd = 0;
     long rowID = 0;
     
     try {
          for (int q = 0; q<=services.size(); q++){
               auxServico = (WsServicos) services.get(q);
               values.put("NAME", auxServico.getNome());
               values.put("LOCATION", auxServico.getAddressLocation());
               
               rowID = this.createElement(TABLE_SERVICES, values);
          }
          } catch (Exception e) {
               // TODO: handle exception
               return false;
          }
          return false;
    }
}

myDB = a.openOrCreateDatabase("gstock_user_data", MODE_PRIVATE, null);
               
               //Get money info
               Cursor c = myDB.query("Money", new String[] {"banktransactions", "bankaccount"}, null, null, null, null, null);
               if(c != null)
               {
                    if(c.getCount() == 1)
                    {
                         banktransactions = Integer.parseInt(c.getString(c.getColumnIndex("banktransactions")));
                         bankaccount = Integer.parseInt(c.getString(c.getColumnIndex("bankaccount")));
                    }
               }
               return banktransactions;