· 9 years ago · Nov 11, 2016, 02:56 PM
1package main.page;
2
3import java.io.File;
4import java.io.FileNotFoundException;
5import java.io.FileOutputStream;
6import java.io.IOException;
7import java.io.InputStream;
8import java.io.OutputStream;
9
10import android.content.ContentValues;
11import android.content.Context;
12import android.database.Cursor;
13import android.database.SQLException;
14import android.database.sqlite.SQLiteDatabase;
15import android.database.sqlite.SQLiteOpenHelper;
16import android.os.Bundle;
17import android.provider.BaseColumns;
18import android.util.Log;
19import android.widget.ArrayAdapter;
20import android.widget.AutoCompleteTextView;
21import android.widget.Button;
22import android.widget.Spinner;
23import android.widget.Toast;
24
25public class InfoDBAdapter
26{
27 public static final String KEY_ROWID = "_id";
28 public static final String KEY_NAME = "name";
29 public static final String KEY_DATE = "date";
30 public static final String KEY_TYPE = "type";
31 public static final String KEY_LIKES = "likes";
32 public static final String KEY_DISLIKES = "dislikes";
33 private static final String TAG = "InfoDBAdapter";
34
35 private static final String DATABASE_NAME = "AnniversaryDB";
36 private static final String DATABASE_TABLE = "personalInfo";
37 private static final int DATABASE_VERSION = 2;
38
39 private static final String DATABASE_CREATE = "create table personalInfo (_id integer primary key autoincrement, "
40 + "name text not null, date text not null, type text not null, likes text not null, dislikes text not null);";
41
42 private final Context context;
43
44 private DatabaseHelper DBHelper;
45 private SQLiteDatabase db;
46
47 public InfoDBAdapter(Context ctx)
48 {
49 this.context = ctx;
50 DBHelper = new DatabaseHelper(context);
51 }
52
53 private static class DatabaseHelper extends SQLiteOpenHelper
54 {
55 DatabaseHelper(Context context)
56 {
57 super(context, DATABASE_NAME, null, DATABASE_VERSION);
58 }
59
60 @Override
61 public void onCreate(SQLiteDatabase db)
62 {
63 try
64 {
65 db.execSQL(DATABASE_CREATE);
66 } catch (SQLException e)
67 {
68 e.printStackTrace();
69 }
70 }// end onCreate()
71
72 @Override
73 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
74 {
75 Log.w(TAG, "Upgrading database from version " + oldVersion + " to "
76 + newVersion + ", which will destroy all old data");
77 db.execSQL("DROP TABLE IF EXISTS info");
78 onCreate(db);
79 }// end onUpgrade()
80
81 }// end DatabaseHelper
82
83 // ---opens the database---
84 public InfoDBAdapter open() throws SQLException
85 {
86 db = DBHelper.getWritableDatabase();
87 return this;
88 }// end open()
89
90 // ---closes the database---
91 public void close()
92 {
93 DBHelper.close();
94 }// end close()
95
96 // ---insert a contact into the database---
97 public long insertContact(String name, String date, String type, String likes, String dislikes)
98 {
99 ContentValues initialValues = new ContentValues();
100 initialValues.put(KEY_NAME, name);
101 initialValues.put(KEY_DATE, date);
102 initialValues.put(KEY_TYPE, type);
103 initialValues.put(KEY_LIKES, likes);
104 initialValues.put(KEY_DISLIKES, dislikes);
105 return db.insert(DATABASE_TABLE, null, initialValues);
106 }// end insertContact()
107
108 // ---deletes a particular contact---
109 public boolean deleteContact(long rowId)
110 {
111 return db.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId, null) > 0;
112 }// end deleteContact()
113
114 // ---retrieves all the contacts---
115 public Cursor getAllContacts()
116 {
117 return db.query(DATABASE_TABLE, new String[]
118 { KEY_ROWID, KEY_NAME, KEY_DATE, KEY_TYPE, KEY_LIKES, KEY_DISLIKES }, null, null, null, null, null);
119 }// end getAllContacts()
120
121 // ---retrieves a particular contact---
122 public Cursor getContact(long rowId) throws SQLException
123 {
124 Cursor mCursor = db.query(true, DATABASE_TABLE, new String[] {
125 KEY_ROWID, KEY_NAME, KEY_DATE, KEY_TYPE, KEY_LIKES, KEY_DISLIKES }, KEY_ROWID + "=" + rowId,
126 null, null, null, null, null);
127 if (mCursor != null)
128 {
129 mCursor.moveToFirst();
130 }
131 return mCursor;
132 }// end getContact()
133
134 // ---updates a contact---
135 public boolean updateContact(long rowId, String name, String date, String type, String likes, String dislikes)
136 {
137 ContentValues args = new ContentValues();
138 args.put(KEY_NAME, name);
139 args.put(KEY_DATE, date);
140 args.put(KEY_TYPE, type);
141 args.put(KEY_LIKES, likes);
142 args.put(KEY_DISLIKES, dislikes);
143 return db.update(DATABASE_TABLE, args, KEY_ROWID + "=" + rowId, null) > 0;
144 }// end updateContact()
145
146}//end DBAdapter
147
148
149
150
151
152
153
154package main.page;
155
156import java.io.File;
157import java.io.FileNotFoundException;
158import java.io.FileOutputStream;
159import java.io.IOException;
160import java.io.InputStream;
161import java.io.OutputStream;
162import java.util.ArrayList;
163import java.util.List;
164
165
166import android.app.Activity;
167import android.content.Context;
168import android.content.Intent;
169import android.database.Cursor;
170import android.database.SQLException;
171import android.database.sqlite.SQLiteDatabase;
172import android.database.sqlite.SQLiteOpenHelper;
173import android.os.Bundle;
174import android.view.View;
175import android.view.View.OnClickListener;
176
177
178import android.widget.ArrayAdapter;
179import android.widget.Button;
180import android.widget.EditText;
181import android.widget.Spinner;
182import android.widget.Toast;
183
184public class PersonalInfo extends Activity
185{
186 Button btnSave, btnBack;
187 EditText txtDate, txtType, txtLikes, txtDislikes;
188
189 Spinner nameSpinner;
190 ArrayAdapter<String>adapter;
191 String names[] = {"Kanak Priya", "Joanne Liew", "Michelle Lam", "Natasha Akhbar", "Joan Tang", "Teo Kin Hua", "David Yeo"};
192
193 @Override
194 public void onCreate(Bundle savedInstanceState)
195 {
196 super.onCreate(savedInstanceState);
197 setContentView(R.layout.info);
198
199 /*try{
200 String destPath = "/data/data" + getPackageName() +
201 "/databases/AnniversaryDB";
202 File f = new File(destPath);
203 if(!f.exists())
204 {
205 CopyDB(getBaseContext().getAssets().open("AnniversaryDB"),
206 new FileOutputStream(destPath));
207 }
208 }catch (FileNotFoundException e)
209 {
210 e.printStackTrace();
211 }catch (IOException e)
212 {
213 e.printStackTrace();
214 }*/
215
216 InfoDBAdapter dbInfo = new InfoDBAdapter(this);
217
218 dbInfo.open();
219 long id = dbInfo.insertContact("Kanak Priya", "24/6/1990", "Birthday", "Painting", "Bungee jumping");
220 id = dbInfo.insertContact("Joanne Liew", "15/8/1990", "Birthday", "Skating", "Yoga");
221 dbInfo.close();
222
223 /*//---get all contacts--
224 dbInfo.open();
225 Cursor c = dbInfo.getAllContacts();
226 if (c.moveToFirst())
227 {
228 do
229 {
230 DisplayContact(c);
231 } while (c.moveToNext());
232 }
233 dbInfo.close();*/
234
235
236 Spinner nameSpinner = (Spinner) findViewById(R.id.nameSpinner);
237 adapter = new ArrayAdapter<String>(this,
238 android.R.layout.simple_spinner_item, names);
239 nameSpinner.setAdapter(adapter);
240
241
242
243 Button btnSave = (Button) findViewById(R.id.btnSave);
244 btnSave.setOnClickListener(new View.OnClickListener()
245 {
246
247 @Override
248 public void onClick(View v)
249 {
250 Spinner nameSpinner = (Spinner) findViewById(R.id.nameSpinner);
251 EditText txtDate = (EditText) findViewById(R.id.txtDate);
252 EditText txtType = (EditText) findViewById(R.id.txtType);
253 EditText txtLikes = (EditText) findViewById(R.id.txtLikes);
254 EditText txtDislikes = (EditText) findViewById(R.id.txtDislikes);
255
256 Toast.makeText(getBaseContext(),
257 "Your info is saved successfully!",
258 Toast.LENGTH_SHORT).show();
259
260 }
261 });
262
263 Button btnBack = (Button) findViewById(R.id.btnMain);
264 btnBack.setOnClickListener(new View.OnClickListener()
265 {
266
267 @Override
268 public void onClick(View arg0)
269 {
270 finish();
271
272 }
273 });
274
275 }// end onCreate()
276
277 /*public void CopyDB(InputStream inputStream,
278 OutputStream outputStream)
279 throws IOException
280{
281 //---copy 1K bytes at a time---
282 byte[] buffer = new byte[1024];
283 int length;
284 while ((length = inputStream.read(buffer)) > 0)
285 {
286 outputStream.write(buffer, 0, length);
287 }
288 inputStream.close();
289 outputStream.close();
290}*/
291
292 /*public void DisplayContact(Cursor c)
293 {
294 Toast.makeText(
295 this,
296 "id: " + c.getString(0) + "n" + "Name: " + c.getString(1)
297 + "n" + "Date: " + c.getString(2) + "n" + "Type: " + c.getString(3) + "n" + "Likes: " + c.getString(4)
298 + "n" + "Dislikes: " + c.getString(5), Toast.LENGTH_LONG)
299 .show();
300 }*/
301
302}
303
304
305
306<?xml version="1.0" encoding="utf-8"?>
307<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
308 style="@style/InfoStyle"
309 android:layout_width="match_parent"
310 android:layout_height="match_parent"
311 android:orientation="vertical" >
312
313 <TextView
314 android:id="@+id/fName"
315 style="@style/InfoStyle"
316 android:layout_width="wrap_content"
317 android:layout_height="wrap_content"
318 android:text="Full Name"
319 android:textAppearance="?android:attr/textAppearanceMedium" />
320
321 <Spinner
322 android:id="@+id/nameSpinner"
323 android:layout_width="match_parent"
324 android:layout_height="wrap_content"
325 >
326
327 <requestFocus />
328 </Spinner>
329
330 <TextView
331 android:id="@+id/date"
332 style="@style/InfoStyle"
333 android:layout_width="wrap_content"
334 android:layout_height="wrap_content"
335 android:text="Date"
336 android:textAppearance="?android:attr/textAppearanceMedium" />
337
338 <RelativeLayout
339 android:layout_width="match_parent"
340 android:layout_height="wrap_content" >
341
342
343 <EditText
344 android:id="@+id/txtDate"
345 android:layout_width="wrap_content"
346 android:layout_height="wrap_content"
347 android:layout_alignParentLeft="true"
348 android:layout_alignParentRight="true"
349 android:layout_alignParentTop="true"
350 android:ems="10"
351 android:inputType="date" />
352
353
354
355 </RelativeLayout>
356
357 <TextView
358 android:id="@+id/type"
359 style="@style/InfoStyle"
360 android:layout_width="wrap_content"
361 android:layout_height="wrap_content"
362 android:text="Type"
363 android:textAppearance="?android:attr/textAppearanceMedium" />
364
365 <EditText
366 android:id="@+id/txtType"
367 android:layout_width="match_parent"
368 android:layout_height="wrap_content"
369 android:ems="10" />
370
371 <TextView
372 android:id="@+id/bow"
373 style="@style/InfoStyle"
374 android:layout_width="wrap_content"
375 android:layout_height="wrap_content"
376 android:text="birthday or wedding"
377 android:textAppearance="?android:attr/textAppearanceSmall" />
378
379 <TextView
380 android:id="@+id/likes"
381 style="@style/InfoStyle"
382 android:layout_width="wrap_content"
383 android:layout_height="wrap_content"
384 android:text="Likes"
385 android:textAppearance="?android:attr/textAppearanceMedium" />
386
387 <AutoCompleteTextView
388 android:id="@+id/txtLikes"
389 android:layout_width="match_parent"
390 android:layout_height="wrap_content"
391 android:ems="10"
392 android:gravity="top" />
393
394 <TextView
395 android:id="@+id/dislikes"
396 style="@style/InfoStyle"
397 android:layout_width="wrap_content"
398 android:layout_height="wrap_content"
399 android:text="Dislikes"
400 android:textAppearance="?android:attr/textAppearanceMedium" />
401
402 <AutoCompleteTextView
403 android:id="@+id/txtDislikes"
404 android:layout_width="match_parent"
405 android:layout_height="wrap_content"
406 android:ems="10"
407 android:gravity="top" />
408
409
410
411 <Button
412 android:id="@+id/btnSave"
413 style="@style/main_menu"
414 android:layout_width="109dp"
415 android:layout_height="wrap_content"
416 android:layout_gravity="center_horizontal"
417 android:background="@drawable/red_btn_info"
418 android:text="Save" />
419
420 <Button
421 android:id="@+id/btnMain"
422 style="@style/main_menu"
423 android:layout_width="wrap_content"
424 android:layout_height="wrap_content"
425 android:background="@drawable/red_btn_info"
426 android:text="Main Menu" />
427
428</LinearLayout>