7rf7Hyip

1package com.example.foodbares;
2import android.content.Context;
3import android.database.sqlite.SQLiteDatabase;
4import android.database.sqlite.SQLiteOpenHelper;
5import android.util.Log;
6
7public class DBHelper extends SQLiteOpenHelper {
8	public static final String TABLE_NAME = "data_report";
9    public static final String COLUMN_ID = "_id";
10    public static final String COLUMN_NAME = "nama_report";
11    public static final String COLUMN_TOTAL = "total_harga";
12    private static final String db_name ="report.db";
13    private static final int db_version=1;
14    
15    private static final String db_create = "create table "
16            + TABLE_NAME + "("
17            + COLUMN_ID +" integer primary key autoincrement, "
18            + COLUMN_NAME+ " varchar(50) not null, "
19            + COLUMN_TOTAL+ " varchar(50) not null )";
20   
21      public DBHelper(Context context) {
22          super(context, db_name, null, db_version);
23          // Auto generated
24      }
25   
26      @Override
27      public void onCreate(SQLiteDatabase db) {
28          db.execSQL(db_create);
29      }
30   
31      @Override
32      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
33          Log.w(DBHelper.class.getName(),"Upgrading database from version " + oldVersion + " to "
34                  + newVersion + ", which will destroy all old data");
35          db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
36          onCreate(db);
37   
38      }
39}