uZ2hFvLe

1MyDataBaseHelper dbCon = new MyDataBaseHelper(this);
2dbCon.open();
3dbCon.pushToDatabase(uniqueName, date, time, wingType, nozzle, orifice, angle, speed, pressure, dv1, dv5, dv9, sprayVolume1, sprayVolume2, droplet, tableExist);
4dbCon.close();
5
6MyDataBaseHelper
7public void pushToDatabase(String uniqueName, String date, String time, String wingType, String nozzle, String orifice, String angle, String speed, String pressure,
8              String dv1, String dv5, String dv9, String sprayVolume1, String sprayVolume2, String droplet, String tableExist)
9      {
10
11          final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS Results("
12              + "uniqueName TEXT,"
13              + "date TEXT,"
14              + "time TEXT,"
15              + "wingType TEXT,"
16              + "nozzle TEXT,"
17              + "orifice TEXT,"
18              + "angle TEXT,"
19              + "pressure TEXT,"
20              + "speed TEXT,"
21              + "dv1 TEXT,"
22              + "dv5 TEXT,"
23              + "dv9 TEXT,"
24              + "sprayvolume1 TEXT,"
25              + "sprayvolume2 TEXT,"
26              + "droplet TEXT);";
27         myDB.execSQL(CREATE_TABLE);
28
29      ContentValues values = new ContentValues();
30
31      values.put("uniqueName", uniqueName);
32      values.put("date", date);
33      values.put("time", time);
34      values.put("wingType", wingType);
35      values.put("nozzle", nozzle);
36      values.put("orifice", orifice);
37      values.put("angle", angle);
38      values.put("pressure", pressure);
39      values.put("speed", speed);
40      values.put("dv1", dv1);
41      values.put("dv5", dv5);
42      values.put("dv9", dv9);
43      values.put("sprayvolume1", sprayVolume1);
44      values.put("sprayvolume2", sprayVolume2);
45      values.put("droplet", droplet);
46
47      myDB.insert("Results", null, values);
48      myDB.close();
49
50      //Cursor mCursor;
51      //mCursor = myDB.rawQuery(data, null);
52      //mCursor.moveToFirst();*/
53  }
54	
55final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS Results("
56          + "uniqueName TEXT,"
57          + "date TEXT,"
58          + "time TEXT,"
59          + "wingType TEXT,"
60          + "nozzle TEXT,"
61          + "orifice TEXT,"
62          + "angle TEXT,"
63          + "pressure TEXT,"
64          + "speed TEXT,"
65          + "dv1 TEXT,"
66          + "dv5 TEXT,"
67          + "dv9 TEXT,"
68          + "sprayvolume1 TEXT,"
69          + "sprayvolume2 TEXT,"
70          + "droplet TEXT, PRIMARY KEY(uniqueName));";