Advertisement
Guest User

sqlite problem android

a guest
Sep 14th, 2011
262
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 3.98 KB | None | 0 0
  1. package com.finaldb.android;
  2. import android.R;
  3. import android.content.Context;
  4. import android.database.Cursor;
  5. import android.database.sqlite.SQLiteDatabase;
  6. import android.database.sqlite.SQLiteOpenHelper;
  7. import android.provider.BaseColumns;
  8. import android.util.Log;
  9. import android.widget.EditText;
  10. /** Helper to the database, manages versions and creation */
  11.     public class EventDataSQLHelper extends SQLiteOpenHelper {
  12.         SQLiteDatabase db;
  13.         EditText results;
  14.         String special;
  15.     private static String DB_PATH = "/data/data/com.finaldb.android/databases/";
  16.     private static final String DATABASE_NAME = "smiledb.db";
  17.     private static final int DATABASE_VERSION = 1;
  18.     // Table name
  19.     public static final String TABLE = "smiley_info";
  20.    // Columns
  21.     public static final String POSITION = "";
  22.     private static final String URL= "";
  23.     public static final String SPECIALCHARCTER = "";
  24.     protected static final Object Ob = null;
  25.     public EventDataSQLHelper(Context context) {
  26.         super(context, DATABASE_NAME, null, DATABASE_VERSION);
  27.     }
  28.     public void onSelect(SQLiteDatabase db) {
  29.         //String sql = "create table " + TABLE + "( " + BaseColumns._ID
  30.             //+ " integer primary key autoincrement, " + POSITION + " integer, "
  31.             //+ SPECIALCHARCTER + " text not null);";
  32.         //   Log.d("EventsData", "onCreate: " + sql);
  33.         // Log.d("EventsData", "onSelect: " + sql);
  34.         // db.execSQL(cursor);
  35.            //db.execSQL(sql);
  36.         //  String sql = "Select _ID, POSITION, SPECIALCHARCTER from TABLE Where(position like " + "'1'" +
  37.         //        ")";            
  38.         //   Log.d("EventsData", "onSelect: " + sql);
  39.         //   db.execSQL(sql);
  40.         //  }
  41.     //public String selectSpecialChar(int Position)
  42. //  {
  43.         //String strRet = "aaaaaaa1111";
  44.    
  45.      db= this.getReadableDatabase();
  46.      db= this.getWritableDatabase();
  47.      db = this.openOrCreateDatabase(DATABASE_NAME, null);
  48.     // String sql = "Select _ID, POSITION, SPECIALCHARCTER from " +
  49.         //          " "+ TABLE + "Where(position = " + POSITION + ")";            
  50.     // Log.d("EventsData", "onSelect: " + sql);
  51.     // db.execSQL(sql);
  52.      
  53.    
  54.     EditText result=(EditText)findViewById(R.id.input);
  55. //  SQLiteDatabase sampleDB = null;
  56. //  sampleDB =  this.openOrCreateDatabase(DATABASE_NAME, null);
  57.     Cursor c = db.rawQuery("SELECT SPECIALCHARCTER FROM " +
  58.             TABLE + " where POSITION = 0", null);
  59.      int A = c.getColumnIndex("POSITION");
  60.      String strRet;
  61.               strRet = c.getString(A);
  62.                   results.setText("" + strRet);
  63.         c.moveToNext();
  64.     }
  65.         private EditText findViewById(int input) {
  66.         // TODO Auto-generated method stub
  67.         return null;
  68.     }
  69.     private SQLiteDatabase openOrCreateDatabase(String DATABASE_NAME,
  70.             Object object) {
  71.         // TODO Auto-generated method stub
  72.         return null;
  73.     }
  74.     /*
  75.      Cursor c = db.rawQuery("Select SPECIALCHARCTER from TABLE Where POSITION = 1 " , null);
  76.      int A = c.getColumnIndex("SPECIALCHARCTER");
  77.      /*int B = c.getColumnIndex("middlename");
  78.      int C = c.getColumnIndex("lastname");
  79.      int D = c.getColumnIndex("dob");
  80.      int E = c.getColumnIndex("dor");
  81.      c.moveToFirst();
  82.      if (c == null)
  83.      {
  84.          do
  85.           {
  86.              // strRet = c.getString(A);
  87.               strRet="aaaa";
  88.           }1
  89.           while(c.moveToNext());
  90.      }
  91.      return strRet;
  92.     }
  93.     */
  94. //  private SQLiteDatabase openOrCreateDatabase(String DATABASE_NAME,
  95.     //      Object object) {
  96.         // TODO Auto-generated method stub
  97.         //return null;
  98.     //}
  99.     /*
  100.     private SQLiteDatabase openOrCreateDatabase(String databaseName,
  101.             Object object) {
  102.         // TODO Auto-generated method stub
  103.         return null;
  104.     }
  105. */
  106.     public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  107.         if (oldVersion >= newVersion)
  108.             return;
  109.         //String sql = null;
  110.         //if (oldVersion == 1)
  111.             //sql = "alter table " + TABLE + " add note text;";
  112.         //if (oldVersion == 2)
  113.             //sql = "";
  114.         //Log.d("EventsData", "onUpgrade    : " + sql);
  115.         //if (sql != null)
  116.             //db.execSQL(sql);
  117.     }
  118.         @Override
  119.         public void onCreate(SQLiteDatabase db) {
  120.             // TODO Auto-generated method stub
  121.            
  122.         }
  123. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement