JAyH892K

1public class DBHelp extends SQLiteOpenHelper {
2
3private static final int DATABASE_VERSION = 1;
4private static final String DATABASE_NAME = "arrived.db";
5
6public DBHelp(Context context) {
7    super(context, DATABASE_NAME, null, DATABASE_VERSION);
8}
9
10@Override
11public void onCreate(SQLiteDatabase db) {
12    // Create table
13    String Create_Query = "CREATE TABLE IF NOT EXISTS  arrivedservice ("
14            + "_id INTEGER PRIMARY KEY AUTOINCREMENT, "
15            + "Lat TEXT ,"
16            + "Lon TEXT , "
17            + "LeaveTime TEXT "
18            + ");";
19    db.execSQL(Create_Query);
20
21    // Insert into database
22    String LeaveTime = String.valueOf(System.currentTimeMillis());
23    String Insert_Query = "INSERT INTO arrivedservice (_id,Lat,Lon,LeaveTime) VALUES ('1','240.22652','151.523978'," + LeaveTime + ")";
24    db.execSQL(Insert_Query);
25    db.close();
26}