Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.finaldb.android;
- import android.R;
- import android.content.Context;
- import android.database.Cursor;
- import android.database.sqlite.SQLiteDatabase;
- import android.database.sqlite.SQLiteOpenHelper;
- import android.provider.BaseColumns;
- import android.util.Log;
- import android.widget.EditText;
- /** Helper to the database, manages versions and creation */
- public class EventDataSQLHelper extends SQLiteOpenHelper {
- SQLiteDatabase db;
- EditText results;
- String special;
- private static String DB_PATH = "/data/data/com.finaldb.android/databases/";
- private static final String DATABASE_NAME = "smiledb.db";
- private static final int DATABASE_VERSION = 1;
- // Table name
- public static final String TABLE = "smiley_info";
- // Columns
- public static final String POSITION = "";
- private static final String URL= "";
- public static final String SPECIALCHARCTER = "";
- protected static final Object Ob = null;
- public EventDataSQLHelper(Context context) {
- super(context, DATABASE_NAME, null, DATABASE_VERSION);
- }
- public void onSelect(SQLiteDatabase db) {
- //String sql = "create table " + TABLE + "( " + BaseColumns._ID
- //+ " integer primary key autoincrement, " + POSITION + " integer, "
- //+ SPECIALCHARCTER + " text not null);";
- // Log.d("EventsData", "onCreate: " + sql);
- // Log.d("EventsData", "onSelect: " + sql);
- // db.execSQL(cursor);
- //db.execSQL(sql);
- // String sql = "Select _ID, POSITION, SPECIALCHARCTER from TABLE Where(position like " + "'1'" +
- // ")";
- // Log.d("EventsData", "onSelect: " + sql);
- // db.execSQL(sql);
- // }
- //public String selectSpecialChar(int Position)
- // {
- //String strRet = "aaaaaaa1111";
- db= this.getReadableDatabase();
- db= this.getWritableDatabase();
- db = this.openOrCreateDatabase(DATABASE_NAME, null);
- // String sql = "Select _ID, POSITION, SPECIALCHARCTER from " +
- // " "+ TABLE + "Where(position = " + POSITION + ")";
- // Log.d("EventsData", "onSelect: " + sql);
- // db.execSQL(sql);
- EditText result=(EditText)findViewById(R.id.input);
- // SQLiteDatabase sampleDB = null;
- // sampleDB = this.openOrCreateDatabase(DATABASE_NAME, null);
- Cursor c = db.rawQuery("SELECT SPECIALCHARCTER FROM " +
- TABLE + " where POSITION = 0", null);
- int A = c.getColumnIndex("POSITION");
- String strRet;
- strRet = c.getString(A);
- results.setText("" + strRet);
- c.moveToNext();
- }
- private EditText findViewById(int input) {
- // TODO Auto-generated method stub
- return null;
- }
- private SQLiteDatabase openOrCreateDatabase(String DATABASE_NAME,
- Object object) {
- // TODO Auto-generated method stub
- return null;
- }
- /*
- Cursor c = db.rawQuery("Select SPECIALCHARCTER from TABLE Where POSITION = 1 " , null);
- int A = c.getColumnIndex("SPECIALCHARCTER");
- /*int B = c.getColumnIndex("middlename");
- int C = c.getColumnIndex("lastname");
- int D = c.getColumnIndex("dob");
- int E = c.getColumnIndex("dor");
- c.moveToFirst();
- if (c == null)
- {
- do
- {
- // strRet = c.getString(A);
- strRet="aaaa";
- }1
- while(c.moveToNext());
- }
- return strRet;
- }
- */
- // private SQLiteDatabase openOrCreateDatabase(String DATABASE_NAME,
- // Object object) {
- // TODO Auto-generated method stub
- //return null;
- //}
- /*
- private SQLiteDatabase openOrCreateDatabase(String databaseName,
- Object object) {
- // TODO Auto-generated method stub
- return null;
- }
- */
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- if (oldVersion >= newVersion)
- return;
- //String sql = null;
- //if (oldVersion == 1)
- //sql = "alter table " + TABLE + " add note text;";
- //if (oldVersion == 2)
- //sql = "";
- //Log.d("EventsData", "onUpgrade : " + sql);
- //if (sql != null)
- //db.execSQL(sql);
- }
- @Override
- public void onCreate(SQLiteDatabase db) {
- // TODO Auto-generated method stub
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement