Advertisement
Guest User

Headshop sql helper

a guest
Sep 2nd, 2011
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.88 KB | None | 0 0
  1. package com.redorange.database;
  2.  
  3. import android.content.Context;
  4. import android.database.sqlite.SQLiteDatabase;
  5. import android.database.sqlite.SQLiteOpenHelper;
  6. import android.database.sqlite.SQLiteDatabase.CursorFactory;
  7. import android.provider.BaseColumns;
  8. import android.util.Log;
  9.  
  10. public class HeadshopSQLHelper extends SQLiteOpenHelper{
  11.  
  12. private static final String DATABASE_Name1 = "HeadShop DataBase";
  13. private static final int DATABASE_VERSION1 = 1;
  14.  
  15. //create table name
  16. public static final String TABLE1 = "HeadTable1";
  17.  
  18. //DEFINE COLOMN Name
  19. public static final long _ID = 1;
  20. public static final String NAME = "Name";
  21. public static final String GRADE = "Grade";
  22. public static final String DESCRIPTION = "Description";
  23.  
  24.  
  25.  
  26.  
  27. public HeadshopSQLHelper(Context context) {
  28. super(context ,DATABASE_Name1, null, DATABASE_VERSION1);
  29.  
  30. }
  31.  
  32. @Override
  33. public void onCreate(SQLiteDatabase db1) {
  34. String sql = "create table " + TABLE1 + "( " + BaseColumns._ID
  35. + " integer primary key autoincrement, " + NAME + " text not null, "
  36. + GRADE + " text not null, " + DESCRIPTION + " text not null);";
  37. Log.d("Headshop", "onCreate: " + sql);
  38. db1.execSQL(sql);
  39.  
  40. }
  41.  
  42. //@Override
  43. public void onCreate1(SQLiteDatabase db1) {
  44. String sql = "Alter table " + TABLE1 + "( " + BaseColumns._ID
  45. + " integer primary key autoincrement, " + NAME + " text not null, "
  46. + GRADE + " text not null, " + DESCRIPTION + " text not null);";
  47. Log.d("Headshop", "onCreate: " + sql);
  48. db1.execSQL(sql);
  49.  
  50. }
  51.  
  52. @Override
  53. public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  54. if (oldVersion >= newVersion)
  55. return;
  56.  
  57. String sql = null;
  58. if (oldVersion == 1)
  59. sql = "alter table " + TABLE1 + " add note text;";
  60. if (oldVersion == 2)
  61. sql = "";
  62.  
  63. Log.d("Headshop", "onUpgrade : " + sql);
  64. if (sql != null)
  65. db.execSQL(sql);
  66.  
  67. }
  68.  
  69. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement