· 8 years ago · Aug 10, 2018, 07:52 AM
1Database problems - finding a number from an already created database
2package com.partnumbers;
3
4import android.app.Activity;
5import android.content.ContentValues;
6import android.content.Context;
7import android.database.Cursor;
8import android.database.sqlite.SQLiteDatabase.CursorFactory;
9import android.database.SQLException;
10import android.database.sqlite.SQLiteDatabase;
11import android.database.sqlite.SQLiteException;
12import android.database.sqlite.SQLiteOpenHelper;
13import android.util.Log;
14
15
16
17public class DBAdapter
18{
19public static final String distributor = "Distributor #";
20public static final String engine = "Engine #";
21public static final String chasis = "Chasis #";
22public static final String body = "Body #";
23public static final String carb = "Carb #";
24private static final String TAG = "DBAdapter";
25
26private static final String DATABASE_NAME = "myDatabase.db";
27private static final String DATABASE_TABLE0 = "distributorTable";
28private static final String DATABASE_TABLE1 = "engineTable";
29private static final String DATABASE_TABLE2 = "chasisTable";
30private static final String DATABASE_TABLE3 = "bodyTable";
31private static final String DATABASE_TABLE4 = "carbTable";
32static final int DATABASE_VERSION = 1;
33
34private static String dist_id = "Distributor #";
35private static String points = "Points";
36private static String condensor = "Condensor";
37private static String rotor = "Rotor";
38private static String cap = "Distributor Cap";
39private static String coil = "Coil";
40private static String vacuum = "Vacuum Can";
41private static String ignition = "Ignition Wires";
42private static String sparkplug = "Spark Plug";
43private static String timing = "Timing";
44private static String advance = "Advance/Retard Range";
45
46
47
48 private static final String CREATE_TABLE_1 =
49 "CREATE TABLE " + DATABASE_TABLE0 +
50 " (" +
51 dist_id + " TEXT " +
52 points + " TEXT " +
53 condensor + " TEXT " +
54 rotor + " TEXT " +
55 cap + " TEXT " +
56 coil + " TEXT " +
57 vacuum + " TEXT " +
58 ignition + " TEXT " +
59 sparkplug + " TEXT " +
60 timing + " TEXT " +
61 advance + " TEXT );";
62
63 private static final String CREATE_TABLE_2 =
64 " create table " + engine +
65 " (_id integer primary key autoincrement," +
66 " tagName text not null)";
67
68 private static final String CREATE_TABLE_3 =
69 " create table " + chasis +
70 " (_id integer primary key autoincrement," +
71 " locationName text not null, gpsCoOrds text);";
72
73 private static final String CREATE_TABLE_4 =
74 " create table " + body +
75 " (_id integer primary key autoincrement," +
76 " title text not null, body text not null);";
77
78 private static final String CREATE_TABLE_5 =
79 " create table " + carb +
80 " (_id integer primary key autoincrement," +
81 " tagName text not null)";
82
83
84
85
86
87private static final String DATABASE_CREATE =
88 "create table titles (_id integer primary key autoincrement, "
89 + "isbn text not null, title text not null, "
90 + "publisher text not null);";
91
92
93
94public void onCreate(SQLiteDatabase db) {
95db.execSQL(CREATE_TABLE_1);
96db.execSQL(CREATE_TABLE_2);
97db.execSQL(CREATE_TABLE_3);
98db.execSQL(CREATE_TABLE_4);
99db.execSQL(CREATE_TABLE_5);
100}
101
102
103
104
105private final Context context;
106private static DatabaseHelper DBHelper;
107private SQLiteDatabase db;
108
109public DBAdapter(Context _context)
110{
111 this.context = _context;
112 DBHelper = new DatabaseHelper(context, DATABASE_NAME, null, DATABASE_VERSION);
113
114
115
116}
117
118public DBAdapter open() throws SQLException
119{
120 db = DBHelper.getWritableDatabase();
121 return this;
122}
123
124public void close()
125{
126 DBHelper.close();
127}
128
129
130public long insertData(String name, String address) {
131 ContentValues initialValues = new ContentValues();
132
133 initialValues.put(dist_id, "211905205E");
134 initialValues.put(points, "01 001");
135 initialValues.put(condensor, "02 170");
136 return db.insert(DATABASE_TABLE0, null, initialValues);
137 }
138
139// public long insertTitle(String isbn, String title, String publisher)
140// {
141// ContentValues initialValues = new ContentValues();
142// initialValues.put(KEY_ISBN, isbn);
143// initialValues.put(KEY_TITLE, title);
144// initialValues.put(KEY_PUBLISHER, publisher);
145// return db.insert(DATABASE_TABLE, null, initialValues);
146// }
147
148
149private static class DatabaseHelper extends SQLiteOpenHelper
150{
151 DatabaseHelper(Context context, String name, CursorFactory factory, int version)
152 {
153 super(context, name, factory, version);
154 }
155
156 @Override
157 public void onCreate(SQLiteDatabase db)
158 {
159 db.execSQL(DATABASE_CREATE);
160 }
161
162 @Override
163 public void onUpgrade(SQLiteDatabase db, int oldVersion,
164 int newVersion)
165 {
166 Log.w(TAG, "Upgrading database from version " + oldVersion
167 + " to "
168 + newVersion + ", which will destroy all old data");
169 db.execSQL("DROP TABLE IF EXISTS titles");
170 onCreate(db);
171 }
172}
173
174{
175DBHelper = new DatabaseHelper(context, DATABASE_NAME, null, DATABASE_VERSION);
176SQLiteDatabase db;
177try {
178 db = DBHelper.getWritableDatabase();
179}
180catch (SQLiteException ex) {
181 db = DBHelper.getReadableDatabase();
182}
183
184}
185
186// String where = dist_id + "=" + mEdit.getText().toString()
187// Cursor myResult = "myDatabase".query(DATABASE_TABLE0, null, where,
188// null, null, null, null);
189public Cursor all(Activity activity) {
190 String[] from = { dist_id, points, condensor };
191 String order = dist_id;
192
193//getReadableDatabase() is causing an error, wants its own Method
194 SQLiteDatabase db = getReadableDatabase();
195 Cursor cursor = db.query(DATABASE_TABLE0, from, null, null, null, null, order);
196 activity.startManagingCursor(cursor);
197
198 return cursor;
199 }
200
201
202
203}