UsNWJEFT

1package p32929.mhclops.Database;
2
3import android.content.ContentValues;
4import android.content.Context;
5import android.database.sqlite.SQLiteDatabase;
6import android.database.sqlite.SQLiteOpenHelper;
7
8import java.text.DateFormat;
9import java.util.Date;
10
11public class DBHelper extends SQLiteOpenHelper {
12
13    Context context;
14
15    private static final String DATABASE_FIRST_NAME = "IE-";
16    private static final int DATABASE_VERSION = 1;
17
18    private static final String TABLE_NAME = "DATA";
19    private static final String COL_SERIAL = "SERIAL";
20    private static final String COL_VESSEL_NAME = "VESSEL_NAME";
21    private static final String COL_VOYAGE = "VOYAGE";
22    private static final String COL_ROT_NO = "ROT_NO";
23    private static final String COL_CONTAINER_NO = "CONTAINER_NO";
24    private static final String COL_MLO = "MLO";
25    private static final String COL_YARD_LOCATION = "YARD_LOCATION";
26    private static final String COL_VEHICLE_NO = "VEHICLE_NO";
27    private static final String COL_SIZE = "SIZE";
28    private static final String COL_RL_NO = "RL_NO";
29    private static final String COL_SEAL_NO = "SEAL_NO";
30    private static final String COL_WEIGHT = "WEIGHT";
31
32    static String currentDate = DateFormat.getDateInstance().format(new Date());
33
34    private static final String DATABASE_NAME = DATABASE_FIRST_NAME + currentDate + ".db";
35
36    private static final String CREATE_TABLE = " CREATE TABLE IF NOT EXISTS " + TABLE_NAME +
37            "(" + COL_SERIAL + " INTEGER PRIMARY KEY AUTOINCREMENT," +
38            COL_VESSEL_NAME + " TEXT, " +
39            COL_VOYAGE + " TEXT, " +
40            COL_ROT_NO + " TEXT, " +
41            COL_CONTAINER_NO + " TEXT, " +
42            COL_MLO + " TEXT, " +
43            COL_YARD_LOCATION + " TEXT, " +
44            COL_VEHICLE_NO + " TEXT, " +
45            COL_SIZE + " TEXT, " +
46            COL_RL_NO + " TEXT, " +
47            COL_SEAL_NO + " TEXT, " +
48            COL_WEIGHT + " TEXT) ";
49
50    private static final String UPGRADE_TABLE = "DROP TABLE IF EXISTS ";
51
52
53    public DBHelper(Context context) {
54        super(context, "/mnt/sdcard/MHCL/ExportDB/" + DATABASE_NAME, null, DATABASE_VERSION);
55        SQLiteDatabase db = this.getWritableDatabase();
56
57    }
58
59
60    @Override
61    public void onCreate(SQLiteDatabase db) {
62        db.execSQL(CREATE_TABLE);
63    }
64
65    @Override
66    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
67        db.execSQL(UPGRADE_TABLE + TABLE_NAME);
68        onCreate(db);
69    }
70
71    public boolean insertData(String vesselName, String voyage, String rotNo,
72                              String containerNo, String MLQ, String yardLocation,
73                              String vehicleNo, String size, String RLNo,
74                              String sealNo, String weight) {
75
76
77        SQLiteDatabase db = this.getWritableDatabase();
78        ContentValues contentValues = new ContentValues();
79        contentValues.put(COL_VESSEL_NAME, vesselName);
80        contentValues.put(COL_VOYAGE, voyage);
81        contentValues.put(COL_ROT_NO, rotNo);
82        contentValues.put(COL_CONTAINER_NO, containerNo);
83        contentValues.put(COL_MLO, MLQ);
84        contentValues.put(COL_YARD_LOCATION, yardLocation);
85        contentValues.put(COL_VEHICLE_NO, vehicleNo);
86        contentValues.put(COL_SIZE, size);
87        contentValues.put(COL_RL_NO, RLNo);
88        contentValues.put(COL_SEAL_NO, sealNo);
89        contentValues.put(COL_WEIGHT, weight);
90
91        long result = db.insert(TABLE_NAME, null, contentValues);
92
93        if (result == -1)
94            return false;
95        else return true;
96
97    }
98
99}